[jira] [Created] (CALCITE-7699) ARRAY_INSERT fails in validation when first argument is not an array constructor

["Mihai Budiu (Jira)" <ji...@apache.org>]

Mihai Budiu created CALCITE-7699:
------------------------------------

             Summary: ARRAY_INSERT fails in validation when first argument is not an array constructor
                 Key: CALCITE-7699
                 URL: https://issues.apache.org/jira/browse/CALCITE-7699
             Project: Calcite
          Issue Type: Bug
          Components: core
    Affects Versions: 1.42.0
         Environment: Related to CALCITE-6743
            Reporter: Mihai Budiu


{code:sql}
select array_insert(cast(array(1, 2, 3) as integer array), 3, cast(4 as double));{code}
fails with

{code}
SqlValidatorException: Cast function cannot convert value of type
INTEGER NOT NULL ARRAY NOT NULL to type DOUBLE
{code}



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