[
https://issues.apache.org/jira/browse/CALCITE-6606?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17886428#comment-17886428
]
xiong duan commented on CALCITE-6606:
-------------------------------------
Hi [~brandon.chong] .Do we have an SQL that can reproduce this problem based on
the current main branch? The SQL will help everyone quickly understand this
issue.
> RelDecorrelator Can't decorrelate JOIN conditions with correlate variables
> --------------------------------------------------------------------------
>
> Key: CALCITE-6606
> URL: https://issues.apache.org/jira/browse/CALCITE-6606
> Project: Calcite
> Issue Type: Bug
> Reporter: Brandon Chong
> Priority: Minor
>
> If we have a query plan like:
> Correlate(id = 0)
> BaseQuery
> Join(cor0.blah = $0)
> ...
>
>
> Then RelDecorrelator fails to decorrelate. My local workaround was to run
> FilterJoinRule.JoinConditionPushRule on the input before decorrelation.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
