Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
0: jdbc:drill:zk=local> select count from region r1 where r1.r_regionkey not in (select r2.r_regionkey from region r2 where r2.r_regionkey = 10);
--
--
--
No rows selected
This correct result is 5 rows since right side of the NOT IN produces 0 rows.