[MDEV-7146] NULLIF returns unexpected result with a YEAR field - Jira

XML

Word

Printable

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a YEAR(2));

INSERT INTO t1 VALUES (0);

SELECT a,NULLIF(a,2000),NULLIF(2001,a) FROM t1;

returns

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

| a    | NULLIF(a,2000) | NULLIF(2001,a) |

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

|   00 |           NULL |              1 |

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

This is Ok that YEAR=00 is compared as equal to 2000, but the return value for NULLIF(2001,a) does not look Ok. The expected values is 2001, not 1.