Guillaume Massé created CALCITE-6218:
----------------------------------------
Summary: RelToSqlConverter fails to convert correlated lateral
joins
Key: CALCITE-6218
URL: https://issues.apache.org/jira/browse/CALCITE-6218
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.36.0
Reporter: Guillaume Massé
input query:
{code:java}
select
"a", "x"
from
"myDb"."myTable",
unnest("xs") as "x"; {code}
logical plan:
{code:java}
LogicalProject(a=[$0], x=[$6])
LogicalCorrelate(correlation=[$cor0], joinType=[inner],
requiredColumns=[{4}])
LogicalProject(a=[$0], b=[$1.n11.b], c=[$1.n12.c], d=[$2.d], xs=[$3],
e=[$4])
LogicalTableScan(table=[[myDb, myTable]])
Uncollect
LogicalProject(xs=[$cor0.xs])
LogicalValues(tuples=[[{ 0 }]]) {code}
obtained sql:
{code:java}
SELECT
"$cor0"."a",
"$cor0"."xs0" AS "x"
FROM (
SELECT "a", "n1"."n11"."b", "n1"."n12"."c", "n2"."d", "xs", "e" FROM
"myDb"."myTable"
) AS "$cor0",
LATERAL UNNEST (
SELECT "$cor0"."xs" FROM (VALUES (0)) AS "t" ("ZERO")
) AS "t1" ("xs") AS "t10" {code}
I would expect the query to be converted to something close to the original
query. Here "xs0" does not exists.
[https://github.com/MasseGuillaume/calcite/commit/0126e6cfa47061886b2012ad2d2c32408455ae88]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
