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

MySQL connector cannot parse table with WITH SYSTEM VERSIONING PARTITION BY SYSTEM_TIME

XMLWordPrintable

      What Debezium connector do you use and what version?

      MySqlConnector 2.5

      What is the connector configuration?

      <Your answer>

      What is the captured database version and mode of depoyment?

      MariaDB-1:10.11.6

      What behaviour do you see?

      Caused by: io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'CREATE TABLE `dailydata` (
        `DATE` bigint(20) NOT NULL,
        `ID` varchar(25) NOT NULL, 
        `OPEN` double DEFAULT NULL,
        `HIGH` double DEFAULT NULL,
        `LOW` double DEFAULT NULL,
        `CLOSE` double DEFAULT NULL,
        PRIMARY KEY (`ID`,`DATE`)
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci WITH SYSTEM VERSIONING
       PARTITION BY SYSTEM_TIME INTERVAL 1 DAY STARTS TIMESTAMP'2024-02-05 00:00:00' AUTO
      PARTITIONS 6'

            ccranfor@redhat.com Chris Cranford
            jvdm_tt Jordi van der Maas (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: