This is an automated email from the ASF dual-hosted git repository.

lihaopeng pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git


The following commit(s) were added to refs/heads/master by this push:
     new dac10b761ca [case](array) fix unsort array case (#39941)
dac10b761ca is described below

commit dac10b761caece33203cb45893b7b0872eaf167b
Author: Mryange <59914473+mrya...@users.noreply.github.com>
AuthorDate: Sat Aug 31 16:45:30 2024 +0800

    [case](array) fix unsort array case (#39941)
---
 regression-test/data/nereids_p0/aggregate/agg_nullable_2.out      | 2 +-
 regression-test/suites/nereids_p0/aggregate/agg_nullable_2.groovy | 6 +++---
 2 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/regression-test/data/nereids_p0/aggregate/agg_nullable_2.out 
b/regression-test/data/nereids_p0/aggregate/agg_nullable_2.out
index 37a9eba793c..a038340000d 100644
--- a/regression-test/data/nereids_p0/aggregate/agg_nullable_2.out
+++ b/regression-test/data/nereids_p0/aggregate/agg_nullable_2.out
@@ -141,7 +141,7 @@
 [4, 5, 6]
 
 -- !select_group_array_intersect_n --
-[2, 1, 3]
+[1, 2, 3]
 
 -- !select_group_bit_and --
 50
diff --git a/regression-test/suites/nereids_p0/aggregate/agg_nullable_2.groovy 
b/regression-test/suites/nereids_p0/aggregate/agg_nullable_2.groovy
index 42c24815a9a..5337f59d015 100644
--- a/regression-test/suites/nereids_p0/aggregate/agg_nullable_2.groovy
+++ b/regression-test/suites/nereids_p0/aggregate/agg_nullable_2.groovy
@@ -331,19 +331,19 @@ suite("agg_nullable_2") {
         contains "colUniqueId=null, type=bigint, nullable=false"
     }
     
-    qt_select_group_array_intersect """select group_array_intersect(kaint) 
from agg_nullable_test_2;"""
+    qt_select_group_array_intersect """select 
array_sort(group_array_intersect(kaint)) from agg_nullable_test_2;"""
     explain {
         sql("verbose select group_array_intersect(kaint) from 
agg_nullable_test_2;")
         contains "colUniqueId=null, type=array<int>, nullable=false"
     }
 
-    qt_select_group_array_intersect2 """select group_array_intersect(kaint) 
from agg_nullable_test_2 group by id;"""
+    qt_select_group_array_intersect2 """select 
array_sort(group_array_intersect(kaint)) from agg_nullable_test_2 group by 
id;"""
     explain {
         sql("verbose select group_array_intersect(kaint) from 
agg_nullable_test_2 group by id;")
         contains "colUniqueId=null, type=array<int>, nullable=false"
     }
 
-    qt_select_group_array_intersect_n """select group_array_intersect(knaint) 
from agg_nullable_test_2;"""
+    qt_select_group_array_intersect_n """select 
array_sort(group_array_intersect(knaint)) from agg_nullable_test_2;"""
     explain {
         sql("verbose select group_array_intersect(knaint) from 
agg_nullable_test_2;")
         contains "colUniqueId=null, type=array<int>, nullable=false"


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to