Interval() with expressions is not working in Tidb

[ramanich1]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

SET sql_mode = 'NO_ENGINE_SUBSTITUTION';
SELECT (INTERVAL(1,0,1,2) + 5) * 7 + INTERVAL(1,0,1,2) / 2;
SELECT INTERVAL(0,(1*5)/2) + INTERVAL(5,4,3);

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

mysql> SELECT (INTERVAL(1,0,1,2) + 5) * 7 + INTERVAL(1,0,1,2) / 2;
+-----------------------------------------------------+
| (INTERVAL(1,0,1,2) + 5) * 7 + INTERVAL(1,0,1,2) / 2 |
+-----------------------------------------------------+
|                                             50.0000 |
+-----------------------------------------------------+
1 row in set (0.00 sec)

mysql> SELECT INTERVAL(0,(1*5)/2) + INTERVAL(5,4,3);
+---------------------------------------+
| INTERVAL(0,(1*5)/2) + INTERVAL(5,4,3) |
+---------------------------------------+
|                                     2 |
+---------------------------------------+
1 row in set (0.00 sec)

3. What did you see instead (Required)

mysql> SELECT (INTERVAL(1,0,1,2) + 5) * 7 + INTERVAL(1,0,1,2) / 2;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 58 near "" 
mysql> SELECT INTERVAL(0,(1*5)/2) + INTERVAL(5,4,3);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 44 near "" 

4. What is your TiDB version? (Required)

| Release Version: v5.4.0-alpha-264-g6efa36df6
Edition: Community
Git Commit Hash: 6efa36df6cff325106f67ecfe3d79816ba37ca6a
Git Branch: master
UTC Build Time: 2021-11-29 16:57:51
GoVersion: go1.17.2
Race Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |

[Defined2014]

Seems the problem is caused by precedence for interval.

mysql> SELECT (INTERVAL(0,(1*5)/2)) + (INTERVAL(5,4,3));
+-------------------------------------------+
| (INTERVAL(0,(1*5)/2)) + (INTERVAL(5,4,3)) |
+-------------------------------------------+
|                                         2 |
+-------------------------------------------+
1 row in set (0.01 sec)

[github-actions]

Please check whether the issue should be labeled with 'affects-x.y' or 'fixes-x.y.z', and then remove 'needs-more-info' label.