Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
None
Description
SELECT TIME(8395960), TIME('839:59:60'); |
+---------------+-------------------+
|
| TIME(8395960) | TIME('839:59:60') |
|
+---------------+-------------------+
|
| 838:59:59 | NULL |
|
+---------------+-------------------+
|
1 row in set, 2 warnings (0.00 sec)
|
Looks wrong. Both columns should be NULL,
A value with a bad second value 60 should not adjust to the maximum time value.
Attachments
Issue Links
- relates to
-
MDEV-16991 Rounding vs truncation for TIME, DATETIME, TIMESTAMP
-
- Closed
-