[MDEV-8754] Wrong result for SELECT..WHERE year_field=2020 AND NULLIF(year_field,2010)='2020' - Jira

XML

Word

Printable

DROP TABLE IF EXISTS t1;

CREATE TABLE t1 (a YEAR);

INSERT INTO t1 VALUES (2010),(2020);

SELECT * FROM t1 WHERE a=2020;

SELECT * FROM t1 WHERE NULLIF(a,2010)='2020';

SELECT * FROM t1 WHERE a=2020 AND NULLIF(a,2010)='2020';

The first and the second SELECT queries correctly return one row, and third SELECT query erroneously returns emptu set.

blocks

MDEV-8728 Fix a number of problems in equal field and equal expression propagation

is blocked by

MDEV-8785 Wrong results for EXPLAIN EXTENDED...WHERE NULLIF(latin1_col, _utf8'a' COLLATE utf8_bin) IS NOT NULL