[
https://issues.apache.org/jira/browse/CALCITE-7286?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dmitry Sysolyatin updated CALCITE-7286:
---------------------------------------
Component/s: core
Affects Version/s: 1.41.0
Issue Type: Bug (was: Improvement)
> SqlToRelConverterTest.testJoinOnExists has wrong plan
> -----------------------------------------------------
>
> Key: CALCITE-7286
> URL: https://issues.apache.org/jira/browse/CALCITE-7286
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.41.0
> Reporter: Dmitry Sysolyatin
> Priority: Major
>
> It looks like the plan for this test is missing variables set. The variable
> `$cor0` is used, but there’s no information about where it was defined.
> {code}
> <TestCase name="testJoinOnExists">
> <Resource name="sql">
> <![CDATA[select * from emp left join dept
> on emp.empno = 1
> or exists (select deptno from emp where empno > dept.deptno + 5)]]>
> </Resource>
> <Resource name="plan">
> <![CDATA[
> LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4],
> SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8], DEPTNO0=[$9], NAME=[$10])
> LogicalJoin(condition=[OR(=($0, 1), EXISTS({
> LogicalFilter(condition=[>($0, +($cor0.DEPTNO0, 5))])
> LogicalTableScan(table=[[CATALOG, SALES, EMP]])
> }))], joinType=[left])
> LogicalTableScan(table=[[CATALOG, SALES, EMP]])
> LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
> ]]>
> </Resource>
> </TestCase>
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
