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

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

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • 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 .

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: