Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.1.6
-
Fix Version/s: 10.1.8
-
Component/s: Optimizer
-
Labels:
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.