Subject | Re: [Firebird-Java] Dialect 3 and FBDatabaseMetaData#getIndexInfo |
---|---|
Author | Aljoscha Rittner |
Post date | 2006-02-01T15:54:07Z |
Hi Roman!
|>> 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);
STATISTICS over all tables)
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);
>>Ok, number is 1421579 (I need the function for a big run with SET
>> 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.
STATISTICS over all tables)
best regards
josh.