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)
