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: