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 2019/04/01 18:14:00 UTC

[jira] [Commented] (CALCITE-2971) Correlated subquery in JOIN is failing

    [ https://issues.apache.org/jira/browse/CALCITE-2971?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16807049#comment-16807049 ] 

Julian Hyde commented on CALCITE-2971:
--------------------------------------

We have standardized on "sub-query". Sorry to be pedantic.

> Correlated subquery in JOIN is failing
> --------------------------------------
>
>                 Key: CALCITE-2971
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2971
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>            Reporter: Vineet Garg
>            Priority: Major
>              Labels: sub-query
>
> Following query if added in RelOptRulesTest tests throws an exception:
> {code:sql}
> select empno from sales.emp as r left join sales.dept as s on exists (select deptno from sales.emp where empno = s.deptno+20)
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)