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 d20b18f222e [test](fix) Fix test check fail when test nested mv hit
(#34293)
d20b18f222e is described below
commit d20b18f222ea1a60c88b43a51bdea529f53f506b
Author: seawinde <[email protected]>
AuthorDate: Wed May 8 16:25:33 2024 +0800
[test](fix) Fix test check fail when test nested mv hit (#34293)
if mv3 is def as following:
select c1, c2, c3 from t1;
mv4 is def as following:
select c1, c2 from mv3;
when query is
select c1, c2 from t1;
the mv3 and mv4 both can be rewritten successfully
---
.../suites/nereids_rules_p0/mv/nested_mtmv/nested_mtmv.groovy | 6 +++++-
1 file changed, 5 insertions(+), 1 deletion(-)
diff --git
a/regression-test/suites/nereids_rules_p0/mv/nested_mtmv/nested_mtmv.groovy
b/regression-test/suites/nereids_rules_p0/mv/nested_mtmv/nested_mtmv.groovy
index 881d91d0a45..ce64cc21bf1 100644
--- a/regression-test/suites/nereids_rules_p0/mv/nested_mtmv/nested_mtmv.groovy
+++ b/regression-test/suites/nereids_rules_p0/mv/nested_mtmv/nested_mtmv.groovy
@@ -279,7 +279,11 @@ suite("nested_mtmv") {
"""
explain {
sql("${query_stmt_2}")
- contains "${mv_level4_name}(${mv_level4_name})"
+ check {result ->
+ // both mv_level4_name and mv_level3_name can be rewritten
successfully
+ result.contains("${mv_level4_name}(${mv_level4_name})")
+ || result.contains("${mv_level3_name}(${mv_level3_name})")
+ }
}
compare_res(query_stmt_2 + " order by 1,2,3,4,5,6,7")
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]