You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "James Starr (Jira)" <ji...@apache.org> on 2021/09/22 19:02:00 UTC

[jira] [Created] (CALCITE-4791) RelBuilder.join incorrectly rewrites correlated conditions

James Starr created CALCITE-4791:
------------------------------------

             Summary: RelBuilder.join incorrectly rewrites correlated conditions
                 Key: CALCITE-4791
                 URL: https://issues.apache.org/jira/browse/CALCITE-4791
             Project: Calcite
          Issue Type: Improvement
          Components: core
            Reporter: James Starr
            Assignee: James Starr


When are correlated join is rewritten to correlate + filters, if the conditions contains a subquery with correlate variable from the right side, the result rewrite is incorrect.  The correlated variable while be indexed from the context of the join, however in the case of right side, this should be shifted by the size of the left index.





--
This message was sent by Atlassian Jira
(v8.3.4#803005)