[MDEV-4862] Wrong result of MAKETIME(0, 0, 59.9) Created: 2013-08-08  Updated: 2013-08-09  Resolved: 2013-08-09

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.3, 5.5.32, 5.3.12
Fix Version/s: None

Type: Bug Priority: Minor
Reporter: Alexander Barkov Assignee: Alexander Barkov
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-4724 Some temporal functions do not preser... Closed

 Description   

MariaDB [test]> SELECT MAKETIME(0, 0, 59.9);
+----------------------+
| MAKETIME(0, 0, 59.9) |
+----------------------+
| NULL                 |
+----------------------+

The above result is wrong.
The expected result is '00:00:59.9'.

Note: MySQL-5.6 correctly returns '00:00:59.9'.


Generated at Thu Feb 08 06:59:45 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.