Result of function QUARTER/DATE_FORMAT is different from MySQL.

[SunRunAway]

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 QUARTER( 0 ), QUARTER( 0.0 );

2. What did you expect to see?

mysql> select QUARTER( 0 ), QUARTER( 0.0 );
+--------------+----------------+
| QUARTER( 0 ) | QUARTER( 0.0 ) |
+--------------+----------------+
|            0 |              0 |
+--------------+----------------+
1 row in set (0.00 sec)

3. What did you see instead?

mysql> select QUARTER( 0 ), QUARTER( 0.0 );
+--------------+----------------+
| QUARTER( 0 ) | QUARTER( 0.0 ) |
+--------------+----------------+
|         NULL |           NULL |
+--------------+----------------+
1 row in set, 2 warnings (0.00 sec)

mysql> show warnings;
+---------+------+--------------------------------------------------------+
| Level   | Code | Message                                                |
+---------+------+--------------------------------------------------------+
| Warning | 1292 | Incorrect datetime value: '0000-00-00 00:00:00.000000' |
| Warning | 1292 | invalid time format: '0.0'                             |
+---------+------+--------------------------------------------------------+
2 rows in set (0.00 sec)

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

[SunRunAway]

Function DATE_FORMAT meets the same problem.

In MySQL:

mysql> select DATE_FORMAT(0, 0);
+-------------------+
| DATE_FORMAT(0, 0) |
+-------------------+
| 0                 |
+-------------------+
1 row in set (0.00 sec)

In TiDB:

mysql> select DATE_FORMAT(0, 0);
+-------------------+
| DATE_FORMAT(0, 0) |
+-------------------+
| NULL              |
+-------------------+
1 row in set, 1 warning (0.00 sec)

mysql> show warnings;
+---------+------+--------------------------------------------------------+
| Level   | Code | Message                                                |
+---------+------+--------------------------------------------------------+
| Warning | 1292 | Incorrect datetime value: '0000-00-00 00:00:00.000000' |
+---------+------+--------------------------------------------------------+
1 row in set (0.00 sec)

[tiancaiamao]

@SunRunAway Would you like to solve it?

[SunRunAway]

@tiancaiamao #12488 is on going

[ekalinin]

The issue could be closed now. Related PR just was merged.