Details
-
Sub-task
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Setup
create table a as SELECT 100 as key, a.value as value FROM src LATERAL VIEW explode(array(40, 50, 60)) a as value limit 3;
Query:
select * from a left outer join a b on (a.key=b.key AND a.value=50 AND b.value=50) left outer join a c on (a.key=c.key AND a.value=60 AND c.value=60);
Expected Result:
100 40 NULL NULL NULL NULL 100 50 100 50 NULL NULL 100 60 NULL NULL 100 60
Actual Result:
100 40 NULL 50 NULL 60 100 50 100 50 NULL 60 100 60 NULL 50 100 60
Attachments
Issue Links
- relates to
-
CALCITE-1338 JoinProjectTransposeRule makes wrong transformation when the right child of left outer join has a RexLiteral project expression
- Closed