conversion from zero int to time is not compatible with MySQL #25285
Description
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
mysql> select @@sql_mode;
+-------------------------------------------------------------------------------------------------------------------------------------------+
| @@sql_mode |
+-------------------------------------------------------------------------------------------------------------------------------------------+
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+-------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)Make sure sql_mode contains "NO_ZERO_DATE".
drop table if exists t;
create table t (a int);
insert into t values (0);
alter table t modify column a date;2. What did you expect to see? (Required)
mysql> alter table t modify column a date;
ERROR 1292 (22007): Incorrect date value: '0' for column 'a' at row 13. What did you see instead (Required)
mysql> alter table t modify column a date;
Query OK, 0 rows affected (0.58 sec)
mysql> select * from t;
+------------+
| a |
+------------+
| 0000-00-00 |
+------------+
1 row in set (0.01 sec)4. What is your TiDB version? (Required)
master
commit f81ef5579551a0523d18b049eb25ab3375bcfb48 (HEAD, upstream/master)
Author: Yuanjia Zhang <zhangyuanjia@pingcap.com>
Date: Tue Jun 8 20:08:28 2021 +0800
planner: solve an incompatible issue about dynamic-mode and TiFlash and enable dynamic mode by default (#25255)