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 19e2126c510 [fix](mtmv) Fix union rewrite by materialized view
regression test instability (#36770)
19e2126c510 is described below
commit 19e2126c510f87f852e7f68e8c55097567e51f3e
Author: seawinde <[email protected]>
AuthorDate: Tue Jun 25 14:14:22 2024 +0800
[fix](mtmv) Fix union rewrite by materialized view regression test
instability (#36770)
When union rewrite by materialized view, the final plan chosen by CBO is
instability.
So the regression test only check mv is rewritten successful or not,
doesn't check is chosen by CBO or not.
Optimize to make sure chosen by CBO would be anther pr to fix this
thoroughly。
---
.../mv/union_rewrite/usercase_union_rewrite.groovy | 11 +++++++++--
1 file changed, 9 insertions(+), 2 deletions(-)
diff --git
a/regression-test/suites/nereids_rules_p0/mv/union_rewrite/usercase_union_rewrite.groovy
b/regression-test/suites/nereids_rules_p0/mv/union_rewrite/usercase_union_rewrite.groovy
index 3b6e51d38a8..c076d13166c 100644
---
a/regression-test/suites/nereids_rules_p0/mv/union_rewrite/usercase_union_rewrite.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/union_rewrite/usercase_union_rewrite.groovy
@@ -153,9 +153,13 @@ suite ("usercase_union_rewrite") {
o_comment,
o_orderdate
"""
+
explain {
sql("${query_stmt}")
- contains "${mv_name}(${mv_name})"
+ check {result ->
+ def splitResult = result.split("MaterializedViewRewriteFail")
+ splitResult.length == 2 ? splitResult[0].contains(mv_name) : false
+ }
}
compare_res(query_stmt + " order by 1,2,3,4,5,6,7,8")
@@ -163,7 +167,10 @@ suite ("usercase_union_rewrite") {
sleep(10 * 1000)
explain {
sql("${query_stmt}")
- contains "${mv_name}(${mv_name})"
+ check {result ->
+ def splitResult = result.split("MaterializedViewRewriteFail")
+ splitResult.length == 2 ? splitResult[0].contains(mv_name) : false
+ }
}
compare_res(query_stmt + " order by 1,2,3,4,5,6,7,8")
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
