This is an automated email from the ASF dual-hosted git repository. kxiao pushed a commit to branch branch-2.0 in repository https://gitbox.apache.org/repos/asf/doris.git
commit e5e0bce445a03cca2f0ee157c4b9b533fff73695 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]
