See https://gitter.im/debezium/dev?at=60916d174d0065337e51e893

When DDL like

ALTER TABLE `db`.`table`
CHANGE COLUMN `end_date` `end_date` DATE NULL DEFAULT '2050-01-01 00:00:00'

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.