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: