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)