Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.0.6
Description
Notice the difference between the two expressions:
mysql> select '10:10:10'+interval 1 minute, time('10:10:10')+interval 1 minute;
|
+------------------------------+------------------------------------+
|
| '10:10:10'+interval 1 minute | time('10:10:10')+interval 1 minute |
|
+------------------------------+------------------------------------+
|
| 2010-10-10 00:01:00 | 10:11:10 |
|
+------------------------------+------------------------------------+
|
1 row in set (0.00 sec)
|
The first expression should return '10:11:10',
similar to the second one.
Let's do it only in 10.x.
Note, another temporal hybrid function ADDTIME() seems to work correctly:
mysql> select addtime('10:10:10',1), addtime('2001-01-01 10:10:10',1);
|
+-----------------------+----------------------------------+
|
| addtime('10:10:10',1) | addtime('2001-01-01 10:10:10',1) |
|
+-----------------------+----------------------------------+
|
| 10:10:11 | 2001-01-01 10:10:11 |
|
+-----------------------+----------------------------------+
|
1 row in set (0.00 sec)
|