Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.3.12, 5.5.36, 10.0.10
-
Component/s: None
-
Labels:None
Description
Conversion of an out-of-range number to TIME does not produce a warning:
mysql> SELECT CAST(9000000 AS TIME);
|
+-----------------------+
|
| CAST(9000000 AS TIME) |
|
+-----------------------+
|
| 838:59:59 |
|
+-----------------------+
|
1 row in set (0.00 sec)
|
MySQL-5.5 returns 838:59:59 with a warning, which looks correct.
MySQL-5.6 returns NULL with a warning, which looks wrong.
Attachments
Issue Links
- blocks
-
MDEV-6001 Merge tests for MySQL WL#946 TIME/DATETIME/TIMESTAMP with fractional precision
-
- Stalled
-