Steve Carlin created IMPALA-13429:
-------------------------------------
Summary: Calcite planner: Outer join query with nonequi conjunct
crashes Impala server
Key: IMPALA-13429
URL: https://issues.apache.org/jira/browse/IMPALA-13429
Project: IMPALA
Issue Type: Sub-task
Reporter: Steve Carlin
The server is crashing on the following query:
select * from alltypesagg a left join altypesagg_dup b on (a.id = b.id and
a.month = a.id)
The reason is because "a.month=a.id" is being treated as an "equiconjunct",
meaning that it places this conjunct as a join between two different tables.
But this conjunct compares two columns in the same table.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
