Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.0.3, 5.5.31, 5.1.67, 5.2.14, 5.3.12
-
None
-
None
Description
This query
mysql> select time('11111112233'); |
+---------------------+ |
| time('11111112233') | |
+---------------------+ |
| 838:59:59.999999 |
|
+---------------------+ |
1 row in set, 1 warning (0.00 sec) |
correctly adjusts (with a warning) the results to the maximum supported
value. However, if the string gets longer, it does not work any more:
mysql> select time('111111112233'); |
+----------------------+ |
| time('111111112233') | |
+----------------------+ |
| 11:22:33 |
|
+----------------------+ |
The last query should be fixed to adjust the TIME value and produce a warning.