[IMPALA-2478] Incorrect predicate assignment with outer-joined correlated inline view.

• Type: Bug
• Status: Resolved
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: Impala 2.3.0
• Fix Version/s: Impala 2.3.0
• Labels: correctness nested_types
• Target Version: Impala 2.3.0
• Assignee: Dimitris Tsirogiannis
• Reporter: Alexander Behm
• Created: 04/Oct/15 05:48
• Updated: 07/Oct/15 00:22
• Resolved: 07/Oct/15 00:22

Description

The predicate assignment is not correct in this query:

select id from functional.allcomplextypes t1 left outer join
  (select pos, item from t1.int_array_col t2) v
where t1.id > v.pos and v.item = 1

01:SUBPLAN
|
|--04:NESTED LOOP JOIN [RIGHT OUTER JOIN]
|  |  predicates: t1.id > pos <--- Bug: t2.item = 1 should be here as well!
|  |
|  |--02:SINGULAR ROW SRC
|  |
|  03:UNNEST [t1.int_array_col t2]
|
00:SCAN HDFS [functional.allcomplextypes t1]
   partitions=0/0 files=0 size=0B
   predicates on t2: t2.item = 1

Looks like the scan incorrectly marks the source of the propagated t2.item = 1 predicate as assigned.