Subject | Dialect 3 and FBDatabaseMetaData#getIndexInfo |
---|---|
Author | Aljoscha Rittner |
Post date | 2006-01-31T18:11:59Z |
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.