[
https://issues.apache.org/jira/browse/CALCITE-4475?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17272013#comment-17272013
]
Stamatis Zampetakis commented on CALCITE-4475:
----------------------------------------------
Cannot say for sure without putting some more though into it. The original rule
does not work for inner joins since removing rows before the join could lead to
wrong results; aren't you risk the same when you remove rows before the
semi/anti join?
> New Sort SEMI/ANTI Join Transpose optimization
> ----------------------------------------------
>
> Key: CALCITE-4475
> URL: https://issues.apache.org/jira/browse/CALCITE-4475
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: Ruben Q L
> Priority: Major
>
> If I am not mistaken, the optimization that is currently applied by
> {{SortJoinTransposeRule}} for LEFT and RIGHT joins could also by applied to
> SEMI / ANTI joins (it would be very similar to the current LEFT join
> optimization).
> It is proposed to either improve this rule to cover SEMI / ANTI joins or
> create a new dedicated rule for this matter.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
