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/14 01:20:12 UTC

[jira] [Created] (OPTIQ-371) Cannot implement JOIN whose ON clause contains mixed equi and theta

Julian Hyde created OPTIQ-371:
---------------------------------

             Summary: Cannot implement JOIN whose ON clause contains mixed equi and theta
                 Key: OPTIQ-371
                 URL: https://issues.apache.org/jira/browse/OPTIQ-371
             Project: Optiq
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde


Cannot implement a JOIN whose ON clause contains a mixture of equi and theta conditions. The equivalent query expressed using WHERE can be implemented.

The solution is to make EnumerableJoinRule split the condition into equi and non-equi parts, provided that the join type is inner.



--
This message was sent by Atlassian JIRA
(v6.2#6252)