Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5, 10.0, 10.1, 10.2, 10.3, 10.4
-
None
Description
SELECT MAKETIME(900,0,0.111); |
+-----------------------+
|
| MAKETIME(900,0,0.111) |
|
+-----------------------+
|
| 838:59:59.000 |
|
+-----------------------+
|
This is wrong. The expected result is 838:59:59.999, i.e. the maximum possible value with 3 fractional digits, according to the last argument precision.
Attachments
Issue Links
- blocks
-
MDEV-16991 Rounding vs truncation for TIME, DATETIME, TIMESTAMP
- Closed