[
https://issues.apache.org/jira/browse/CALCITE-3373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17932098#comment-17932098
]
Julian Hyde edited comment on CALCITE-3373 at 3/3/25 10:21 PM:
---------------------------------------------------------------
There's no need for a new issue. I don't have time to fix it, but I am happy to
talk about designs or to review PRs. Do you intend to fix this issue? If so,
feel free to assign it to yourself. It is currently unassigned, so I assume no
one is currently working on it.
[~viggoc], I briefly looked at your PR. It seems to make sense. I wonder
whether we could add this logic into {{SubQueryRemoveRule}}.
I think it should be helpful to modify the description of this case. Give an
example of a simple SQL query, and the relational algebra that would be
produced. Describe the requirements of the rule (e.g. queries that are a little
too complex for the rule to handle).
was (Author: julianhyde):
There's no need for a new issue. I don't have time to fix it, but I am happy to
talk about designs or to review PRs. Do you intend to fix this issue? If so,
feel free to assign it to yourself. It is currently unassigned, so I assume no
one is currently working on it.
> 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
> Priority: Major
> Attachments: image-2025-03-02-17-04-54-608.png
>
>
> 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 one is related to CALCITE-3367
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
