Function adddate() returns unexpected when connect with jdbc driver

[Damon-Guo]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

select adddate('2022-07-21',interval 1 day) from dual;

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

mysql> select adddate('2022-07-21',interval 1 day) from dual;
+--------------------------------------+
| adddate('2022-07-21',interval 1 day) |
+--------------------------------------+
| 2022-07-22 |
+--------------------------------------+
1 row in set (0.00 sec)

3. What did you see instead (Required)

return null when use jdbc driver 8.0.29

return ’2022-07-22 00:00:00.0‘ when use jdbc driver 5.1.49

4. What is your TiDB version? (Required)

mysql> select version();
+--------------------+
| version() |
+--------------------+
| 5.7.25-TiDB-v5.3.2 |
+--------------------+
1 row in set (0.00 sec)

[tangenta]

@Damon-Guo Is it convenient for you to put the MySQL's result here?

[Damon-Guo]

@Damon-Guo Is it convenient for you to put the MySQL's result here?

[tangenta]

This issue has been fixed by #28133. It takes effect in v5.4.0 or higher version TiDB.