[doris] branch master updated: [improvement](testcase) change order by sql in test_dup_mv_bitmap_hash.groovy to make result stable

[pa...@apache.org]

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

panxiaolei 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 68d2067f51 [improvement](testcase) change order by sql in test_dup_mv_bitmap_hash.groovy to make result stable
68d2067f51 is described below

commit 68d2067f518c555908e17178df2f3fe91a00ae3d
Author: Kang <kx...@gmail.com>
AuthorDate: Thu Feb 2 16:42:58 2023 +0800

    [improvement](testcase) change order by sql in test_dup_mv_bitmap_hash.groovy to make result stable
    
    change order by sql in test_dup_mv_bitmap_hash.groovy to make result stable
---
 .../test_dup_mv_bitmap_hash/test_dup_mv_bitmap_hash.out          | 9 ++++++++-
 .../test_dup_mv_bitmap_hash/test_dup_mv_bitmap_hash.groovy       | 4 +++-
 2 files changed, 11 insertions(+), 2 deletions(-)

diff --git a/regression-test/data/materialized_view_p0/test_dup_mv_bitmap_hash/test_dup_mv_bitmap_hash.out b/regression-test/data/materialized_view_p0/test_dup_mv_bitmap_hash/test_dup_mv_bitmap_hash.out
index 2a9437547a..70f2bed42a 100644
--- a/regression-test/data/materialized_view_p0/test_dup_mv_bitmap_hash/test_dup_mv_bitmap_hash.out
+++ b/regression-test/data/materialized_view_p0/test_dup_mv_bitmap_hash/test_dup_mv_bitmap_hash.out
@@ -4,10 +4,17 @@
 1
 1
 
+-- !select_k1 --
+1
+2
+2
+3
+3
+
 -- !select_star --
 1	1	a
-2	2	bb
 2	2	b
+2	2	bb
 3	3	c
 3	3	c
 
diff --git a/regression-test/suites/materialized_view_p0/test_dup_mv_bitmap_hash/test_dup_mv_bitmap_hash.groovy b/regression-test/suites/materialized_view_p0/test_dup_mv_bitmap_hash/test_dup_mv_bitmap_hash.groovy
index f7b133e426..710e52fbc4 100644
--- a/regression-test/suites/materialized_view_p0/test_dup_mv_bitmap_hash/test_dup_mv_bitmap_hash.groovy
+++ b/regression-test/suites/materialized_view_p0/test_dup_mv_bitmap_hash/test_dup_mv_bitmap_hash.groovy
@@ -69,7 +69,9 @@ suite ("test_dup_mv_bitmap_hash") {
     sql "insert into d_table select 2,2,'bb';"
     sql "insert into d_table select 3,3,'c';"
 
-    qt_select_star "select * from d_table order by k1;"
+    qt_select_k1 "select k1 from d_table order by k1;"
+
+    qt_select_star "select * from d_table order by k1,k2,k3;"
 
     explain {
         sql("select k1,bitmap_union_count(bitmap_hash(k3)) from d_table group by k1;")


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