date_add/date_sub does not handle invalid date properly

[gengliqi]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

mysql> create table t(a int);
Query OK, 0 rows affected (0.07 sec)

mysql> insert into t values(0),(20015),(20100);
Query OK, 3 rows affected (0.02 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> select date_add(a, interval 12345 DAY_HOUR) from t;
+--------------------------------------+
| date_add(a, interval 12345 DAY_HOUR) |
+--------------------------------------+
| 0001-04-27 09:00:00                  |
| 2003-05-13 09:00:00                  |
| 2003-05-29 09:00:00                  |
+--------------------------------------+
3 rows in set, 3 warnings (0.01 sec)

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

MySQL 8.0
mysql> create table t(a int);
Query OK, 0 rows affected (0.02 sec)

mysql> insert into t values(0),(20015),(20100);
Query OK, 3 rows affected (0.01 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> select date_add(a, interval 12345 DAY_HOUR) from t;
+--------------------------------------+
| date_add(a, interval 12345 DAY_HOUR) |
+--------------------------------------+
| NULL                                 |
| NULL                                 |
| NULL                                 |
+--------------------------------------+
3 rows in set, 3 warnings (0.01 sec)

3. What did you see instead (Required)

mysql> select date_add(a, interval 12345 DAY_HOUR) from t;
+--------------------------------------+
| date_add(a, interval 12345 DAY_HOUR) |
+--------------------------------------+
| 0001-04-27 09:00:00                  |
| 2003-05-13 09:00:00                  |
| 2003-05-29 09:00:00                  |
+--------------------------------------+
3 rows in set, 3 warnings (0.01 sec)

4. What is your TiDB version? (Required)

Master

[gengliqi]

/severity moderate