This is an automated email from the ASF dual-hosted git repository.
morrysnow 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 9b6b847745 [test](Nereids) diable Nereids explicitly on explain case
in regression test (#19744)
9b6b847745 is described below
commit 9b6b847745bcac8f36e3055508219432305d797d
Author: Zhang Wenxin <[email protected]>
AuthorDate: Wed May 17 19:26:30 2023 +0800
[test](Nereids) diable Nereids explicitly on explain case in regression
test (#19744)
---
.../suites/correctness_p0/test_bucket_shuffle_join.groovy | 4 ++++
regression-test/suites/correctness_p0/test_colocate_join.groovy | 4 ++++
regression-test/suites/demo_p0/explain_action.groovy | 4 ++++
.../suites/mv_p0/agg_have_dup_base/agg_have_dup_base.groovy | 4 ++++
regression-test/suites/mv_p0/case_ignore/case_ignore.groovy | 4 ++++
regression-test/suites/mv_p0/k1ap2spa/k1ap2spa.groovy | 4 ++++
.../suites/mv_p0/multi_slot_k123p/multi_slot_k123p.groovy | 4 ++++
.../suites/mv_p0/multi_slot_k1a2p2ap3p/multi_slot_k1a2p2ap3p.groovy | 4 ++++
.../mv_p0/multi_slot_k1a2p2ap3ps/multi_slot_k1a2p2ap3ps.groovy | 4 ++++
.../suites/mv_p0/multi_slot_k1p2ap3p/multi_slot_k1p2ap3p.groovy | 4 ++++
.../suites/mv_p0/multi_slot_k1p2ap3ps/multi_slot_k1p2ap3ps.groovy | 4 ++++
.../suites/mv_p0/multi_slot_multi_mv/multi_slot_multi_mv.groovy | 4 ++++
regression-test/suites/mv_p0/mv_with_view/mv_with_view.groovy | 4 ++++
.../suites/mv_p0/sum_divede_count/sum_devide_count.groovy | 4 ++++
.../mv_p0/test_dup_group_by_mv_abs/test_dup_group_by_mv_abs.groovy | 4 ++++
.../test_dup_group_by_mv_plus/test_dup_group_by_mv_plus.groovy | 4 ++++
regression-test/suites/mv_p0/test_dup_mv_abs/test_dup_mv_abs.groovy | 4 ++++
regression-test/suites/mv_p0/test_dup_mv_bin/test_dup_mv_bin.groovy | 4 ++++
.../mv_p0/test_dup_mv_bitmap_hash/test_dup_mv_bitmap_hash.groovy | 4 ++++
.../suites/mv_p0/test_dup_mv_plus/test_dup_mv_plus.groovy | 4 ++++
.../suites/mv_p0/test_dup_mv_year/test_dup_mv_year.groovy | 4 ++++
.../mv_p0/ut/testAggQueryOnAggMV1/testAggQueryOnAggMV1.groovy | 4 ++++
.../mv_p0/ut/testAggQueryOnAggMV10/testAggQueryOnAggMV10.groovy | 4 ++++
.../mv_p0/ut/testAggQueryOnAggMV11/testAggQueryOnAggMV11.groovy | 4 ++++
.../mv_p0/ut/testAggQueryOnAggMV2/testAggQueryOnAggMV2.groovy | 4 ++++
.../mv_p0/ut/testAggQueryOnAggMV3/testAggQueryOnAggMV3.groovy | 6 +++++-
.../mv_p0/ut/testAggQuqeryOnAggMV5/testAggQuqeryOnAggMV5.groovy | 4 ++++
.../mv_p0/ut/testAggQuqeryOnAggMV6/testAggQuqeryOnAggMV6.groovy | 4 ++++
.../mv_p0/ut/testAggQuqeryOnAggMV7/testAggQuqeryOnAggMV7.groovy | 4 ++++
.../mv_p0/ut/testBitmapUnionInQuery/testBitmapUnionInQuery.groovy | 4 ++++
.../testJoinOnLeftProjectToJoin/testJoinOnLeftProjectToJoin.groovy | 4 ++++
.../suites/mv_p0/ut/testQueryOnStar/testQueryOnStar.groovy | 4 ++++
.../ut/testSelectMVWithTableAlias/testSelectMVWithTableAlias.groovy | 4 ++++
regression-test/suites/mv_p0/where/k123/k123.groovy | 4 ++++
.../suites/query_p0/grouping_sets/test_grouping_sets.groovy | 2 ++
regression-test/suites/rollup/test_materialized_view_bitmap.groovy | 4 ++++
regression-test/suites/rollup/test_materialized_view_date.groovy | 4 ++++
regression-test/suites/rollup/test_materialized_view_hll.groovy | 4 ++++
.../suites/rollup/test_materialized_view_hll_with_light_sc.groovy | 4 ++++
regression-test/suites/rollup_p0/test_materialized_view.groovy | 4 ++++
regression-test/suites/rollup_p0/test_rollup_agg.groovy | 4 ++++
regression-test/suites/trino_p0/constant_group_key.groovy | 4 ++++
42 files changed, 167 insertions(+), 1 deletion(-)
diff --git
a/regression-test/suites/correctness_p0/test_bucket_shuffle_join.groovy
b/regression-test/suites/correctness_p0/test_bucket_shuffle_join.groovy
index 3c172d82e9..2538e32961 100644
--- a/regression-test/suites/correctness_p0/test_bucket_shuffle_join.groovy
+++ b/regression-test/suites/correctness_p0/test_bucket_shuffle_join.groovy
@@ -16,6 +16,10 @@
// under the License.
suite("test_bucket_shuffle_join") {
+
+ // this case check explain, so we disable nereids
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS `test_colo1` """
sql """ DROP TABLE IF EXISTS `test_colo2` """
sql """ DROP TABLE IF EXISTS `test_colo3` """
diff --git a/regression-test/suites/correctness_p0/test_colocate_join.groovy
b/regression-test/suites/correctness_p0/test_colocate_join.groovy
index e5d7ffcbec..53ed6e9843 100644
--- a/regression-test/suites/correctness_p0/test_colocate_join.groovy
+++ b/regression-test/suites/correctness_p0/test_colocate_join.groovy
@@ -16,6 +16,10 @@
// under the License.
suite("test_colocate_join") {
+
+ // this case check explain, so we disable nereids
+ sql """set enable_nereids_planner=false"""
+
def db1 = "test_colocate_join_db1"
def db2 = "test_colocate_join_db2"
sql """ drop database if exists ${db1}"""
diff --git a/regression-test/suites/demo_p0/explain_action.groovy
b/regression-test/suites/demo_p0/explain_action.groovy
index e4a9f21dd1..4dd65ba0da 100644
--- a/regression-test/suites/demo_p0/explain_action.groovy
+++ b/regression-test/suites/demo_p0/explain_action.groovy
@@ -16,6 +16,10 @@
// under the License.
suite("explain_action") {
+
+ // this case check explain, so we disable nereids
+ sql """set enable_nereids_planner=false"""
+
explain {
sql("select 100")
diff --git
a/regression-test/suites/mv_p0/agg_have_dup_base/agg_have_dup_base.groovy
b/regression-test/suites/mv_p0/agg_have_dup_base/agg_have_dup_base.groovy
index b95e868f95..7c64d9642a 100644
--- a/regression-test/suites/mv_p0/agg_have_dup_base/agg_have_dup_base.groovy
+++ b/regression-test/suites/mv_p0/agg_have_dup_base/agg_have_dup_base.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("agg_have_dup_base") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS d_table; """
sql """
diff --git a/regression-test/suites/mv_p0/case_ignore/case_ignore.groovy
b/regression-test/suites/mv_p0/case_ignore/case_ignore.groovy
index 88f9a38578..c0215182cc 100644
--- a/regression-test/suites/mv_p0/case_ignore/case_ignore.groovy
+++ b/regression-test/suites/mv_p0/case_ignore/case_ignore.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("case_ignore") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS d_table; """
sql """
diff --git a/regression-test/suites/mv_p0/k1ap2spa/k1ap2spa.groovy
b/regression-test/suites/mv_p0/k1ap2spa/k1ap2spa.groovy
index 2d1e8fd656..0514dbb4ad 100644
--- a/regression-test/suites/mv_p0/k1ap2spa/k1ap2spa.groovy
+++ b/regression-test/suites/mv_p0/k1ap2spa/k1ap2spa.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("k1ap2spa") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS d_table; """
sql """
diff --git
a/regression-test/suites/mv_p0/multi_slot_k123p/multi_slot_k123p.groovy
b/regression-test/suites/mv_p0/multi_slot_k123p/multi_slot_k123p.groovy
index 70eb71a1a5..5b2a534bca 100644
--- a/regression-test/suites/mv_p0/multi_slot_k123p/multi_slot_k123p.groovy
+++ b/regression-test/suites/mv_p0/multi_slot_k123p/multi_slot_k123p.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("multi_slot_k123p") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS d_table; """
sql """
diff --git
a/regression-test/suites/mv_p0/multi_slot_k1a2p2ap3p/multi_slot_k1a2p2ap3p.groovy
b/regression-test/suites/mv_p0/multi_slot_k1a2p2ap3p/multi_slot_k1a2p2ap3p.groovy
index d75b2c1326..747a18cfdd 100644
---
a/regression-test/suites/mv_p0/multi_slot_k1a2p2ap3p/multi_slot_k1a2p2ap3p.groovy
+++
b/regression-test/suites/mv_p0/multi_slot_k1a2p2ap3p/multi_slot_k1a2p2ap3p.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("multi_slot_k1a2p2ap3p") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS d_table; """
sql """
diff --git
a/regression-test/suites/mv_p0/multi_slot_k1a2p2ap3ps/multi_slot_k1a2p2ap3ps.groovy
b/regression-test/suites/mv_p0/multi_slot_k1a2p2ap3ps/multi_slot_k1a2p2ap3ps.groovy
index 136d58e2ec..5f6a404173 100644
---
a/regression-test/suites/mv_p0/multi_slot_k1a2p2ap3ps/multi_slot_k1a2p2ap3ps.groovy
+++
b/regression-test/suites/mv_p0/multi_slot_k1a2p2ap3ps/multi_slot_k1a2p2ap3ps.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("multi_slot_k1a2p2ap3ps") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS d_table; """
sql """
diff --git
a/regression-test/suites/mv_p0/multi_slot_k1p2ap3p/multi_slot_k1p2ap3p.groovy
b/regression-test/suites/mv_p0/multi_slot_k1p2ap3p/multi_slot_k1p2ap3p.groovy
index 5d93712271..65c736f09b 100644
---
a/regression-test/suites/mv_p0/multi_slot_k1p2ap3p/multi_slot_k1p2ap3p.groovy
+++
b/regression-test/suites/mv_p0/multi_slot_k1p2ap3p/multi_slot_k1p2ap3p.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("multi_slot_k1p2ap3p") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS d_table; """
sql """
diff --git
a/regression-test/suites/mv_p0/multi_slot_k1p2ap3ps/multi_slot_k1p2ap3ps.groovy
b/regression-test/suites/mv_p0/multi_slot_k1p2ap3ps/multi_slot_k1p2ap3ps.groovy
index af08794300..4e588c2d82 100644
---
a/regression-test/suites/mv_p0/multi_slot_k1p2ap3ps/multi_slot_k1p2ap3ps.groovy
+++
b/regression-test/suites/mv_p0/multi_slot_k1p2ap3ps/multi_slot_k1p2ap3ps.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("multi_slot_k1p2ap3ps") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS d_table; """
sql """
diff --git
a/regression-test/suites/mv_p0/multi_slot_multi_mv/multi_slot_multi_mv.groovy
b/regression-test/suites/mv_p0/multi_slot_multi_mv/multi_slot_multi_mv.groovy
index 70caf98b16..0cf3396042 100644
---
a/regression-test/suites/mv_p0/multi_slot_multi_mv/multi_slot_multi_mv.groovy
+++
b/regression-test/suites/mv_p0/multi_slot_multi_mv/multi_slot_multi_mv.groovy
@@ -16,6 +16,10 @@
// under the License.
suite ("multi_slot_multi_mv") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS d_table; """
sql """
diff --git a/regression-test/suites/mv_p0/mv_with_view/mv_with_view.groovy
b/regression-test/suites/mv_p0/mv_with_view/mv_with_view.groovy
index 9e1ea01606..d5f6fe7f96 100644
--- a/regression-test/suites/mv_p0/mv_with_view/mv_with_view.groovy
+++ b/regression-test/suites/mv_p0/mv_with_view/mv_with_view.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("mv_with_view") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS d_table; """
sql """
diff --git
a/regression-test/suites/mv_p0/sum_divede_count/sum_devide_count.groovy
b/regression-test/suites/mv_p0/sum_divede_count/sum_devide_count.groovy
index 19b06d9fbc..d40698dedb 100644
--- a/regression-test/suites/mv_p0/sum_divede_count/sum_devide_count.groovy
+++ b/regression-test/suites/mv_p0/sum_divede_count/sum_devide_count.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("sum_devide_count") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS d_table; """
sql """
diff --git
a/regression-test/suites/mv_p0/test_dup_group_by_mv_abs/test_dup_group_by_mv_abs.groovy
b/regression-test/suites/mv_p0/test_dup_group_by_mv_abs/test_dup_group_by_mv_abs.groovy
index 42c9ffd277..fd0e27a028 100644
---
a/regression-test/suites/mv_p0/test_dup_group_by_mv_abs/test_dup_group_by_mv_abs.groovy
+++
b/regression-test/suites/mv_p0/test_dup_group_by_mv_abs/test_dup_group_by_mv_abs.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("test_dup_group_by_mv_abs") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS d_table; """
sql """
diff --git
a/regression-test/suites/mv_p0/test_dup_group_by_mv_plus/test_dup_group_by_mv_plus.groovy
b/regression-test/suites/mv_p0/test_dup_group_by_mv_plus/test_dup_group_by_mv_plus.groovy
index 162c5f46d6..7545c7ef57 100644
---
a/regression-test/suites/mv_p0/test_dup_group_by_mv_plus/test_dup_group_by_mv_plus.groovy
+++
b/regression-test/suites/mv_p0/test_dup_group_by_mv_plus/test_dup_group_by_mv_plus.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("test_dup_group_by_mv_plus") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS d_table; """
sql """
diff --git
a/regression-test/suites/mv_p0/test_dup_mv_abs/test_dup_mv_abs.groovy
b/regression-test/suites/mv_p0/test_dup_mv_abs/test_dup_mv_abs.groovy
index a5f595959a..0c658bd582 100644
--- a/regression-test/suites/mv_p0/test_dup_mv_abs/test_dup_mv_abs.groovy
+++ b/regression-test/suites/mv_p0/test_dup_mv_abs/test_dup_mv_abs.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("test_dup_mv_abs") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS d_table; """
sql """
diff --git
a/regression-test/suites/mv_p0/test_dup_mv_bin/test_dup_mv_bin.groovy
b/regression-test/suites/mv_p0/test_dup_mv_bin/test_dup_mv_bin.groovy
index 94b838a6c4..28e5c75830 100644
--- a/regression-test/suites/mv_p0/test_dup_mv_bin/test_dup_mv_bin.groovy
+++ b/regression-test/suites/mv_p0/test_dup_mv_bin/test_dup_mv_bin.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("test_dup_mv_bin") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS d_table; """
sql """
diff --git
a/regression-test/suites/mv_p0/test_dup_mv_bitmap_hash/test_dup_mv_bitmap_hash.groovy
b/regression-test/suites/mv_p0/test_dup_mv_bitmap_hash/test_dup_mv_bitmap_hash.groovy
index ff9ae2ee5f..ece622c298 100644
---
a/regression-test/suites/mv_p0/test_dup_mv_bitmap_hash/test_dup_mv_bitmap_hash.groovy
+++
b/regression-test/suites/mv_p0/test_dup_mv_bitmap_hash/test_dup_mv_bitmap_hash.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("test_dup_mv_bitmap_hash") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS d_table; """
sql """
diff --git
a/regression-test/suites/mv_p0/test_dup_mv_plus/test_dup_mv_plus.groovy
b/regression-test/suites/mv_p0/test_dup_mv_plus/test_dup_mv_plus.groovy
index 2c3f403996..eb116d9fd2 100644
--- a/regression-test/suites/mv_p0/test_dup_mv_plus/test_dup_mv_plus.groovy
+++ b/regression-test/suites/mv_p0/test_dup_mv_plus/test_dup_mv_plus.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("test_dup_mv_plus") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS d_table; """
sql """
diff --git
a/regression-test/suites/mv_p0/test_dup_mv_year/test_dup_mv_year.groovy
b/regression-test/suites/mv_p0/test_dup_mv_year/test_dup_mv_year.groovy
index a046dfd247..e0ed6c6153 100644
--- a/regression-test/suites/mv_p0/test_dup_mv_year/test_dup_mv_year.groovy
+++ b/regression-test/suites/mv_p0/test_dup_mv_year/test_dup_mv_year.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("test_dup_mv_year") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS d_table; """
sql """
diff --git
a/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV1/testAggQueryOnAggMV1.groovy
b/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV1/testAggQueryOnAggMV1.groovy
index 1f1802dd75..885443a4b4 100644
---
a/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV1/testAggQueryOnAggMV1.groovy
+++
b/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV1/testAggQueryOnAggMV1.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("testAggQueryOnAggMV1") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS emps; """
sql """
diff --git
a/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV10/testAggQueryOnAggMV10.groovy
b/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV10/testAggQueryOnAggMV10.groovy
index ce049ad1d3..59e457554a 100644
---
a/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV10/testAggQueryOnAggMV10.groovy
+++
b/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV10/testAggQueryOnAggMV10.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("testAggQueryOnAggMV10") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS emps; """
sql """
diff --git
a/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV11/testAggQueryOnAggMV11.groovy
b/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV11/testAggQueryOnAggMV11.groovy
index 94dd436ec1..ca8b678ca1 100644
---
a/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV11/testAggQueryOnAggMV11.groovy
+++
b/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV11/testAggQueryOnAggMV11.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("testAggQueryOnAggMV11") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS emps; """
sql """
diff --git
a/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV2/testAggQueryOnAggMV2.groovy
b/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV2/testAggQueryOnAggMV2.groovy
index fa9daf5ff0..0c7671fcf6 100644
---
a/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV2/testAggQueryOnAggMV2.groovy
+++
b/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV2/testAggQueryOnAggMV2.groovy
@@ -16,6 +16,10 @@
// under the License.
suite ("testAggQueryOnAggMV2") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS emps; """
sql """
create table emps (
diff --git
a/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV3/testAggQueryOnAggMV3.groovy
b/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV3/testAggQueryOnAggMV3.groovy
index 1771731e13..966e9c7f64 100644
---
a/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV3/testAggQueryOnAggMV3.groovy
+++
b/regression-test/suites/mv_p0/ut/testAggQueryOnAggMV3/testAggQueryOnAggMV3.groovy
@@ -18,7 +18,11 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("testAggQueryOnAggMV3") {
- sql """ DROP TABLE IF EXISTS emps; """
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
+ sql """ DROP TABLE IF EXISTS emps; """
sql """
create table emps (
diff --git
a/regression-test/suites/mv_p0/ut/testAggQuqeryOnAggMV5/testAggQuqeryOnAggMV5.groovy
b/regression-test/suites/mv_p0/ut/testAggQuqeryOnAggMV5/testAggQuqeryOnAggMV5.groovy
index 8e45dc4ae2..7c760dd4eb 100644
---
a/regression-test/suites/mv_p0/ut/testAggQuqeryOnAggMV5/testAggQuqeryOnAggMV5.groovy
+++
b/regression-test/suites/mv_p0/ut/testAggQuqeryOnAggMV5/testAggQuqeryOnAggMV5.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("testAggQuqeryOnAggMV5") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS emps; """
sql """
diff --git
a/regression-test/suites/mv_p0/ut/testAggQuqeryOnAggMV6/testAggQuqeryOnAggMV6.groovy
b/regression-test/suites/mv_p0/ut/testAggQuqeryOnAggMV6/testAggQuqeryOnAggMV6.groovy
index 824ee1ffce..7ac9532e11 100644
---
a/regression-test/suites/mv_p0/ut/testAggQuqeryOnAggMV6/testAggQuqeryOnAggMV6.groovy
+++
b/regression-test/suites/mv_p0/ut/testAggQuqeryOnAggMV6/testAggQuqeryOnAggMV6.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("testAggQuqeryOnAggMV6") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS emps; """
sql """
diff --git
a/regression-test/suites/mv_p0/ut/testAggQuqeryOnAggMV7/testAggQuqeryOnAggMV7.groovy
b/regression-test/suites/mv_p0/ut/testAggQuqeryOnAggMV7/testAggQuqeryOnAggMV7.groovy
index d6eeba138e..667c4098df 100644
---
a/regression-test/suites/mv_p0/ut/testAggQuqeryOnAggMV7/testAggQuqeryOnAggMV7.groovy
+++
b/regression-test/suites/mv_p0/ut/testAggQuqeryOnAggMV7/testAggQuqeryOnAggMV7.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("testAggQuqeryOnAggMV7") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS emps; """
sql """
diff --git
a/regression-test/suites/mv_p0/ut/testBitmapUnionInQuery/testBitmapUnionInQuery.groovy
b/regression-test/suites/mv_p0/ut/testBitmapUnionInQuery/testBitmapUnionInQuery.groovy
index da00a043b5..848704aac6 100644
---
a/regression-test/suites/mv_p0/ut/testBitmapUnionInQuery/testBitmapUnionInQuery.groovy
+++
b/regression-test/suites/mv_p0/ut/testBitmapUnionInQuery/testBitmapUnionInQuery.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("testBitmapUnionInQuery") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS user_tags; """
sql """ create table user_tags (
diff --git
a/regression-test/suites/mv_p0/ut/testJoinOnLeftProjectToJoin/testJoinOnLeftProjectToJoin.groovy
b/regression-test/suites/mv_p0/ut/testJoinOnLeftProjectToJoin/testJoinOnLeftProjectToJoin.groovy
index 1febdd59b5..9a6625a672 100644
---
a/regression-test/suites/mv_p0/ut/testJoinOnLeftProjectToJoin/testJoinOnLeftProjectToJoin.groovy
+++
b/regression-test/suites/mv_p0/ut/testJoinOnLeftProjectToJoin/testJoinOnLeftProjectToJoin.groovy
@@ -16,6 +16,10 @@
// under the License.
suite ("testJoinOnLeftProjectToJoin") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS emps; """
sql """
create table emps (
diff --git
a/regression-test/suites/mv_p0/ut/testQueryOnStar/testQueryOnStar.groovy
b/regression-test/suites/mv_p0/ut/testQueryOnStar/testQueryOnStar.groovy
index 57ddba4d3c..3e7a57f778 100644
--- a/regression-test/suites/mv_p0/ut/testQueryOnStar/testQueryOnStar.groovy
+++ b/regression-test/suites/mv_p0/ut/testQueryOnStar/testQueryOnStar.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("testQueryOnStar") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS emps; """
sql """
diff --git
a/regression-test/suites/mv_p0/ut/testSelectMVWithTableAlias/testSelectMVWithTableAlias.groovy
b/regression-test/suites/mv_p0/ut/testSelectMVWithTableAlias/testSelectMVWithTableAlias.groovy
index f7d81ac7fb..2602992af4 100644
---
a/regression-test/suites/mv_p0/ut/testSelectMVWithTableAlias/testSelectMVWithTableAlias.groovy
+++
b/regression-test/suites/mv_p0/ut/testSelectMVWithTableAlias/testSelectMVWithTableAlias.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("testSelectMVWithTableAlias") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS user_tags; """
sql """ create table user_tags (
diff --git a/regression-test/suites/mv_p0/where/k123/k123.groovy
b/regression-test/suites/mv_p0/where/k123/k123.groovy
index 29da7d05af..4eac05be5f 100644
--- a/regression-test/suites/mv_p0/where/k123/k123.groovy
+++ b/regression-test/suites/mv_p0/where/k123/k123.groovy
@@ -18,6 +18,10 @@
import org.codehaus.groovy.runtime.IOGroovyMethods
suite ("k123p") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
sql """ DROP TABLE IF EXISTS d_table; """
sql """
diff --git
a/regression-test/suites/query_p0/grouping_sets/test_grouping_sets.groovy
b/regression-test/suites/query_p0/grouping_sets/test_grouping_sets.groovy
index fa296c3a12..e27b067f9a 100644
--- a/regression-test/suites/query_p0/grouping_sets/test_grouping_sets.groovy
+++ b/regression-test/suites/query_p0/grouping_sets/test_grouping_sets.groovy
@@ -192,6 +192,8 @@ suite("test_grouping_sets", "p0") {
"""
sql """drop table if exists test_query_db.test_grouping_sets_id_null"""
// test grouping sets shoot rollup
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
sql "drop table if exists test_query_db.test_grouping_sets_rollup"
sql """
create table if not exists test_query_db.test_grouping_sets_rollup(
diff --git a/regression-test/suites/rollup/test_materialized_view_bitmap.groovy
b/regression-test/suites/rollup/test_materialized_view_bitmap.groovy
index 744ebbaea9..28be3744a2 100644
--- a/regression-test/suites/rollup/test_materialized_view_bitmap.groovy
+++ b/regression-test/suites/rollup/test_materialized_view_bitmap.groovy
@@ -15,6 +15,10 @@
// specific language governing permissions and limitations
// under the License.
suite("test_materialized_view_bitmap", "rollup") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
def tbName1 = "test_materialized_view_bitmap"
def getJobState = { tableName ->
diff --git a/regression-test/suites/rollup/test_materialized_view_date.groovy
b/regression-test/suites/rollup/test_materialized_view_date.groovy
index 504a6575a3..2e9265aab1 100644
--- a/regression-test/suites/rollup/test_materialized_view_date.groovy
+++ b/regression-test/suites/rollup/test_materialized_view_date.groovy
@@ -15,6 +15,10 @@
// specific language governing permissions and limitations
// under the License.
suite("test_materialized_view_date", "rollup") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
def tbName1 = "test_materialized_view_date"
def getJobState = { tableName ->
diff --git a/regression-test/suites/rollup/test_materialized_view_hll.groovy
b/regression-test/suites/rollup/test_materialized_view_hll.groovy
index c38c0d1c4f..b30934ed4b 100644
--- a/regression-test/suites/rollup/test_materialized_view_hll.groovy
+++ b/regression-test/suites/rollup/test_materialized_view_hll.groovy
@@ -15,6 +15,10 @@
// specific language governing permissions and limitations
// under the License.
suite("test_materialized_view_hll", "rollup") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
def tbName1 = "test_materialized_view_hll"
def getJobState = { tableName ->
diff --git
a/regression-test/suites/rollup/test_materialized_view_hll_with_light_sc.groovy
b/regression-test/suites/rollup/test_materialized_view_hll_with_light_sc.groovy
index 8775cce7cd..1257ef8bd0 100644
---
a/regression-test/suites/rollup/test_materialized_view_hll_with_light_sc.groovy
+++
b/regression-test/suites/rollup/test_materialized_view_hll_with_light_sc.groovy
@@ -15,6 +15,10 @@
// specific language governing permissions and limitations
// under the License.
suite("test_materialized_view_hll_with_light_sc", "rollup") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
def tbName1 = "test_materialized_view_hll_with_light_sc"
def getJobState = { tableName ->
diff --git a/regression-test/suites/rollup_p0/test_materialized_view.groovy
b/regression-test/suites/rollup_p0/test_materialized_view.groovy
index 21a957747f..f570e82080 100644
--- a/regression-test/suites/rollup_p0/test_materialized_view.groovy
+++ b/regression-test/suites/rollup_p0/test_materialized_view.groovy
@@ -15,6 +15,10 @@
// specific language governing permissions and limitations
// under the License.
suite("test_materialized_view") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
def tbName1 = "test_materialized_view1"
def tbName2 = "test_materialized_view2"
diff --git a/regression-test/suites/rollup_p0/test_rollup_agg.groovy
b/regression-test/suites/rollup_p0/test_rollup_agg.groovy
index d5d4988dc1..31d57cc6b3 100644
--- a/regression-test/suites/rollup_p0/test_rollup_agg.groovy
+++ b/regression-test/suites/rollup_p0/test_rollup_agg.groovy
@@ -15,6 +15,10 @@
// specific language governing permissions and limitations
// under the License.
suite("test_rollup_agg") {
+
+ // because nereids cannot support rollup correctly forbid it temporary
+ sql """set enable_nereids_planner=false"""
+
def tbName = "test_rollup_agg"
def getJobRollupState = { tableName ->
diff --git a/regression-test/suites/trino_p0/constant_group_key.groovy
b/regression-test/suites/trino_p0/constant_group_key.groovy
index d666b5244c..ea51175c81 100644
--- a/regression-test/suites/trino_p0/constant_group_key.groovy
+++ b/regression-test/suites/trino_p0/constant_group_key.groovy
@@ -17,6 +17,10 @@
// This suit test remove constant group_by_key
suite("constant_group_key") {
+
+ // this case check explain, so we disable nereids
+ sql """set enable_nereids_planner=false"""
+
//remove constant key
explain {
sql("select 'oneline' from nation group by n_nationkey, 'constant1'")
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
