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

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

XMLWordPrintable

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

      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'.

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

                Created:
                Updated:
                Resolved: