[hibernate-issues] [Hibernate-JIRA] Commented: (HBX-961) invalid column name in H2MetaDataDialect getSuggestedPrimaryKeyStrategyName query
[
http://opensource.atlassian.com/projects/hibernate/browse/HBX-961?page=co...
]
Dan Allen commented on HBX-961:
-------------------------------
And here is the explain plan:
SELECT
INDEXES.TABLE_CATALOG,
INDEXES.TABLE_SCHEMA,
INDEXES.TABLE_NAME,
INDEXES.NON_UNIQUE,
INDEXES.INDEX_NAME,
INDEXES.ORDINAL_POSITION,
INDEXES.COLUMN_NAME,
INDEXES.CARDINALITY,
INDEXES.PRIMARY_KEY,
INDEXES.INDEX_TYPE_NAME,
INDEXES.IS_GENERATED,
INDEXES.INDEX_TYPE,
INDEXES.ASC_OR_DESC,
INDEXES.PAGES,
INDEXES.FILTER_CONDITION,
INDEXES.REMARKS,
INDEXES.SQL, INDEXES.ID
FROM
INFORMATION_SCHEMA.INDEXES
invalid column name in H2MetaDataDialect
getSuggestedPrimaryKeyStrategyName query
---------------------------------------------------------------------------------
Key: HBX-961
URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-961
Project: Hibernate Tools
Issue Type: Bug
Components: reverse-engineer
Affects Versions: 3.2beta10
Environment: H2, version: 1.0 (2007-06-17)
Reporter: Dan Allen
Attachments: HBX-961-v1.txt, HBX-961-v2.txt
Original Estimate: 5 minutes
Remaining Estimate: 5 minutes
There is an invalid column name used in the query to get the primary keys for a table.
The query uses the column name TABLE_CATNAME but the appropriate name of the column is
TABLE_CATALOG. A patch is supplied.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira