Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL)
-
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