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
The following commit(s) were added to refs/heads/branch-2.1 by this push:
new e586198d588 [Fix](Nereids) remove unstable cases (#40752)
e586198d588 is described below
commit e586198d5880c77314853c37cfd19b507fd2c598
Author: LiBinfeng <46676950+libinfeng...@users.noreply.github.com>
AuthorDate: Thu Sep 12 22:42:20 2024 +0800
[Fix](Nereids) remove unstable cases (#40752)
remove unstable cases which does not totally controlled by hint
---
.../suites/nereids_hint_tpch_p0/shape/q4.groovy | 63 ----------------------
.../suites/nereids_p0/hint/test_leading.groovy | 2 -
2 files changed, 65 deletions(-)
diff --git a/regression-test/suites/nereids_hint_tpch_p0/shape/q4.groovy
b/regression-test/suites/nereids_hint_tpch_p0/shape/q4.groovy
deleted file mode 100644
index 00741fce400..00000000000
--- a/regression-test/suites/nereids_hint_tpch_p0/shape/q4.groovy
+++ /dev/null
@@ -1,63 +0,0 @@
-/*
- * Licensed to the Apache Software Foundation (ASF) under one
- * or more contributor license agreements. See the NOTICE file
- * distributed with this work for additional information
- * regarding copyright ownership. The ASF licenses this file
- * to you under the Apache License, Version 2.0 (the
- * "License"); you may not use this file except in compliance
- * with the License. You may obtain a copy of the License at
- *
- * http://www.apache.org/licenses/LICENSE-2.0
- *
- * Unless required by applicable law or agreed to in writing,
- * software distributed under the License is distributed on an
- * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
- * KIND, either express or implied. See the License for the
- * specific language governing permissions and limitations
- * under the License.
- */
-
-suite("q4") {
- String db = context.config.getDbNameByFile(new File(context.file.parent))
- sql "use ${db}"
- sql 'set enable_nereids_planner=true'
- sql 'set enable_fallback_to_original_planner=false'
- sql "set disable_nereids_rules=PRUNE_EMPTY_PARTITION"
-
- sql 'set exec_mem_limit=21G'
- sql 'SET enable_pipeline_engine = true'
- sql 'set parallel_pipeline_task_num=8'
- sql 'set runtime_filter_mode=OFF'
-
-
-
-
-sql 'set be_number_for_test=3'
-
-
- qt_select """
- explain shape plan
- select
- /*+ leading(lineitem orders) */
- o_orderpriority,
- count(*) as order_count
- from
- orders
- where
- o_orderdate >= date '1993-07-01'
- and o_orderdate < date '1993-07-01' + interval '3' month
- and exists (
- select
- *
- from
- lineitem
- where
- l_orderkey = o_orderkey
- and l_commitdate < l_receiptdate
- )
- group by
- o_orderpriority
- order by
- o_orderpriority;
- """
-}
diff --git a/regression-test/suites/nereids_p0/hint/test_leading.groovy
b/regression-test/suites/nereids_p0/hint/test_leading.groovy
index ec7d568362e..ad321424f29 100644
--- a/regression-test/suites/nereids_p0/hint/test_leading.groovy
+++ b/regression-test/suites/nereids_p0/hint/test_leading.groovy
@@ -947,12 +947,10 @@ suite("test_leading") {
}
// only distribute hint + multi hints
- qt_select90_3 """explain shape plan select count(*) from t1 join
[broadcast] t2 on c1 = c2 join[shuffle] t3 on c2 = c3;"""
explain {
sql """shape plan select count(*) from t1 right outer join [broadcast]
t2 on c1 = c2 join[shuffle] t3 on c2 = c3;"""
contains("UnUsed: [broadcast]_2")
}
- qt_select90_5 """explain shape plan select count(*) from t1 join
[broadcast] t2 on c1 = c2 right outer join[shuffle] t3 on c2 = c3;"""
explain {
sql """shape plan select count(*) from t1 join [shuffle] t2 on c1 = c2
right outer join[broadcast] t3 on c2 = c3;"""
contains("UnUsed: [broadcast]_3")
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
