[jira] [Created] (CALCITE-5150) Parser should parse subquery with order by inside array constructor

[Dmitry Sysolyatin (Jira)]

Dmitry Sysolyatin created CALCITE-5150:
------------------------------------------

             Summary: Parser should parse subquery with order by inside array 
constructor
                 Key: CALCITE-5150
                 URL: https://issues.apache.org/jira/browse/CALCITE-5150
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: Dmitry Sysolyatin
            Assignee: Dmitry Sysolyatin


Parser can't parse query that looks like:
{code}
SELECT array(select x from (VALUES(1)) x ORDER BY x)
{code}

{code}
Caused by: org.apache.calcite.sql.parser.babel.ParseException: Encountered 
"ORDER" at line 1, column 42.
Was expecting one of:
    ")" ...
    "NATURAL" ...
{code}



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