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)
