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

Posted to issues@calcite.apache.org by "Mihai Budiu (Jira)" <ji...@apache.org> on 2026/10/22 01:38:00 UTC

[jira] [Commented] (CALCITE-7873) Correlated subqueries in ON JOIN conditions crash the compiler with expand=true

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

Mihai Budiu commented on CALCITE-7873:
--------------------------------------

I will submit a fix which has many queries, some of which crash the compiler, and some of which produce incorrect results, but they are all due to the same failure to expand properly the subqueries in the ON condition.

> Correlated subqueries in ON JOIN conditions crash the compiler with expand=true
> -------------------------------------------------------------------------------
>
>                 Key: CALCITE-7873
>                 URL: https://issues.apache.org/jira/browse/CALCITE-7873
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>    Affects Versions: 1.42.0
>            Reporter: Mihai Budiu
>            Assignee: Mihai Budiu
>            Priority: Minor
>
> Here is quidem test which fails:
> {code:java}
> select e.ename, d.dname
> from emp as e join dept as d
> on e.deptno = d.deptno
>   and e.sal = (select max(s.sal) from emp as s)
> order by e.ename; {code}



--
This message was sent by Atlassian Jira
(v10.3.26#10030026)