[jira] [Created] (CALCITE-6508) Parse error when using scalar sub-query as operant to Array constructor function

["Ian Bertolacci (Jira)" <ji...@apache.org>]

Ian Bertolacci created CALCITE-6508:
---------------------------------------

             Summary: Parse error when using scalar sub-query as operant to Array constructor function
                 Key: CALCITE-6508
                 URL: https://issues.apache.org/jira/browse/CALCITE-6508
             Project: Calcite
          Issue Type: Bug
            Reporter: Ian Bertolacci


Using a scalar subquery in the {{`ARRAY[ ... ]`}} function throws "parse failed: Query expression encountered in illegal context"
(Calcite version 1.36)
For example:
{code:sql}
select ARRAY[ (select 1) ]
select ARRAY[ (select max(x) from table) ]
{code}

Is this something that can be configured or easily altered?



--
This message was sent by Atlassian Jira
(v8.20.10#820010)