Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5.36, 10.0.10
-
None
Description
mysql> SELECT DATE_ADD('2001-01-01 10:20:30',INTERVAL 250000000000.0 SECOND) AS c1, DATE_ADD('2001-01-01 10:20:30',INTERVAL 2000000000000000000.0 SECOND) AS c2;
|
+---------------------+---------------------+
|
| c1 | c2 |
|
+---------------------+---------------------+
|
| 9923-03-10 22:47:10 | 2001-01-01 10:20:30 |
|
+---------------------+---------------------+
|
The result for c1 is correct.
The result for c2 is wrong. It should be NULL with a warning reporting overflow.
Attachments
Issue Links
- blocks
-
MDEV-6001 Merge tests for MySQL WL#946 TIME/DATETIME/TIMESTAMP with fractional precision
-
- Stalled
-