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

Generated columns not supported by DDL parser

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • 0.9.1.Final
    • 0.9.0.Beta2, 0.9.0.Final
    • mysql-connector
    • None

      Im trying to use Debezium, but has an error to a specific table:

      [2019-02-05 21:19:21,984] WARN Ignoring unparseable DDL statement 'CREATE TABLE `Testing` (
      `id` binary(16) NOT NULL,
      `createdAt` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
      `updatedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
      `idChar` char(32) GENERATED ALWAYS AS (hex(`id`)) STORED,
      PRIMARY KEY (`id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1': {} (io.debezium.connector.mysql.MySqlSchema:307)

      if i use ddl.parser.mode=legacy, it works

              jpechane Jiri Pechanec
              gabrielcslima Gabriel Lima (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: