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

Tables with spaces or non-ASCII characters in their name are not captured by Oracle because they must be quoted.

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 2.1.3.Final, 2.2.0.Alpha3
    • 1.9.7.Final, 2.0.1.Final, 2.1.2.Final, 2.2.0.Alpha2
    • oracle-connector
    • None

      Create a table using the following SQL:

      create table "Q1! 表"(a int);
      

      Then insert a record that should be snapshotted using this SQL:

      INSERT INTO "Q1! 表" (a) VALUES (1);
      

      Finally set the table in the connector's configuration include list as follows:

      table.include.list=DEBEZIUM."Q1! 表"
      

      When the connector starts, it will report that no tables matched the include filters and no events will be captured. Similar behavior happens if the table has the same name, sans the space.

            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: