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

Posted to issues@calcite.apache.org by "jin xing (Jira)" <ji...@apache.org> on 2019/09/22 15:44:00 UTC

[jira] [Updated] (CALCITE-3366) RelDecorrelator supports Union

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

jin xing updated CALCITE-3366:
------------------------------
    Description: 
This issue proposes to support decorrelation for below sql
{code:java}
SELECT deptno FROM dept where exists
(SELECT 1 FROM emp where sal < 100 and emp.deptno=dept.deptno
union all
SELECT 1 FROM emp where sal > 200 and emp.deptno=dept.deptno)
{code}

> RelDecorrelator supports Union
> ------------------------------
>
>                 Key: CALCITE-3366
>                 URL: https://issues.apache.org/jira/browse/CALCITE-3366
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: jin xing
>            Priority: Major
>
> This issue proposes to support decorrelation for below sql
> {code:java}
> SELECT deptno FROM dept where exists
> (SELECT 1 FROM emp where sal < 100 and emp.deptno=dept.deptno
> union all
> SELECT 1 FROM emp where sal > 200 and emp.deptno=dept.deptno)
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)