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

Function DATE_ADD can be used as an identifier


    • False
    • None
    • False
    • If Release Note Needed, Set a Value
    • Set a Value

      What Debezium connector do you use and what version?


      What is the connector configuration?


      What is the captured database version and mode of depoyment?

      On-premises, 5.7.36-39 (Percona)

      What behaviour do you expect?

      i guess i expected the connector to work

      What behaviour do you see?

      connector started to crash with error on startup after database update (added some tables)

      Do you see the same behaviour using the latest relesead Debezium version?


      Do you have the connector logs, ideally from start till finish?

      i do, the relevant part:

      Caused by: io.debezium.text.ParsingException: DDL statement couldn't be parsed. Please open a Jira issue with the statement 'create table  `site_checker_b_sonet_group_favorites`
          USER_ID int(11) not null,
          GROUP_ID int(11) not null,
          DATE_ADD datetime DEFAULT NULL,
          primary key (USER_ID, GROUP_ID)
      no viable alternative at input 'create table  `site_checker_b_sonet_group_favorites`\n(\n\tUSER_ID int(11) not null,\n\tGROUP_ID int(11) not null,\n\tDATE_ADD'

      How to reproduce the issue using our tutorial deployment?

      create table using the statement above


            Unassigned Unassigned
            adruzinin967 Andrey Druzhinin (Inactive)
            0 Vote for this issue
            5 Start watching this issue