[MDEV-17607] DATE(COALESCE(year_column)) returns a wrong result - Jira

XML

Word

Printable

CREATE OR REPLACE TABLE t1 (a YEAR);

INSERT INTO t1 VALUES (NULL);

SELECT COALESCE(a), DATE(COALESCE(a)) FROM t1;

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

| COALESCE(a) | DATE(COALESCE(a)) |

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

|        NULL | 0000-00-00        |

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

The result for DATE(COALESCE(a)) is wrong. It should be NULL.

relates to

MDEV-16926 CAST(COALESCE(year_field)) returns wrong value