(doris) 10/13: [fix](hint) fix hint tests with different be instances (#35188)

[yiguolei]

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 6d362c106187263f86e913d8cf6a7ed0aa6ba896
Author: LiBinfeng <46676950+libinfeng...@users.noreply.github.com>
AuthorDate: Mon May 27 11:23:21 2024 +0800

    [fix](hint) fix hint tests with different be instances (#35188)
    
    Problem:
    When using multiple be to test hint with distribute hint, the result would 
be unstable
    Solved:
    Add ordered hint to every distribute hint and move some leading hint cases 
to check containing of hint infomation
---
 regression-test/suites/nereids_p0/hint/fix_leading.groovy   | 3 +++
 regression-test/suites/nereids_p0/hint/multi_leading.groovy | 3 +++
 regression-test/suites/nereids_p0/hint/test_leading.groovy  | 3 +++
 3 files changed, 9 insertions(+)

diff --git a/regression-test/suites/nereids_p0/hint/fix_leading.groovy 
b/regression-test/suites/nereids_p0/hint/fix_leading.groovy
index ae17b17c53a..9229e44a466 100644
--- a/regression-test/suites/nereids_p0/hint/fix_leading.groovy
+++ b/regression-test/suites/nereids_p0/hint/fix_leading.groovy
@@ -24,6 +24,9 @@ suite("fix_leading") {
     sql 'use fix_leading'
 
     // setting planner to nereids
+    sql 'set exec_mem_limit=21G'
+    sql 'set be_number_for_test=1'
+    sql "set disable_nereids_rules=PRUNE_EMPTY_PARTITION"
     sql 'set enable_nereids_planner=true'
     sql 'set enable_fallback_to_original_planner=false'
     sql 'set runtime_filter_mode=OFF'
diff --git a/regression-test/suites/nereids_p0/hint/multi_leading.groovy 
b/regression-test/suites/nereids_p0/hint/multi_leading.groovy
index b1d6b010de9..bcefcfef141 100644
--- a/regression-test/suites/nereids_p0/hint/multi_leading.groovy
+++ b/regression-test/suites/nereids_p0/hint/multi_leading.groovy
@@ -23,6 +23,9 @@ suite("multi_leading") {
     sql 'use test_multi_leading'
 
     // setting planner to nereids
+    sql 'set exec_mem_limit=21G'
+    sql 'set be_number_for_test=1'
+    sql "set disable_nereids_rules=PRUNE_EMPTY_PARTITION"
     sql 'set enable_nereids_planner=true'
     sql "set ignore_shape_nodes='PhysicalProject'"
     sql 'set enable_fallback_to_original_planner=false'
diff --git a/regression-test/suites/nereids_p0/hint/test_leading.groovy 
b/regression-test/suites/nereids_p0/hint/test_leading.groovy
index 3908f55504b..d056adeb106 100644
--- a/regression-test/suites/nereids_p0/hint/test_leading.groovy
+++ b/regression-test/suites/nereids_p0/hint/test_leading.groovy
@@ -24,6 +24,9 @@ suite("test_leading") {
     sql 'use test_leading'
 
     // setting planner to nereids
+    sql 'set exec_mem_limit=21G'
+    sql 'set be_number_for_test=1'
+    sql "set disable_nereids_rules=PRUNE_EMPTY_PARTITION"
     sql 'set enable_nereids_planner=true'
     sql "set ignore_shape_nodes='PhysicalProject'"
     sql 'set enable_fallback_to_original_planner=false'


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