[HIVE-15183] Wrong result with NOT IN involving null values

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Cannot Reproduce
• Component/s: Logical Optimizer
• Labels: sub-query
• Assignee: Vineet Garg
• Reporter: Vineet Garg
• Created: 11/Nov/16 03:19
• Updated: 16/Dec/16 22:11
• Resolved: 16/Dec/16 22:11

Description

Reproducer

create table t7(i int, j int);
create table fixOb(i int, j int);
insert into t7 values(null, 5);
insert into t7 values(4, 15);

insert into fixOb values(-1, 5);
insert into fixOb values(-1, 15);

Query:

 select * from fixOb where j NOT IN (select i from t7 where t7.j=fixOb.j);  

Expected Result

i  | j  
----+----
 -1 | 15

Actual Result

 No result