[ https://issues.apache.org/jira/browse/HIVE-15183?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vineet Garg updated HIVE-15183: ------------------------------- Labels: sub-query (was: ) > 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 > Labels: sub-query > > Reproducer > {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)