[
https://issues.apache.org/jira/browse/CALCITE-7350?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Silun Dong reassigned CALCITE-7350:
-----------------------------------
Assignee: Zhen Chen (was: Silun Dong)
> Missing allowEmptyOutputFromRewrite parameter in
> TopDownGeneralDecorrelator.unnestInternal
> ------------------------------------------------------------------------------------------
>
> Key: CALCITE-7350
> URL: https://issues.apache.org/jira/browse/CALCITE-7350
> Project: Calcite
> Issue Type: Improvement
> Reporter: Zhen Chen
> Assignee: Zhen Chen
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.42.0
>
>
> {{The method definition of TopDownGeneralDecorrelator is incorrect. The
> method}}
> {{_public RelNode unnestInternal(RelNode other)_}}
> {{should perhaps be}}
> {{{}_public RelNode unnestInternal(RelNode other, boolean
> allowEmptyOutputFromRewrite)_{}}}.
>
> {code:java}
> @Test void testUnnestInternalMissingParameter() {
> final String sql = "SELECT empno FROM emp e"
> + " WHERE sal > some(SELECT avg(sal) over (partition by deptno) from
> emp_b b"
> + " where b.deptno = e.deptno)";
> sql(sql)
> .withRule(
> CoreRules.FILTER_SUB_QUERY_TO_MARK_CORRELATE,
> CoreRules.PROJECT_TO_LOGICAL_PROJECT_AND_WINDOW)
> .withLateDecorrelate(true)
> .withTopDownGeneralDecorrelate(true)
> .check();
> } {code}
> Running this case will throw following:
> Method not found: unnestInternal([interface org.apache.calcite.rel.RelNode,
> boolean])
> java.lang.IllegalArgumentException: Method not found:
> unnestInternal([interface org.apache.calcite.rel
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
