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

Issue while parsing create table script with ENUM type and default value 'b'

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 0.3.6, 0.4
    • 0.3.5
    • mysql-connector
    • None

    Description

      suppose I have the following create table script :

      CREATE TABLE t ( c1 ENUM('a','b','c') NOT NULL DEFAULT 'b';

      Then, I am getting below exception while trying to parse the above ddl statement.

      "io.debezium.text.ParsingException: Expecting 8|16 at line 1, column 59 but found ';': NOT NULL DEFAULT 'b' ===>> "

      Note : Issue happens only when the default value is 'b'.

      Attachments

        Activity

          People

            sherafpm Sheraf pm (Inactive)
            sherafpm Sheraf pm (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: