[IMPALA-2643] Nested inline view produces incorrect result when referencing the same column implicitly

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 2.3.0
• Fix Version/s: Impala 2.5.0, Impala 2.3.2, Impala 2.2.10
• Component/s: Frontend
• Labels: correctness
• Target Version: Impala 2.5.0, Impala 2.3.2
• Assignee: Huaisi Xu
• Reporter: Huaisi Xu
• Created: 06/Nov/15 00:51
• Updated: 11/Apr/19 06:48
• Resolved: 19/Jan/16 16:23

Description

Reproduce step:

CREATE TABLE t (a int);
INSERT INTO TABLE t VALUES(NULL);
select count(*) from t;     =>  1
create view vv (aa, bb) as select a aa, a bb from t;
select count(*) from vv;     =>  0

In query plan there is predicates: a = a, and this filters out null.

This affects view because impala rewrites this view to nested select statement.

Issue Links

• is related to: IMPALA-8386 Incorrect predicate in a left outer join query