datetime defaults of '0000-00-00 00:00:00' to be removed?

[pmaloney]

Hi,

Any plans to remove the invalid datetime defaults?

The optimization script won't run on MySQL 8.2 without dropping those defaults. Generally, these defaults don't appear to be supported on current MySQL versions.

Regards, Patrick

[pgbennett]

Usually, set sql_mode = ''; lets you use the invalid dates. I don't know if that still applies to 8.2.