SQL_MODE NO_ZERO_IN_DATE is not respected

[tisonkun]

Bug Report

1. Minimal reproduce step (Required)

reproduce.sql.txt

2. What did you expect to see? (Required)

mysql produces results without zero_in_date rows, such as 2022-00-23 00:00:00

3. What did you see instead (Required)

tidb produces results with zero_in_date rows, such as 2022-00-23 00:00:00, even if set sql_mode with NO_ZERO_IN_DATE

4. What is your TiDB version? (Required)

$ mysql -V     
mysql  Ver 8.0.23 for osx10.15 on x86_64 (Homebrew)

mysql> SELECT tidb_version();
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version()                                                                                                                                                                                                                                                                                                              |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v4.0.0-beta.2-2226-g8230f4162
Edition: Community
Git Commit Hash: 8230f4162ba019dc5a22c3bf62feabccde1379f9
Git Branch: master
UTC Build Time: 2021-03-01 14:55:34
GoVersion: go1.13.1
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.06 sec)

[tisonkun]

Closed as no more activities.