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)

Reply via email to