[
https://issues.apache.org/jira/browse/CALCITE-7335?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhen Chen reassigned CALCITE-7335:
----------------------------------
Assignee: Zhen Chen
> RelToSqlConverter generate sql containing Scala subqueries includes redundant
> parentheses
> -----------------------------------------------------------------------------------------
>
> Key: CALCITE-7335
> URL: https://issues.apache.org/jira/browse/CALCITE-7335
> Project: Calcite
> Issue Type: Bug
> Reporter: xiong duan
> Assignee: Zhen Chen
> Priority: Major
> Labels: pull-request-available
>
> The UT in RelToSqlConverterTest:
> {code:java}
> @Test void testScalarSubqueryInSelectList() {
> final String sql2 = "" +
> "select\n" +
> " (SELECT\n" +
> " COUNT(*)\n" +
> " FROM\n" +
> " \"employee\"" +
> " WHERE\n" +
> " v.\"product_id\" >= 2), 3\n" +
> "from \"product\" as v";
> final String expected = "SELECT (((SELECT COUNT(*)\nFROM
> \"foodmart\".\"employee\"\nWHERE \"product\".\"product_id\" >= 2))), 3\n" +
> "FROM \"foodmart\".\"product\"";
> sql(sql2).ok(expected);
> } {code}
> {code:java}
> (((SELECT COUNT(*)\nFROM \"foodmart\".\"employee\"\nWHERE
> \"product\".\"product_id\" >= 2)))
> {code}
> should be:
> {code:java}
> (SELECT COUNT(*)\nFROM \"foodmart\".\"employee\"\nWHERE
> \"product\".\"product_id\" >= 2){code}
> The result with redundant parentheses is correct but not sufficiently
> standardized.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
