default_as_expession is failed because of the wrong error msg #52267
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
run test [ddl/default_as_expression] err: sql:alter table t0 modify column c1 datetime DEFAULT (date_format(now(), '%Y-%m-%d'));: failed to run query
\"alter table t0 modify column c1 datetime DEFAULT (date_format(now(), '%Y-%m-%d'));\"
around line 58,
we need(139):
alter table t0 modify column c1 datetime DEFAULT (date_format(now(), '%Y-%m-%d'));
Error 1292 (22007): Incorrect datetime value: '2024-03'
but got(139):
alter table t0 modify column c1 datetime DEFAULT (date_format(now(), '%Y-%m-%d'));
Error 1292 (22007): Incorrect datetime value: '2024-04'