This is an automated email from the ASF dual-hosted git repository. yiguolei pushed a commit to branch branch-2.1 in repository https://gitbox.apache.org/repos/asf/doris.git
commit 63b3e8b0b17f08d3ecda167af8589e03b691b7d0 Author: morrySnow <[email protected]> AuthorDate: Wed Apr 17 13:59:38 2024 +0800 [fix](test) remove array_intersect case since its result is not stable (#33742) --- .../nereids_function_p0/agg_function/agg.groovy | 131 +++++++++++---------- 1 file changed, 66 insertions(+), 65 deletions(-) diff --git a/regression-test/suites/nereids_function_p0/agg_function/agg.groovy b/regression-test/suites/nereids_function_p0/agg_function/agg.groovy index c59899131ba..bdc524c4091 100644 --- a/regression-test/suites/nereids_function_p0/agg_function/agg.groovy +++ b/regression-test/suites/nereids_function_p0/agg_function/agg.groovy @@ -589,71 +589,72 @@ suite("nereids_agg_fn") { select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id, kint), count(kint) from fn_test group by kbool order by kbool''' qt_sql_count_AnyData_agg_phase_4_notnull ''' select /*+SET_VAR(disable_nereids_rules='THREE_PHASE_AGGREGATE_WITH_DISTINCT, TWO_PHASE_AGGREGATE_WITH_DISTINCT')*/ count(distinct id), count(kint) from fn_test''' - - qt_sql_group_array_intersect_array_bool ''' - select group_array_intersect(kabool) from fn_test where id<= 2;''' - qt_sql_group_array_intersect_array_tinyint ''' - select group_array_intersect(katint) from fn_test where id between 7 and 10;''' - qt_sql_group_array_intersect_array_smallint ''' - select group_array_intersect(kasint) from fn_test;''' - qt_sql_group_array_intersect_array_int ''' - select group_array_intersect(kaint) from fn_test group by id order by id;''' - qt_sql_group_array_intersect_array_bigint ''' - select group_array_intersect(kabint) from fn_test where id between 7 and 10;''' - qt_sql_group_array_intersect_array_largeint ''' - select group_array_intersect(kalint) from fn_test where id = 7;''' - qt_sql_group_array_intersect_array_float ''' - select group_array_intersect(kafloat) from fn_test where id = 4;''' - qt_sql_group_array_intersect_array_double ''' - select group_array_intersect(kadbl) from fn_test where id = 1;''' - qt_sql_group_array_intersect_array_date ''' - select group_array_intersect(kadt) from fn_test where id = 2;''' - qt_sql_group_array_intersect_array_datetime ''' - select group_array_intersect(kadtm) from fn_test where id = 3;''' - qt_sql_group_array_intersect_array_datev2 ''' - select group_array_intersect(kadtv2) from fn_test where id = 5;''' - qt_sql_group_array_intersect_array_datetimev2 ''' - select group_array_intersect(kadtmv2) from fn_test where id = 8;''' - qt_sql_group_array_intersect_array_char ''' - select group_array_intersect(kachr) from fn_test where id in (0, 3);''' - qt_sql_group_array_intersect_array_varchar ''' - select group_array_intersect(kavchr) from fn_test where id = 6;''' - qt_sql_group_array_intersect_array_string ''' - select group_array_intersect(kastr) from fn_test where id in (6, 9);''' - qt_sql_group_array_intersect_array_decimal ''' - select group_array_intersect(kadcml) from fn_test group by id order by id;''' - qt_sql_group_array_intersect_array_bool_notnull ''' - select group_array_intersect(kabool) from fn_test_not_nullable where id<= 2;''' - qt_sql_group_array_intersect_array_tinyint_notnull ''' - select group_array_intersect(katint) from fn_test_not_nullable where id between 7 and 10;''' - qt_sql_group_array_intersect_array_smallint_notnull ''' - select group_array_intersect(kasint) from fn_test_not_nullable;''' - qt_sql_group_array_intersect_array_int_notnull ''' - select group_array_intersect(kaint) from fn_test_not_nullable group by id order by id;''' - qt_sql_group_array_intersect_array_bigint_notnull ''' - select group_array_intersect(kabint) from fn_test_not_nullable where id between 7 and 10;''' - qt_sql_group_array_intersect_array_largeint_notnull ''' - select group_array_intersect(kalint) from fn_test_not_nullable where id = 7;''' - qt_sql_group_array_intersect_array_float_notnull ''' - select group_array_intersect(kafloat) from fn_test_not_nullable where id = 4;''' - qt_sql_group_array_intersect_array_double_notnull ''' - select group_array_intersect(kadbl) from fn_test_not_nullable where id = 1;''' - qt_sql_group_array_intersect_array_date_notnull ''' - select group_array_intersect(kadt) from fn_test_not_nullable where id = 2;''' - qt_sql_group_array_intersect_array_datetime_notnull ''' - select group_array_intersect(kadtm) from fn_test_not_nullable where id = 3;''' - qt_sql_group_array_intersect_array_datev2_notnull ''' - select group_array_intersect(kadtv2) from fn_test_not_nullable where id = 5;''' - qt_sql_group_array_intersect_array_datetimev2_notnull ''' - select group_array_intersect(kadtmv2) from fn_test_not_nullable where id = 8;''' - qt_sql_group_array_intersect_array_char_notnull ''' - select group_array_intersect(kachr) from fn_test_not_nullable where id in (0, 3);''' - qt_sql_group_array_intersect_array_varchar_notnull ''' - select group_array_intersect(kavchr) from fn_test_not_nullable where id = 6;''' - qt_sql_group_array_intersect_array_string_notnull ''' - select group_array_intersect(kastr) from fn_test_not_nullable where id in (6, 9);''' - qt_sql_group_array_intersect_array_decimal_notnull ''' - select group_array_intersect(kadcml) from fn_test_not_nullable group by id order by id;''' + + // array intersect result is not stable, we comment them + // qt_sql_group_array_intersect_array_bool ''' + // select group_array_intersect(kabool) from fn_test where id<= 2;''' + // qt_sql_group_array_intersect_array_tinyint ''' + // select group_array_intersect(katint) from fn_test where id between 7 and 10;''' + // qt_sql_group_array_intersect_array_smallint ''' + // select group_array_intersect(kasint) from fn_test;''' + // qt_sql_group_array_intersect_array_int ''' + // select group_array_intersect(kaint) from fn_test group by id order by id;''' + // qt_sql_group_array_intersect_array_bigint ''' + // select group_array_intersect(kabint) from fn_test where id between 7 and 10;''' + // qt_sql_group_array_intersect_array_largeint ''' + // select group_array_intersect(kalint) from fn_test where id = 7;''' + // qt_sql_group_array_intersect_array_float ''' + // select group_array_intersect(kafloat) from fn_test where id = 4;''' + // qt_sql_group_array_intersect_array_double ''' + // select group_array_intersect(kadbl) from fn_test where id = 1;''' + // qt_sql_group_array_intersect_array_date ''' + // select group_array_intersect(kadt) from fn_test where id = 2;''' + // qt_sql_group_array_intersect_array_datetime ''' + // select group_array_intersect(kadtm) from fn_test where id = 3;''' + // qt_sql_group_array_intersect_array_datev2 ''' + // select group_array_intersect(kadtv2) from fn_test where id = 5;''' + // qt_sql_group_array_intersect_array_datetimev2 ''' + // select group_array_intersect(kadtmv2) from fn_test where id = 8;''' + // qt_sql_group_array_intersect_array_char ''' + // select group_array_intersect(kachr) from fn_test where id in (0, 3);''' + // qt_sql_group_array_intersect_array_varchar ''' + // select group_array_intersect(kavchr) from fn_test where id = 6;''' + // qt_sql_group_array_intersect_array_string ''' + // select group_array_intersect(kastr) from fn_test where id in (6, 9);''' + // qt_sql_group_array_intersect_array_decimal ''' + // select group_array_intersect(kadcml) from fn_test group by id order by id;''' + // qt_sql_group_array_intersect_array_bool_notnull ''' + // select group_array_intersect(kabool) from fn_test_not_nullable where id<= 2;''' + // qt_sql_group_array_intersect_array_tinyint_notnull ''' + // select group_array_intersect(katint) from fn_test_not_nullable where id between 7 and 10;''' + // qt_sql_group_array_intersect_array_smallint_notnull ''' + // select group_array_intersect(kasint) from fn_test_not_nullable;''' + // qt_sql_group_array_intersect_array_int_notnull ''' + // select group_array_intersect(kaint) from fn_test_not_nullable group by id order by id;''' + // qt_sql_group_array_intersect_array_bigint_notnull ''' + // select group_array_intersect(kabint) from fn_test_not_nullable where id between 7 and 10;''' + // qt_sql_group_array_intersect_array_largeint_notnull ''' + // select group_array_intersect(kalint) from fn_test_not_nullable where id = 7;''' + // qt_sql_group_array_intersect_array_float_notnull ''' + // select group_array_intersect(kafloat) from fn_test_not_nullable where id = 4;''' + // qt_sql_group_array_intersect_array_double_notnull ''' + // select group_array_intersect(kadbl) from fn_test_not_nullable where id = 1;''' + // qt_sql_group_array_intersect_array_date_notnull ''' + // select group_array_intersect(kadt) from fn_test_not_nullable where id = 2;''' + // qt_sql_group_array_intersect_array_datetime_notnull ''' + // select group_array_intersect(kadtm) from fn_test_not_nullable where id = 3;''' + // qt_sql_group_array_intersect_array_datev2_notnull ''' + // select group_array_intersect(kadtv2) from fn_test_not_nullable where id = 5;''' + // qt_sql_group_array_intersect_array_datetimev2_notnull ''' + // select group_array_intersect(kadtmv2) from fn_test_not_nullable where id = 8;''' + // qt_sql_group_array_intersect_array_char_notnull ''' + // select group_array_intersect(kachr) from fn_test_not_nullable where id in (0, 3);''' + // qt_sql_group_array_intersect_array_varchar_notnull ''' + // select group_array_intersect(kavchr) from fn_test_not_nullable where id = 6;''' + // qt_sql_group_array_intersect_array_string_notnull ''' + // select group_array_intersect(kastr) from fn_test_not_nullable where id in (6, 9);''' + // qt_sql_group_array_intersect_array_decimal_notnull ''' + // select group_array_intersect(kadcml) from fn_test_not_nullable group by id order by id;''' qt_sql_group_bit_and_TinyInt_gb ''' select group_bit_and(ktint) from fn_test group by kbool order by kbool''' --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
