Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-4584

Incremental snapshots does not honor column case sensitivity

    XMLWordPrintable

Details

    Description

      oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1099)\n\tat oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1293)\n\tat oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:366)\n\tat io.debezium.jdbc.JdbcConnection.queryAndMap(JdbcConnection.java:644)\n\tat io.debezium.jdbc.JdbcConnection.queryAndMap(JdbcConnection.java:513)\n\tat io.debezium.pipeline.source.snapshot.incremental.AbstractIncrementalSnapshotChangeEventSource.readChunk(AbstractIncrementalSnapshotChangeEventSource.java:274)\n\t... 26 more\nCaused by: Error : 904, Position : 45, Sql = SELECT * FROM \"ODS_XMES_QY\".\"ORDER\" ORDER BY Oid DESC FETCH NEXT 1 ROWS ONLY, OriginalSql = SELECT * FROM \"ODS_XMES_QY\".\"ORDER\" ORDER BY Oid DESC FETCH NEXT 1 ROWS ONLY, Error Msg = ORA-00904: \"OID\": invalid identifier\n\n\tat oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)\n\t... 41 more\n"

       PS:"Oid" is primary key,Oracle is case-insensitive。

      Attachments

        Activity

          People

            ccranfor@redhat.com Chris Cranford
            desctan90 zainc chou (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: