[
https://issues.apache.org/jira/browse/CALCITE-6647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Roman Churganov updated CALCITE-6647:
-------------------------------------
Description:
A query like
{code:sql}
SELECT x.c11 FROM (
SELECT tt1.c11 FROM (
SELECT c11 FROM sch1.foo as cp1 LIMIT ?
) AS tt1
UNION ALL
SELECT tt2.c11 FROM (
SELECT c11 FROM sch1.foo as cp2 LIMIT ?
) AS tt2
) AS x LIMIT ?
{code}
hungs on building a plan, with debug log, can see a growing plans with a
nested LogicalSort nodes, eventually it fails with StackOverflow...,
{noformat}
.....
LogicalSort(fetch=[?2])
LogicalSort(subset=[rel#3740:RelSubset#269.NONE.[]], fetch=[?2])
LogicalSort(subset=[rel#3670:RelSubset#264.NONE.[]], fetch=[?2])
LogicalSort(subset=[rel#3600:RelSubset#259.NONE.[]], fetch=[?2])
LogicalSort(subset=[rel#3530:RelSubset#254.NONE.[]], fetch=[?2])
LogicalSort(subset=[rel#3460:RelSubset#249.NONE.[]], fetch=[?2])
LogicalSort(subset=[rel#3390:RelSubset#244.NONE.[]], fetch=[?2])
LogicalSort(subset=[rel#3320:RelSubset#239.NONE.[]], fetch=[?2])
LogicalSort(subset=[rel#3250:RelSubset#234.NONE.[]], fetch=[?2])
LogicalSort(subset=[rel#3180:RelSubset#229.NONE.[]],
fetch=[?2])
LogicalSort(subset=[rel#3110:RelSubset#224.NONE.[]],
fetch=[?2])
LogicalSort(subset=[rel#3040:RelSubset#219.NONE.[]],
fetch=[?2])
...
{noformat}
Seem like an issue with `SortUnionTransposeRule `
was:
If query has a sub-query in EXIXST function and full column names used in
sub-query , like
{code:sql}
SELECT sch1.foo.c11 FROM sch1.foo
WHERE exists ( SELECT sch2.tab.c41 FROM sch2.tab
where sch2.tab.c41 = 1 )
{code}
it fails with exception:
{noformat}
.....
at
org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:787)
at org.apache.calcite.prepare.PlannerImpl.validate(PlannerImpl.java:226)
... 73 more
Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Table
'SCH2.TAB' not found
at
java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
at
java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at
java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
at
java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
at
org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:505)
at org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:599)
... 98 more
{noformat}
also need to have a different table in the outer query to reproduce
> union with params and limit looping
> -----------------------------------
>
> Key: CALCITE-6647
> URL: https://issues.apache.org/jira/browse/CALCITE-6647
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.37.0
> Reporter: Roman Churganov
> Priority: Blocker
>
> A query like
> {code:sql}
> SELECT x.c11 FROM (
> SELECT tt1.c11 FROM (
> SELECT c11 FROM sch1.foo as cp1 LIMIT ?
> ) AS tt1
> UNION ALL
> SELECT tt2.c11 FROM (
> SELECT c11 FROM sch1.foo as cp2 LIMIT ?
> ) AS tt2
> ) AS x LIMIT ?
> {code}
> hungs on building a plan, with debug log, can see a growing plans with a
> nested LogicalSort nodes, eventually it fails with StackOverflow...,
> {noformat}
> .....
> LogicalSort(fetch=[?2])
> LogicalSort(subset=[rel#3740:RelSubset#269.NONE.[]], fetch=[?2])
> LogicalSort(subset=[rel#3670:RelSubset#264.NONE.[]], fetch=[?2])
> LogicalSort(subset=[rel#3600:RelSubset#259.NONE.[]], fetch=[?2])
> LogicalSort(subset=[rel#3530:RelSubset#254.NONE.[]], fetch=[?2])
> LogicalSort(subset=[rel#3460:RelSubset#249.NONE.[]], fetch=[?2])
> LogicalSort(subset=[rel#3390:RelSubset#244.NONE.[]], fetch=[?2])
> LogicalSort(subset=[rel#3320:RelSubset#239.NONE.[]], fetch=[?2])
> LogicalSort(subset=[rel#3250:RelSubset#234.NONE.[]],
> fetch=[?2])
> LogicalSort(subset=[rel#3180:RelSubset#229.NONE.[]],
> fetch=[?2])
> LogicalSort(subset=[rel#3110:RelSubset#224.NONE.[]],
> fetch=[?2])
> LogicalSort(subset=[rel#3040:RelSubset#219.NONE.[]],
> fetch=[?2])
> ...
> {noformat}
> Seem like an issue with `SortUnionTransposeRule `
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
