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 2af920c6f89d2b75eda599be1ac4a2795efee118
Author: Dongyang Li <hello_step...@qq.com>
AuthorDate: Tue Feb 20 15:51:50 2024 +0800
[chore](regression) Update q03.sql (#31063)
add 'order by' of case
---
.../suites/query_p0/sql_functions/array_functions/sql/q03.sql | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git
a/regression-test/suites/query_p0/sql_functions/array_functions/sql/q03.sql
b/regression-test/suites/query_p0/sql_functions/array_functions/sql/q03.sql
index ed765d235f0..90b9eb8abbe 100644
--- a/regression-test/suites/query_p0/sql_functions/array_functions/sql/q03.sql
+++ b/regression-test/suites/query_p0/sql_functions/array_functions/sql/q03.sql
@@ -1,4 +1,4 @@
DROP TABLE IF EXISTS array_insert_select_test;
CREATE TABLE IF NOT EXISTS array_insert_select_test (id int, c_array
array<int(11)>) ENGINE = Olap DUPLICATE KEY(id) DISTRIBUTED BY HASH(id) BUCKETS
1 PROPERTIES('replication_num' = '1');
insert into array_insert_select_test select k1, collect_list(k3) from
test_query_db.test group by k1;
-select c_array from array_insert_select_test;
+select c_array from array_insert_select_test order by id;
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
