xiong duan created CALCITE-6785:
-----------------------------------
Summary: 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
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}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
