[#MDEV-4862] Wrong result of MAKETIME(0, 0, 59.9)

[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:

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.