Subject Re: [Firebird-Java] Dialect 3 and FBDatabaseMetaData#getIndexInfo
Author Aljoscha Rittner
Hi Roman!


>> 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.

> Yup, you're right. Please fill a bug report in SourceForge.net area, so we
> don't forget about the issue.

Ok, number is 1421579 (I need the function for a big run with SET
STATISTICS over all tables)

best regards
josh.