[
https://issues.apache.org/jira/browse/CALCITE-374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde updated CALCITE-374:
--------------------------------
Labels: sub-query (was: )
> NOT EXISTS and semi-anti-join
> -----------------------------
>
> Key: CALCITE-374
> URL: https://issues.apache.org/jira/browse/CALCITE-374
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
> Labels: sub-query
>
> EXISTS can be converted to a SemiJoin via RelDecorrelator and the
> SemiJoinRule. NOT EXISTS currently requires access to the boolean "indicator
> column", therefore the SemiJoinRule does not work.
> We need to add a 'boolean negate' member to SemiJoinRel, and fix up
> SemiJoinRule to generate it.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
