[jira] [Resolved] (CALCITE-7698) RelDecorrelator throws AssertionError when decorrelating a correlated sub-query with outer join

["Sergey Nuyanzin (Jira)" <ji...@apache.org>]

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

Sergey Nuyanzin resolved CALCITE-7698.
--------------------------------------
    Fix Version/s: 1.43.0
       Resolution: Fixed

> RelDecorrelator throws AssertionError when decorrelating a correlated sub-query with outer join
> -----------------------------------------------------------------------------------------------
>
>                 Key: CALCITE-7698
>                 URL: https://issues.apache.org/jira/browse/CALCITE-7698
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>            Reporter: Sergey Nuyanzin
>            Assignee: Sergey Nuyanzin
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 1.43.0
>
>
> sql to reproduce the issue
> {code:sql}
>   SELECT * FROM emp WHERE EXISTS (
>     SELECT * FROM (SELECT * FROM dept
>       WHERE dept.deptno = emp.deptno AND dept.deptno > 100) s
>     LEFT JOIN bonus ON s.name = bonus.ename AND emp.ename = bonus.job)
> {code}
> it throws
> {noformat}
> java.lang.AssertionError
> 	at org.apache.calcite.sql2rel.RelDecorrelator.decorrelateRel(RelDecorrelator.java:1929)
> 	at org.apache.calcite.sql2rel.RelDecorrelator.decorrelateRel(RelDecorrelator.java:1895)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	at java.lang.reflect.Method.invoke(Method.java:498)
> 	at org.apache.calcite.util.ReflectUtil$2.invoke(ReflectUtil.java:533)
> 	at org.apache.calcite.sql2rel.RelDecorrelator.getInvoke(RelDecorrelator.java:1046)
> {noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)