This is an automated email from the ASF dual-hosted git repository.
englefly 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 7652d8649b [regression](nereids) check tpc-h 1G/500G/1T plan if
backend_num == 1 #18848
7652d8649b is described below
commit 7652d8649bd942d0974bc329e9941007d3f7a167
Author: minghong <[email protected]>
AuthorDate: Thu May 4 08:55:06 2023 +0800
[regression](nereids) check tpc-h 1G/500G/1T plan if backend_num == 1 #18848
cases in nereids_tpch_shape_sf1_p0, nereids_tpch_shape_sf500_p0 and
nereids_tpch_shape_sf1000_p0 are only for one be environment
---
.../nereids_tpch_shape_sf1000_p0/shape/q1.groovy | 6 +++
.../nereids_tpch_shape_sf1000_p0/shape/q10.groovy | 8 ++--
.../nereids_tpch_shape_sf1000_p0/shape/q11.groovy | 6 ++-
.../nereids_tpch_shape_sf1000_p0/shape/q12.groovy | 9 ++--
.../nereids_tpch_shape_sf1000_p0/shape/q13.groovy | 6 ++-
.../nereids_tpch_shape_sf1000_p0/shape/q14.groovy | 8 ++--
.../nereids_tpch_shape_sf1000_p0/shape/q15.groovy | 6 +++
.../nereids_tpch_shape_sf1000_p0/shape/q16.groovy | 6 +++
.../nereids_tpch_shape_sf1000_p0/shape/q17.groovy | 6 +++
.../nereids_tpch_shape_sf1000_p0/shape/q18.groovy | 6 +++
.../nereids_tpch_shape_sf1000_p0/shape/q19.groovy | 6 +++
.../nereids_tpch_shape_sf1000_p0/shape/q2.groovy | 6 +++
.../nereids_tpch_shape_sf1000_p0/shape/q20.groovy | 6 +++
.../nereids_tpch_shape_sf1000_p0/shape/q21.groovy | 49 ++++++++++++++++++++++
.../nereids_tpch_shape_sf1000_p0/shape/q22.groovy | 6 +++
.../nereids_tpch_shape_sf1000_p0/shape/q3.groovy | 6 +++
.../nereids_tpch_shape_sf1000_p0/shape/q4.groovy | 6 ++-
.../nereids_tpch_shape_sf1000_p0/shape/q5.groovy | 6 +++
.../nereids_tpch_shape_sf1000_p0/shape/q6.groovy | 6 +++
.../nereids_tpch_shape_sf1000_p0/shape/q7.groovy | 6 +++
.../nereids_tpch_shape_sf1000_p0/shape/q8.groovy | 6 +++
.../nereids_tpch_shape_sf1000_p0/shape/q9.groovy | 6 +++
.../nereids_tpch_shape_sf1_p0/shape/q1.groovy | 7 +++-
.../nereids_tpch_shape_sf1_p0/shape/q10.groovy | 6 +++
.../nereids_tpch_shape_sf1_p0/shape/q11.groovy | 6 +++
.../nereids_tpch_shape_sf1_p0/shape/q12.groovy | 6 +++
.../nereids_tpch_shape_sf1_p0/shape/q13.groovy | 6 +++
.../nereids_tpch_shape_sf1_p0/shape/q14.groovy | 6 +++
.../nereids_tpch_shape_sf1_p0/shape/q15.groovy | 6 +++
.../nereids_tpch_shape_sf1_p0/shape/q16.groovy | 6 +++
.../nereids_tpch_shape_sf1_p0/shape/q17.groovy | 6 +++
.../nereids_tpch_shape_sf1_p0/shape/q18.groovy | 6 +++
.../nereids_tpch_shape_sf1_p0/shape/q19.groovy | 6 +++
.../nereids_tpch_shape_sf1_p0/shape/q2.groovy | 6 +++
.../nereids_tpch_shape_sf1_p0/shape/q20.groovy | 6 +++
.../nereids_tpch_shape_sf1_p0/shape/q21.groovy | 6 +++
.../nereids_tpch_shape_sf1_p0/shape/q22.groovy | 6 +++
.../nereids_tpch_shape_sf1_p0/shape/q3.groovy | 6 +++
.../nereids_tpch_shape_sf1_p0/shape/q4.groovy | 6 +++
.../nereids_tpch_shape_sf1_p0/shape/q5.groovy | 7 ++++
.../nereids_tpch_shape_sf1_p0/shape/q6.groovy | 7 ++++
.../nereids_tpch_shape_sf1_p0/shape/q7.groovy | 7 ++++
.../nereids_tpch_shape_sf1_p0/shape/q8.groovy | 6 +++
.../nereids_tpch_shape_sf1_p0/shape/q9.groovy | 6 +++
.../nereids_tpch_shape_sf500_p0/shape/q1.groovy | 7 ++++
.../nereids_tpch_shape_sf500_p0/shape/q10.groovy | 6 +++
.../nereids_tpch_shape_sf500_p0/shape/q11.groovy | 6 +++
.../nereids_tpch_shape_sf500_p0/shape/q12.groovy | 6 +++
.../nereids_tpch_shape_sf500_p0/shape/q13.groovy | 10 +++--
.../nereids_tpch_shape_sf500_p0/shape/q14.groovy | 9 ++--
.../nereids_tpch_shape_sf500_p0/shape/q15.groovy | 6 +++
.../nereids_tpch_shape_sf500_p0/shape/q16.groovy | 6 +++
.../nereids_tpch_shape_sf500_p0/shape/q17.groovy | 6 +++
.../nereids_tpch_shape_sf500_p0/shape/q18.groovy | 6 +++
.../nereids_tpch_shape_sf500_p0/shape/q19.groovy | 6 +++
.../nereids_tpch_shape_sf500_p0/shape/q2.groovy | 8 ++++
.../nereids_tpch_shape_sf500_p0/shape/q20.groovy | 6 +++
.../nereids_tpch_shape_sf500_p0/shape/q21.groovy | 6 +++
.../nereids_tpch_shape_sf500_p0/shape/q22.groovy | 6 +++
.../nereids_tpch_shape_sf500_p0/shape/q3.groovy | 9 ++++
.../nereids_tpch_shape_sf500_p0/shape/q4.groovy | 8 ++++
.../nereids_tpch_shape_sf500_p0/shape/q5.groovy | 9 ++--
.../nereids_tpch_shape_sf500_p0/shape/q6.groovy | 11 +++--
.../nereids_tpch_shape_sf500_p0/shape/q7.groovy | 9 ++--
.../nereids_tpch_shape_sf500_p0/shape/q8.groovy | 8 ++--
.../nereids_tpch_shape_sf500_p0/shape/q9.groovy | 7 +++-
66 files changed, 442 insertions(+), 37 deletions(-)
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q1.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q1.groovy
index a368d2451b..db6c31979f 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q1.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q1.groovy
@@ -24,6 +24,12 @@ suite("q1") {
sql 'set enable_fallback_to_original_planner=false'
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q10.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q10.groovy
index e008b2a7d6..70c83d4a68 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q10.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q10.groovy
@@ -26,9 +26,11 @@ suite("q10") {
sql 'set exec_mem_limit=21G'
-
-
-
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q11.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q11.groovy
index bf58240e1c..07826df511 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q11.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q11.groovy
@@ -25,7 +25,11 @@ suite("q11") {
sql "set runtime_filter_mode='GLOBAL'"
sql 'set exec_mem_limit=21G'
-
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q12.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q12.groovy
index 4a3eefb91b..26abda25fe 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q12.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q12.groovy
@@ -25,10 +25,11 @@ suite("q12") {
sql "set runtime_filter_mode='GLOBAL'"
sql 'set exec_mem_limit=21G'
-
-
-
-
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q13.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q13.groovy
index 1da4512526..2f0b1f5951 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q13.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q13.groovy
@@ -29,7 +29,11 @@ suite("q13") {
-
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q14.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q14.groovy
index 9c57ba1c67..e09e892d22 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q14.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q14.groovy
@@ -26,9 +26,11 @@ suite("q14") {
sql 'set exec_mem_limit=21G'
-
-
-
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q15.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q15.groovy
index ee4369037f..71f867bc40 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q15.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q15.groovy
@@ -29,6 +29,12 @@ suite("q15") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q16.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q16.groovy
index e056ef806f..2cca813194 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q16.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q16.groovy
@@ -29,6 +29,12 @@ suite("q16") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q17.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q17.groovy
index 8c647b3c20..6c1f179f3b 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q17.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q17.groovy
@@ -29,6 +29,12 @@ suite("q17") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q18.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q18.groovy
index e3b7aaee8f..27eab023fb 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q18.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q18.groovy
@@ -29,6 +29,12 @@ suite("q18") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q19.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q19.groovy
index 89ab74fa9a..a1fc068fe8 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q19.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q19.groovy
@@ -30,6 +30,12 @@ suite("q19") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q2.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q2.groovy
index bff504bfc3..c05ca3855c 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q2.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q2.groovy
@@ -29,6 +29,12 @@ suite("q2") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q20.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q20.groovy
index 49198ed4f3..3a9322a8a5 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q20.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q20.groovy
@@ -30,6 +30,12 @@ suite("q20") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q21.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q21.groovy
index 19e0a307bf..808fdf8a4a 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q21.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q21.groovy
@@ -29,6 +29,55 @@ suite("q21") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
+ qt_select """
+ explain shape plan
+ select
+ s_name,
+ count(*) as numwait
+ from
+ supplier,
+ lineitem l1,
+ orders,
+ nation
+ where
+ s_suppkey = l1.l_suppkey
+ and o_orderkey = l1.l_orderkey
+ and o_orderstatus = 'F'
+ and l1.l_receiptdate > l1.l_commitdate
+ and exists (
+ select
+ *
+ from
+ lineitem l2
+ where
+ l2.l_orderkey = l1.l_orderkey
+ and l2.l_suppkey <> l1.l_suppkey
+ )
+ and not exists (
+ select
+ *
+ from
+ lineitem l3
+ where
+ l3.l_orderkey = l1.l_orderkey
+ and l3.l_suppkey <> l1.l_suppkey
+ and l3.l_receiptdate > l3.l_commitdate
+ )
+ and s_nationkey = n_nationkey
+ and n_name = 'SAUDI ARABIA'
+ group by
+ s_name
+ order by
+ numwait desc,
+ s_name
+ limit 100;
+ """
// qt_select """
// explain shape plan
// select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q22.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q22.groovy
index 0cad1e7bd2..e34391ee8d 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q22.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q22.groovy
@@ -29,6 +29,12 @@ suite("q22") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q3.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q3.groovy
index 34a55f03e8..1c491914b0 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q3.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q3.groovy
@@ -30,6 +30,12 @@ suite("q3") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q4.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q4.groovy
index bc00e332f3..edc58269be 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q4.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q4.groovy
@@ -23,8 +23,12 @@ suite("q4") {
sql 'set enable_nereids_planner=true'
sql 'set enable_fallback_to_original_planner=false'
sql "set runtime_filter_mode='GLOBAL'"
-
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q5.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q5.groovy
index 24b74ada88..78bd0dbe8a 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q5.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q5.groovy
@@ -29,6 +29,12 @@ suite("q5") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q6.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q6.groovy
index d935874c53..c6162bd5b6 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q6.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q6.groovy
@@ -29,6 +29,12 @@ suite("q6") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q7.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q7.groovy
index bcf8bcbbc5..a8acf16171 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q7.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q7.groovy
@@ -29,6 +29,12 @@ suite("q7") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q8.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q8.groovy
index d11c6c5778..638b18db48 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q8.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q8.groovy
@@ -29,6 +29,12 @@ suite("q8") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q9.groovy
b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q9.groovy
index 9be034c621..4083b10c39 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q9.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1000_p0/shape/q9.groovy
@@ -29,6 +29,12 @@ suite("q9") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q1.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q1.groovy
index a368d2451b..3457cd3257 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q1.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q1.groovy
@@ -23,8 +23,11 @@ suite("q1") {
sql 'set enable_nereids_planner=true'
sql 'set enable_fallback_to_original_planner=false'
sql 'set exec_mem_limit=21G'
-
-
+
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ return;
+ }
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q10.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q10.groovy
index 3d1701cf6f..52dc482253 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q10.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q10.groovy
@@ -26,6 +26,12 @@ suite("q10") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q11.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q11.groovy
index d9d95ddb54..701a9c6ebb 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q11.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q11.groovy
@@ -26,6 +26,12 @@ suite("q11") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q12.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q12.groovy
index 1a93bf92d2..7e991db974 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q12.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q12.groovy
@@ -26,6 +26,12 @@ suite("q12") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q13.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q13.groovy
index 0e3b3d10ee..fe9638c41f 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q13.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q13.groovy
@@ -26,6 +26,12 @@ suite("q13") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q14.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q14.groovy
index 23fb926e2b..fd853a0aea 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q14.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q14.groovy
@@ -26,6 +26,12 @@ suite("q14") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q15.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q15.groovy
index 39d473a629..16a4e604c5 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q15.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q15.groovy
@@ -26,6 +26,12 @@ suite("q15") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q16.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q16.groovy
index b7e466ed3a..314c64281c 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q16.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q16.groovy
@@ -26,6 +26,12 @@ suite("q16") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q17.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q17.groovy
index afad572be2..2233882f5f 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q17.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q17.groovy
@@ -26,6 +26,12 @@ suite("q17") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q18.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q18.groovy
index 65f22c9dba..0cfb788fe4 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q18.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q18.groovy
@@ -26,6 +26,12 @@ suite("q18") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q19.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q19.groovy
index f6a77f3c6f..f6a83ab759 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q19.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q19.groovy
@@ -27,6 +27,12 @@ suite("q19") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q2.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q2.groovy
index 16f65d80fe..8f330ed86c 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q2.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q2.groovy
@@ -26,6 +26,12 @@ suite("q2") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q20.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q20.groovy
index 812497e8a9..dbab2cea42 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q20.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q20.groovy
@@ -27,6 +27,12 @@ suite("q20") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q21.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q21.groovy
index cc6a106cd8..e8a5864abf 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q21.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q21.groovy
@@ -26,6 +26,12 @@ suite("q21") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q22.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q22.groovy
index 0dfbe32f12..7ef937325b 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q22.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q22.groovy
@@ -26,6 +26,12 @@ suite("q22") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q3.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q3.groovy
index 38d34abdbe..63f661bdfd 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q3.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q3.groovy
@@ -27,6 +27,12 @@ suite("q3") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q4.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q4.groovy
index 9d377d4e82..b2f9f85da2 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q4.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q4.groovy
@@ -26,6 +26,12 @@ suite("q4") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q5.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q5.groovy
index f996037305..0e496aa7d2 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q5.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q5.groovy
@@ -26,6 +26,13 @@ suite("q5") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q6.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q6.groovy
index 08e31ab3b7..c6ef8311f3 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q6.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q6.groovy
@@ -26,6 +26,13 @@ suite("q6") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q7.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q7.groovy
index ff80059519..37e75cd4cb 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q7.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q7.groovy
@@ -26,6 +26,13 @@ suite("q7") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q8.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q8.groovy
index c32bcf4b72..58bec7d4c3 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q8.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q8.groovy
@@ -26,6 +26,12 @@ suite("q8") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q9.groovy
b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q9.groovy
index 81f8a31013..6d12412a2c 100644
--- a/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q9.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf1_p0/shape/q9.groovy
@@ -26,6 +26,12 @@ suite("q9") {
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q1.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q1.groovy
index a368d2451b..b57d48539d 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q1.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q1.groovy
@@ -24,6 +24,13 @@ suite("q1") {
sql 'set enable_fallback_to_original_planner=false'
sql 'set exec_mem_limit=21G'
+
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
diff --git
a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q10.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q10.groovy
index e008b2a7d6..49cc9e4c3b 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q10.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q10.groovy
@@ -29,6 +29,12 @@ suite("q10") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q11.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q11.groovy
index bf58240e1c..5682aec36c 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q11.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q11.groovy
@@ -29,6 +29,12 @@ suite("q11") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q12.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q12.groovy
index 4a3eefb91b..e29f4ca638 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q12.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q12.groovy
@@ -29,6 +29,12 @@ suite("q12") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q13.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q13.groovy
index 1da4512526..0b9d53cf35 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q13.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q13.groovy
@@ -25,11 +25,13 @@ suite("q13") {
sql "set runtime_filter_mode='GLOBAL'"
sql 'set exec_mem_limit=21G'
-
-
-
-
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q14.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q14.groovy
index 9c57ba1c67..e5dbe46fd6 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q14.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q14.groovy
@@ -25,9 +25,12 @@ suite("q14") {
sql "set runtime_filter_mode='GLOBAL'"
sql 'set exec_mem_limit=21G'
-
-
-
+
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
qt_select """
explain shape plan
diff --git
a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q15.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q15.groovy
index ee4369037f..71f867bc40 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q15.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q15.groovy
@@ -29,6 +29,12 @@ suite("q15") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q16.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q16.groovy
index e056ef806f..2cca813194 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q16.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q16.groovy
@@ -29,6 +29,12 @@ suite("q16") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q17.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q17.groovy
index 8c647b3c20..6c1f179f3b 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q17.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q17.groovy
@@ -29,6 +29,12 @@ suite("q17") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q18.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q18.groovy
index e3b7aaee8f..27eab023fb 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q18.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q18.groovy
@@ -29,6 +29,12 @@ suite("q18") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q19.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q19.groovy
index 89ab74fa9a..a1fc068fe8 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q19.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q19.groovy
@@ -30,6 +30,12 @@ suite("q19") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q2.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q2.groovy
index c6b22ec021..a3c3d461f5 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q2.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q2.groovy
@@ -28,6 +28,14 @@ suite("q2") {
+
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q20.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q20.groovy
index 49198ed4f3..3a9322a8a5 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q20.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q20.groovy
@@ -30,6 +30,12 @@ suite("q20") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q21.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q21.groovy
index b948c4b012..7cf680cd33 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q21.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q21.groovy
@@ -29,6 +29,12 @@ suite("q21") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git
a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q22.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q22.groovy
index 0cad1e7bd2..e34391ee8d 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q22.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q22.groovy
@@ -29,6 +29,12 @@ suite("q22") {
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q3.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q3.groovy
index 34a55f03e8..662fb854fe 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q3.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q3.groovy
@@ -30,6 +30,15 @@ suite("q3") {
+
+
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q4.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q4.groovy
index bc00e332f3..56930c507d 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q4.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q4.groovy
@@ -29,6 +29,14 @@ suite("q4") {
+
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
+
+
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q5.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q5.groovy
index 24b74ada88..3b0c613b6f 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q5.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q5.groovy
@@ -25,10 +25,13 @@ suite("q5") {
sql "set runtime_filter_mode='GLOBAL'"
sql 'set exec_mem_limit=21G'
+
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
-
-
-
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q6.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q6.groovy
index d935874c53..23a1f68391 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q6.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q6.groovy
@@ -24,11 +24,14 @@ suite("q6") {
sql 'set enable_fallback_to_original_planner=false'
sql "set runtime_filter_mode='GLOBAL'"
- sql 'set exec_mem_limit=21G'
+ sql 'set global exec_mem_limit = 21G'
+
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
-
-
-
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q7.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q7.groovy
index bcf8bcbbc5..7c5fef0a67 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q7.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q7.groovy
@@ -25,10 +25,13 @@ suite("q7") {
sql "set runtime_filter_mode='GLOBAL'"
sql 'set exec_mem_limit=21G'
+
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
-
-
-
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q8.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q8.groovy
index d11c6c5778..3b5409de58 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q8.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q8.groovy
@@ -25,10 +25,12 @@ suite("q8") {
sql "set runtime_filter_mode='GLOBAL'"
sql 'set exec_mem_limit=21G'
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
-
-
-
qt_select """
explain shape plan
select
diff --git a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q9.groovy
b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q9.groovy
index 9be034c621..543a51a7d5 100644
--- a/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q9.groovy
+++ b/regression-test/suites/nereids_tpch_shape_sf500_p0/shape/q9.groovy
@@ -26,8 +26,11 @@ suite("q9") {
sql 'set exec_mem_limit=21G'
-
-
+ def result = sql "show backends;"
+ if (result.size() != 1) {
+ print("backends num: ${result.size()}");
+ return;
+ }
qt_select """
explain shape plan
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
