TIME_FORMAT is not compatible with MySQL

[qw4990]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. What did you do?
   If possible, provide a recipe for reproducing the error.

SELECT TIME_FORMAT("24:00:00", '%r');
SELECT TIME_FORMAT("25:00:00", '%r');
SELECT TIME_FORMAT("24:00:00", '%l %p');

2. What did you expect to see?
   In Mysql

mysql> SELECT TIME_FORMAT("24:00:00", '%r');
+-------------------------------+
| TIME_FORMAT("24:00:00", '%r') |
+-------------------------------+
| 12:00:00 AM                   |
+-------------------------------+
1 row in set (0.00 sec)

mysql> SELECT TIME_FORMAT("25:00:00", '%r');
+-------------------------------+
| TIME_FORMAT("25:00:00", '%r') |
+-------------------------------+
| 01:00:00 AM                   |
+-------------------------------+
1 row in set (0.00 sec)

mysql> SELECT TIME_FORMAT("24:00:00", '%l %p');
+----------------------------------+
| TIME_FORMAT("24:00:00", '%l %p') |
+----------------------------------+
| 12 AM                            |
+----------------------------------+
1 row in set (0.00 sec)

3. What did you see instead?
   In TiDB

mysql> SELECT TIME_FORMAT("24:00:00", '%r');
+-------------------------------+
| TIME_FORMAT("24:00:00", '%r') |
+-------------------------------+
| 12:00:00 PM                   |
+-------------------------------+
1 row in set (0.00 sec)

mysql> SELECT TIME_FORMAT("25:00:00", '%r');
+-------------------------------+
| TIME_FORMAT("25:00:00", '%r') |
+-------------------------------+
| 13:00:00 PM                   |
+-------------------------------+
1 row in set (0.00 sec)

mysql> SELECT TIME_FORMAT("24:00:00", '%l %p');
+----------------------------------+
| TIME_FORMAT("24:00:00", '%l %p') |
+----------------------------------+
| 0 AM                             |
+----------------------------------+
1 row in set (0.00 sec)

4. What version of TiDB are you using (tidb-server -V or run select tidb_version(); on TiDB)?

+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version()                                                                                                                                                                                                                                                                                                                           |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v3.0.0-beta-227-g06183393e-dirty
Git Commit Hash: 06183393ed536aa248248b72d4bf9f5010947f66
Git Branch: master
UTC Build Time: 2019-03-15 08:22:53
GoVersion: go version go1.12 darwin/amd64
Race Enabled: false
TiKV Min Version: 2.1.0-alpha.1-ff3dd160846b7d1aed9079c389fc188f7f5ea13e
Check Table Before Drop: false |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+