[
https://issues.apache.org/jira/browse/CALCITE-4042?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17125879#comment-17125879
]
Haisheng Yuan commented on CALCITE-4042:
----------------------------------------
Never mind, I will close CALCITE-3911.
> JoinCommuteRule must not match SEMI / ANTI join
> -----------------------------------------------
>
> Key: CALCITE-4042
> URL: https://issues.apache.org/jira/browse/CALCITE-4042
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.23.0
> Reporter: Ruben Q L
> Assignee: Ruben Q L
> Priority: Minor
> Labels: pull-request-available
> Fix For: 1.24.0
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> JoinCommuteRule must not match SEMI / ANTI join, because these types cannot
> be swapped.
> This is a minor issue, because the "default" JoinCommuteRule.INSTANCE matches
> only INNER joins. However, there is another version of the rule
> (JoinCommuteRule.SWAP_OUTER, currently only used in a few unit tests), to
> match also outer joins, which could potentially match a SEMI / ANTI join.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
