[jira] [Created] (HIVE-13733) CTE + "IS NULL" predicate + column aliasing as existing column leads to wrong results

["Dudu Markovitz (JIRA)" <ji...@apache.org>]

Dudu Markovitz created HIVE-13733:
-------------------------------------

             Summary: CTE + "IS NULL" predicate + column aliasing as existing column leads to wrong results 
                 Key: HIVE-13733
                 URL: https://issues.apache.org/jira/browse/HIVE-13733
             Project: Hive
          Issue Type: Bug
    Affects Versions: 1.1.0
            Reporter: Dudu Markovitz


hive> create table t (i int,a string,b string);
hive> insert into t values (1,'hello','world'),(2,'bye',null);
hive> select * from t where t.b is null;
2	bye	NULL

This is wrong, all 3 columns should return the same value - t.a.

hive> with cte as (select t.a as a,t.a as b,t.a as c from t where t.b is null) select * from cte;
bye	NULL	bye


However, this are right:

hive> select t.a as a,t.a as b,t.a as c from t where t.b is null;
bye	bye	bye


hive> with cte as (select t.a as a,t.a as b,t.a as c from t where t.b is not null) select * from cte;OK
hello	hello	hello




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