This is an automated email from the ASF dual-hosted git repository.
yiguolei 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 4efc68a33d [fix](test)disable join reorder for test_bitmap_filter
regression test (#23150)
4efc68a33d is described below
commit 4efc68a33d8d0a192ddb4ae666d39a17cebd6cd7
Author: starocean999 <[email protected]>
AuthorDate: Thu Sep 14 16:05:09 2023 +0800
[fix](test)disable join reorder for test_bitmap_filter regression test
(#23150)
the nereids planner may reorder the join without any statistics info. This
could lead to very bad join order that cause the query timeout. This pr disable
join reorder for this sql.
---
regression-test/suites/query_p1/test_bitmap_filter_p1.groovy | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/regression-test/suites/query_p1/test_bitmap_filter_p1.groovy
b/regression-test/suites/query_p1/test_bitmap_filter_p1.groovy
index da7b048ad8..f6be6bde74 100644
--- a/regression-test/suites/query_p1/test_bitmap_filter_p1.groovy
+++ b/regression-test/suites/query_p1/test_bitmap_filter_p1.groovy
@@ -259,7 +259,7 @@ suite("test_bitmap_filter", "query_p1,p1") {
'where k2 in (select bm_k4 from test_k1_bitmap)) b order by b.k3,
a.k1, a.k4 limit 5'
qt_sql33 'select * from bm_dup_data a join (select k3 from
test_k1_k2_k3_bitmap ' +
'where k2 in (select bm_k4 from test_k1_bitmap)) b on b.k3=a.k3
order by b.k3, a.k1, a.k4 limit 5'
- qt_sql34 'select * from (select k3 from bm_dup_data where k4 not in
(select bm_k4 from test_k1_bitmap)) a ' +
+ qt_sql34 'select /*+SET_VAR(disable_join_reorder=true)*/ * from (select k3
from bm_dup_data where k4 not in (select bm_k4 from test_k1_bitmap)) a ' +
'join (select k3 from test_k1_k2_k3_bitmap where k2 in (select
bm_k4 from test_k1_bitmap)) b on b.k3=a.k3'
qt_sql35 'select * from (select k3 from bm_dup_data where k4 not in
(select bm_k4 from test_k1_bitmap)) a ' +
'left join (select k3 from test_k1_k2_k3_bitmap where k2 in
(select bm_k4 from test_k1_bitmap)) b on b.k3=a.k3 order by a.k3, b.k3'
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
