Wrong result for CONCAT(GREATEST(TIME('00:00:01'),TIME('00:00:00')))

Description

This query:

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

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

Note,

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

MySQL-5.5 and MySQL-5.6 are not affected.

Environment

None

Status

Assignee

Alexander Barkov

Reporter

Alexander Barkov

Labels

None

External issue ID

None

External issue ID

None

Fix versions

Affects versions

Priority

Minor
Configure