Julian Hyde created OPTIQ-374:
---------------------------------
Summary: NOT EXISTS and semi-anti-join
Key: OPTIQ-374
URL: https://issues.apache.org/jira/browse/OPTIQ-374
Project: Optiq
Issue Type: Bug
Reporter: Julian Hyde
Assignee: Julian Hyde
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.2#6252)