You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by en...@apache.org on 2023/06/16 02:39:44 UTC
[doris] branch master updated: [fix](nereids)use "analyze table XXX with sync" in regression cases #20856
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 7f413f13c4 [fix](nereids)use "analyze table XXX with sync" in regression cases #20856
7f413f13c4 is described below
commit 7f413f13c4faff7cc89cf09739e180e12121687b
Author: minghong <en...@gmail.com>
AuthorDate: Fri Jun 16 10:39:37 2023 +0800
[fix](nereids)use "analyze table XXX with sync" in regression cases #20856
replace analyze table XXX by analyze table XXX with sync in regression test cases
---
regression-test/suites/nereids_p0/join/bucket_shuffle_join.groovy | 6 ++----
regression-test/suites/nereids_syntax_p0/join.groovy | 4 ++--
2 files changed, 4 insertions(+), 6 deletions(-)
diff --git a/regression-test/suites/nereids_p0/join/bucket_shuffle_join.groovy b/regression-test/suites/nereids_p0/join/bucket_shuffle_join.groovy
index 5a48d2a99f..786a478d20 100644
--- a/regression-test/suites/nereids_p0/join/bucket_shuffle_join.groovy
+++ b/regression-test/suites/nereids_p0/join/bucket_shuffle_join.groovy
@@ -56,10 +56,8 @@ suite("bucket-shuffle-join") {
sql """insert into shuffle_join_t2 values("1","1","1");"""
sql """insert into shuffle_join_t2 values("1","1","1");"""
- sql """analyze table shuffle_join_t1;"""
- sql """analyze table shuffle_join_t2;"""
-
- Thread.sleep(2000)
+ sql """analyze table shuffle_join_t1 with sync;"""
+ sql """analyze table shuffle_join_t2 with sync;"""
explain {
sql("select * from shuffle_join_t1 t1 left join shuffle_join_t2 t2 on t1.a = t2.a;")
diff --git a/regression-test/suites/nereids_syntax_p0/join.groovy b/regression-test/suites/nereids_syntax_p0/join.groovy
index 1748e2a855..63382c3ed4 100644
--- a/regression-test/suites/nereids_syntax_p0/join.groovy
+++ b/regression-test/suites/nereids_syntax_p0/join.groovy
@@ -69,11 +69,11 @@ suite("join") {
// must analyze before explain, because empty table may generate different plan
sql """
- analyze table test_table_b;
+ analyze table test_table_b with sync;
"""
sql """
- analyze table test_table_a;
+ analyze table test_table_a with sync;
"""
order_qt_inner_join_1 """
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org