[#MDEV-17736] Inconsistency between DATE('0') and TIME('0')

[MDEV-17736] Inconsistency between DATE('0') and TIME('0') Created: 2018-11-16 Updated: 2020-06-12
Status:	Open
Project:	MariaDB Server
Component/s:	None
Affects Version/s:	5.5, 10.0, 10.1, 10.2, 10.3, 10.4
Fix Version/s:	10.4

Type:

Bug

Priority:

Major

Reporter:

Alexander Barkov

Assignee:

Alexander Barkov

Resolution:

Unresolved

Votes:

Labels:

None

Issue Links:

Relates
relates to	~~MDEV-21553~~	DATE(IFNULL(XXX, 0)) is not returning...	Closed

Description

SELECT DATE('0'), TIME('0');

+-----------+-----------+

| DATE('0') | TIME('0') |

+-----------+-----------+

| NULL      | 00:00:00  |

+-----------+-----------+

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