Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: 10.0.3, 5.5.32, 5.3.13
-
Component/s: None
-
Labels:None
Description
This query:
SELECT CONCAT(GREATEST(TIME('00:00:01'),TIME('00:00:00'))); |
returns "0000-00-00 00:00:01.000000".
The expected result is "00:00:01.000000".
Note,
SELECT GREATEST(TIME('00:00:01'),TIME('00:00:00')); |
works fine and returns "00:00:01.000000".
MySQL-5.5 and MySQL-5.6 are not affected.