Firebird 5 Column unknown; IND.RDB$CONDITION_SOURCE

[Stefan Schmaltz]

Hi!

Situation:

Firebird 5.0 Windows 11

Database fb from Firebird 4

When I call getRuntimeMetaData().getJdbcMetaData().getIndexInfo(..) 

I get this stack trace:

Dynamic SQL Error; SQL error code = -206; Column unknown; IND.RDB$CONDITION_SOURCE; At line 9, column 3 [SQLState:42S22, ISC error code:335544578]

at org.firebirdsql.gds.ng.FbExceptionBuilder$Type$1.createSQLException(FbExceptionBuilder.java:613)

at org.firebirdsql.gds.ng.FbExceptionBuilder.toFlatSQLException(FbExceptionBuilder.java:384)

at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readStatusVector(AbstractWireOperations.java:154)

at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readStatusVector(AbstractWireOperations.java:99)

at org.firebirdsql.gds.ng.wire.AbstractWireOperations.processOperation(AbstractWireOperations.java:209)

at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readOperationResponse(AbstractWireOperations.java:175)

at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readResponse(AbstractWireOperations.java:169)

at org.firebirdsql.gds.ng.wire.AbstractWireOperations.readGenericResponse(AbstractWireOperations.java:283)

at org.firebirdsql.gds.ng.wire.AbstractFbWireDatabase.readGenericResponse(AbstractFbWireDatabase.java:206)

at org.firebirdsql.gds.ng.wire.version11.V11Statement.prepare(V11Statement.java:98)

at org.firebirdsql.jdbc.FBStatement.prepareFixedStatement(FBStatement.java:920)

at org.firebirdsql.jdbc.FBPreparedStatement.prepareFixedStatement(FBPreparedStatement.java:771)

at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:148)

at org.firebirdsql.jdbc.FBDatabaseMetaData.getStatement(FBDatabaseMetaData.java:1729)

at org.firebirdsql.jdbc.FBDatabaseMetaData.doQuery(FBDatabaseMetaData.java:1768)

at org.firebirdsql.jdbc.FBDatabaseMetaData$DbMetadataMediatorImpl.performMetaDataQuery(FBDatabaseMetaData.java:1873)

at org.firebirdsql.jdbc.metadata.AbstractMetadataMethod.createMetaDataResultSet(AbstractMetadataMethod.java:59)

at org.firebirdsql.jdbc.metadata.GetIndexInfo.getIndexInfo(GetIndexInfo.java:77)

at org.firebirdsql.jdbc.FBDatabaseMetaData.getIndexInfo(FBDatabaseMetaData.java:1341)

Again, it's a Database from Firebird 4, so I know "update to Version 5" will fix this problem.

Best regards

Stefan

[Mark Rotteveel]

This would be more suitable to post the firebird-java group
(https://groups.google.com/g/firebird-java), or report on
https://github.com/FirebirdSQL/jaybird/issues

In any case, it is a bug with Jaybird generating a query in
FBDatabaseMetaData.getIndexInfo for a Firebird 5 database (ODS 13.1)
feature which is not available in your Firebird 4.0 database (ODS 13.0).
It only checks for the server version, and not the ODS version.

Upgrading your database to ODS 13.1 using a backup and restore, or using
gfix to upgrade the ODS will solve the issue, or you'll need to wait
until I have fixed this in a next Jaybird release.

Mark
--
Mark Rotteveel

[Mark Rotteveel]

I've created https://github.com/FirebirdSQL/jaybird/issues/813 to track
and fix this.

Mark

[Mark Rotteveel]

On 23/07/2024 18:14, 'Mark Rotteveel' via firebird-support wrote:

> This would be more suitable to post the firebird-java group
> (https://groups.google.com/g/firebird-java), or report on
> https://github.com/FirebirdSQL/jaybird/issues
>
> In any case, it is a bug with Jaybird generating a query in
> FBDatabaseMetaData.getIndexInfo for a Firebird 5 database (ODS 13.1)
> feature which is not available in your Firebird 4.0 database (ODS 13.0).
> It only checks for the server version, and not the ODS version.
>
> Upgrading your database to ODS 13.1 using a backup and restore, or using
> gfix to upgrade the ODS will solve the issue, or you'll need to wait
> until I have fixed this in a next Jaybird release.

As a workaround, you can downgrade to Jaybird 5.0.4.

Mark
--
Mark Rotteveel