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

Property snapshot.select.statement.overrides is not case insensitive

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not a Bug
    • Minor
    • None
    • 2.0.0.Final
    • oracle-connector
    • None
    • False
    • None
    • False
    • Low

    Description

      Bug report

      What Debezium connector do you use and what version?

      Oracle Connector

      What is the connector configuration?

      "table.include.list": "ASEDBUSR.ABRDVRS,ASEDBUSR.ABRDVRSUNT,ASEDBUSR.ACTIVITY,ASEDBUSR.ADRESSE,ASEDBUSR.ADRESSEROLE,ASEDBUSR.ANTRFRAGENANTW,ASEDBUSR.ARBUN,ASEDBUSR.BANK,ASEDBUSR.BEZIEHUNG,ASEDBUSR.BILANZAUSGLEICH,ASEDBUSR.BUCHSTOFFV,ASEDBUSR.BUCHUNGSTOFF", 
      "snapshot.select.statement.overrides": "asedbusr.abrdvrs,asedbusr.abrdvrsunt,asedbusr.activity,asedbusr.adresse,asedbusr.adresserole,asedbusr.antrfragenantw,asedbusr.arbun,asedbusr.bank,asedbusr.beziehung,asedbusr.bilanzausgleich,asedbusr.buchstoffv,asedbusr.buchungstoff""snapshot.select.statement.overrides.asedbusr.abrdvrs": "SELECT * FROM ASEDBUSR.ABRDVRS WHERE REPLACED = TO_DATE('3000-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') ORDER BY PKEY ASC", }}
      "snapshot.select.statement.overrides.asedbusr.abrdvrsunt": "SELECT * FROM ASEDBUSR.ABRDVRSUNT WHERE REPLACED = TO_DATE('3000-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') ORDER BY PKEY ASC", ...

      What is the captured database version and mode of depoyment?

      Oracle 19c on prem, Non CDB

      What behaviour do you expect?

      The configuration should be case insensitive.

      What behaviour do you see?

      When the tables in the table.include.list are upper case and the entries in snapshot.select.statement.overrides are lower case, then snapshot.select.statement.overrides.schema.table property in lower case doesn't work.

      Do you see the same behaviour using the latest relesead Debezium version?

      2.0 Final

      Attachments

        Activity

          People

            Unassigned Unassigned
            renerh René Rütter
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: