[jira] [Created] (HIVE-14027) NULL values produced by left outer join do not behave as NULL

["Vaibhav Gumashta (JIRA)" <ji...@apache.org>]

Vaibhav Gumashta created HIVE-14027:
---------------------------------------

             Summary: NULL values produced by left outer join do not behave as NULL
                 Key: HIVE-14027
                 URL: https://issues.apache.org/jira/browse/HIVE-14027
             Project: Hive
          Issue Type: Bug
          Components: Query Processor
    Affects Versions: 2.0.1, 1.2.1
            Reporter: Vaibhav Gumashta
            Assignee: Vaibhav Gumashta


Consider the following setup:
{code}
create table tbl (n bigint, t string); 

insert into tbl values (1, 'one'); 
insert into tbl values(2, 'two');

select a.n, a.t, isnull(b.n), isnull(b.t) from (select * from tbl where n = 1) a  left outer join  (select * from tbl where 1 = 2) b on a.n = b.n;

1    one    false    true
{code}

The query should return true for isnull(b.n).

I've tested by inserting a row with null value for the bigint column into tbl, and isnull returns true in that case. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)