morrySnow commented on code in PR #16824: URL: https://github.com/apache/doris/pull/16824#discussion_r1108414819
########## regression-test/suites/nereids_function_p0/window_function/window_fn.groovy: ########## @@ -0,0 +1,46 @@ +// 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_window_fn") { + sql 'use regression_test_nereids_function_p0' + sql 'set enable_nereids_planner=true' + sql 'set enable_fallback_to_original_planner=false' + qt_sql_dense_rank "select ktint, ksint, dense_rank() over(partition by ktint order by ksint) as rank from fn_test" + qt_sql_dense_rank_notnull "select ktint, ksint, dense_rank() over(partition by ktint order by ksint) as rank from fn_test_not_nullable" + + qt_sql_first_value "select ktint, ksint, first_value(kint) over(partition by ktint order by ksint) as fv from fn_test" + qt_sql_first_value_notnull "select ktint, ksint, first_value(kint) over(partition by ktint order by ksint) as fv from fn_test_not_nullable" + + qt_sql_lag "select ktint, ksint, lag(kint, 2, 1) over(partition by ktint order by ksint) as lag from fn_test" + qt_sql_lag_notnull "select ktint, ksint, lag(kint, 2, 1) over(partition by ktint order by ksint) as lag from fn_test_not_nullable" + + qt_sql_last_value "select ktint, ksint, last_value(kint) over(partition by ktint order by ksint) as lv from fn_test" Review Comment: need enumerate with/without partition, with/without order by and all window frame ########## regression-test/suites/nereids_function_p0/agg_function/agg.groovy: ########## @@ -0,0 +1,597 @@ +// 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_agg_fn") { + sql 'use regression_test_nereids_function_p0' + sql 'set enable_nereids_planner=true' + sql 'set enable_fallback_to_original_planner=false' + qt_sql_any_value_AnyData_gb "select any_value(kint) from fn_test group by kbool order by kbool" Review Comment: need to enumerate all valid stages, and with/with out group by ########## regression-test/suites/nereids_function_p0/agg_function/agg.groovy: ########## @@ -0,0 +1,597 @@ +// 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_agg_fn") { + sql 'use regression_test_nereids_function_p0' + sql 'set enable_nereids_planner=true' + sql 'set enable_fallback_to_original_planner=false' + qt_sql_any_value_AnyData_gb "select any_value(kint) from fn_test group by kbool order by kbool" + qt_sql_any_value_AnyData "select any_value(kint) from fn_test" + qt_sql_any_value_AnyData_notnull_gb "select any_value(kint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_any_value_AnyData_notnull "select any_value(kint) from fn_test_not_nullable" + + qt_sql_avg_TinyInt_gb "select avg(ktint) from fn_test group by kbool order by kbool" + qt_sql_avg_TinyInt "select avg(ktint) from fn_test" + qt_sql_avg_TinyInt_notnull_gb "select avg(ktint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_avg_TinyInt_notnull "select avg(ktint) from fn_test_not_nullable" + + qt_sql_avg_SmallInt_gb "select avg(ksint) from fn_test group by kbool order by kbool" + qt_sql_avg_SmallInt "select avg(ksint) from fn_test" + qt_sql_avg_SmallInt_notnull_gb "select avg(ksint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_avg_SmallInt_notnull "select avg(ksint) from fn_test_not_nullable" + + qt_sql_avg_Integer_gb "select avg(kint) from fn_test group by kbool order by kbool" + qt_sql_avg_Integer "select avg(kint) from fn_test" + qt_sql_avg_Integer_notnull_gb "select avg(kint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_avg_Integer_notnull "select avg(kint) from fn_test_not_nullable" + + qt_sql_avg_BigInt_gb "select avg(kbint) from fn_test group by kbool order by kbool" + qt_sql_avg_BigInt "select avg(kbint) from fn_test" + qt_sql_avg_BigInt_notnull_gb "select avg(kbint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_avg_BigInt_notnull "select avg(kbint) from fn_test_not_nullable" + + qt_sql_avg_Double_gb "select avg(kdbl) from fn_test group by kbool order by kbool" + qt_sql_avg_Double "select avg(kdbl) from fn_test" + qt_sql_avg_Double_notnull_gb "select avg(kdbl) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_avg_Double_notnull "select avg(kdbl) from fn_test_not_nullable" + + qt_sql_avg_DecimalV2_gb "select avg(kdcmls1) from fn_test group by kbool order by kbool" + qt_sql_avg_DecimalV2 "select avg(kdcmls1) from fn_test" + qt_sql_avg_DecimalV2_notnull_gb "select avg(kdcmls1) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_avg_DecimalV2_notnull "select avg(kdcmls1) from fn_test_not_nullable" + + qt_sql_avg_weighted_TinyInt_Double_gb "select avg_weighted(ktint, kdbl) from fn_test group by kbool order by kbool" + qt_sql_avg_weighted_TinyInt_Double "select avg_weighted(ktint, kdbl) from fn_test" + qt_sql_avg_weighted_TinyInt_Double_notnull_gb "select avg_weighted(ktint, kdbl) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_avg_weighted_TinyInt_Double_notnull "select avg_weighted(ktint, kdbl) from fn_test_not_nullable" + + qt_sql_avg_weighted_SmallInt_Double_gb "select avg_weighted(ksint, kdbl) from fn_test group by kbool order by kbool" + qt_sql_avg_weighted_SmallInt_Double "select avg_weighted(ksint, kdbl) from fn_test" + qt_sql_avg_weighted_SmallInt_Double_notnull_gb "select avg_weighted(ksint, kdbl) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_avg_weighted_SmallInt_Double_notnull "select avg_weighted(ksint, kdbl) from fn_test_not_nullable" + + qt_sql_avg_weighted_Integer_Double_gb "select avg_weighted(kint, kdbl) from fn_test group by kbool order by kbool" + qt_sql_avg_weighted_Integer_Double "select avg_weighted(kint, kdbl) from fn_test" + qt_sql_avg_weighted_Integer_Double_notnull_gb "select avg_weighted(kint, kdbl) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_avg_weighted_Integer_Double_notnull "select avg_weighted(kint, kdbl) from fn_test_not_nullable" + + qt_sql_avg_weighted_BigInt_Double_gb "select avg_weighted(kbint, kdbl) from fn_test group by kbool order by kbool" + qt_sql_avg_weighted_BigInt_Double "select avg_weighted(kbint, kdbl) from fn_test" + qt_sql_avg_weighted_BigInt_Double_notnull_gb "select avg_weighted(kbint, kdbl) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_avg_weighted_BigInt_Double_notnull "select avg_weighted(kbint, kdbl) from fn_test_not_nullable" + + qt_sql_avg_weighted_Float_Double_gb "select avg_weighted(kfloat, kdbl) from fn_test group by kbool order by kbool" + qt_sql_avg_weighted_Float_Double "select avg_weighted(kfloat, kdbl) from fn_test" + qt_sql_avg_weighted_Float_Double_notnull_gb "select avg_weighted(kfloat, kdbl) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_avg_weighted_Float_Double_notnull "select avg_weighted(kfloat, kdbl) from fn_test_not_nullable" + + qt_sql_avg_weighted_Double_Double_gb "select avg_weighted(kdbl, kdbl) from fn_test group by kbool order by kbool" + qt_sql_avg_weighted_Double_Double "select avg_weighted(kdbl, kdbl) from fn_test" + qt_sql_avg_weighted_Double_Double_notnull_gb "select avg_weighted(kdbl, kdbl) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_avg_weighted_Double_Double_notnull "select avg_weighted(kdbl, kdbl) from fn_test_not_nullable" + + qt_sql_avg_weighted_DecimalV2_Double_gb "select avg_weighted(kdcmls1, kdbl) from fn_test group by kbool order by kbool" + qt_sql_avg_weighted_DecimalV2_Double "select avg_weighted(kdcmls1, kdbl) from fn_test" + qt_sql_avg_weighted_DecimalV2_Double_notnull_gb "select avg_weighted(kdcmls1, kdbl) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_avg_weighted_DecimalV2_Double_notnull "select avg_weighted(kdcmls1, kdbl) from fn_test_not_nullable" + + qt_sql_bitmap_intersect_Bitmap_gb "select bitmap_intersect(to_bitmap(kbint)) from fn_test group by kbool order by kbool" + qt_sql_bitmap_intersect_Bitmap "select bitmap_intersect(to_bitmap(kbint)) from fn_test" + qt_sql_bitmap_intersect_Bitmap_notnull_gb "select bitmap_intersect(to_bitmap(kbint)) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_bitmap_intersect_Bitmap_notnull "select bitmap_intersect(to_bitmap(kbint)) from fn_test_not_nullable" + + qt_sql_bitmap_union_Bitmap_gb "select bitmap_union(to_bitmap(kbint)) from fn_test group by kbool order by kbool" + qt_sql_bitmap_union_Bitmap "select bitmap_union(to_bitmap(kbint)) from fn_test" + qt_sql_bitmap_union_Bitmap_notnull_gb "select bitmap_union(to_bitmap(kbint)) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_bitmap_union_Bitmap_notnull "select bitmap_union(to_bitmap(kbint)) from fn_test_not_nullable" + + qt_sql_bitmap_union_count_Bitmap_gb "select bitmap_union_count(to_bitmap(kbint)) from fn_test group by kbool order by kbool" + qt_sql_bitmap_union_count_Bitmap "select bitmap_union_count(to_bitmap(kbint)) from fn_test" + qt_sql_bitmap_union_count_Bitmap_notnull_gb "select bitmap_union_count(to_bitmap(kbint)) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_bitmap_union_count_Bitmap_notnull "select bitmap_union_count(to_bitmap(kbint)) from fn_test_not_nullable" + + qt_sql_bitmap_union_int_SmallInt_gb "select bitmap_union_int(ksint) from fn_test group by kbool order by kbool" + qt_sql_bitmap_union_int_SmallInt "select bitmap_union_int(ksint) from fn_test" + qt_sql_bitmap_union_int_SmallInt_notnull_gb "select bitmap_union_int(ksint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_bitmap_union_int_SmallInt_notnull "select bitmap_union_int(ksint) from fn_test_not_nullable" + + qt_sql_bitmap_union_int_TinyInt_gb "select bitmap_union_int(ktint) from fn_test group by kbool order by kbool" + qt_sql_bitmap_union_int_TinyInt "select bitmap_union_int(ktint) from fn_test" + qt_sql_bitmap_union_int_TinyInt_notnull_gb "select bitmap_union_int(ktint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_bitmap_union_int_TinyInt_notnull "select bitmap_union_int(ktint) from fn_test_not_nullable" + + qt_sql_bitmap_union_int_Integer_gb "select bitmap_union_int(kint) from fn_test group by kbool order by kbool" + qt_sql_bitmap_union_int_Integer "select bitmap_union_int(kint) from fn_test" + qt_sql_bitmap_union_int_Integer_notnull_gb "select bitmap_union_int(kint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_bitmap_union_int_Integer_notnull "select bitmap_union_int(kint) from fn_test_not_nullable" + + qt_sql_bitmap_union_int_BigInt_gb "select bitmap_union_int(kbint) from fn_test group by kbool order by kbool" + qt_sql_bitmap_union_int_BigInt "select bitmap_union_int(kbint) from fn_test" + qt_sql_bitmap_union_int_BigInt_notnull_gb "select bitmap_union_int(kbint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_bitmap_union_int_BigInt_notnull "select bitmap_union_int(kbint) from fn_test_not_nullable" + + qt_sql_count_gb "select count() from fn_test group by kbool order by kbool" + qt_sql_count "select count() from fn_test" + qt_sql_count_notnull_gb "select count() from fn_test_not_nullable group by kbool order by kbool" + qt_sql_count_notnull "select count() from fn_test_not_nullable" + + qt_sql_count_AnyData_gb "select count(kint) from fn_test group by kbool order by kbool" + qt_sql_count_AnyData "select count(kint) from fn_test" + qt_sql_count_AnyData_notnull_gb "select count(kint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_count_AnyData_notnull "select count(kint) from fn_test_not_nullable" + + qt_sql_group_bit_and_TinyInt_gb "select group_bit_and(ktint) from fn_test group by kbool order by kbool" + qt_sql_group_bit_and_TinyInt "select group_bit_and(ktint) from fn_test" + qt_sql_group_bit_and_TinyInt_notnull_gb "select group_bit_and(ktint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_group_bit_and_TinyInt_notnull "select group_bit_and(ktint) from fn_test_not_nullable" + + qt_sql_group_bit_and_SmallInt_gb "select group_bit_and(ksint) from fn_test group by kbool order by kbool" + qt_sql_group_bit_and_SmallInt "select group_bit_and(ksint) from fn_test" + qt_sql_group_bit_and_SmallInt_notnull_gb "select group_bit_and(ksint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_group_bit_and_SmallInt_notnull "select group_bit_and(ksint) from fn_test_not_nullable" + + qt_sql_group_bit_and_Integer_gb "select group_bit_and(kint) from fn_test group by kbool order by kbool" + qt_sql_group_bit_and_Integer "select group_bit_and(kint) from fn_test" + qt_sql_group_bit_and_Integer_notnull_gb "select group_bit_and(kint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_group_bit_and_Integer_notnull "select group_bit_and(kint) from fn_test_not_nullable" + + qt_sql_group_bit_and_BigInt_gb "select group_bit_and(kbint) from fn_test group by kbool order by kbool" + qt_sql_group_bit_and_BigInt "select group_bit_and(kbint) from fn_test" + qt_sql_group_bit_and_BigInt_notnull_gb "select group_bit_and(kbint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_group_bit_and_BigInt_notnull "select group_bit_and(kbint) from fn_test_not_nullable" + + qt_sql_group_bit_and_LargeInt_gb "select group_bit_and(klint) from fn_test group by kbool order by kbool" + qt_sql_group_bit_and_LargeInt "select group_bit_and(klint) from fn_test" + qt_sql_group_bit_and_LargeInt_notnull_gb "select group_bit_and(klint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_group_bit_and_LargeInt_notnull "select group_bit_and(klint) from fn_test_not_nullable" + + qt_sql_group_bit_or_TinyInt_gb "select group_bit_or(ktint) from fn_test group by kbool order by kbool" + qt_sql_group_bit_or_TinyInt "select group_bit_or(ktint) from fn_test" + qt_sql_group_bit_or_TinyInt_notnull_gb "select group_bit_or(ktint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_group_bit_or_TinyInt_notnull "select group_bit_or(ktint) from fn_test_not_nullable" + + qt_sql_group_bit_or_SmallInt_gb "select group_bit_or(ksint) from fn_test group by kbool order by kbool" + qt_sql_group_bit_or_SmallInt "select group_bit_or(ksint) from fn_test" + qt_sql_group_bit_or_SmallInt_notnull_gb "select group_bit_or(ksint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_group_bit_or_SmallInt_notnull "select group_bit_or(ksint) from fn_test_not_nullable" + + qt_sql_group_bit_or_Integer_gb "select group_bit_or(kint) from fn_test group by kbool order by kbool" + qt_sql_group_bit_or_Integer "select group_bit_or(kint) from fn_test" + qt_sql_group_bit_or_Integer_notnull_gb "select group_bit_or(kint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_group_bit_or_Integer_notnull "select group_bit_or(kint) from fn_test_not_nullable" + + qt_sql_group_bit_or_BigInt_gb "select group_bit_or(kbint) from fn_test group by kbool order by kbool" + qt_sql_group_bit_or_BigInt "select group_bit_or(kbint) from fn_test" + qt_sql_group_bit_or_BigInt_notnull_gb "select group_bit_or(kbint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_group_bit_or_BigInt_notnull "select group_bit_or(kbint) from fn_test_not_nullable" + + qt_sql_group_bit_or_LargeInt_gb "select group_bit_or(klint) from fn_test group by kbool order by kbool" + qt_sql_group_bit_or_LargeInt "select group_bit_or(klint) from fn_test" + qt_sql_group_bit_or_LargeInt_notnull_gb "select group_bit_or(klint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_group_bit_or_LargeInt_notnull "select group_bit_or(klint) from fn_test_not_nullable" + + qt_sql_group_bit_xor_TinyInt_gb "select group_bit_xor(ktint) from fn_test group by kbool order by kbool" + qt_sql_group_bit_xor_TinyInt "select group_bit_xor(ktint) from fn_test" + qt_sql_group_bit_xor_TinyInt_notnull_gb "select group_bit_xor(ktint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_group_bit_xor_TinyInt_notnull "select group_bit_xor(ktint) from fn_test_not_nullable" + + qt_sql_group_bit_xor_SmallInt_gb "select group_bit_xor(ksint) from fn_test group by kbool order by kbool" + qt_sql_group_bit_xor_SmallInt "select group_bit_xor(ksint) from fn_test" + qt_sql_group_bit_xor_SmallInt_notnull_gb "select group_bit_xor(ksint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_group_bit_xor_SmallInt_notnull "select group_bit_xor(ksint) from fn_test_not_nullable" + + qt_sql_group_bit_xor_Integer_gb "select group_bit_xor(kint) from fn_test group by kbool order by kbool" + qt_sql_group_bit_xor_Integer "select group_bit_xor(kint) from fn_test" + qt_sql_group_bit_xor_Integer_notnull_gb "select group_bit_xor(kint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_group_bit_xor_Integer_notnull "select group_bit_xor(kint) from fn_test_not_nullable" + + qt_sql_group_bit_xor_BigInt_gb "select group_bit_xor(kbint) from fn_test group by kbool order by kbool" + qt_sql_group_bit_xor_BigInt "select group_bit_xor(kbint) from fn_test" + qt_sql_group_bit_xor_BigInt_notnull_gb "select group_bit_xor(kbint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_group_bit_xor_BigInt_notnull "select group_bit_xor(kbint) from fn_test_not_nullable" + + qt_sql_group_bit_xor_LargeInt_gb "select group_bit_xor(klint) from fn_test group by kbool order by kbool" + qt_sql_group_bit_xor_LargeInt "select group_bit_xor(klint) from fn_test" + qt_sql_group_bit_xor_LargeInt_notnull_gb "select group_bit_xor(klint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_group_bit_xor_LargeInt_notnull "select group_bit_xor(klint) from fn_test_not_nullable" + + qt_sql_group_bitmap_xor_Bitmap_gb "select group_bitmap_xor(to_bitmap(kbint)) from fn_test group by kbool order by kbool" + qt_sql_group_bitmap_xor_Bitmap "select group_bitmap_xor(to_bitmap(kbint)) from fn_test" + qt_sql_group_bitmap_xor_Bitmap_notnull_gb "select group_bitmap_xor(to_bitmap(kbint)) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_group_bitmap_xor_Bitmap_notnull "select group_bitmap_xor(to_bitmap(kbint)) from fn_test_not_nullable" + + qt_sql_group_concat_Varchar_gb "select group_concat(kvchrs1) from fn_test group by kbool order by kbool" + qt_sql_group_concat_Varchar "select group_concat(kvchrs1) from fn_test" + qt_sql_group_concat_Varchar_notnull_gb "select group_concat(kvchrs1) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_group_concat_Varchar_notnull "select group_concat(kvchrs1) from fn_test_not_nullable" + + qt_sql_group_concat_Varchar_AnyData_gb "select group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint), kdt) from fn_test group by kbool order by kbool" +// qt_sql_group_concat_Varchar_AnyData "select group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint), kdt) from fn_test" + qt_sql_group_concat_Varchar_AnyData_notnull_gb "select group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint), kdt) from fn_test_not_nullable group by kbool order by kbool" +// qt_sql_group_concat_Varchar_AnyData_notnull "select group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint), kdt) from fn_test_not_nullable" + + qt_sql_group_concat_Varchar_Varchar_AnyData_gb "select group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint), kdt) from fn_test group by kbool order by kbool" +// qt_sql_group_concat_Varchar_Varchar_AnyData "select group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint), kdt) from fn_test" + qt_sql_group_concat_Varchar_Varchar_AnyData_notnull_gb "select group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint), kdt) from fn_test_not_nullable group by kbool order by kbool" +// qt_sql_group_concat_Varchar_Varchar_AnyData_notnull "select group_concat(distinct cast(abs(kint) as varchar) order by abs(ksint), kdt) from fn_test_not_nullable" + + qt_sql_histogram_Boolean_gb "select histogram(kbool) from fn_test group by kbool order by kbool" + qt_sql_histogram_Boolean "select histogram(kbool) from fn_test" + qt_sql_histogram_Boolean_notnull_gb "select histogram(kbool) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_histogram_Boolean_notnull "select histogram(kbool) from fn_test_not_nullable" + + qt_sql_histogram_TinyInt_gb "select histogram(ktint) from fn_test group by kbool order by kbool" + qt_sql_histogram_TinyInt "select histogram(ktint) from fn_test" + qt_sql_histogram_TinyInt_notnull_gb "select histogram(ktint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_histogram_TinyInt_notnull "select histogram(ktint) from fn_test_not_nullable" + + qt_sql_histogram_SmallInt_gb "select histogram(ksint) from fn_test group by kbool order by kbool" + qt_sql_histogram_SmallInt "select histogram(ksint) from fn_test" + qt_sql_histogram_SmallInt_notnull_gb "select histogram(ksint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_histogram_SmallInt_notnull "select histogram(ksint) from fn_test_not_nullable" + + qt_sql_histogram_Integer_gb "select histogram(kint) from fn_test group by kbool order by kbool" + qt_sql_histogram_Integer "select histogram(kint) from fn_test" + qt_sql_histogram_Integer_notnull_gb "select histogram(kint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_histogram_Integer_notnull "select histogram(kint) from fn_test_not_nullable" + + qt_sql_histogram_BigInt_gb "select histogram(kbint) from fn_test group by kbool order by kbool" + qt_sql_histogram_BigInt "select histogram(kbint) from fn_test" + qt_sql_histogram_BigInt_notnull_gb "select histogram(kbint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_histogram_BigInt_notnull "select histogram(kbint) from fn_test_not_nullable" + + qt_sql_histogram_LargeInt_gb "select histogram(klint) from fn_test group by kbool order by kbool" + qt_sql_histogram_LargeInt "select histogram(klint) from fn_test" + qt_sql_histogram_LargeInt_notnull_gb "select histogram(klint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_histogram_LargeInt_notnull "select histogram(klint) from fn_test_not_nullable" + + qt_sql_histogram_Float_gb "select histogram(kfloat) from fn_test group by kbool order by kbool" + qt_sql_histogram_Float "select histogram(kfloat) from fn_test" + qt_sql_histogram_Float_notnull_gb "select histogram(kfloat) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_histogram_Float_notnull "select histogram(kfloat) from fn_test_not_nullable" + + qt_sql_histogram_Double_gb "select histogram(kdbl) from fn_test group by kbool order by kbool" + qt_sql_histogram_Double "select histogram(kdbl) from fn_test" + qt_sql_histogram_Double_notnull_gb "select histogram(kdbl) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_histogram_Double_notnull "select histogram(kdbl) from fn_test_not_nullable" + + qt_sql_histogram_DecimalV2_gb "select histogram(kdcmls1) from fn_test group by kbool order by kbool" + qt_sql_histogram_DecimalV2 "select histogram(kdcmls1) from fn_test" + qt_sql_histogram_DecimalV2_notnull_gb "select histogram(kdcmls1) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_histogram_DecimalV2_notnull "select histogram(kdcmls1) from fn_test_not_nullable" + + qt_sql_histogram_Date_gb "select histogram(kdt) from fn_test group by kbool order by kbool" + qt_sql_histogram_Date "select histogram(kdt) from fn_test" + qt_sql_histogram_Date_notnull_gb "select histogram(kdt) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_histogram_Date_notnull "select histogram(kdt) from fn_test_not_nullable" + + qt_sql_histogram_DateTime_gb "select histogram(kdtm) from fn_test group by kbool order by kbool" + qt_sql_histogram_DateTime "select histogram(kdtm) from fn_test" + qt_sql_histogram_DateTime_notnull_gb "select histogram(kdtm) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_histogram_DateTime_notnull "select histogram(kdtm) from fn_test_not_nullable" + + qt_sql_histogram_DateV2_gb "select histogram(kdtv2) from fn_test group by kbool order by kbool" + qt_sql_histogram_DateV2 "select histogram(kdtv2) from fn_test" + qt_sql_histogram_DateV2_notnull_gb "select histogram(kdtv2) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_histogram_DateV2_notnull "select histogram(kdtv2) from fn_test_not_nullable" + + qt_sql_histogram_DateTimeV2_gb "select histogram(kdtmv2s1) from fn_test group by kbool order by kbool" + qt_sql_histogram_DateTimeV2 "select histogram(kdtmv2s1) from fn_test" + qt_sql_histogram_DateTimeV2_notnull_gb "select histogram(kdtmv2s1) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_histogram_DateTimeV2_notnull "select histogram(kdtmv2s1) from fn_test_not_nullable" + + qt_sql_histogram_Char_gb "select histogram(kchrs1) from fn_test group by kbool order by kbool" + qt_sql_histogram_Char "select histogram(kchrs1) from fn_test" + qt_sql_histogram_Char_notnull_gb "select histogram(kchrs1) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_histogram_Char_notnull "select histogram(kchrs1) from fn_test_not_nullable" + + qt_sql_histogram_String_gb "select histogram(kstr) from fn_test group by kbool order by kbool" + qt_sql_histogram_String "select histogram(kstr) from fn_test" + qt_sql_histogram_String_notnull_gb "select histogram(kstr) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_histogram_String_notnull "select histogram(kstr) from fn_test_not_nullable" + + qt_sql_max_by_AnyData_AnyData_gb "select max_by(kint, kint) from fn_test group by kbool order by kbool" + qt_sql_max_by_AnyData_AnyData "select max_by(kint, kint) from fn_test" + qt_sql_max_by_AnyData_AnyData_notnull_gb "select max_by(kint, kint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_max_by_AnyData_AnyData_notnull "select max_by(kint, kint) from fn_test_not_nullable" + + qt_sql_min_by_AnyData_AnyData_gb "select min_by(kint, kint) from fn_test group by kbool order by kbool" + qt_sql_min_by_AnyData_AnyData "select min_by(kint, kint) from fn_test" + qt_sql_min_by_AnyData_AnyData_notnull_gb "select min_by(kint, kint) from fn_test_not_nullable group by kbool order by kbool" + qt_sql_min_by_AnyData_AnyData_notnull "select min_by(kint, kint) from fn_test_not_nullable" + +// qt_sql_multi_distinct_count_AnyData_gb "select multi_distinct_count(kint) from fn_test group by kbool order by kbool" Review Comment: these function could not use directly, remove them -- 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
