You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2014/08/15 01:17:18 UTC

[jira] [Created] (OPTIQ-374) NOT EXISTS and semi-anti-join

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)