You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Haisheng Yuan (Jira)" <ji...@apache.org> on 2020/06/04 12:14:00 UTC
[jira] [Commented] (CALCITE-4042) JoinCommuteRule must not match
SEMI / ANTI join
[ https://issues.apache.org/jira/browse/CALCITE-4042?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17125868#comment-17125868 ]
Haisheng Yuan commented on CALCITE-4042:
----------------------------------------
Is it same issue? 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)