Closed pkommoju closed 3 years ago
Given the standard table a
select * from a where not (a1 = 1 or a3 = 4)
is producing wrong results, 0,1,2,3 1,2,3,4 2,3,4,5
instead of the correct output 0,1,2,3
It looks like NOT is disappearing because select * from a where a1 not in (2) produces 2,3,4,5
filter is null in the parsed statement itself if NOT is used in this manner.
select * from a where not a1 in (1) Produces ERROR[Optimizer]: not on .a1 is not supported.
Given the standard table a
select * from a where not (a1 = 1 or a3 = 4)
is producing wrong results, 0,1,2,3 1,2,3,4 2,3,4,5
instead of the correct output 0,1,2,3
It looks like NOT is disappearing because select * from a where a1 not in (2) produces 2,3,4,5
filter is null in the parsed statement itself if NOT is used in this manner.
select * from a where not a1 in (1) Produces ERROR[Optimizer]: not on .a1 is not supported.