xiong duan created CALCITE-7343:
-----------------------------------
Summary: RelToSqlConverter generate wrong sql when scalar
correlated sub-query in Project
Key: CALCITE-7343
URL: https://issues.apache.org/jira/browse/CALCITE-7343
Project: Calcite
Issue Type: Bug
Reporter: xiong duan
The unit test in RelToSqlConverterTest:
{code:java}
@Test void testProjectScalarSubquery() {
final String sql = "SELECT \"EMPNO\", (SELECT COUNT(*) AS \"c\"\n" +
"FROM \"EMP\"\n" +
"WHERE \"MGR\" < \"t\".\"MGR\") AS \"$f1\"\n" +
"FROM \"EMP\" as \"t\"\n" +
"WHERE \"SAL\" > 10";
final String expected = "SELECT \"EMPNO\", (SELECT COUNT(*) AS \"c\"\n" +
"FROM \"SCOTT\".\"EMP\"\n" +
"WHERE \"MGR\" < \"t\".\"MGR\") AS \"$f1\"\n" +
"FROM \"SCOTT\".\"EMP\"\n" +
"WHERE CAST(\"SAL\" AS DECIMAL(12, 2)) > 10.00";
sql(sql)
.schema(CalciteAssert.SchemaSpec.JDBC_SCOTT)
.withCalcite()
.ok(expected);
} {code}
The expected Sql should be:
{code:java}
final String expected = "SELECT \"EMPNO\", (SELECT COUNT(*) AS \"c\"\n" +
"FROM \"SCOTT\".\"EMP\"\n" +
"WHERE \"MGR\" < \"t\".\"MGR\") AS \"$f1\"\n" +
"FROM \"SCOTT\".\"EMP\" as \"t\"\n" +
"WHERE CAST(\"SAL\" AS DECIMAL(12, 2)) > 10.00"; {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
