[DRILL-831] NOT-IN query returns wrong results if right side is empty

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Assignee: Aman Sinha
• Reporter: Aman Sinha
• Created: 23/May/14 20:26
• Updated: 31/Jul/14 06:31
• Resolved: 28/May/14 19:27

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.