Vineet Garg created HIVE-15183: ---------------------------------- Summary: Wrong result with NOT IN involving null values Key: HIVE-15183 URL: https://issues.apache.org/jira/browse/HIVE-15183 Project: Hive Issue Type: Bug Components: Logical Optimizer Reporter: Vineet Garg Assignee: Vineet Garg
{noformat} Reproducer {noformat} {code} 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); {code} Query: {code} select * from fixOb where j NOT IN (select i from t7 where t7.j=fixOb.j); {code} Expected Result {noformat} i | j ----+---- -1 | 15 {noformat} Actual Result {noformat} No result {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)