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

Generated columns not supported by DDL parser

    XMLWordPrintable

Details

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

    Description

      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

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: