jin xing created CALCITE-3373: --------------------------------- Summary: Decorrelate boolean context IN or existential subquery directly into SEMI/ANTI join Key: CALCITE-3373 URL: https://issues.apache.org/jira/browse/CALCITE-3373 Project: Calcite Issue Type: Improvement Components: core Reporter: jin xing
The current approach to generate semi-join from IN/EXISTS is as below: # Decorrelation # Transforming by SemiJoinRule to get a semi-join A more straightforward approach is to generate the semi-join right in Decorrelation. What's more, we should also have an approach to generate anti-join right in Decorrelation.(Currently there's no analogous rule to SemiJoinRule for anti-join) -- This message was sent by Atlassian Jira (v8.3.4#803005)