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

Exception when parsing enum field with escaped characters values

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 0.7.0
    • 0.6.2
    • mysql-connector
    • None
    • Hide

      Create this table:
      CREATE TABLE `filters` (
      `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
      `operator` enum('=','>','<','>=','<=','!=','LIKE ''%$%''') DEFAULT NULL,
      `value` varchar(255) DEFAULT NULL,
      PRIMARY KEY (`id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8

      And run debezium job against it

      Show
      Create this table: CREATE TABLE `filters` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `operator` enum('=','>','<','>=','<=','!=','LIKE ''%$%''') DEFAULT NULL, `value` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 And run debezium job against it

    Description

      Debezium snapshotting breaks if mysql database contains enum with string value that has escaped quotation marks in it. Like 'hel''lo'.

      The exception is:
      2017-11-21 09:11:08,671 ERROR MySQL|db123|binlog Failed due to error: Error processing binlog event [io.debezium.connector.mysql.BinlogReader]
      org.apache.kafka.connect.errors.ConnectException: Expecting ')' at line 1, column 40 but found ''%$%'': =','<=','!=','LIKE ' ===>> '%$%''','LIKE ''$%''

      All valid mysql escaping cases listed here:
      https://dev.mysql.com/doc/refman/5.7/en/string-literals.html

      Attachments

        Issue Links

          is related to

          Bug - A problem that impairs or prevents the functions of the product. DBZ-481 Escape sequence handling needs to be unified

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Closed

          Activity

            People

              jpechane Jiri Pechanec
              pimpelsang Eero Koplimets (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: