[
https://issues.apache.org/jira/browse/IMPALA-15567?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Steve Carlin closed IMPALA-15567.
---------------------------------
Resolution: Duplicate
Duplicate of IMPALA-15268
> Calcite Planner: Avoid equality JoinRelationInfo when join elements are on
> the same side
> ----------------------------------------------------------------------------------------
>
> Key: IMPALA-15567
> URL: https://issues.apache.org/jira/browse/IMPALA-15567
> Project: IMPALA
> Issue Type: Sub-task
> Reporter: Steve Carlin
> Priority: Major
>
> The following query fails after upgrading to Calcite 1.41:
>
> select a.id, b.id, c.id, a.day, b.day, c.month, a.month, b.month
> from alltypesagg a join alltypesagg b on
> (a.id = b.id and a.month = b.day and b.month = 1 and b.month = b.day and
> a.day = b.day)
> left outer join alltypessmall c on
> (c.id = a.id and a.month = c.id and a.month=c.month)
> where a.id < 10;
> The problem lies with b.month=b.day where both parts of the predicate are
> from the same table.
> when running test
> query_test.test_join_queries.TestJoinQueries.test_outer_joins
>
> The reason is because a join condition contains =($0,$1), and both are on
> the
> same side. It cannot be pushed because JOIN_CONDITION_PUSH does not allow
> the push to the left side. So we need to skip over putting this into the
> equality constraints.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
