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

Reserved keywords (e.g. `UNIQUE`) is used as column name in source table

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Blocker Blocker
    • 0.4.1
    • 0.4, 0.4.1
    • mysql-connector
    • None
    • Hide

      Add SqlDdlParserTestWithKeyWordsInTheColumnName.java into mysql-connector tests and run and see .

      Show
      Add SqlDdlParserTestWithKeyWordsInTheColumnName.java into mysql-connector tests and run and see .

      If reserved keywords (e.g. `UNIQUE`) is used as column name in source table - processing of that table fails / related kafka topic is not created. See attached error-msg.txt.


      General problem of conditions which are used in current context is they in the same moment modify compared content and consume token. Even if column is quoted and should be anyhow used, second part condition is run - than finds keyword and consume it. My simple partial solution (for `UNIQUE` keyword) I added in attached zip - included is mysql-connector part and core part. I tested it by my unit tests and worked, but this problem should be generally solved.

        1. SqlDdlParserTestWithKeyWordsInTheColumnName.java
          6 kB
          Jan Pastrnak
        2. error-msg.txt
          3 kB
          Jan Pastrnak

            rhauch Randall Hauch (Inactive)
            jan.pastrnak Jan Pastrnak (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: