Wrong warning when inserting zero date into TIMESTAMP with SQL_MODE=no_zero_date

mysql> DROP TABLE IF EXISTS t1; CREATE TABLE t1 (a DATE, b DATETIME, c TIMESTAMP); SET SQL_MODE='no_zero_date'; INSERT INTO t1 VALUES (0,0,0); SHOW WARNINGS;

Query OK, 0 rows affected (0.05 sec)

Query OK, 0 rows affected (0.21 sec)

Query OK, 0 rows affected (0.00 sec)

Query OK, 1 row affected, 3 warnings (0.00 sec)

+---------+------+--------------------------------------------+

| Level   | Code | Message                                    |

+---------+------+--------------------------------------------+

| Warning | 1264 | Out of range value for column 'a' at row 1 |

| Warning | 1264 | Out of range value for column 'b' at row 1 |

| Warning | 1265 | Data truncated for column 'c' at row 1     |

+---------+------+--------------------------------------------+

3 rows in set (0.00 sec)