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

LogMinerDatabaseStateWriter causes a SQLException

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 1.7.0.Beta1
    • 1.7.0.Alpha1
    • oracle-connector
    • None

      When fetching archive logs for the last 48 hours, a SQLException is thrown due to the following incorrect SQL statement:

      SELECT * FROM V$ARCHIVED_LOG WHERE FIST_TIME >= SYSDATE - 2
      

      The where-clause should reference column FIRST_TIME instead.

            ccranfor@redhat.com Chris Cranford
            ccranfor@redhat.com Chris Cranford
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: