[jira] [Created] (IMPALA-15268) Calcite Planner: Fix failure with no equality join condition

["Steve Carlin (Jira)" <ji...@apache.org>]

Steve Carlin created IMPALA-15268:
-------------------------------------

             Summary: Calcite Planner: Fix failure with no equality join condition
                 Key: IMPALA-15268
                 URL: https://issues.apache.org/jira/browse/IMPALA-15268
             Project: IMPALA
          Issue Type: Sub-task
            Reporter: Steve Carlin


    The following query fails after upgrading to 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;

    

    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)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org