[MDEV-17244] MAKETIME(900,0,0.111) returns a wrong result Created: 2018-09-19  Updated: 2018-09-20  Resolved: 2018-09-20

Status: Closed
Project: MariaDB Server
Component/s: Temporal Types
Affects Version/s: 5.5, 10.0, 10.1, 10.2, 10.3, 10.4
Fix Version/s: 5.5.62, 10.0.37, 10.2.18, 10.3.11, 10.4.0, 10.1.37

Type: Bug Priority: Major
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-16991 Rounding vs truncation for TIME, DATE... Closed

 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.
Generated at Thu Feb 08 08:35:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.