Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.6
Description
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.