What Debezium connector do you use and what version?

debezium-mysql-1.9.5.Final

What is the connector configuration?

default

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?

yes

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