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 05:19:18 UTC

[jira] [Resolved] (OPTIQ-371) Implement JOIN whose ON clause contains mixed equi and theta

     [ https://issues.apache.org/jira/browse/OPTIQ-371?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Julian Hyde resolved OPTIQ-371.
-------------------------------

    Resolution: Fixed

Fixed in http://git-wip-us.apache.org/repos/asf/incubator-optiq/commit/f25e0d83.

> 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)