[
https://issues.apache.org/jira/browse/IMPALA-13429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Steve Carlin reassigned IMPALA-13429:
-------------------------------------
Assignee: Steve Carlin
> 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
> Assignee: Steve Carlin
> Priority: Major
> Fix For: Impala 4.5.0
>
>
> 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)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
