Aman Sinha created DRILL-831:
--------------------------------
Summary: NOT-IN query returns wrong results if right side is empty
Key: DRILL-831
URL: https://issues.apache.org/jira/browse/DRILL-831
Project: Apache Drill
Issue Type: Bug
Reporter: Aman Sinha
Assignee: Aman Sinha
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.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
