You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by "Ruben Quesada Lopez (JIRA)" <ji...@apache.org> on 2019/03/06 13:47:02 UTC

[jira] [Created] (CALCITE-2898) RelOptUtil#splitJoinCondition must consider RexFieldAccess referencing RexInputRef

Ruben Quesada Lopez created CALCITE-2898:
--------------------------------------------

             Summary: RelOptUtil#splitJoinCondition must consider RexFieldAccess referencing RexInputRef
                 Key: CALCITE-2898
                 URL: https://issues.apache.org/jira/browse/CALCITE-2898
             Project: Calcite
          Issue Type: Bug
    Affects Versions: 1.18.0
            Reporter: Ruben Quesada Lopez


{{RelOptUtil#splitJoinCondition}} "Splits out the equi-join components of a join condition, and returns what's left (remaining join filters that are not equijoins)". This works fine in case of RexInputRef operands in the condition (e.g. $0 = $1), but if any of the operands is a RexFieldAccess referencing a RexInputRef (e.g. $0 = $1.id), then condition will NOT be detected as an equi-join and will be returned as it were a non-equijoin. 
This can lead to undesired consequences, e.g in {{JoinInfo#of}} which will return NonEquiJoinInfo instead of an EquiJoinInfo.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)