[
https://issues.apache.org/jira/browse/CALCITE-6785?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated CALCITE-6785:
------------------------------------
Labels: pull-request-available (was: )
> RelToSqlConverter generate wrong sql when UNNEST has a correlate variable
> -------------------------------------------------------------------------
>
> Key: CALCITE-6785
> URL: https://issues.apache.org/jira/browse/CALCITE-6785
> Project: Calcite
> Issue Type: Bug
> Reporter: xiong duan
> Priority: Major
> Labels: pull-request-available
>
> The unit test case in RelToSqlConverterTest:
> {code:java}
> @Test void testUnnest() {
> final String sql = "select
> \"department_id\",split(\"department_description\", ','), unnestValues as
> code_path\n"
> + "from
> \"foodmart\".\"department\",UNNEST(split(\"department_description\", ',')) as
> unnestValues";
> final String expected = "SELECT \"$cor0\".\"department_id\",
> SPLIT(\"$cor0\".\"department_description\", ','), \"t10\".\"col_0\" AS
> \"CODE_PATH\"\n"
> + "FROM (SELECT \"department_id\", \"department_description\",
> SPLIT(\"department_description\", ',') AS \"$f2\"\n"
> + "FROM \"foodmart\".\"department\") AS \"$cor0\",\n"
> + "LATERAL UNNEST (SELECT \"$cor0\".\"$f2\"\n"
> + "FROM (VALUES (0)) AS \"t\" (\"ZERO\")) AS \"t1\" (\"col_0\") AS
> \"t10\"";
> sql(sql).withLibrary(SqlLibrary.BIG_QUERY).ok(expected);
> }
> {code}
> {code:java}
> UNNEST (SELECT \"$cor0\".\"$f2\" FROM (VALUES (0)) AS \"t\" (\"ZERO\")) AS
> \"t1\" (\"col_0\") AS \"t10\"{code}
> is a illegal expression.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
