[MDEV-4652] Wrong result for CONCAT(GREATEST(TIME('00:00:01'),TIME('00:00:00'))) Created: 2013-06-13  Updated: 2013-08-12  Resolved: 2013-08-12

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

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


 Description   

This query:

SELECT CONCAT(GREATEST(TIME('00:00:01'),TIME('00:00:00')));

returns "0000-00-00 00:00:01.000000".

The expected result is "00:00:01.000000".

Note,

SELECT GREATEST(TIME('00:00:01'),TIME('00:00:00'));

works fine and returns "00:00:01.000000".

MySQL-5.5 and MySQL-5.6 are not affected.

 Comments   
Comment by Alexander Barkov [ 2013-08-12 ]

Fixed in 5.3.13 and 5.5.32.

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