[jira] [Commented] (CALCITE-5194) Cannot parse parenthesized UNION in subquery

["Julian Hyde (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-5194?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17556680#comment-17556680 ] 

Julian Hyde commented on CALCITE-5194:
--------------------------------------

I agree that this is a regression. However it less serious than it appears. If you remove the parentheses, as in the following, the parse succeeds.
{code:java}
  final String sql = "select * from\n" +
        "(select columns[0] as col0 from emps t1\n" +
        "union all\n" +
        "select columns[0] c2 from emps t2)";
{code}

> Cannot parse parenthesized UNION in subquery
> --------------------------------------------
>
>                 Key: CALCITE-5194
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5194
>             Project: Calcite
>          Issue Type: Bug
>    Affects Versions: 1.31.0
>            Reporter: Vova Vysotskyi
>            Assignee: Julian Hyde
>            Priority: Blocker
>             Fix For: 1.31.0
>
>
> The following test:
> {code:java}
>   @Test void testUnionAllInSubquery() {
>     final String sql = "select * from \n" +
>         "((select columns[0] as col0 from emps t1) \n" +
>         "union all \n" +
>         "(select columns[0] c2 from emps t2))";
>     final String expected = "SELECT *\n"
>         + "FROM (SELECT `COLUMNS`[0] AS `COL0`\n"
>         + "FROM `EMPS` AS `T1`\n"
>         + "UNION ALL\n"
>         + "SELECT `COLUMNS`[0] AS `C2`\n"
>         + "FROM `EMPS` AS `T2`)";
>     sql(sql).ok(expected);
>   }
> {code}
> Fails with the following exception:
> {noformat}
> Caused by: org.apache.calcite.sql.parser.SqlParseException: Encountered "union" at line 3, column 1.
> Was expecting one of:
>     "AS" ...
>     "CROSS" ...
>     "FULL" ...
>     "INNER" ...
>     "JOIN" ...
>     "LEFT" ...
>     "MATCH_RECOGNIZE" ...
>     "NATURAL" ...
>     "OUTER" ...
>     "RIGHT" ...
>     "TABLESAMPLE" ...
>     ")" ...
>     <BRACKET_QUOTED_IDENTIFIER> ...
>     <QUOTED_IDENTIFIER> ...
>     <BACK_QUOTED_IDENTIFIER> ...
>     <BIG_QUERY_BACK_QUOTED_IDENTIFIER> ...
>     <HYPHENATED_IDENTIFIER> ...
>     <IDENTIFIER> ...
>     <UNICODE_QUOTED_IDENTIFIER> ...
>     
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.convertException(SqlParserImpl.java:398)
> 	at org.apache.calcite.sql.parser.impl.SqlParserImpl.normalizeException(SqlParserImpl.java:154)
> 	at org.apache.calcite.sql.parser.SqlParser.handleException(SqlParser.java:145)
> 	at org.apache.calcite.sql.parser.SqlParser.parseQuery(SqlParser.java:160)
> 	at org.apache.calcite.sql.parser.SqlParser.parseStmt(SqlParser.java:185)
> 	at org.apache.calcite.sql.parser.SqlParserTest$TesterImpl.parseStmtAndHandleEx(SqlParserTest.java:9863)
> 	... 72 more
> {noformat}
> This is a regression caused by changes from CALCITE-35



--
This message was sent by Atlassian Jira
(v8.20.7#820007)