array.slt

# Licensed to the Apache Software Foundation (ASF) under one
# or more contributor license agreements.  See the NOTICE file
# distributed with this work for additional information
# regarding copyright ownership.  The ASF licenses this file
# to you under the Apache License, Version 2.0 (the
# "License"); you may not use this file except in compliance
# with the License.  You may obtain a copy of the License at

#   http://www.apache.org/licenses/LICENSE-2.0

# Unless required by applicable law or agreed to in writing,
# software distributed under the License is distributed on an
# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
# KIND, either express or implied.  See the License for the
# specific language governing permissions and limitations
# under the License.

query ?
SELECT array(1, 2, 3);
----
[1, 2, 3]


query ?
SELECT array('a', 'b');
----
[a, b]


query ?
SELECT array();
----
[]

query ??
SELECT array(), array(array());
----
[] [[]]


query ?
SELECT array(null);
----
[NULL]


query ?
SELECT array(1, NULL, 3);
----
[1, NULL, 3]


query I
SELECT ascii(substr(array['hello', '', null, 'nULl', 'nULlx', 'aa"bb', 'mm\nn', 'uu,vv', 'yy zz'][7], 3 ,1));
----
10

query ?
SELECT array(array(1,2),array(3,4));
----
[[1, 2], [3, 4]]


query ?
SELECT array(array(1), array(2,3,4));
----
[[1], [2, 3, 4]]

query ?
SELECT array(array(1,2));
----
[[1, 2]]

query ?
SELECT array(arrow_cast(array(1), 'LargeList(Int64)'));
----
[[1]]

query ?
SELECT array(arrow_cast(array(1), 'LargeList(Int64)'), arrow_cast(array(), 'LargeList(Int64)'));
----
[[1], []]

query ?
SELECT array(arrow_cast(array(1,2), 'LargeList(Int64)'), array(3));
----
[[1, 2], [3]]