eldenmoon commented on code in PR #45435: URL: https://github.com/apache/doris/pull/45435#discussion_r1889916478
########## regression-test/suites/nereids_function_p0/scalar_function/Array1.groovy: ########## @@ -0,0 +1,1342 @@ +// 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. + +suite("nereids_scalar_fn_Array1") { + sql 'use regression_test_nereids_function_p0' + sql 'set enable_nereids_planner=true' + sql 'set enable_fallback_to_original_planner=false' + sql ' set enable_decimal256=true; ' + + def tb_suffix = ['array', 'rowstore_array'] + + for (def tb : tb_suffix) { + def nullable_tb = "fn_test_nullable_" + tb + def not_nullable_tb = "fn_test_not_nullable_" + tb + + // array avg + order_qt_sql_array_avg_Double "select array_avg(kadbl) from $nullable_tb order by id" + order_qt_sql_array_avg_Double_notnull "select array_avg(kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_avg_Float "select array_avg(kafloat) from $nullable_tb order by id" + order_qt_sql_array_avg_Float_notnull "select array_avg(kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_avg_LargeInt "select array_avg(kalint) from $nullable_tb order by id" + order_qt_sql_array_avg_LargeInt_notnull "select array_avg(kalint) from $not_nullable_tb order by id" + order_qt_sql_array_avg_BigInt "select array_avg(kabint) from $nullable_tb order by id" + order_qt_sql_array_avg_BigInt_notnull "select array_avg(kabint) from $not_nullable_tb order by id" + order_qt_sql_array_avg_SmallInt "select array_avg(kasint) from $nullable_tb order by id" + order_qt_sql_array_avg_SmallInt_notnull "select array_avg(kasint) from $not_nullable_tb order by id" + order_qt_sql_array_avg_Integer "select array_avg(kaint) from $nullable_tb order by id" + order_qt_sql_array_avg_Integer_notnull "select array_avg(kaint) from $not_nullable_tb order by id" + order_qt_sql_array_avg_TinyInt "select array_avg(katint) from $nullable_tb order by id" + order_qt_sql_array_avg_TinyInt_notnull "select array_avg(katint) from $not_nullable_tb order by id" + order_qt_sql_array_avg_DecimalV3 "select array_avg(kadcml) from $nullable_tb order by id" + order_qt_sql_array_avg_DecimalV3_notnull "select array_avg(kadcml) from $not_nullable_tb order by id" + + // array_compact + order_qt_sql_array_compact_Double "select array_compact(kadbl) from $nullable_tb order by id" + order_qt_sql_array_compact_Double_notnull "select array_compact(kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_compact_Float "select array_compact(kafloat) from $nullable_tb order by id" + order_qt_sql_array_compact_Float_notnull "select array_compact(kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_compact_LargeInt "select array_compact(kalint) from $nullable_tb order by id" + order_qt_sql_array_compact_LargeInt_notnull "select array_compact(kalint) from $not_nullable_tb order by id" + order_qt_sql_array_compact_BigInt "select array_compact(kabint) from $nullable_tb order by id" + order_qt_sql_array_compact_BigInt_notnull "select array_compact(kabint) from $not_nullable_tb order by id" + order_qt_sql_array_compact_SmallInt "select array_compact(kasint) from $nullable_tb order by id" + order_qt_sql_array_compact_SmallInt_notnull "select array_compact(kasint) from $not_nullable_tb order by id" + order_qt_sql_array_compact_Integer "select array_compact(kaint) from $nullable_tb order by id" + order_qt_sql_array_compact_Integer_notnull "select array_compact(kaint) from $not_nullable_tb order by id" + order_qt_sql_array_compact_TinyInt "select array_compact(katint) from $nullable_tb order by id" + order_qt_sql_array_compact_TinyInt_notnull "select array_compact(katint) from $not_nullable_tb order by id" + order_qt_sql_array_compact_DecimalV3 "select array_compact(kadcml) from $nullable_tb order by id" + order_qt_sql_array_compact_DecimalV3_notnull "select array_compact(kadcml) from $not_nullable_tb order by id" + + order_qt_sql_array_compact_Boolean "select array_compact(kabool) from $nullable_tb order by id" + order_qt_sql_array_compact_Boolean_notnull "select array_compact(kabool) from $not_nullable_tb order by id" + + order_qt_sql_array_compact_Char "select array_compact(kachr) from $nullable_tb order by id" + order_qt_sql_array_compact_Char_notnull "select array_compact(kachr) from $not_nullable_tb order by id" + order_qt_sql_array_compact_Varchar "select array_compact(kavchr) from $nullable_tb order by id" + order_qt_sql_array_compact_Varchar_notnull "select array_compact(kavchr) from $not_nullable_tb order by id" + order_qt_sql_array_compact_String "select array_compact(kastr) from $nullable_tb order by id" + order_qt_sql_array_compact_String_notnull "select array_compact(kastr) from $not_nullable_tb order by id" + + order_qt_sql_array_compact_DatetimeV2 "select array_compact(kadtmv2) from $nullable_tb order by id" + order_qt_sql_array_compact_DatetimeV2_notnull "select array_compact(kadtmv2) from $not_nullable_tb order by id" + order_qt_sql_array_compact_DateV2 "select array_compact(kadtv2) from $nullable_tb order by id" + order_qt_sql_array_compact_DateV2_notnull "select array_compact(kadtv2) from $not_nullable_tb order by id" + + // array_concat + order_qt_sql_array_concat_Double "select array_concat(kadbl, kadbl) from $nullable_tb order by id" + order_qt_sql_array_concat_Double_notnull "select array_concat(kadbl, kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_concat_Float "select array_concat(kafloat, kafloat) from $nullable_tb order by id" + order_qt_sql_array_concat_Float_notnull "select array_concat(kafloat, kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_concat_LargeInt "select array_concat(kalint, kalint) from $nullable_tb order by id" + order_qt_sql_array_concat_LargeInt_notnull "select array_concat(kalint, kalint) from $not_nullable_tb order by id" + order_qt_sql_array_concat_BigInt "select array_concat(kabint, kabint) from $nullable_tb order by id" + order_qt_sql_array_concat_BigInt_notnull "select array_concat(kabint, kabint) from $not_nullable_tb order by id" + order_qt_sql_array_concat_SmallInt "select array_concat(kasint, kasint) from $nullable_tb order by id" + order_qt_sql_array_concat_SmallInt_notnull "select array_concat(kasint, kasint) from $not_nullable_tb order by id" + order_qt_sql_array_concat_Integer "select array_concat(kaint, kaint) from $nullable_tb order by id" + order_qt_sql_array_concat_Integer_notnull "select array_concat(kaint, kaint) from $not_nullable_tb order by id" + order_qt_sql_array_concat_TinyInt "select array_concat(katint, katint) from $nullable_tb order by id" + order_qt_sql_array_concat_TinyInt_notnull "select array_concat(katint, katint) from $not_nullable_tb order by id" + order_qt_sql_array_concat_DecimalV3 "select array_concat(kadcml, kadcml) from $nullable_tb order by id" + order_qt_sql_array_concat_DecimalV3_notnull "select array_concat(kadcml, kadcml) from $not_nullable_tb order by id" + + order_qt_sql_array_concat_Boolean "select array_concat(kabool, kabool) from $nullable_tb order by id" + order_qt_sql_array_concat_Boolean_notnull "select array_concat(kabool, kabool) from $not_nullable_tb order by id" + + order_qt_sql_array_concat_Char "select array_concat(kachr, kachr) from $nullable_tb order by id" + order_qt_sql_array_concat_Char_notnull "select array_concat(kachr, kachr) from $not_nullable_tb order by id" + order_qt_sql_array_concat_Varchar "select array_concat(kavchr, kavchr) from $nullable_tb order by id" + order_qt_sql_array_concat_Varchar_notnull "select array_concat(kavchr, kavchr) from $not_nullable_tb order by id" + order_qt_sql_array_concat_String "select array_concat(kastr, kastr) from $nullable_tb order by id" + order_qt_sql_array_concat_String_notnull "select array_concat(kastr, kastr) from $not_nullable_tb order by id" + + order_qt_sql_array_concat_DatetimeV2 "select array_concat(kadtmv2, kadtmv2) from $nullable_tb order by id" + order_qt_sql_array_concat_DatetimeV2_notnull "select array_concat(kadtmv2, kadtmv2) from $not_nullable_tb order by id" + order_qt_sql_array_concat_DateV2 "select array_concat(kadtv2, kadtv2) from $nullable_tb order by id" + order_qt_sql_array_concat_DateV2_notnull "select array_concat(kadtv2, kadtv2) from $not_nullable_tb order by id" + + // array_difference + order_qt_sql_array_difference_Double "select array_difference(kadbl) from $nullable_tb order by id" + order_qt_sql_array_difference_Double_notnull "select array_difference(kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_difference_Float "select array_difference(kafloat) from $nullable_tb order by id" + order_qt_sql_array_difference_Float_notnull "select array_difference(kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_difference_LargeInt "select array_difference(kalint) from $nullable_tb order by id" + order_qt_sql_array_difference_LargeInt_notnull "select array_difference(kalint) from $not_nullable_tb order by id" + order_qt_sql_array_difference_BigInt "select array_difference(kabint) from $nullable_tb order by id" + order_qt_sql_array_difference_BigInt_notnull "select array_difference(kabint) from $not_nullable_tb order by id" + order_qt_sql_array_difference_SmallInt "select array_difference(kasint) from $nullable_tb order by id" + order_qt_sql_array_difference_SmallInt_notnull "select array_difference(kasint) from $not_nullable_tb order by id" + order_qt_sql_array_difference_Integer "select array_difference(kaint) from $nullable_tb order by id" + order_qt_sql_array_difference_Integer_notnull "select array_difference(kaint) from $not_nullable_tb order by id" + order_qt_sql_array_difference_TinyInt "select array_difference(katint) from $nullable_tb order by id" + order_qt_sql_array_difference_TinyInt_notnull "select array_difference(katint) from $not_nullable_tb order by id" + order_qt_sql_array_difference_DecimalV3 "select array_difference(kadcml) from $nullable_tb order by id" + order_qt_sql_array_difference_DecimalV3_notnull "select array_difference(kadcml) from $not_nullable_tb order by id" + + order_qt_sql_array_difference_Boolean "select array_difference(kabool) from $nullable_tb order by id" + order_qt_sql_array_difference_Boolean_notnull "select array_difference(kabool) from $not_nullable_tb order by id" + + order_qt_sql_array_difference_Char "select array_difference(kachr) from $nullable_tb order by id" + order_qt_sql_array_difference_Char_notnull "select array_difference(kachr) from $not_nullable_tb order by id" + order_qt_sql_array_difference_Varchar "select array_difference(kavchr) from $nullable_tb order by id" + order_qt_sql_array_difference_Varchar_notnull "select array_difference(kavchr) from $not_nullable_tb order by id" + order_qt_sql_array_difference_String "select array_difference(kastr) from $nullable_tb order by id" + order_qt_sql_array_difference_String_notnull "select array_difference(kastr) from $not_nullable_tb order by id" + + order_qt_sql_array_difference_DatetimeV2 "select array_difference(kadtmv2) from $nullable_tb order by id" + order_qt_sql_array_difference_DatetimeV2_notnull "select array_difference(kadtmv2) from $not_nullable_tb order by id" + order_qt_sql_array_difference_DateV2 "select array_difference(kadtv2) from $nullable_tb order by id" + order_qt_sql_array_difference_DateV2_notnull "select array_difference(kadtv2) from $not_nullable_tb order by id" + + // array_distinct + order_qt_sql_array_distinct_Double "select array_distinct(kadbl) from $nullable_tb order by id" + order_qt_sql_array_distinct_Double_notnull "select array_distinct(kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_distinct_Float "select array_distinct(kafloat) from $nullable_tb order by id" + order_qt_sql_array_distinct_Float_notnull "select array_distinct(kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_distinct_LargeInt "select array_distinct(kalint) from $nullable_tb order by id" + order_qt_sql_array_distinct_LargeInt_notnull "select array_distinct(kalint) from $not_nullable_tb order by id" + order_qt_sql_array_distinct_BigInt "select array_distinct(kabint) from $nullable_tb order by id" + order_qt_sql_array_distinct_BigInt_notnull "select array_distinct(kabint) from $not_nullable_tb order by id" + order_qt_sql_array_distinct_SmallInt "select array_distinct(kasint) from $nullable_tb order by id" + order_qt_sql_array_distinct_SmallInt_notnull "select array_distinct(kasint) from $not_nullable_tb order by id" + order_qt_sql_array_distinct_Integer "select array_distinct(kaint) from $nullable_tb order by id" + order_qt_sql_array_distinct_Integer_notnull "select array_distinct(kaint) from $not_nullable_tb order by id" + order_qt_sql_array_distinct_TinyInt "select array_distinct(katint) from $nullable_tb order by id" + order_qt_sql_array_distinct_TinyInt_notnull "select array_distinct(katint) from $not_nullable_tb order by id" + order_qt_sql_array_distinct_DecimalV3 "select array_distinct(kadcml) from $nullable_tb order by id" + order_qt_sql_array_distinct_DecimalV3_notnull "select array_distinct(kadcml) from $not_nullable_tb order by id" + + order_qt_sql_array_distinct_Boolean "select array_distinct(kabool) from $nullable_tb order by id" + order_qt_sql_array_distinct_Boolean_notnull "select array_distinct(kabool) from $not_nullable_tb order by id" + + order_qt_sql_array_distinct_Char "select array_distinct(kachr) from $nullable_tb order by id" + order_qt_sql_array_distinct_Char_notnull "select array_distinct(kachr) from $not_nullable_tb order by id" + order_qt_sql_array_distinct_Varchar "select array_distinct(kavchr) from $nullable_tb order by id" + order_qt_sql_array_distinct_Varchar_notnull "select array_distinct(kavchr) from $not_nullable_tb order by id" + order_qt_sql_array_distinct_String "select array_distinct(kastr) from $nullable_tb order by id" + order_qt_sql_array_distinct_String_notnull "select array_distinct(kastr) from $not_nullable_tb order by id" + + order_qt_sql_array_distinct_DatetimeV2 "select array_distinct(kadtmv2) from $nullable_tb order by id" + order_qt_sql_array_distinct_DatetimeV2_notnull "select array_distinct(kadtmv2) from $not_nullable_tb order by id" + order_qt_sql_array_distinct_DateV2 "select array_distinct(kadtv2) from $nullable_tb order by id" + order_qt_sql_array_distinct_DateV2_notnull "select array_distinct(kadtv2) from $not_nullable_tb order by id" + + // array_except + order_qt_sql_array_except_Double "select array_except(kadbl, kadbl) from $nullable_tb order by id" + order_qt_sql_array_except_Double_notnull "select array_except(kadbl, kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_except_Float "select array_except(kafloat, kafloat) from $nullable_tb order by id" + order_qt_sql_array_except_Float_notnull "select array_except(kafloat, kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_except_LargeInt "select array_except(kalint, kalint) from $nullable_tb order by id" + order_qt_sql_array_except_LargeInt_notnull "select array_except(kalint, kalint) from $not_nullable_tb order by id" + order_qt_sql_array_except_BigInt "select array_except(kabint, kabint) from $nullable_tb order by id" + order_qt_sql_array_except_BigInt_notnull "select array_except(kabint, kabint) from $not_nullable_tb order by id" + order_qt_sql_array_except_SmallInt "select array_except(kasint, kasint) from $nullable_tb order by id" + order_qt_sql_array_except_SmallInt_notnull "select array_except(kasint, kasint) from $not_nullable_tb order by id" + order_qt_sql_array_except_Integer "select array_except(kaint, kaint) from $nullable_tb order by id" + order_qt_sql_array_except_Integer_notnull "select array_except(kaint, kaint) from $not_nullable_tb order by id" + order_qt_sql_array_except_TinyInt "select array_except(katint, katint) from $nullable_tb order by id" + order_qt_sql_array_except_TinyInt_notnull "select array_except(katint, katint) from $not_nullable_tb order by id" + order_qt_sql_array_except_DecimalV3 "select array_except(kadcml, kadcml) from $nullable_tb order by id" + order_qt_sql_array_except_DecimalV3_notnull "select array_except(kadcml, kadcml) from $not_nullable_tb order by id" + + order_qt_sql_array_except_Boolean "select array_except(kabool, kabool) from $nullable_tb order by id" + order_qt_sql_array_except_Boolean_notnull "select array_except(kabool, kabool) from $not_nullable_tb order by id" + + order_qt_sql_array_except_Char "select array_except(kachr, kachr) from $nullable_tb order by id" + order_qt_sql_array_except_Char_notnull "select array_except(kachr, kachr) from $not_nullable_tb order by id" + order_qt_sql_array_except_Varchar "select array_except(kavchr, kavchr) from $nullable_tb order by id" + order_qt_sql_array_except_Varchar_notnull "select array_except(kavchr, kavchr) from $not_nullable_tb order by id" + order_qt_sql_array_except_String "select array_except(kastr, kastr) from $nullable_tb order by id" + order_qt_sql_array_except_String_notnull "select array_except(kastr, kastr) from $not_nullable_tb order by id" + + order_qt_sql_array_except_DatetimeV2 "select array_except(kadtmv2, kadtmv2) from $nullable_tb order by id" + order_qt_sql_array_except_DatetimeV2_notnull "select array_except(kadtmv2, kadtmv2) from $not_nullable_tb order by id" + order_qt_sql_array_except_DateV2 "select array_except(kadtv2, kadtv2) from $nullable_tb order by id" + order_qt_sql_array_except_DateV2_notnull "select array_except(kadtv2, kadtv2) from $not_nullable_tb order by id" + + // array_intersect + order_qt_sql_array_intersect_Double "select array_sort(array_intersect(kadbl, kadbl)) from $nullable_tb order by id" + order_qt_sql_array_intersect_Double_notnull "select array_sort(array_intersect(kadbl, kadbl)) from $not_nullable_tb order by id" + order_qt_sql_array_intersect_Float "select array_sort(array_intersect(kafloat, kafloat)) from $nullable_tb order by id" + order_qt_sql_array_intersect_Float_notnull "select array_sort(array_intersect(kafloat, kafloat)) from $not_nullable_tb order by id" + order_qt_sql_array_intersect_LargeInt "select array_sort(array_intersect(kalint, kalint)) from $nullable_tb order by id" + order_qt_sql_array_intersect_LargeInt_notnull "select array_sort(array_intersect(kalint, kalint)) from $not_nullable_tb order by id" + order_qt_sql_array_intersect_BigInt "select array_sort(array_intersect(kabint, kabint)) from $nullable_tb order by id" + order_qt_sql_array_intersect_BigInt_notnull "select array_sort(array_intersect(kabint, kabint)) from $not_nullable_tb order by id" + order_qt_sql_array_intersect_SmallInt "select array_sort(array_intersect(kasint, kasint)) from $nullable_tb order by id" + order_qt_sql_array_intersect_SmallInt_notnull "select array_sort(array_intersect(kasint, kasint)) from $not_nullable_tb order by id" + order_qt_sql_array_intersect_Integer "select array_sort(array_intersect(kaint, kaint)) from $nullable_tb order by id" + order_qt_sql_array_intersect_Integer_notnull "select array_sort(array_intersect(kaint, kaint)) from $not_nullable_tb order by id" + order_qt_sql_array_intersect_TinyInt "select array_sort(array_intersect(katint, katint)) from $nullable_tb order by id" + order_qt_sql_array_intersect_TinyInt_notnull "select array_sort(array_intersect(katint, katint)) from $not_nullable_tb order by id" + order_qt_sql_array_intersect_DecimalV3 "select array_sort(array_intersect(kadcml, kadcml)) from $nullable_tb order by id" + order_qt_sql_array_intersect_DecimalV3_notnull "select array_sort(array_intersect(kadcml, kadcml)) from $not_nullable_tb order by id" + + order_qt_sql_array_intersect_Boolean "select array_sort(array_intersect(kabool, kabool)) from $nullable_tb order by id" + order_qt_sql_array_intersect_Boolean_notnull "select array_sort(array_intersect(kabool, kabool)) from $not_nullable_tb order by id" + + order_qt_sql_array_intersect_Char "select array_sort(array_intersect(kachr, kachr)) from $nullable_tb order by id" + order_qt_sql_array_intersect_Char_notnull "select array_sort(array_intersect(kachr, kachr)) from $not_nullable_tb order by id" + order_qt_sql_array_intersect_Varchar "select array_sort(array_intersect(kavchr, kavchr)) from $nullable_tb order by id" + order_qt_sql_array_intersect_Varchar_notnull "select array_sort(array_intersect(kavchr, kavchr)) from $not_nullable_tb order by id" + order_qt_sql_array_intersect_String "select array_sort(array_intersect(kastr, kastr)) from $nullable_tb order by id" + order_qt_sql_array_intersect_String_notnull "select array_sort(array_intersect(kastr, kastr)) from $not_nullable_tb order by id" + + order_qt_sql_array_intersect_DatetimeV2 "select array_sort(array_intersect(kadtmv2, kadtmv2)) from $nullable_tb order by id" + order_qt_sql_array_intersect_DatetimeV2_notnull "select array_sort(array_intersect(kadtmv2, kadtmv2)) from $not_nullable_tb order by id" + order_qt_sql_array_intersect_DateV2 "select array_sort(array_intersect(kadtv2, kadtv2)) from $nullable_tb order by id" + order_qt_sql_array_intersect_DateV2_notnull "select array_sort(array_intersect(kadtv2, kadtv2)) from $not_nullable_tb order by id" + + // array_join + order_qt_sql_array_join_Double "select array_join(kadbl, ',', 'null') from $nullable_tb order by id" + order_qt_sql_array_join_Double_notnull "select array_join(kadbl, ',', 'null') from $not_nullable_tb order by id" + order_qt_sql_array_join_Float "select array_join(kafloat, ',', 'null') from $nullable_tb order by id" + order_qt_sql_array_join_Float_notnull "select array_join(kafloat, ',', 'null') from $not_nullable_tb order by id" + order_qt_sql_array_join_LargeInt "select array_join(kalint, ',', 'null') from $nullable_tb order by id" + order_qt_sql_array_join_LargeInt_notnull "select array_join(kalint, ',', 'null') from $not_nullable_tb order by id" + order_qt_sql_array_join_BigInt "select array_join(kabint, ',', 'null') from $nullable_tb order by id" + order_qt_sql_array_join_BigInt_notnull "select array_join(kabint, ',', 'null') from $not_nullable_tb order by id" + order_qt_sql_array_join_SmallInt "select array_join(kasint, ',', 'null') from $nullable_tb order by id" + order_qt_sql_array_join_SmallInt_notnull "select array_join(kasint, ',', 'null') from $not_nullable_tb order by id" + order_qt_sql_array_join_Integer "select array_join(kaint, ',', 'null') from $nullable_tb order by id" + order_qt_sql_array_join_Integer_notnull "select array_join(kaint, ',', 'null') from $not_nullable_tb order by id" + order_qt_sql_array_join_TinyInt "select array_join(katint, ',', 'null') from $nullable_tb order by id" + order_qt_sql_array_join_TinyInt_notnull "select array_join(katint, ',', 'null') from $not_nullable_tb order by id" + order_qt_sql_array_join_DecimalV3 "select array_join(kadcml, ',', 'null') from $nullable_tb order by id" + order_qt_sql_array_join_DecimalV3_notnull "select array_join(kadcml, ',', 'null') from $not_nullable_tb order by id" + + order_qt_sql_array_join_Boolean "select array_join(kabool, ',', 'null') from $nullable_tb order by id" + order_qt_sql_array_join_Boolean_notnull "select array_join(kabool, ',', 'null') from $not_nullable_tb order by id" + + order_qt_sql_array_join_Char "select array_join(kachr, ',', 'null') from $nullable_tb order by id" + order_qt_sql_array_join_Char_notnull "select array_join(kachr, ',', 'null') from $not_nullable_tb order by id" + order_qt_sql_array_join_Varchar "select array_join(kavchr, ',', 'null') from $nullable_tb order by id" + order_qt_sql_array_join_Varchar_notnull "select array_join(kavchr, ',', 'null') from $not_nullable_tb order by id" + order_qt_sql_array_join_String "select array_join(kastr, ',', 'null') from $nullable_tb order by id" + order_qt_sql_array_join_String_notnull "select array_join(kastr, ',', 'null') from $not_nullable_tb order by id" + + order_qt_sql_array_join_DatetimeV2 "select array_join(kadtmv2, ',', 'null') from $nullable_tb order by id" + order_qt_sql_array_join_DatetimeV2_notnull "select array_join(kadtmv2, ',', 'null') from $not_nullable_tb order by id" + order_qt_sql_array_join_DateV2 "select array_join(kadtv2, ',', 'null') from $nullable_tb order by id" + order_qt_sql_array_join_DateV2_notnull "select array_join(kadtv2, ',', 'null') from $not_nullable_tb order by id" + + order_qt_sql_array_join_two_params_Double "select array_join(kadbl, ',') from $nullable_tb order by id" + order_qt_sql_array_join_two_params_Double_notnull "select array_join(kadbl, ',') from $not_nullable_tb order by id" + order_qt_sql_array_join_two_params_Float "select array_join(kafloat, ',') from $nullable_tb order by id" + order_qt_sql_array_join_two_params_Float_notnull "select array_join(kafloat, ',') from $not_nullable_tb order by id" + order_qt_sql_array_join_two_params_LargeInt "select array_join(kalint, ',') from $nullable_tb order by id" + order_qt_sql_array_join_two_params_LargeInt_notnull "select array_join(kalint, ',') from $not_nullable_tb order by id" + order_qt_sql_array_join_two_params_BigInt "select array_join(kabint, ',') from $nullable_tb order by id" + order_qt_sql_array_join_two_params_BigInt_notnull "select array_join(kabint, ',') from $not_nullable_tb order by id" + order_qt_sql_array_join_two_params_SmallInt "select array_join(kasint, ',') from $nullable_tb order by id" + order_qt_sql_array_join_two_params_SmallInt_notnull "select array_join(kasint, ',') from $not_nullable_tb order by id" + order_qt_sql_array_join_two_params_Integer "select array_join(kaint, ',') from $nullable_tb order by id" + order_qt_sql_array_join_two_params_Integer_notnull "select array_join(kaint, ',') from $not_nullable_tb order by id" + order_qt_sql_array_join_two_params_TinyInt "select array_join(katint, ',') from $nullable_tb order by id" + order_qt_sql_array_join_two_params_TinyInt_notnull "select array_join(katint, ',') from $not_nullable_tb order by id" + order_qt_sql_array_join_two_params_DecimalV3 "select array_join(kadcml, ',') from $nullable_tb order by id" + order_qt_sql_array_join_two_params_DecimalV3_notnull "select array_join(kadcml, ',') from $not_nullable_tb order by id" + + order_qt_sql_array_join_two_params_Boolean "select array_join(kabool, ',') from $nullable_tb order by id" + order_qt_sql_array_join_two_params_Boolean_notnull "select array_join(kabool, ',') from $not_nullable_tb order by id" + + order_qt_sql_array_join_two_params_Char "select array_join(kachr, ',') from $nullable_tb order by id" + order_qt_sql_array_join_two_params_Char_notnull "select array_join(kachr, ',') from $not_nullable_tb order by id" + order_qt_sql_array_join_two_params_Varchar "select array_join(kavchr, ',') from $nullable_tb order by id" + order_qt_sql_array_join_two_params_Varchar_notnull "select array_join(kavchr, ',') from $not_nullable_tb order by id" + order_qt_sql_array_join_two_params_String "select array_join(kastr, ',') from $nullable_tb order by id" + order_qt_sql_array_join_two_params_String_notnull "select array_join(kastr, ',') from $not_nullable_tb order by id" + + order_qt_sql_array_join_two_params_DatetimeV2 "select array_join(kadtmv2, ',') from $nullable_tb order by id" + order_qt_sql_array_join_two_params_DatetimeV2_notnull "select array_join(kadtmv2, ',') from $not_nullable_tb order by id" + order_qt_sql_array_join_two_params_DateV2 "select array_join(kadtv2, ',') from $nullable_tb order by id" + order_qt_sql_array_join_two_params_DateV2_notnull "select array_join(kadtv2, ',') from $not_nullable_tb order by id" + + // l1_distance + order_qt_sql_l1_distance_Double "select l1_distance(kadbl, kadbl) from $nullable_tb order by id" + order_qt_sql_l1_distance_Double_notnull "select l1_distance(kadbl, kadbl) from $not_nullable_tb order by id" + order_qt_sql_l1_distance_Float "select l1_distance(kafloat, kafloat) from $nullable_tb order by id" + order_qt_sql_l1_distance_Float_notnull "select l1_distance(kafloat, kafloat) from $not_nullable_tb order by id" + order_qt_sql_l1_distance_LargeInt "select l1_distance(kalint, kalint) from $nullable_tb order by id" + order_qt_sql_l1_distance_LargeInt_notnull "select l1_distance(kalint, kalint) from $not_nullable_tb order by id" + order_qt_sql_l1_distance_BigInt "select l1_distance(kabint, kabint) from $nullable_tb order by id" + order_qt_sql_l1_distance_BigInt_notnull "select l1_distance(kabint, kabint) from $not_nullable_tb order by id" + order_qt_sql_l1_distance_SmallInt "select l1_distance(kasint, kasint) from $nullable_tb order by id" + order_qt_sql_l1_distance_SmallInt_notnull "select l1_distance(kasint, kasint) from $not_nullable_tb order by id" + order_qt_sql_l1_distance_Integer "select l1_distance(kaint, kaint) from $nullable_tb order by id" + order_qt_sql_l1_distance_Integer_notnull "select l1_distance(kaint, kaint) from $not_nullable_tb order by id" + order_qt_sql_l1_distance_TinyInt "select l1_distance(katint, katint) from $nullable_tb order by id" + order_qt_sql_l1_distance_TinyInt_notnull "select l1_distance(katint, katint) from $not_nullable_tb order by id" + + // l2_distance + order_qt_sql_l2_distance_Double "select l2_distance(kadbl, kadbl) from $nullable_tb order by id" + order_qt_sql_l2_distance_Double_notnull "select l2_distance(kadbl, kadbl) from $not_nullable_tb order by id" + order_qt_sql_l2_distance_Float "select l2_distance(kafloat, kafloat) from $nullable_tb order by id" + order_qt_sql_l2_distance_Float_notnull "select l2_distance(kafloat, kafloat) from $not_nullable_tb order by id" + order_qt_sql_l2_distance_LargeInt "select l2_distance(kalint, kalint) from $nullable_tb order by id" + order_qt_sql_l2_distance_LargeInt_notnull "select l2_distance(kalint, kalint) from $not_nullable_tb order by id" + order_qt_sql_l2_distance_BigInt "select l2_distance(kabint, kabint) from $nullable_tb order by id" + order_qt_sql_l2_distance_BigInt_notnull "select l2_distance(kabint, kabint) from $not_nullable_tb order by id" + order_qt_sql_l2_distance_SmallInt "select l2_distance(kasint, kasint) from $nullable_tb order by id" + order_qt_sql_l2_distance_SmallInt_notnull "select l2_distance(kasint, kasint) from $not_nullable_tb order by id" + order_qt_sql_l2_distance_Integer "select l2_distance(kaint, kaint) from $nullable_tb order by id" + order_qt_sql_l2_distance_Integer_notnull "select l2_distance(kaint, kaint) from $not_nullable_tb order by id" + order_qt_sql_l2_distance_TinyInt "select l2_distance(katint, katint) from $nullable_tb order by id" + order_qt_sql_l2_distance_TinyInt_notnull "select l2_distance(katint, katint) from $not_nullable_tb order by id" + + // cosine_distance + order_qt_sql_cosine_distance_Double "select cosine_distance(kadbl, kadbl) from $nullable_tb order by id" + order_qt_sql_cosine_distance_Double_notnull "select cosine_distance(kadbl, kadbl) from $not_nullable_tb order by id" + order_qt_sql_cosine_distance_Float "select cosine_distance(kafloat, kafloat) from $nullable_tb order by id" + order_qt_sql_cosine_distance_Float_notnull "select cosine_distance(kafloat, kafloat) from $not_nullable_tb order by id" + order_qt_sql_cosine_distance_LargeInt "select cosine_distance(kalint, kalint) from $nullable_tb order by id" + order_qt_sql_cosine_distance_LargeInt_notnull "select cosine_distance(kalint, kalint) from $not_nullable_tb order by id" + order_qt_sql_cosine_distance_BigInt "select cosine_distance(kabint, kabint) from $nullable_tb order by id" + order_qt_sql_cosine_distance_BigInt_notnull "select cosine_distance(kabint, kabint) from $not_nullable_tb order by id" + order_qt_sql_cosine_distance_SmallInt "select cosine_distance(kasint, kasint) from $nullable_tb order by id" + order_qt_sql_cosine_distance_SmallInt_notnull "select cosine_distance(kasint, kasint) from $not_nullable_tb order by id" + order_qt_sql_cosine_distance_Integer "select cosine_distance(kaint, kaint) from $nullable_tb order by id" + order_qt_sql_cosine_distance_Integer_notnull "select cosine_distance(kaint, kaint) from $not_nullable_tb order by id" + order_qt_sql_cosine_distance_TinyInt "select cosine_distance(katint, katint) from $nullable_tb order by id" + order_qt_sql_cosine_distance_TinyInt_notnull "select cosine_distance(katint, katint) from $not_nullable_tb order by id" + + // inner_product + order_qt_sql_inner_product_Double "select inner_product(kadbl, kadbl) from $nullable_tb order by id" + order_qt_sql_inner_product_Double_notnull "select inner_product(kadbl, kadbl) from $not_nullable_tb order by id" + order_qt_sql_inner_product_Float "select inner_product(kafloat, kafloat) from $nullable_tb order by id" + order_qt_sql_inner_product_Float_notnull "select inner_product(kafloat, kafloat) from $not_nullable_tb order by id" + order_qt_sql_inner_product_LargeInt "select inner_product(kalint, kalint) from $nullable_tb order by id" + order_qt_sql_inner_product_LargeInt_notnull "select inner_product(kalint, kalint) from $not_nullable_tb order by id" + order_qt_sql_inner_product_BigInt "select inner_product(kabint, kabint) from $nullable_tb order by id" + order_qt_sql_inner_product_BigInt_notnull "select inner_product(kabint, kabint) from $not_nullable_tb order by id" + order_qt_sql_inner_product_SmallInt "select inner_product(kasint, kasint) from $nullable_tb order by id" + order_qt_sql_inner_product_SmallInt_notnull "select inner_product(kasint, kasint) from $not_nullable_tb order by id" + order_qt_sql_inner_product_Integer "select inner_product(kaint, kaint) from $nullable_tb order by id" + order_qt_sql_inner_product_Integer_notnull "select inner_product(kaint, kaint) from $not_nullable_tb order by id" + order_qt_sql_inner_product_TinyInt "select inner_product(katint, katint) from $nullable_tb order by id" + order_qt_sql_inner_product_TinyInt_notnull "select inner_product(katint, katint) from $not_nullable_tb order by id" + + // array_max + order_qt_sql_array_max_Double "select array_max(kadbl) from $nullable_tb order by id" + order_qt_sql_array_max_Double_notnull "select array_max(kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_max_Float "select array_max(kafloat) from $nullable_tb order by id" + order_qt_sql_array_max_Float_notnull "select array_max(kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_max_LargeInt "select array_max(kalint) from $nullable_tb order by id" + order_qt_sql_array_max_LargeInt_notnull "select array_max(kalint) from $not_nullable_tb order by id" + order_qt_sql_array_max_BigInt "select array_max(kabint) from $nullable_tb order by id" + order_qt_sql_array_max_BigInt_notnull "select array_max(kabint) from $not_nullable_tb order by id" + order_qt_sql_array_max_SmallInt "select array_max(kasint) from $nullable_tb order by id" + order_qt_sql_array_max_SmallInt_notnull "select array_max(kasint) from $not_nullable_tb order by id" + order_qt_sql_array_max_Integer "select array_max(kaint) from $nullable_tb order by id" + order_qt_sql_array_max_Integer_notnull "select array_max(kaint) from $not_nullable_tb order by id" + order_qt_sql_array_max_TinyInt "select array_max(katint) from $nullable_tb order by id" + order_qt_sql_array_max_TinyInt_notnull "select array_max(katint) from $not_nullable_tb order by id" + order_qt_sql_array_max_DecimalV3 "select array_max(kadcml) from $nullable_tb order by id" + order_qt_sql_array_max_DecimalV3_notnull "select array_max(kadcml) from $not_nullable_tb order by id" + + order_qt_sql_array_max_Boolean "select array_max(kabool) from $nullable_tb order by id" + order_qt_sql_array_max_Boolean_notnull "select array_max(kabool) from $not_nullable_tb order by id" + + // TODO enable it when be support character like type + // order_qt_sql_array_max_Char "select array_max(kachr) from $nullable_tb order by id" + // order_qt_sql_array_max_Char_notnull "select array_max(kachr) from $not_nullable_tb order by id" + // order_qt_sql_array_max_Varchar "select array_max(kavchr) from $nullable_tb order by id" + // order_qt_sql_array_max_Varchar_notnull "select array_max(kavchr) from $not_nullable_tb order by id" + // order_qt_sql_array_max_String "select array_max(kastr) from $nullable_tb order by id" + // order_qt_sql_array_max_String_notnull "select array_max(kastr) from $not_nullable_tb order by id" + + order_qt_sql_array_max_DatetimeV2 "select array_max(kadtmv2) from $nullable_tb order by id" + order_qt_sql_array_max_DatetimeV2_notnull "select array_max(kadtmv2) from $not_nullable_tb order by id" + order_qt_sql_array_max_DateV2 "select array_max(kadtv2) from $nullable_tb order by id" + order_qt_sql_array_max_DateV2_notnull "select array_max(kadtv2) from $not_nullable_tb order by id" + + // array_min + order_qt_sql_array_min_Double "select array_min(kadbl) from $nullable_tb order by id" + order_qt_sql_array_min_Double_notnull "select array_min(kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_min_Float "select array_min(kafloat) from $nullable_tb order by id" + order_qt_sql_array_min_Float_notnull "select array_min(kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_min_LargeInt "select array_min(kalint) from $nullable_tb order by id" + order_qt_sql_array_min_LargeInt_notnull "select array_min(kalint) from $not_nullable_tb order by id" + order_qt_sql_array_min_BigInt "select array_min(kabint) from $nullable_tb order by id" + order_qt_sql_array_min_BigInt_notnull "select array_min(kabint) from $not_nullable_tb order by id" + order_qt_sql_array_min_SmallInt "select array_min(kasint) from $nullable_tb order by id" + order_qt_sql_array_min_SmallInt_notnull "select array_min(kasint) from $not_nullable_tb order by id" + order_qt_sql_array_min_Integer "select array_min(kaint) from $nullable_tb order by id" + order_qt_sql_array_min_Integer_notnull "select array_min(kaint) from $not_nullable_tb order by id" + order_qt_sql_array_min_TinyInt "select array_min(katint) from $nullable_tb order by id" + order_qt_sql_array_min_TinyInt_notnull "select array_min(katint) from $not_nullable_tb order by id" + order_qt_sql_array_min_DecimalV3 "select array_min(kadcml) from $nullable_tb order by id" + order_qt_sql_array_min_DecimalV3_notnull "select array_min(kadcml) from $not_nullable_tb order by id" + + order_qt_sql_array_min_Boolean "select array_min(kabool) from $nullable_tb order by id" + order_qt_sql_array_min_Boolean_notnull "select array_min(kabool) from $not_nullable_tb order by id" + + // TODO enable it when be support character like type + // order_qt_sql_array_min_Char "select array_min(kachr) from $nullable_tb order by id" + // order_qt_sql_array_min_Char_notnull "select array_min(kachr) from $not_nullable_tb order by id" + // order_qt_sql_array_min_Varchar "select array_min(kavchr) from $nullable_tb order by id" + // order_qt_sql_array_min_Varchar_notnull "select array_min(kavchr) from $not_nullable_tb order by id" + // order_qt_sql_array_min_String "select array_min(kastr) from $nullable_tb order by id" + // order_qt_sql_array_min_String_notnull "select array_min(kastr) from $not_nullable_tb order by id" + + order_qt_sql_array_min_DatetimeV2 "select array_min(kadtmv2) from $nullable_tb order by id" + order_qt_sql_array_min_DatetimeV2_notnull "select array_min(kadtmv2) from $not_nullable_tb order by id" + order_qt_sql_array_min_DateV2 "select array_min(kadtv2) from $nullable_tb order by id" + order_qt_sql_array_min_DateV2_notnull "select array_min(kadtv2) from $not_nullable_tb order by id" + + // array_popback + order_qt_sql_array_popback_Double "select array_popback(kadbl) from $nullable_tb order by id" + order_qt_sql_array_popback_Double_notnull "select array_popback(kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_popback_Float "select array_popback(kafloat) from $nullable_tb order by id" + order_qt_sql_array_popback_Float_notnull "select array_popback(kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_popback_LargeInt "select array_popback(kalint) from $nullable_tb order by id" + order_qt_sql_array_popback_LargeInt_notnull "select array_popback(kalint) from $not_nullable_tb order by id" + order_qt_sql_array_popback_BigInt "select array_popback(kabint) from $nullable_tb order by id" + order_qt_sql_array_popback_BigInt_notnull "select array_popback(kabint) from $not_nullable_tb order by id" + order_qt_sql_array_popback_SmallInt "select array_popback(kasint) from $nullable_tb order by id" + order_qt_sql_array_popback_SmallInt_notnull "select array_popback(kasint) from $not_nullable_tb order by id" + order_qt_sql_array_popback_Integer "select array_popback(kaint) from $nullable_tb order by id" + order_qt_sql_array_popback_Integer_notnull "select array_popback(kaint) from $not_nullable_tb order by id" + order_qt_sql_array_popback_TinyInt "select array_popback(katint) from $nullable_tb order by id" + order_qt_sql_array_popback_TinyInt_notnull "select array_popback(katint) from $not_nullable_tb order by id" + order_qt_sql_array_popback_DecimalV3 "select array_popback(kadcml) from $nullable_tb order by id" + order_qt_sql_array_popback_DecimalV3_notnull "select array_popback(kadcml) from $not_nullable_tb order by id" + + order_qt_sql_array_popback_Boolean "select array_popback(kabool) from $nullable_tb order by id" + order_qt_sql_array_popback_Boolean_notnull "select array_popback(kabool) from $not_nullable_tb order by id" + + order_qt_sql_array_popback_Char "select array_popback(kachr) from $nullable_tb order by id" + order_qt_sql_array_popback_Char_notnull "select array_popback(kachr) from $not_nullable_tb order by id" + order_qt_sql_array_popback_Varchar "select array_popback(kavchr) from $nullable_tb order by id" + order_qt_sql_array_popback_Varchar_notnull "select array_popback(kavchr) from $not_nullable_tb order by id" + order_qt_sql_array_popback_String "select array_popback(kastr) from $nullable_tb order by id" + order_qt_sql_array_popback_String_notnull "select array_popback(kastr) from $not_nullable_tb order by id" + + order_qt_sql_array_popback_DatetimeV2 "select array_popback(kadtmv2) from $nullable_tb order by id" + order_qt_sql_array_popback_DatetimeV2_notnull "select array_popback(kadtmv2) from $not_nullable_tb order by id" + order_qt_sql_array_popback_DateV2 "select array_popback(kadtv2) from $nullable_tb order by id" + order_qt_sql_array_popback_DateV2_notnull "select array_popback(kadtv2) from $not_nullable_tb order by id" + + // array_popfront + order_qt_sql_array_popfront_Double "select array_popfront(kadbl) from $nullable_tb order by id" + order_qt_sql_array_popfront_Double_notnull "select array_popfront(kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_popfront_Float "select array_popfront(kafloat) from $nullable_tb order by id" + order_qt_sql_array_popfront_Float_notnull "select array_popfront(kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_popfront_LargeInt "select array_popfront(kalint) from $nullable_tb order by id" + order_qt_sql_array_popfront_LargeInt_notnull "select array_popfront(kalint) from $not_nullable_tb order by id" + order_qt_sql_array_popfront_BigInt "select array_popfront(kabint) from $nullable_tb order by id" + order_qt_sql_array_popfront_BigInt_notnull "select array_popfront(kabint) from $not_nullable_tb order by id" + order_qt_sql_array_popfront_SmallInt "select array_popfront(kasint) from $nullable_tb order by id" + order_qt_sql_array_popfront_SmallInt_notnull "select array_popfront(kasint) from $not_nullable_tb order by id" + order_qt_sql_array_popfront_Integer "select array_popfront(kaint) from $nullable_tb order by id" + order_qt_sql_array_popfront_Integer_notnull "select array_popfront(kaint) from $not_nullable_tb order by id" + order_qt_sql_array_popfront_TinyInt "select array_popfront(katint) from $nullable_tb order by id" + order_qt_sql_array_popfront_TinyInt_notnull "select array_popfront(katint) from $not_nullable_tb order by id" + order_qt_sql_array_popfront_DecimalV3 "select array_popfront(kadcml) from $nullable_tb order by id" + order_qt_sql_array_popfront_DecimalV3_notnull "select array_popfront(kadcml) from $not_nullable_tb order by id" + + order_qt_sql_array_popfront_Boolean "select array_popfront(kabool) from $nullable_tb order by id" + order_qt_sql_array_popfront_Boolean_notnull "select array_popfront(kabool) from $not_nullable_tb order by id" + + order_qt_sql_array_popfront_Char "select array_popfront(kachr) from $nullable_tb order by id" + order_qt_sql_array_popfront_Char_notnull "select array_popfront(kachr) from $not_nullable_tb order by id" + order_qt_sql_array_popfront_Varchar "select array_popfront(kavchr) from $nullable_tb order by id" + order_qt_sql_array_popfront_Varchar_notnull "select array_popfront(kavchr) from $not_nullable_tb order by id" + order_qt_sql_array_popfront_String "select array_popfront(kastr) from $nullable_tb order by id" + order_qt_sql_array_popfront_String_notnull "select array_popfront(kastr) from $not_nullable_tb order by id" + + order_qt_sql_array_popfront_DatetimeV2 "select array_popfront(kadtmv2) from $nullable_tb order by id" + order_qt_sql_array_popfront_DatetimeV2_notnull "select array_popfront(kadtmv2) from $not_nullable_tb order by id" + order_qt_sql_array_popfront_DateV2 "select array_popfront(kadtv2) from $nullable_tb order by id" + order_qt_sql_array_popfront_DateV2_notnull "select array_popfront(kadtv2) from $not_nullable_tb order by id" + + // array_position + order_qt_sql_array_position_Double "select array_position(kadbl, element_at(kadbl, 1)) from $nullable_tb order by id" + order_qt_sql_array_position_Double_notnull "select array_position(kadbl, element_at(kadbl, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_position_Float "select array_position(kafloat, element_at(kafloat, 1)) from $nullable_tb order by id" + order_qt_sql_array_position_Float_notnull "select array_position(kafloat, element_at(kafloat, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_position_LargeInt "select array_position(kalint, element_at(kalint, 1)) from $nullable_tb order by id" + order_qt_sql_array_position_LargeInt_notnull "select array_position(kalint, element_at(kalint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_position_BigInt "select array_position(kabint, element_at(kabint, 1)) from $nullable_tb order by id" + order_qt_sql_array_position_BigInt_notnull "select array_position(kabint, element_at(kabint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_position_SmallInt "select array_position(kasint, element_at(kasint, 1)) from $nullable_tb order by id" + order_qt_sql_array_position_SmallInt_notnull "select array_position(kasint, element_at(kasint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_position_Integer "select array_position(kasint, element_at(kasint, 1)) from $nullable_tb order by id" + order_qt_sql_array_position_Integer_notnull "select array_position(kaint, element_at(kaint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_position_TinyInt "select array_position(katint, element_at(katint, 1)) from $nullable_tb order by id" + order_qt_sql_array_position_TinyInt_notnull "select array_position(katint, element_at(katint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_position_DecimalV3 "select array_position(kadcml, element_at(kadcml, 1)) from $nullable_tb order by id" + order_qt_sql_array_position_DecimalV3_notnull "select array_position(kadcml, element_at(kadcml, 1)) from $not_nullable_tb order by id" + + order_qt_sql_array_position_Boolean "select array_position(kabool, element_at(kabool, 1)) from $nullable_tb order by id" + order_qt_sql_array_position_Boolean_notnull "select array_position(kabool, element_at(kabool, 1)) from $not_nullable_tb order by id" + + order_qt_sql_array_position_Char "select array_position(kachr, element_at(kachr, 1)) from $nullable_tb order by id" + order_qt_sql_array_position_Char_notnull "select array_position(kachr, element_at(kachr, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_position_Varchar "select array_position(kavchr, element_at(kavchr, 1)) from $nullable_tb order by id" + order_qt_sql_array_position_Varchar_notnull "select array_position(kavchr, element_at(kavchr, 1)) from $not_nullable_tb order by id" + + order_qt_sql_array_position_DatetimeV2 "select array_position(kadtmv2, element_at(kadtmv2, 1)) from $nullable_tb order by id" + order_qt_sql_array_position_DatetimeV2_notnull "select array_position(kadtmv2, element_at(kadtmv2, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_position_DateV2 "select array_position(kadtv2, element_at(kadtv2, 1)) from $nullable_tb order by id" + order_qt_sql_array_position_DateV2_notnull "select array_position(kadtv2, element_at(kadtv2, 1)) from $not_nullable_tb order by id" + + // array_product + order_qt_sql_array_product_Double "select array_product(kadbl) from $nullable_tb order by id" + order_qt_sql_array_product_Double_notnull "select array_product(kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_product_Float "select array_product(kafloat) from $nullable_tb order by id" + order_qt_sql_array_product_Float_notnull "select array_product(kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_product_LargeInt "select array_product(kalint) from $nullable_tb order by id" + order_qt_sql_array_product_LargeInt_notnull "select array_product(kalint) from $not_nullable_tb order by id" + order_qt_sql_array_product_BigInt "select array_product(kabint) from $nullable_tb order by id" + order_qt_sql_array_product_BigInt_notnull "select array_product(kabint) from $not_nullable_tb order by id" + order_qt_sql_array_product_SmallInt "select array_product(kasint) from $nullable_tb order by id" + order_qt_sql_array_product_SmallInt_notnull "select array_product(kasint) from $not_nullable_tb order by id" + order_qt_sql_array_product_Integer "select array_product(kaint) from $nullable_tb order by id" + order_qt_sql_array_product_Integer_notnull "select array_product(kaint) from $not_nullable_tb order by id" + order_qt_sql_array_product_TinyInt "select array_product(katint) from $nullable_tb order by id" + order_qt_sql_array_product_TinyInt_notnull "select array_product(katint) from $not_nullable_tb order by id" + order_qt_sql_array_product_DecimalV3 "select array_product(kadcml) from $nullable_tb order by id" + order_qt_sql_array_product_DecimalV3_notnull "select array_product(kadcml) from $not_nullable_tb order by id" + + // array_pushback + order_qt_sql_array_pushback_Double "select array_pushback(kadbl, element_at(kadbl, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushback_Double_notnull "select array_pushback(kadbl, element_at(kadbl, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushback_Float "select array_pushback(kafloat, element_at(kafloat, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushback_Float_notnull "select array_pushback(kafloat, element_at(kafloat, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushback_LargeInt "select array_pushback(kalint, element_at(kalint, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushback_LargeInt_notnull "select array_pushback(kalint, element_at(kalint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushback_BigInt "select array_pushback(kabint, element_at(kabint, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushback_BigInt_notnull "select array_pushback(kabint, element_at(kabint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushback_SmallInt "select array_pushback(kasint, element_at(kasint, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushback_SmallInt_notnull "select array_pushback(kasint, element_at(kasint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushback_Integer "select array_pushback(kaint, element_at(kaint, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushback_Integer_notnull "select array_pushback(kaint, element_at(kaint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushback_TinyInt "select array_pushback(katint, element_at(katint, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushback_TinyInt_notnull "select array_pushback(katint, element_at(katint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushback_DecimalV3 "select array_pushback(kadcml, element_at(kadcml, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushback_DecimalV3_notnull "select array_pushback(kadcml, element_at(kadcml, 1)) from $not_nullable_tb order by id" + + order_qt_sql_array_pushback_Boolean "select array_pushback(kabool, element_at(kabool, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushback_Boolean_notnull "select array_pushback(kabool, element_at(kabool, 1)) from $not_nullable_tb order by id" + + order_qt_sql_array_pushback_Char "select array_pushback(kachr, element_at(kachr, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushback_Char_notnull "select array_pushback(kachr, element_at(kachr, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushback_Varchar "select array_pushback(kavchr, element_at(kavchr, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushback_Varchar_notnull "select array_pushback(kavchr, element_at(kavchr, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushback_String "select array_pushback(kastr, element_at(kastr, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushback_String_notnull "select array_pushback(kastr, element_at(kastr, 1)) from $not_nullable_tb order by id" + + order_qt_sql_array_pushback_DatetimeV2 "select array_pushback(kadtmv2, element_at(kadtmv2, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushback_DatetimeV2_notnull "select array_pushback(kadtmv2, element_at(kadtmv2, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushback_DateV2 "select array_pushback(kadtv2, element_at(kadtv2, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushback_DateV2_notnull "select array_pushback(kadtv2, element_at(kadtv2, 1)) from $not_nullable_tb order by id" + + // array_pushfront + order_qt_sql_array_pushfront_Double "select array_pushfront(kadbl, element_at(kadbl, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushfront_Double_notnull "select array_pushfront(kadbl, element_at(kadbl, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushfront_Float "select array_pushfront(kafloat, element_at(kafloat, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushfront_Float_notnull "select array_pushfront(kafloat, element_at(kafloat, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushfront_LargeInt "select array_pushfront(kalint, element_at(kalint, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushfront_LargeInt_notnull "select array_pushfront(kalint, element_at(kalint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushfront_BigInt "select array_pushfront(kabint, element_at(kabint, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushfront_BigInt_notnull "select array_pushfront(kabint, element_at(kabint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushfront_SmallInt "select array_pushfront(kasint, element_at(kasint, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushfront_SmallInt_notnull "select array_pushfront(kasint, element_at(kasint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushfront_Integer "select array_pushfront(kaint, element_at(kaint, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushfront_Integer_notnull "select array_pushfront(kaint, element_at(kaint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushfront_TinyInt "select array_pushfront(katint, element_at(katint, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushfront_TinyInt_notnull "select array_pushfront(katint, element_at(katint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushfront_DecimalV3 "select array_pushfront(kadcml, element_at(kadcml, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushfront_DecimalV3_notnull "select array_pushfront(kadcml, element_at(kadcml, 1)) from $not_nullable_tb order by id" + + order_qt_sql_array_pushfront_Boolean "select array_pushfront(kabool, element_at(kabool, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushfront_Boolean_notnull "select array_pushfront(kabool, element_at(kabool, 1)) from $not_nullable_tb order by id" + + order_qt_sql_array_pushfront_Char "select array_pushfront(kachr, element_at(kachr, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushfront_Char_notnull "select array_pushfront(kachr, element_at(kachr, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushfront_Varchar "select array_pushfront(kavchr, element_at(kavchr, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushfront_Varchar_notnull "select array_pushfront(kavchr, element_at(kavchr, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushfront_String "select array_pushfront(kastr, element_at(kastr, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushfront_String_notnull "select array_pushfront(kastr, element_at(kastr, 1)) from $not_nullable_tb order by id" + + order_qt_sql_array_pushfront_DatetimeV2 "select array_pushfront(kadtmv2, element_at(kadtmv2, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushfront_DatetimeV2_notnull "select array_pushfront(kadtmv2, element_at(kadtmv2, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_pushfront_DateV2 "select array_pushfront(kadtv2, element_at(kadtv2, 1)) from $nullable_tb order by id" + order_qt_sql_array_pushfront_DateV2_notnull "select array_pushfront(kadtv2, element_at(kadtv2, 1)) from $not_nullable_tb order by id" + + // array_range param is null may cause error +// order_qt_sql_array_range_one_param "select array_range(element_at(kaint, 1)) from $nullable_tb order by id limit 5" +// order_qt_sql_array_range_one_param_notnull "select array_range(element_at(kaint, 1)) from $not_nullable_tb order by id limit 5" +// order_qt_sql_array_range_two_param "select array_range(element_at(kaint, 1), 1000) from $nullable_tb order by id limit 5" +// order_qt_sql_array_range_two_param_notnull "select array_range(element_at(kaint, 1), 1000) from $not_nullable_tb order by id limit 5" +// order_qt_sql_array_range_three_param "select array_range(element_at(kaint, 1), 10000, element_at(katint, 1)) from $nullable_tb order by id" +// order_qt_sql_array_range_three_param_notnull "select array_range(element_at(kaint, 1), 10000, element_at(katint, 1)) from $not_nullable_tb order by id" + + // make a large size of array element, expect to throw error + test { + sql "select array_range(element_at(kaint, 1), 1000000000) from $nullable_tb order by id" + exception('Array size exceeds the limit 1000000') + } + + // array_remove + order_qt_sql_array_remove_Double "select array_remove(kadbl, element_at(kadbl, 1)) from $nullable_tb order by id" + order_qt_sql_array_remove_Double_notnull "select array_remove(kadbl, element_at(kadbl, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_remove_Float "select array_remove(kafloat, element_at(kafloat, 1)) from $nullable_tb order by id" + order_qt_sql_array_remove_Float_notnull "select array_remove(kafloat, element_at(kafloat, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_remove_LargeInt "select array_remove(kalint, element_at(kalint, 1)) from $nullable_tb order by id" + order_qt_sql_array_remove_LargeInt_notnull "select array_remove(kalint, element_at(kalint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_remove_BigInt "select array_remove(kabint, element_at(kabint, 1)) from $nullable_tb order by id" + order_qt_sql_array_remove_BigInt_notnull "select array_remove(kabint, element_at(kabint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_remove_SmallInt "select array_remove(kasint, element_at(kasint, 1)) from $nullable_tb order by id" + order_qt_sql_array_remove_SmallInt_notnull "select array_remove(kasint, element_at(kasint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_remove_Integer "select array_remove(kaint, element_at(kaint, 1)) from $nullable_tb order by id" + order_qt_sql_array_remove_Integer_notnull "select array_remove(kaint, element_at(kaint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_remove_TinyInt "select array_remove(katint, element_at(katint, 1)) from $nullable_tb order by id" + order_qt_sql_array_remove_TinyInt_notnull "select array_remove(katint, element_at(katint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_remove_DecimalV3 "select array_remove(kadcml, element_at(kadcml, 1)) from $nullable_tb order by id" + order_qt_sql_array_remove_DecimalV3_notnull "select array_remove(kadcml, element_at(kadcml, 1)) from $not_nullable_tb order by id" + + order_qt_sql_array_remove_Boolean "select array_remove(kabool, element_at(kabool, 1)) from $nullable_tb order by id" + order_qt_sql_array_remove_Boolean_notnull "select array_remove(kabool, element_at(kabool, 1)) from $not_nullable_tb order by id" + + order_qt_sql_array_remove_Char "select array_remove(kachr, element_at(kachr, 1)) from $nullable_tb order by id" + order_qt_sql_array_remove_Char_notnull "select array_remove(kachr, element_at(kachr, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_remove_Varchar "select array_remove(kavchr, element_at(kavchr, 1)) from $nullable_tb order by id" + order_qt_sql_array_remove_Varchar_notnull "select array_remove(kavchr, element_at(kavchr, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_remove_String "select array_remove(kastr, element_at(kastr, 1)) from $nullable_tb order by id" + order_qt_sql_array_remove_String_notnull "select array_remove(kastr, element_at(kastr, 1)) from $not_nullable_tb order by id" + + order_qt_sql_array_remove_DatetimeV2 "select array_remove(kadtmv2, element_at(kadtmv2, 1)) from $nullable_tb order by id" + order_qt_sql_array_remove_DatetimeV2_notnull "select array_remove(kadtmv2, element_at(kadtmv2, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_remove_DateV2 "select array_remove(kadtv2, element_at(kadtv2, 1)) from $nullable_tb order by id" + order_qt_sql_array_remove_DateV2_notnull "select array_remove(kadtv2, element_at(kadtv2, 1)) from $not_nullable_tb order by id" + + // array_reverse_sort + order_qt_sql_array_reverse_sort_Double "select array_reverse_sort(kadbl) from $nullable_tb order by id" + order_qt_sql_array_reverse_sort_Double_notnull "select array_reverse_sort(kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_reverse_sort_Float "select array_reverse_sort(kafloat) from $nullable_tb order by id" + order_qt_sql_array_reverse_sort_Float_notnull "select array_reverse_sort(kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_reverse_sort_LargeInt "select array_reverse_sort(kalint) from $nullable_tb order by id" + order_qt_sql_array_reverse_sort_LargeInt_notnull "select array_reverse_sort(kalint) from $not_nullable_tb order by id" + order_qt_sql_array_reverse_sort_BigInt "select array_reverse_sort(kabint) from $nullable_tb order by id" + order_qt_sql_array_reverse_sort_BigInt_notnull "select array_reverse_sort(kabint) from $not_nullable_tb order by id" + order_qt_sql_array_reverse_sort_SmallInt "select array_reverse_sort(kasint) from $nullable_tb order by id" + order_qt_sql_array_reverse_sort_SmallInt_notnull "select array_reverse_sort(kasint) from $not_nullable_tb order by id" + order_qt_sql_array_reverse_sort_Integer "select array_reverse_sort(kaint) from $nullable_tb order by id" + order_qt_sql_array_reverse_sort_Integer_notnull "select array_reverse_sort(kaint) from $not_nullable_tb order by id" + order_qt_sql_array_reverse_sort_TinyInt "select array_reverse_sort(katint) from $nullable_tb order by id" + order_qt_sql_array_reverse_sort_TinyInt_notnull "select array_reverse_sort(katint) from $not_nullable_tb order by id" + order_qt_sql_array_reverse_sort_DecimalV3 "select array_reverse_sort(kadcml) from $nullable_tb order by id" + order_qt_sql_array_reverse_sort_DecimalV3_notnull "select array_reverse_sort(kadcml) from $not_nullable_tb order by id" + + order_qt_sql_array_reverse_sort_Boolean "select array_reverse_sort(kabool) from $nullable_tb order by id" + order_qt_sql_array_reverse_sort_Boolean_notnull "select array_reverse_sort(kabool) from $not_nullable_tb order by id" + + order_qt_sql_array_reverse_sort_Char "select array_reverse_sort(kachr) from $nullable_tb order by id" + order_qt_sql_array_reverse_sort_Char_notnull "select array_reverse_sort(kachr) from $not_nullable_tb order by id" + order_qt_sql_array_reverse_sort_Varchar "select array_reverse_sort(kavchr) from $nullable_tb order by id" + order_qt_sql_array_reverse_sort_Varchar_notnull "select array_reverse_sort(kavchr) from $not_nullable_tb order by id" + order_qt_sql_array_reverse_sort_String "select array_reverse_sort(kastr) from $nullable_tb order by id" + order_qt_sql_array_reverse_sort_String_notnull "select array_reverse_sort(kastr) from $not_nullable_tb order by id" + + order_qt_sql_array_reverse_sort_DatetimeV2 "select array_reverse_sort(kadtmv2) from $nullable_tb order by id" + order_qt_sql_array_reverse_sort_DatetimeV2_notnull "select array_reverse_sort(kadtmv2) from $not_nullable_tb order by id" + order_qt_sql_array_reverse_sort_DateV2 "select array_reverse_sort(kadtv2) from $nullable_tb order by id" + order_qt_sql_array_reverse_sort_DateV2_notnull "select array_reverse_sort(kadtv2) from $not_nullable_tb order by id" + + // array_slice + order_qt_sql_array_slice_Double "select array_slice(kadbl, element_at(kaint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_Double_notnull "select array_slice(kadbl, element_at(kaint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_Float "select array_slice(kafloat, element_at(kaint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_Float_notnull "select array_slice(kafloat, element_at(kaint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_LargeInt "select array_slice(kalint, element_at(kaint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_LargeInt_notnull "select array_slice(kalint, element_at(kaint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_BigInt "select array_slice(kabint, element_at(kaint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_BigInt_notnull "select array_slice(kabint, element_at(kaint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_SmallInt "select array_slice(kasint, element_at(kaint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_SmallInt_notnull "select array_slice(kasint, element_at(kaint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_Integer "select array_slice(kaint, element_at(kaint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_Integer_notnull "select array_slice(kaint, element_at(kaint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_TinyInt "select array_slice(katint, element_at(kaint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_TinyInt_notnull "select array_slice(katint, element_at(kaint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_DecimalV3 "select array_slice(kadcml, element_at(kaint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_DecimalV3_notnull "select array_slice(kadcml, element_at(kaint, 1)) from $not_nullable_tb order by id" + + order_qt_sql_array_slice_Boolean "select array_slice(kabool, element_at(kaint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_Boolean_notnull "select array_slice(kabool, element_at(kaint, 1)) from $not_nullable_tb order by id" + + order_qt_sql_array_slice_Char "select array_slice(kachr, element_at(kaint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_Char_notnull "select array_slice(kachr, element_at(kaint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_Varchar "select array_slice(kavchr, element_at(kaint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_Varchar_notnull "select array_slice(kavchr, element_at(kaint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_String "select array_slice(kastr, element_at(kaint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_String_notnull "select array_slice(kastr, element_at(kaint, 1)) from $not_nullable_tb order by id" + + order_qt_sql_array_slice_DatetimeV2 "select array_slice(kadtmv2, element_at(kaint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_DatetimeV2_notnull "select array_slice(kadtmv2, element_at(kaint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_DateV2 "select array_slice(kadtv2, element_at(kaint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_DateV2_notnull "select array_slice(kadtv2, element_at(kaint, 1)) from $not_nullable_tb order by id" + + // array_slice + order_qt_sql_array_slice_three_params_Double "select array_slice(kadbl, element_at(kaint, 1), element_at(katint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_three_params_Double_notnull "select array_slice(kadbl, element_at(kaint, 1), element_at(katint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_three_params_Float "select array_slice(kafloat, element_at(kaint, 1), element_at(katint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_three_params_Float_notnull "select array_slice(kafloat, element_at(kaint, 1), element_at(katint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_three_params_LargeInt "select array_slice(kalint, element_at(kaint, 1), element_at(katint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_three_params_LargeInt_notnull "select array_slice(kalint, element_at(kaint, 1), element_at(katint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_three_params_BigInt "select array_slice(kabint, element_at(kaint, 1), element_at(katint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_three_params_BigInt_notnull "select array_slice(kabint, element_at(kaint, 1), element_at(katint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_three_params_SmallInt "select array_slice(kasint, element_at(kaint, 1), element_at(katint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_three_params_SmallInt_notnull "select array_slice(kasint, element_at(kaint, 1), element_at(katint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_three_params_Integer "select array_slice(kaint, element_at(kaint, 1), element_at(katint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_three_params_Integer_notnull "select array_slice(kaint, element_at(kaint, 1), element_at(katint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_three_params_TinyInt "select array_slice(katint, element_at(kaint, 1), element_at(katint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_three_params_TinyInt_notnull "select array_slice(katint, element_at(kaint, 1), element_at(katint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_three_params_DecimalV3 "select array_slice(kadcml, element_at(kaint, 1), element_at(katint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_three_params_DecimalV3_notnull "select array_slice(kadcml, element_at(kaint, 1), element_at(katint, 1)) from $not_nullable_tb order by id" + + order_qt_sql_array_slice_three_params_Boolean "select array_slice(kabool, element_at(kaint, 1), element_at(katint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_three_params_Boolean_notnull "select array_slice(kabool, element_at(kaint, 1), element_at(katint, 1)) from $not_nullable_tb order by id" + + order_qt_sql_array_slice_three_params_Char "select array_slice(kachr, element_at(kaint, 1), element_at(katint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_three_params_Char_notnull "select array_slice(kachr, element_at(kaint, 1), element_at(katint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_three_params_Varchar "select array_slice(kavchr, element_at(kaint, 1), element_at(katint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_three_params_Varchar_notnull "select array_slice(kavchr, element_at(kaint, 1), element_at(katint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_three_params_String "select array_slice(kastr, element_at(kaint, 1), element_at(katint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_three_params_String_notnull "select array_slice(kastr, element_at(kaint, 1), element_at(katint, 1)) from $not_nullable_tb order by id" + + order_qt_sql_array_slice_three_params_DatetimeV2 "select array_slice(kadtmv2, element_at(kaint, 1), element_at(katint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_three_params_DatetimeV2_notnull "select array_slice(kadtmv2, element_at(kaint, 1), element_at(katint, 1)) from $not_nullable_tb order by id" + order_qt_sql_array_slice_three_params_DateV2 "select array_slice(kadtv2, element_at(kaint, 1), element_at(katint, 1)) from $nullable_tb order by id" + order_qt_sql_array_slice_three_params_DateV2_notnull "select array_slice(kadtv2, element_at(kaint, 1), element_at(katint, 1)) from $not_nullable_tb order by id" + + // array_sort + order_qt_sql_array_sort_Double "select array_sort(kadbl) from $nullable_tb order by id" + order_qt_sql_array_sort_Double_notnull "select array_sort(kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_sort_Float "select array_sort(kafloat) from $nullable_tb order by id" + order_qt_sql_array_sort_Float_notnull "select array_sort(kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_sort_LargeInt "select array_sort(kalint) from $nullable_tb order by id" + order_qt_sql_array_sort_LargeInt_notnull "select array_sort(kalint) from $not_nullable_tb order by id" + order_qt_sql_array_sort_BigInt "select array_sort(kabint) from $nullable_tb order by id" + order_qt_sql_array_sort_BigInt_notnull "select array_sort(kabint) from $not_nullable_tb order by id" + order_qt_sql_array_sort_SmallInt "select array_sort(kasint) from $nullable_tb order by id" + order_qt_sql_array_sort_SmallInt_notnull "select array_sort(kasint) from $not_nullable_tb order by id" + order_qt_sql_array_sort_Integer "select array_sort(kaint) from $nullable_tb order by id" + order_qt_sql_array_sort_Integer_notnull "select array_sort(kaint) from $not_nullable_tb order by id" + order_qt_sql_array_sort_TinyInt "select array_sort(katint) from $nullable_tb order by id" + order_qt_sql_array_sort_TinyInt_notnull "select array_sort(katint) from $not_nullable_tb order by id" + order_qt_sql_array_sort_DecimalV3 "select array_sort(kadcml) from $nullable_tb order by id" + order_qt_sql_array_sort_DecimalV3_notnull "select array_sort(kadcml) from $not_nullable_tb order by id" + + order_qt_sql_array_sort_Boolean "select array_sort(kabool) from $nullable_tb order by id" + order_qt_sql_array_sort_Boolean_notnull "select array_sort(kabool) from $not_nullable_tb order by id" + + order_qt_sql_array_sort_Char "select array_sort(kachr) from $nullable_tb order by id" + order_qt_sql_array_sort_Char_notnull "select array_sort(kachr) from $not_nullable_tb order by id" + order_qt_sql_array_sort_Varchar "select array_sort(kavchr) from $nullable_tb order by id" + order_qt_sql_array_sort_Varchar_notnull "select array_sort(kavchr) from $not_nullable_tb order by id" + order_qt_sql_array_sort_String "select array_sort(kastr) from $nullable_tb order by id" + order_qt_sql_array_sort_String_notnull "select array_sort(kastr) from $not_nullable_tb order by id" + + order_qt_sql_array_sort_DatetimeV2 "select array_sort(kadtmv2) from $nullable_tb order by id" + order_qt_sql_array_sort_DatetimeV2_notnull "select array_sort(kadtmv2) from $not_nullable_tb order by id" + order_qt_sql_array_sort_DateV2 "select array_sort(kadtv2) from $nullable_tb order by id" + order_qt_sql_array_sort_DateV2_notnull "select array_sort(kadtv2) from $not_nullable_tb order by id" + + // array_sum + order_qt_sql_array_sum_Double "select array_sum(kadbl) from $nullable_tb order by id" + order_qt_sql_array_sum_Double_notnull "select array_sum(kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_sum_Float "select array_sum(kafloat) from $nullable_tb order by id" + order_qt_sql_array_sum_Float_notnull "select array_sum(kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_sum_LargeInt "select array_sum(kalint) from $nullable_tb order by id" + order_qt_sql_array_sum_LargeInt_notnull "select array_sum(kalint) from $not_nullable_tb order by id" + order_qt_sql_array_sum_BigInt "select array_sum(kabint) from $nullable_tb order by id" + order_qt_sql_array_sum_BigInt_notnull "select array_sum(kabint) from $not_nullable_tb order by id" + order_qt_sql_array_sum_SmallInt "select array_sum(kasint) from $nullable_tb order by id" + order_qt_sql_array_sum_SmallInt_notnull "select array_sum(kasint) from $not_nullable_tb order by id" + order_qt_sql_array_sum_Integer "select array_sum(kaint) from $nullable_tb order by id" + order_qt_sql_array_sum_Integer_notnull "select array_sum(kaint) from $not_nullable_tb order by id" + order_qt_sql_array_sum_TinyInt "select array_sum(katint) from $nullable_tb order by id" + order_qt_sql_array_sum_TinyInt_notnull "select array_sum(katint) from $not_nullable_tb order by id" + order_qt_sql_array_sum_DecimalV3 "select array_sum(kadcml) from $nullable_tb order by id" + order_qt_sql_array_sum_DecimalV3_notnull "select array_sum(kadcml) from $not_nullable_tb order by id" + + // array_union + order_qt_sql_array_union_Double "select array_sort(array_union(kadbl, kadbl)) from $nullable_tb order by id" + order_qt_sql_array_union_Double_notnull "select array_sort(array_union(kadbl, kadbl)) from $not_nullable_tb order by id" + order_qt_sql_array_union_Float "select array_sort(array_union(kafloat, kafloat)) from $nullable_tb order by id" + order_qt_sql_array_union_Float_notnull "select array_sort(array_union(kafloat, kafloat)) from $not_nullable_tb order by id" + order_qt_sql_array_union_LargeInt "select array_sort(array_union(kalint, kalint)) from $nullable_tb order by id" + order_qt_sql_array_union_LargeInt_notnull "select array_sort(array_union(kalint, kalint)) from $not_nullable_tb order by id" + order_qt_sql_array_union_BigInt "select array_sort(array_union(kabint, kabint)) from $nullable_tb order by id" + order_qt_sql_array_union_BigInt_notnull "select array_sort(array_union(kabint, kabint)) from $not_nullable_tb order by id" + order_qt_sql_array_union_SmallInt "select array_sort(array_union(kasint, kasint)) from $nullable_tb order by id" + order_qt_sql_array_union_SmallInt_notnull "select array_sort(array_union(kasint, kasint)) from $not_nullable_tb order by id" + order_qt_sql_array_union_Integer "select array_sort(array_union(kaint, kaint)) from $nullable_tb order by id" + order_qt_sql_array_union_Integer_notnull "select array_sort(array_union(kaint, kaint)) from $not_nullable_tb order by id" + order_qt_sql_array_union_TinyInt "select array_sort(array_union(katint, katint)) from $nullable_tb order by id" + order_qt_sql_array_union_TinyInt_notnull "select array_sort(array_union(katint, katint)) from $not_nullable_tb order by id" + order_qt_sql_array_union_DecimalV3 "select array_sort(array_union(kadcml, kadcml)) from $nullable_tb order by id" + order_qt_sql_array_union_DecimalV3_notnull "select array_sort(array_union(kadcml, kadcml)) from $not_nullable_tb order by id" + + order_qt_sql_array_union_Boolean "select array_sort(array_union(kabool, kabool)) from $nullable_tb order by id" + order_qt_sql_array_union_Boolean_notnull "select array_sort(array_union(kabool, kabool)) from $not_nullable_tb order by id" + + order_qt_sql_array_union_Char "select array_sort(array_union(kachr, kachr)) from $nullable_tb order by id" + order_qt_sql_array_union_Char_notnull "select array_sort(array_union(kachr, kachr)) from $not_nullable_tb order by id" + order_qt_sql_array_union_Varchar "select array_sort(array_union(kavchr, kavchr)) from $nullable_tb order by id" + order_qt_sql_array_union_Varchar_notnull "select array_sort(array_union(kavchr, kavchr)) from $not_nullable_tb order by id" + order_qt_sql_array_union_String "select array_sort(array_union(kastr, kastr)) from $nullable_tb order by id" + order_qt_sql_array_union_String_notnull "select array_sort(array_union(kastr, kastr)) from $not_nullable_tb order by id" + + order_qt_sql_array_union_DatetimeV2 "select array_sort(array_union(kadtmv2, kadtmv2)) from $nullable_tb order by id" + order_qt_sql_array_union_DatetimeV2_notnull "select array_sort(array_union(kadtmv2, kadtmv2)) from $not_nullable_tb order by id" + order_qt_sql_array_union_DateV2 "select array_sort(array_union(kadtv2, kadtv2)) from $nullable_tb order by id" + order_qt_sql_array_union_DateV2_notnull "select array_sort(array_union(kadtv2, kadtv2)) from $not_nullable_tb order by id" + + // array_with_constant + // [INVALID_ARGUMENT]Array size should in range(0, 1000000) +////// order_qt_sql_array_with_constant_Double "select array_with_constant(element_at(kaint, 1), element_at(kadbl, 1)) from $nullable_tb order by id limit 4" +////// order_qt_sql_array_with_constant_Double_notnull "select array_with_constant(element_at(kaint, 1), element_at(kadbl, 1)) from $not_nullable_tb order by id limit 4" +////// order_qt_sql_array_with_constant_Float "select array_with_constant(element_at(kaint, 1), element_at(kafloat, 1)) from $nullable_tb order by id limit 4" +////// order_qt_sql_array_with_constant_Float_notnull "select array_with_constant(element_at(kaint, 1), element_at(kafloat, 1)) from $not_nullable_tb order by id limit 4" +//// order_qt_sql_array_with_constant_LargeInt "select array_with_constant(element_at(kaint, 1), element_at(kalint, 1)) from $nullable_tb order by id" +//// order_qt_sql_array_with_constant_LargeInt_notnull "select array_with_constant(element_at(kaint, 1), element_at(kalint, 1)) from $not_nullable_tb order by id" +//// order_qt_sql_array_with_constant_BigInt "select array_with_constant(element_at(kaint, 1), element_at(kabint, 1)) from $nullable_tb order by id" +//// order_qt_sql_array_with_constant_BigInt_notnull "select array_with_constant(element_at(kaint, 1), element_at(kabint, 1)) from $not_nullable_tb order by id" +// order_qt_sql_array_with_constant_SmallInt "select array_with_constant(element_at(kasint, 1), element_at(kasint, 1)) from $nullable_tb order by id" +// order_qt_sql_array_with_constant_SmallInt_notnull "select array_with_constant(element_at(kasint, 1), element_at(kasint, 1)) from $not_nullable_tb order by id" +// order_qt_sql_array_with_constant_Integer "select array_with_constant(element_at(kaint, 1), element_at(kaint, 1)) from $nullable_tb order by id" +// order_qt_sql_array_with_constant_Integer_notnull "select array_with_constant(element_at(kaint, 1), element_at(kaint, 1)) from $not_nullable_tb order by id" +// order_qt_sql_array_with_constant_TinyInt "select array_with_constant(element_at(katint, 1), element_at(katint, 1)) from $nullable_tb order by id" +// order_qt_sql_array_with_constant_TinyInt_notnull "select array_with_constant(element_at(katint, 1), element_at(katint, 1)) from $not_nullable_tb order by id" +// order_qt_sql_array_with_constant_DecimalV3 "select array_with_constant(element_at(kadcml, 1), element_at(kadcml, 1)) from $nullable_tb order by id" +// order_qt_sql_array_with_constant_DecimalV3_notnull "select array_with_constant(element_at(kadcml, 1), element_at(kadcml, 1)) from $not_nullable_tb order by id" +// +// order_qt_sql_array_with_constant_Boolean "select array_with_constant(element_at(kabool, 1), element_at(kabool, 1)) from $nullable_tb order by id" +// order_qt_sql_array_with_constant_Boolean_notnull "select array_with_constant(element_at(kabool, 1), element_at(kabool, 1)) from $not_nullable_tb order by id" +// +// order_qt_sql_array_with_constant_Char "select array_with_constant(element_at(kaint, 1), element_at(kachr, 1)) from $nullable_tb order by id" +// order_qt_sql_array_with_constant_Char_notnull "select array_with_constant(element_at(kaint, 1), element_at(kachr, 1)) from $not_nullable_tb order by id" +// order_qt_sql_array_with_constant_Varchar "select array_with_constant(element_at(kaint, 1), element_at(kavchr, 1)) from $nullable_tb order by id" +// order_qt_sql_array_with_constant_Varchar_notnull "select array_with_constant(element_at(kaint, 1), element_at(kavchr, 1)) from $not_nullable_tb order by id" +// order_qt_sql_array_with_constant_String "select array_with_constant(element_at(kaint, 1), element_at(kastr, 1)) from $nullable_tb order by id" +// order_qt_sql_array_with_constant_String_notnull "select array_with_constant(element_at(kaint, 1), element_at(kastr, 1)) from $not_nullable_tb order by id" + +// order_qt_sql_array_with_constant_DatetimeV2 "select array_with_constant(element_at(kaint, 1), kadtmv2_) from $nullable_tb order by id" +// order_qt_sql_array_with_constant_DatetimeV2_notnull "select array_with_constant(element_at(kaint, 1), kadtmv2_) from $not_nullable_tb order by id" +// order_qt_sql_array_with_constant_DateV2 "select array_with_constant(element_at(kaint, 1), element_at(kadtv2, 1)) from $nullable_tb order by id" +// order_qt_sql_array_with_constant_DateV2_notnull "select array_with_constant(element_at(kaint, 1), element_at(kadtv2, 1)) from $not_nullable_tb order by id" + + // cardinality + order_qt_sql_cardinality_Double "select cardinality(kadbl) from $nullable_tb order by id" + order_qt_sql_cardinality_Double_notnull "select cardinality(kadbl) from $not_nullable_tb order by id" + order_qt_sql_cardinality_Float "select cardinality(kafloat) from $nullable_tb order by id" + order_qt_sql_cardinality_Float_notnull "select cardinality(kafloat) from $not_nullable_tb order by id" + order_qt_sql_cardinality_LargeInt "select cardinality(kalint) from $nullable_tb order by id" + order_qt_sql_cardinality_LargeInt_notnull "select cardinality(kalint) from $not_nullable_tb order by id" + order_qt_sql_cardinality_BigInt "select cardinality(kabint) from $nullable_tb order by id" + order_qt_sql_cardinality_BigInt_notnull "select cardinality(kabint) from $not_nullable_tb order by id" + order_qt_sql_cardinality_SmallInt "select cardinality(kasint) from $nullable_tb order by id" + order_qt_sql_cardinality_SmallInt_notnull "select cardinality(kasint) from $not_nullable_tb order by id" + order_qt_sql_cardinality_Integer "select cardinality(kaint) from $nullable_tb order by id" + order_qt_sql_cardinality_Integer_notnull "select cardinality(kaint) from $not_nullable_tb order by id" + order_qt_sql_cardinality_TinyInt "select cardinality(katint) from $nullable_tb order by id" + order_qt_sql_cardinality_TinyInt_notnull "select cardinality(katint) from $not_nullable_tb order by id" + order_qt_sql_cardinality_DecimalV3 "select cardinality(kadcml) from $nullable_tb order by id" + order_qt_sql_cardinality_DecimalV3_notnull "select cardinality(kadcml) from $not_nullable_tb order by id" + + order_qt_sql_cardinality_Boolean "select cardinality(kabool) from $nullable_tb order by id" + order_qt_sql_cardinality_Boolean_notnull "select cardinality(kabool) from $not_nullable_tb order by id" + + order_qt_sql_cardinality_Char "select cardinality(kachr) from $nullable_tb order by id" + order_qt_sql_cardinality_Char_notnull "select cardinality(kachr) from $not_nullable_tb order by id" + order_qt_sql_cardinality_Varchar "select cardinality(kavchr) from $nullable_tb order by id" + order_qt_sql_cardinality_Varchar_notnull "select cardinality(kavchr) from $not_nullable_tb order by id" + order_qt_sql_cardinality_String "select cardinality(kastr) from $nullable_tb order by id" + order_qt_sql_cardinality_String_notnull "select cardinality(kastr) from $not_nullable_tb order by id" + + order_qt_sql_cardinality_DatetimeV2 "select cardinality(kadtmv2) from $nullable_tb order by id" + order_qt_sql_cardinality_DatetimeV2_notnull "select cardinality(kadtmv2) from $not_nullable_tb order by id" + order_qt_sql_cardinality_DateV2 "select cardinality(kadtv2) from $nullable_tb order by id" + order_qt_sql_cardinality_DateV2_notnull "select cardinality(kadtv2) from $not_nullable_tb order by id" + + // array_size + order_qt_sql_array_size_Double "select array_size(kadbl) from $nullable_tb order by id" + order_qt_sql_array_size_Double_notnull "select array_size(kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_size_Float "select array_size(kafloat) from $nullable_tb order by id" + order_qt_sql_array_size_Float_notnull "select array_size(kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_size_LargeInt "select array_size(kalint) from $nullable_tb order by id" + order_qt_sql_array_size_LargeInt_notnull "select array_size(kalint) from $not_nullable_tb order by id" + order_qt_sql_array_size_BigInt "select array_size(kabint) from $nullable_tb order by id" + order_qt_sql_array_size_BigInt_notnull "select array_size(kabint) from $not_nullable_tb order by id" + order_qt_sql_array_size_SmallInt "select array_size(kasint) from $nullable_tb order by id" + order_qt_sql_array_size_SmallInt_notnull "select array_size(kasint) from $not_nullable_tb order by id" + order_qt_sql_array_size_Integer "select array_size(kaint) from $nullable_tb order by id" + order_qt_sql_array_size_Integer_notnull "select array_size(kaint) from $not_nullable_tb order by id" + order_qt_sql_array_size_TinyInt "select array_size(katint) from $nullable_tb order by id" + order_qt_sql_array_size_TinyInt_notnull "select array_size(katint) from $not_nullable_tb order by id" + order_qt_sql_array_size_DecimalV3 "select array_size(kadcml) from $nullable_tb order by id" + order_qt_sql_array_size_DecimalV3_notnull "select array_size(kadcml) from $not_nullable_tb order by id" + + order_qt_sql_array_size_Boolean "select array_size(kabool) from $nullable_tb order by id" + order_qt_sql_array_size_Boolean_notnull "select array_size(kabool) from $not_nullable_tb order by id" + + order_qt_sql_array_size_Char "select array_size(kachr) from $nullable_tb order by id" + order_qt_sql_array_size_Char_notnull "select array_size(kachr) from $not_nullable_tb order by id" + order_qt_sql_array_size_Varchar "select array_size(kavchr) from $nullable_tb order by id" + order_qt_sql_array_size_Varchar_notnull "select array_size(kavchr) from $not_nullable_tb order by id" + order_qt_sql_array_size_String "select array_size(kastr) from $nullable_tb order by id" + order_qt_sql_array_size_String_notnull "select array_size(kastr) from $not_nullable_tb order by id" + + order_qt_sql_array_size_DatetimeV2 "select array_size(kadtmv2) from $nullable_tb order by id" + order_qt_sql_array_size_DatetimeV2_notnull "select array_size(kadtmv2) from $not_nullable_tb order by id" + order_qt_sql_array_size_DateV2 "select array_size(kadtv2) from $nullable_tb order by id" + order_qt_sql_array_size_DateV2_notnull "select array_size(kadtv2) from $not_nullable_tb order by id" + + // size + order_qt_sql_size_Double "select size(kadbl) from $nullable_tb order by id" + order_qt_sql_size_Double_notnull "select size(kadbl) from $not_nullable_tb order by id" + order_qt_sql_size_Float "select size(kafloat) from $nullable_tb order by id" + order_qt_sql_size_Float_notnull "select size(kafloat) from $not_nullable_tb order by id" + order_qt_sql_size_LargeInt "select size(kalint) from $nullable_tb order by id" + order_qt_sql_size_LargeInt_notnull "select size(kalint) from $not_nullable_tb order by id" + order_qt_sql_size_BigInt "select size(kabint) from $nullable_tb order by id" + order_qt_sql_size_BigInt_notnull "select size(kabint) from $not_nullable_tb order by id" + order_qt_sql_size_SmallInt "select size(kasint) from $nullable_tb order by id" + order_qt_sql_size_SmallInt_notnull "select size(kasint) from $not_nullable_tb order by id" + order_qt_sql_size_Integer "select size(kaint) from $nullable_tb order by id" + order_qt_sql_size_Integer_notnull "select size(kaint) from $not_nullable_tb order by id" + order_qt_sql_size_TinyInt "select size(katint) from $nullable_tb order by id" + order_qt_sql_size_TinyInt_notnull "select size(katint) from $not_nullable_tb order by id" + order_qt_sql_size_DecimalV3 "select size(kadcml) from $nullable_tb order by id" + order_qt_sql_size_DecimalV3_notnull "select size(kadcml) from $not_nullable_tb order by id" + + order_qt_sql_size_Boolean "select size(kabool) from $nullable_tb order by id" + order_qt_sql_size_Boolean_notnull "select size(kabool) from $not_nullable_tb order by id" + + order_qt_sql_size_Char "select size(kachr) from $nullable_tb order by id" + order_qt_sql_size_Char_notnull "select size(kachr) from $not_nullable_tb order by id" + order_qt_sql_size_Varchar "select size(kavchr) from $nullable_tb order by id" + order_qt_sql_size_Varchar_notnull "select size(kavchr) from $not_nullable_tb order by id" + order_qt_sql_size_String "select size(kastr) from $nullable_tb order by id" + order_qt_sql_size_String_notnull "select size(kastr) from $not_nullable_tb order by id" + + order_qt_sql_size_DatetimeV2 "select size(kadtmv2) from $nullable_tb order by id" + order_qt_sql_size_DatetimeV2_notnull "select size(kadtmv2) from $not_nullable_tb order by id" + order_qt_sql_size_DateV2 "select size(kadtv2) from $nullable_tb order by id" + order_qt_sql_size_DateV2_notnull "select size(kadtv2) from $not_nullable_tb order by id" + + // split_by_string + order_qt_sql_split_by_string_Char "select split_by_string(element_at(kachr, 1), ',') from $nullable_tb order by id" + order_qt_sql_split_by_string_Char_notnull "select split_by_string(element_at(kachr, 1), ',') from $not_nullable_tb order by id" + order_qt_sql_split_by_string_VarChar "select split_by_string(element_at(kavchr, 1), ',') from $nullable_tb order by id" + order_qt_sql_split_by_string_VarChar_notnull "select split_by_string(element_at(kavchr, 1), ',') from $not_nullable_tb order by id" + order_qt_sql_split_by_string_String "select split_by_string(element_at(kastr, 1), ',') from $nullable_tb order by id" + order_qt_sql_split_by_string_String_notnull "select split_by_string(element_at(kastr, 1), ',') from $not_nullable_tb order by id" + + // tokenize + order_qt_sql_tokenize_Char "select tokenize(element_at(kachr, 1), '') from $nullable_tb order by id" + order_qt_sql_tokenize_Char_notnull "select tokenize(element_at(kachr, 1), '') from $not_nullable_tb order by id" + order_qt_sql_tokenize_VarChar "select tokenize(element_at(kavchr, 1), null) from $nullable_tb order by id" + order_qt_sql_tokenize_VarChar_notnull "select tokenize(element_at(kavchr, 1), '') from $not_nullable_tb order by id" + order_qt_sql_tokenize_String "select tokenize(element_at(kastr, 1), '') from $nullable_tb order by id" + order_qt_sql_tokenize_String_notnull "select tokenize(element_at(kastr, 1), null) from $not_nullable_tb order by id" + + // test array_map + order_qt_sql_array_map_Double "select array_map(x -> x is not null, kadbl) from $nullable_tb order by id" + order_qt_sql_array_map_Double_notnull "select array_map(x -> x is not null, kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_map_Float "select array_map(x -> x is not null, kafloat) from $nullable_tb order by id" + order_qt_sql_array_map_Float_notnull "select array_map(x -> x is not null, kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_map_LargeInt "select array_map(x -> x is not null, kalint) from $nullable_tb order by id" + order_qt_sql_array_map_LargeInt_notnull "select array_map(x -> x is not null, kalint) from $not_nullable_tb order by id" + order_qt_sql_array_map_BigInt "select array_map(x -> x is not null, kabint) from $nullable_tb order by id" + order_qt_sql_array_map_BigInt_notnull "select array_map(x -> x is not null, kabint) from $not_nullable_tb order by id" + order_qt_sql_array_map_SmallInt "select array_map(x -> x is not null, kasint) from $nullable_tb order by id" + order_qt_sql_array_map_SmallInt_notnull "select array_map(x -> x is not null, kasint) from $not_nullable_tb order by id" + order_qt_sql_array_map_Integer "select array_map(x -> x is not null, kaint) from $nullable_tb order by id" + order_qt_sql_array_map_Integer_notnull "select array_map(x -> x is not null, kaint) from $not_nullable_tb order by id" + order_qt_sql_array_map_TinyInt "select array_map(x -> x is not null, katint) from $nullable_tb order by id" + order_qt_sql_array_map_TinyInt_notnull "select array_map(x -> x is not null, katint) from $not_nullable_tb order by id" + order_qt_sql_array_map_DecimalV3 "select array_map(x -> x is not null, kadcml) from $nullable_tb order by id" + order_qt_sql_array_map_DecimalV3_notnull "select array_map(x -> x is not null, kadcml) from $not_nullable_tb order by id" + order_qt_sql_array_map_lambda_agg "select array_map(x->(x+100), collect_list(element_at(katint, 1))) from $nullable_tb group by id order by id;" + + // test array_exists + order_qt_sql_array_exists_Double "select array_exists(x -> x > 1, kadbl) from $nullable_tb order by id" + order_qt_sql_array_exists_Double_notnull "select array_exists(x -> x > 1, kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_exists_Float "select array_exists(x -> x > 1, kafloat) from $nullable_tb order by id" + order_qt_sql_array_exists_Float_notnull "select array_exists(x -> x > 1, kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_exists_LargeInt "select array_exists(x -> x > 1, kalint) from $nullable_tb order by id" + order_qt_sql_array_exists_LargeInt_notnull "select array_exists(x -> x > 1, kalint) from $not_nullable_tb order by id" + order_qt_sql_array_exists_BigInt "select array_exists(x -> x > 1, kabint) from $nullable_tb order by id" + order_qt_sql_array_exists_BigInt_notnull "select array_exists(x -> x > 1, kabint) from $not_nullable_tb order by id" + order_qt_sql_array_exists_SmallInt "select array_exists(x -> x > 1, kasint) from $nullable_tb order by id" + order_qt_sql_array_exists_SmallInt_notnull "select array_exists(x -> x > 1, kasint) from $not_nullable_tb order by id" + order_qt_sql_array_exists_Integer "select array_exists(x -> x > 1, kaint) from $nullable_tb order by id" + order_qt_sql_array_exists_Integer_notnull "select array_exists(x -> x > 1, kaint) from $not_nullable_tb order by id" + order_qt_sql_array_exists_TinyInt "select array_exists(x -> x > 1, katint) from $nullable_tb order by id" + order_qt_sql_array_exists_TinyInt_notnull "select array_exists(x -> x > 1, katint) from $not_nullable_tb order by id" + order_qt_sql_array_exists_DecimalV3 "select array_exists(x -> x > 1, kadcml) from $nullable_tb order by id" + order_qt_sql_array_exists_DecimalV3_notnull "select array_exists(x -> x > 1, kadcml) from $not_nullable_tb order by id" + // test array_first_index + order_qt_sql_array_first_index_Double "select array_first_index(x -> x > 1, kadbl) from $nullable_tb order by id" + order_qt_sql_array_first_index_Double_notnull "select array_first_index(x -> x > 1, kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_first_index_Float "select array_first_index(x -> x > 1, kafloat) from $nullable_tb order by id" + order_qt_sql_array_first_index_Float_notnull "select array_first_index(x -> x > 1, kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_first_index_LargeInt "select array_first_index(x -> x > 1, kalint) from $nullable_tb order by id" + order_qt_sql_array_first_index_LargeInt_notnull "select array_first_index(x -> x > 1, kalint) from $not_nullable_tb order by id" + order_qt_sql_array_first_index_BigInt "select array_first_index(x -> x > 1, kabint) from $nullable_tb order by id" + order_qt_sql_array_first_index_BigInt_notnull "select array_first_index(x -> x > 1, kabint) from $not_nullable_tb order by id" + order_qt_sql_array_first_index_SmallInt "select array_first_index(x -> x > 1, kasint) from $nullable_tb order by id" + order_qt_sql_array_first_index_SmallInt_notnull "select array_first_index(x -> x > 1, kasint) from $not_nullable_tb order by id" + order_qt_sql_array_first_index_Integer "select array_first_index(x -> x > 1, kaint) from $nullable_tb order by id" + order_qt_sql_array_first_index_Integer_notnull "select array_first_index(x -> x > 1, kaint) from $not_nullable_tb order by id" + order_qt_sql_array_first_index_TinyInt "select array_first_index(x -> x > 1, katint) from $nullable_tb order by id" + order_qt_sql_array_first_index_TinyInt_notnull "select array_first_index(x -> x > 1, katint) from $not_nullable_tb order by id" + order_qt_sql_array_first_index_DecimalV3 "select array_first_index(x -> x > 1, kadcml) from $nullable_tb order by id" + order_qt_sql_array_first_index_DecimalV3_notnull "select array_first_index(x -> x > 1, kadcml) from $not_nullable_tb order by id" + // test array_count + order_qt_sql_array_count_Double "select array_count(x -> x > 1, kadbl) from $nullable_tb order by id" + order_qt_sql_array_count_Double_notnull "select array_count(x -> x > 1, kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_count_Float "select array_count(x -> x > 1, kafloat) from $nullable_tb order by id" + order_qt_sql_array_count_Float_notnull "select array_count(x -> x > 1, kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_count_LargeInt "select array_count(x -> x > 1, kalint) from $nullable_tb order by id" + order_qt_sql_array_count_LargeInt_notnull "select array_count(x -> x > 1, kalint) from $not_nullable_tb order by id" + order_qt_sql_array_count_BigInt "select array_count(x -> x > 1, kabint) from $nullable_tb order by id" + order_qt_sql_array_count_BigInt_notnull "select array_count(x -> x > 1, kabint) from $not_nullable_tb order by id" + order_qt_sql_array_count_SmallInt "select array_count(x -> x > 1, kasint) from $nullable_tb order by id" + order_qt_sql_array_count_SmallInt_notnull "select array_count(x -> x > 1, kasint) from $not_nullable_tb order by id" + order_qt_sql_array_count_Integer "select array_count(x -> x > 1, kaint) from $nullable_tb order by id" + order_qt_sql_array_count_Integer_notnull "select array_count(x -> x > 1, kaint) from $not_nullable_tb order by id" + order_qt_sql_array_count_TinyInt "select array_count(x -> x > 1, katint) from $nullable_tb order by id" + order_qt_sql_array_count_TinyInt_notnull "select array_count(x -> x > 1, katint) from $not_nullable_tb order by id" + order_qt_sql_array_count_DecimalV3 "select array_count(x -> x > 1, kadcml) from $nullable_tb order by id" + order_qt_sql_array_count_DecimalV3_notnull "select array_count(x -> x > 1, kadcml) from $not_nullable_tb order by id" + // test array_map + order_qt_sql_array_map_Double "select array_map(x -> x > 1, kadbl) from $nullable_tb order by id" + order_qt_sql_array_map_Double_notnull "select array_map(x -> x > 1, kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_map_Float "select array_map(x -> x > 1, kafloat) from $nullable_tb order by id" + order_qt_sql_array_map_Float_notnull "select array_map(x -> x > 1, kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_map_LargeInt "select array_map(x -> x > 1, kalint) from $nullable_tb order by id" + order_qt_sql_array_map_LargeInt_notnull "select array_map(x -> x > 1, kalint) from $not_nullable_tb order by id" + order_qt_sql_array_map_BigInt "select array_map(x -> x > 1, kabint) from $nullable_tb order by id" + order_qt_sql_array_map_BigInt_notnull "select array_map(x -> x > 1, kabint) from $not_nullable_tb order by id" + order_qt_sql_array_map_SmallInt "select array_map(x -> x > 1, kasint) from $nullable_tb order by id" + order_qt_sql_array_map_SmallInt_notnull "select array_map(x -> x > 1, kasint) from $not_nullable_tb order by id" + order_qt_sql_array_map_Integer "select array_map(x -> x > 1, kaint) from $nullable_tb order by id" + order_qt_sql_array_map_Integer_notnull "select array_map(x -> x > 1, kaint) from $not_nullable_tb order by id" + order_qt_sql_array_map_TinyInt "select array_map(x -> x > 1, katint) from $nullable_tb order by id" + order_qt_sql_array_map_TinyInt_notnull "select array_map(x -> x > 1, katint) from $not_nullable_tb order by id" + order_qt_sql_array_map_DecimalV3 "select array_map(x -> x > 1, kadcml) from $nullable_tb order by id" + order_qt_sql_array_map_DecimalV3_notnull "select array_map(x -> x > 1, kadcml) from $not_nullable_tb order by id" + // test array_filter + order_qt_sql_array_filter_Double "select array_filter(x -> x > 1, kadbl) from $nullable_tb order by id" + order_qt_sql_array_filter_Double_notnull "select array_filter(x -> x > 1, kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_filter_Float "select array_filter(x -> x > 1, kafloat) from $nullable_tb order by id" + order_qt_sql_array_filter_Float_notnull "select array_filter(x -> x > 1, kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_filter_LargeInt "select array_filter(x -> x > 1, kalint) from $nullable_tb order by id" + order_qt_sql_array_filter_LargeInt_notnull "select array_filter(x -> x > 1, kalint) from $not_nullable_tb order by id" + order_qt_sql_array_filter_BigInt "select array_filter(x -> x > 1, kabint) from $nullable_tb order by id" + order_qt_sql_array_filter_BigInt_notnull "select array_filter(x -> x > 1, kabint) from $not_nullable_tb order by id" + order_qt_sql_array_filter_SmallInt "select array_filter(x -> x > 1, kasint) from $nullable_tb order by id" + order_qt_sql_array_filter_SmallInt_notnull "select array_filter(x -> x > 1, kasint) from $not_nullable_tb order by id" + order_qt_sql_array_filter_Integer "select array_filter(x -> x > 1, kaint) from $nullable_tb order by id" + order_qt_sql_array_filter_Integer_notnull "select array_filter(x -> x > 1, kaint) from $not_nullable_tb order by id" + order_qt_sql_array_filter_TinyInt "select array_filter(x -> x > 1, katint) from $nullable_tb order by id" + order_qt_sql_array_filter_TinyInt_notnull "select array_filter(x -> x > 1, katint) from $not_nullable_tb order by id" + order_qt_sql_array_filter_DecimalV3 "select array_filter(x -> x > 1, kadcml) from $nullable_tb order by id" + order_qt_sql_array_filter_DecimalV3_notnull "select array_filter(x -> x > 1, kadcml) from $not_nullable_tb order by id" + // test array_sortby + order_qt_sql_array_sortby_Double "select array_sortby(x -> x + 1, kadbl) from $nullable_tb order by id" + order_qt_sql_array_sortby_Double_notnull "select array_sortby(x -> x + 1, kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_sortby_Float "select array_sortby(x -> x + 1, kafloat) from $nullable_tb order by id" + order_qt_sql_array_sortby_Float_notnull "select array_sortby(x -> x + 1, kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_sortby_LargeInt "select array_sortby(x -> x + 1, kalint) from $nullable_tb order by id" + order_qt_sql_array_sortby_LargeInt_notnull "select array_sortby(x -> x + 1, kalint) from $not_nullable_tb order by id" + order_qt_sql_array_sortby_BigInt "select array_sortby(x -> x + 1, kabint) from $nullable_tb order by id" + order_qt_sql_array_sortby_BigInt_notnull "select array_sortby(x -> x + 1, kabint) from $not_nullable_tb order by id" + order_qt_sql_array_sortby_SmallInt "select array_sortby(x -> x + 1, kasint) from $nullable_tb order by id" + order_qt_sql_array_sortby_SmallInt_notnull "select array_sortby(x -> x + 1, kasint) from $not_nullable_tb order by id" + order_qt_sql_array_sortby_Integer "select array_sortby(x -> x + 1, kaint) from $nullable_tb order by id" + order_qt_sql_array_sortby_Integer_notnull "select array_sortby(x -> x + 1, kaint) from $not_nullable_tb order by id" + order_qt_sql_array_sortby_TinyInt "select array_sortby(x -> x + 1, katint) from $nullable_tb order by id" + order_qt_sql_array_sortby_TinyInt_notnull "select array_sortby(x -> x + 1, katint) from $not_nullable_tb order by id" + order_qt_sql_array_sortby_DecimalV3 "select array_sortby(x -> x + 1, kadcml) from $nullable_tb order by id" + order_qt_sql_array_sortby_DecimalV3_notnull "select array_sortby(x -> x + 1, kadcml) from $not_nullable_tb order by id" + // test array_last_index + order_qt_sql_array_last_index_Double "select array_last_index(x -> x > 1, kadbl) from $nullable_tb order by id" + order_qt_sql_array_last_index_Double_notnull "select array_last_index(x -> x > 1, kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_last_index_Float "select array_last_index(x -> x > 1, kafloat) from $nullable_tb order by id" + order_qt_sql_array_last_index_Float_notnull "select array_last_index(x -> x > 1, kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_last_index_LargeInt "select array_last_index(x -> x > 1, kalint) from $nullable_tb order by id" + order_qt_sql_array_last_index_LargeInt_notnull "select array_last_index(x -> x > 1, kalint) from $not_nullable_tb order by id" + order_qt_sql_array_last_index_BigInt "select array_last_index(x -> x > 1, kabint) from $nullable_tb order by id" + order_qt_sql_array_last_index_BigInt_notnull "select array_last_index(x -> x > 1, kabint) from $not_nullable_tb order by id" + order_qt_sql_array_last_index_SmallInt "select array_last_index(x -> x > 1, kasint) from $nullable_tb order by id" + order_qt_sql_array_last_index_SmallInt_notnull "select array_last_index(x -> x > 1, kasint) from $not_nullable_tb order by id" + order_qt_sql_array_last_index_Integer "select array_last_index(x -> x > 1, kaint) from $nullable_tb order by id" + order_qt_sql_array_last_index_Integer_notnull "select array_last_index(x -> x > 1, kaint) from $not_nullable_tb order by id" + order_qt_sql_array_last_index_TinyInt "select array_last_index(x -> x > 1, katint) from $nullable_tb order by id" + order_qt_sql_array_last_index_TinyInt_notnull "select array_last_index(x -> x > 1, katint) from $not_nullable_tb order by id" + order_qt_sql_array_last_index_DecimalV3 "select array_last_index(x -> x > 1, kadcml) from $nullable_tb order by id" + order_qt_sql_array_last_index_DecimalV3_notnull "select array_last_index(x -> x > 1, kadcml) from $not_nullable_tb order by id" + order_qt_sql_array_first_Double "select array_first(x -> x > 1, kadbl) from $nullable_tb order by id" + // test array_first + order_qt_sql_array_first_Double_notnull "select array_first(x -> x > 1, kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_first_Float "select array_first(x -> x > 1, kafloat) from $nullable_tb order by id" + order_qt_sql_array_first_Float_notnull "select array_first(x -> x > 1, kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_first_LargeInt "select array_first(x -> x > 1, kalint) from $nullable_tb order by id" + order_qt_sql_array_first_LargeInt_notnull "select array_first(x -> x > 1, kalint) from $not_nullable_tb order by id" + order_qt_sql_array_first_BigInt "select array_first(x -> x > 1, kabint) from $nullable_tb order by id" + order_qt_sql_array_first_BigInt_notnull "select array_first(x -> x > 1, kabint) from $not_nullable_tb order by id" + order_qt_sql_array_first_SmallInt "select array_first(x -> x > 1, kasint) from $nullable_tb order by id" + order_qt_sql_array_first_SmallInt_notnull "select array_first(x -> x > 1, kasint) from $not_nullable_tb order by id" + order_qt_sql_array_first_Integer "select array_first(x -> x > 1, kaint) from $nullable_tb order by id" + order_qt_sql_array_first_Integer_notnull "select array_first(x -> x > 1, kaint) from $not_nullable_tb order by id" + order_qt_sql_array_first_TinyInt "select array_first(x -> x > 1, katint) from $nullable_tb order by id" + order_qt_sql_array_first_TinyInt_notnull "select array_first(x -> x > 1, katint) from $not_nullable_tb order by id" + order_qt_sql_array_first_DecimalV3 "select array_first(x -> x > 1, kadcml) from $nullable_tb order by id" + order_qt_sql_array_first_DecimalV3_notnull "select array_first(x -> x > 1, kadcml) from $not_nullable_tb order by id" + // test array_last + order_qt_sql_array_last_Double "select array_last(x -> x > 1, kadbl) from $nullable_tb order by id" + order_qt_sql_array_last_Double_notnull "select array_last(x -> x > 1, kadbl) from $not_nullable_tb order by id" + order_qt_sql_array_last_Float "select array_last(x -> x > 1, kafloat) from $nullable_tb order by id" + order_qt_sql_array_last_Float_notnull "select array_last(x -> x > 1, kafloat) from $not_nullable_tb order by id" + order_qt_sql_array_last_LargeInt "select array_last(x -> x > 1, kalint) from $nullable_tb order by id" + order_qt_sql_array_last_LargeInt_notnull "select array_last(x -> x > 1, kalint) from $not_nullable_tb order by id" + order_qt_sql_array_last_BigInt "select array_last(x -> x > 1, kabint) from $nullable_tb order by id" + order_qt_sql_array_last_BigInt_notnull "select array_last(x -> x > 1, kabint) from $not_nullable_tb order by id" + order_qt_sql_array_last_SmallInt "select array_last(x -> x > 1, kasint) from $nullable_tb order by id" + order_qt_sql_array_last_SmallInt_notnull "select array_last(x -> x > 1, kasint) from $not_nullable_tb order by id" + order_qt_sql_array_last_Integer "select array_last(x -> x > 1, kaint) from $nullable_tb order by id" + order_qt_sql_array_last_Integer_notnull "select array_last(x -> x > 1, kaint) from $not_nullable_tb order by id" + order_qt_sql_array_last_TinyInt "select array_last(x -> x > 1, katint) from $nullable_tb order by id" + order_qt_sql_array_last_TinyInt_notnull "select array_last(x -> x > 1, katint) from $not_nullable_tb order by id" + order_qt_sql_array_last_DecimalV3 "select array_last(x -> x > 1, kadcml) from $nullable_tb order by id" + order_qt_sql_array_last_DecimalV3_notnull "select array_last(x -> x > 1, kadcml) from $not_nullable_tb order by id" + + // test array_apply + order_qt_array_apply_datetimev2 """select array_apply(kadtmv2, "=", '2022-12-02 22:23:24.999999') from $nullable_tb order by id""" + order_qt_array_apply_datetimev2_notnull """select array_apply(kadtmv2, "=", '2022-12-02 22:23:24.999999') from $not_nullable_tb order by id""" + order_qt_array_apply_datetimev2_lg """select array_apply(kadtmv2, ">", '2022-12-01 22:23:24.999999') from $nullable_tb order by id""" + order_qt_array_apply_datetimev2_lg_notnull """select array_apply(kadtmv2, ">", '2022-12-01 22:23:24.999999') from $not_nullable_tb order by id""" + order_qt_array_apply_datetimev2_null """select array_apply(kadtmv2, ">", null) from $nullable_tb order by id""" + order_qt_array_apply_datetimev2_null_notnull """select array_apply(kadtmv2, ">", null) from $not_nullable_tb order by id""" + order_qt_array_apply_decimal """select array_apply(kadcml, "=", 22.679) from $nullable_tb order by id""" + order_qt_array_apply_decimal_notnull """select array_apply(kadcml, "=", 22.679) from $not_nullable_tb order by id""" + order_qt_array_apply_decimal_lg """select array_apply(kadcml, ">=", 22.1) from $nullable_tb order by id""" + order_qt_array_apply_decimal_lg_notnull """select array_apply(kadcml, ">=", 22.1) from $not_nullable_tb order by id""" + order_qt_array_apply_decimal_null """select array_apply(kadcml, ">=", null) from $nullable_tb order by id""" + order_qt_array_apply_decimal_null_notnull """select array_apply(kadcml, ">=", null) from $not_nullable_tb order by id""" + + // array_repeat + order_qt_array_repeat_string """select array_repeat("hello", 2) from $nullable_tb order by id""" + order_qt_array_repeat_int """select array_repeat(123, 2) from $nullable_tb order by id""" + order_qt_array_repeat_null """select array_repeat(null, 2) from $nullable_tb order by id""" + order_qt_array_repeat_null2 """select array_repeat(3, null) from $nullable_tb order by id""" + order_qt_array_repeat_string_notnull """select array_repeat("hello", 2) from $not_nullable_tb order by id""" + order_qt_array_repeat_int_notnull """select array_repeat(123, 2) from $not_nullable_tb order by id""" + order_qt_array_repeat_null_notnull """select array_repeat(null, 2) from $not_nullable_tb order by id""" + order_qt_array_repeat_null2_notnull """select array_repeat(3, null) from $not_nullable_tb order by id""" + + // agg for array types add decimal256 cases array_min/array_max/array_product/array_avg/array_sum with decimal256 + + order_qt_sql_array_min_decimal256 "select array_min(kadcml256) from $nullable_tb order by id" + order_qt_sql_array_max_decimal256 "select array_max(kadcml256) from $nullable_tb order by id" + order_qt_sql_array_product_decimal256 "select array_product(kadcml256) from $nullable_tb order by id" + order_qt_sql_array_avg_decimal256 "select array_avg(kadcml256) from $nullable_tb order by id" + order_qt_sql_array_sum_decimal256 "select array_sum(kadcml256) from $nullable_tb order by id" + // array_overlap for type correctness + order_qt_sql_array_overlaps_1 """select arrays_overlap(kadcml, kadcmlv2) from $nullable_tb order by id""" + order_qt_sql_array_overlaps_2 """select arrays_overlap(kadcmlv2, kadcml) from $nullable_tb order by id""" + order_qt_sql_array_overlaps_3 """select arrays_overlap(kadcml, kadcml256) from $nullable_tb order by id""" + order_qt_sql_array_overlaps_4 """select arrays_overlap(kadcml256, kadcml) from $nullable_tb order by id""" + order_qt_sql_array_overlaps_5 """select arrays_overlap(kadcmlv2, kadcml256) from $nullable_tb order by id""" + order_qt_sql_array_overlaps_6 """select arrays_overlap(kadcml256, kadcmlv2) from $nullable_tb order by id""" + + + // array_match_any && array_match_all + // for table + qt_sql_array_match_any_1 "select kastr, array_match_any(x->x!='', kastr) from $nullable_tb order by id" + qt_sql_array_match_all_1 "select kastr, array_match_all(x->x!='', kastr) from $nullable_tb order by id" + // [INTERNAL_ERROR][E6] nested_column's size 1, is not consistent with offsets_column's 0 ?? + // qt_sql_array_match_any_2 "select kastr, array_match_any(x->x!=null, kastr) from $nullable_tb order by id" + // qt_sql_array_match_all_2 "select kastr, array_match_all(x->x!=null, kastr) from $nullable_tb order by id" + qt_sql_array_match_any_3 "select kaint, array_match_any(x->x!=null, kaint) from $nullable_tb order by id" + qt_sql_array_match_all_3 "select kaint, array_match_all(x->x!=null, kaint) from $nullable_tb order by id" + qt_sql_array_match_any_4 "select kastr, array_match_any(x->x='a', kastr) from $nullable_tb order by id" + qt_sql_array_match_all_4 "select kastr, array_match_all(x->x='a', kastr) from $nullable_tb order by id" + qt_sql_array_match_any_5 "select kaint, array_match_any(x->x=2, kaint) from $nullable_tb order by id" + qt_sql_array_match_all_5 "select kaint, array_match_all(x->x=2, kaint) from $nullable_tb order by id" + qt_sql_array_match_any_6 "select kaint, array_match_any(x->x!=2, kaint) from $nullable_tb order by id" + qt_sql_array_match_all_6 "select kaint, array_match_any(x->x!=2, kaint) from $nullable_tb order by id" + + + sql "create view v as select array_first_index(x -> x > 1, kadbl) from $nullable_tb order by id;" + order_qt_sql_view_array_first_index_Double "select * from v;" + sql "drop view v" + // test array_count + sql "create view v as select array_count(x -> x > 1, kadbl) from $nullable_tb order by id;" + order_qt_sql_view_array_count_Double "select * from v;" + sql "drop view v" + // test array_first + sql "create view v as select array_first(x -> x > 1, kadbl) from $nullable_tb order by id;" + order_qt_sql_view_array_first_Double "select * from v;" + sql "drop view v" + // test array_sortby + sql "create view v as select array_sortby(x -> x > 1, kadbl) from $nullable_tb order by id;" + order_qt_sql_view_array_sortby_Double "select * from v;" + sql "drop view v" + // test array_filter + sql "create view v as select array_filter(x -> x > 1, kadbl) from $nullable_tb order by id;" + order_qt_sql_view_array_filter_Double "select * from v;" + sql "drop view v" + // test array_exists + sql "create view v as select array_exists(x -> x > 1, kadbl) from $nullable_tb order by id;" + order_qt_sql_view_array_exists_Double "select * from v;" + sql "drop view v" + // test array_last_index + sql "create view v as select array_last_index(x -> x > 1, kadbl) from $nullable_tb order by id;" + order_qt_sql_view_array_last_index_Double "select * from v;" + sql "drop view v" + // test array_last + sql "create view v as select array_last(x -> x > 1, kadbl) from $nullable_tb order by id;" + order_qt_sql_view_array_last_Double "select * from v;" + sql "drop view v" + // test array_map + sql "create view v as select array_map(x -> x > 1, kadbl) from $nullable_tb order by id;" + order_qt_sql_view_array_map_Double "select * from v;" + sql "drop view v" + + // create view with array funcs for not-nullable_tb + // test array_first_index + sql "create view v as select array_first_index(x -> x > 1, kadbl) from $not_nullable_tb order by id;" + order_qt_sql_view_array_first_index_Double_notnull "select * from v;" + sql "drop view v" + // test array_count + sql "create view v as select array_count(x -> x > 1, kadbl) from $not_nullable_tb order by id;" + order_qt_sql_view_array_count_Double_notnull "select * from v;" + sql "drop view v" + // test array_first + sql "create view v as select array_first(x -> x > 1, kadbl) from $not_nullable_tb order by id;" + order_qt_sql_view_array_first_Double_notnull "select * from v;" + sql "drop view v" + // test array_sortby + sql "create view v as select array_sortby(x -> x > 1, kadbl) from $not_nullable_tb order by id;" + order_qt_sql_view_array_sortby_Double_notnull "select * from v;" + sql "drop view v" + // test array_filter + sql "create view v as select array_filter(x -> x > 1, kadbl) from $not_nullable_tb order by id;" + order_qt_sql_view_array_filter_Double_notnull "select * from v;" + sql "drop view v" + // test array_exists + sql "create view v as select array_exists(x -> x > 1, kadbl) from $not_nullable_tb order by id;" + order_qt_sql_view_array_exists_Double_notnull "select * from v;" + sql "drop view v" + // test array_last_index + sql "create view v as select array_last_index(x -> x > 1, kadbl) from $not_nullable_tb order by id;" + order_qt_sql_view_array_last_index_Double_notnull "select * from v;" + sql "drop view v" + // test array_last + sql "create view v as select array_last(x -> x > 1, kadbl) from $not_nullable_tb order by id;" + order_qt_sql_view_array_last_Double_notnull "select * from v;" + sql "drop view v" + // test array_map + sql "create view v as select array_map(x -> x > 1, kadbl) from $not_nullable_tb order by id;" + order_qt_sql_view_array_map_Double_notnull "select * from v;" + sql "drop view v" + + // test tokenize Review Comment: add lateral view -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
