[
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)
