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

[Mihai Budiu (Jira)]

Mihai Budiu created CALCITE-7873:
------------------------------------

             Summary: 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


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)