Function period_diff is not compatible with MySQL 8.0

[sourcelliu]

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.
   Function period_diff is not compatible with MySQL 8.0

2. What did you expect to see?
   MySQL 8.0:

mysql> SELECT PERIOD_diff(-00013,1);
ERROR 1210 (HY000): Incorrect arguments to period_diff

3. What did you see instead?
   TiDB

mysql>  SELECT PERIOD_diff(-00013,1);
+-----------------------+
| PERIOD_diff(-00013,1) |
+-----------------------+
|   2213609288845122194 |
+-----------------------+
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)?

mysql> select tidb_version();
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| tidb_version()                                                                                                                                                                                                                                                                                                                                             |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Release Version: v3.0.0-beta.1-218-g2f7241138-dirty
Git Commit Hash: 2f7241138adfc434f4b199ecae68fb83ad33b36b
Git Branch: myfeature-perioddiff
UTC Build Time: 2019-05-07 03:36:21
GoVersion: go version go1.11.4 darwin/amd64
Race Enabled: false
TiKV Min Version: 2.1.0-alpha.1-ff3dd160846b7d1aed9079c389fc188f7f5ea13e
Check Table Before Drop: false |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)