When DDL like
is used the default value parser will throw an exception. The problem is that DATE should contain only date but MySQL accepts also timestamp.
It si necessary to update io.debezium.connector.mysql.MySqlDefaultValueConverter.convertToLocalDate(Column, String) and intorduce a new DateTimeFromatter instead of ISO_LOCAL_DATE.
This new formatter wil contain ISO_LOCAL_DATE and optionally ISO_LOCAL_TIME.
It is also necessary to verify whether zero should be compared not only against epoch data but against epoch timestamp too.