Subject | FBDatabaseMetaData#getIndexInfo and dialect 3 |
---|---|
Author | Josch |
Post date | 2006-01-31T21:55:08Z |
Hi!
I've found a bug in FBDatabaseMetaData with the method getIndexInfo.
| public ResultSet getIndexInfo(String catalog, String schema,
| String table, boolean unique, boolean approximate) throws
| SQLException {
| checkCatalogAndSchema(catalog, schema);
| String sql = GET_INDEX_INFO;
| ArrayList params = new ArrayList();
| params.add(table.toUpperCase());
|
| ResultSet rs = doQuery(sql, params);
The call table.toUpperCase() prevents index info for mixed case table
identifiers with dialect 3 databases.
best regards,
josh.
I've found a bug in FBDatabaseMetaData with the method getIndexInfo.
| public ResultSet getIndexInfo(String catalog, String schema,
| String table, boolean unique, boolean approximate) throws
| SQLException {
| checkCatalogAndSchema(catalog, schema);
| String sql = GET_INDEX_INFO;
| ArrayList params = new ArrayList();
| params.add(table.toUpperCase());
|
| ResultSet rs = doQuery(sql, params);
The call table.toUpperCase() prevents index info for mixed case table
identifiers with dialect 3 databases.
best regards,
josh.