This is an automated email from the ASF dual-hosted git repository.

morrysnow pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git


The following commit(s) were added to refs/heads/branch-2.1 by this push:
     new 3eeb83ff110 [test](fix) Fix test check fail when test nested mv hit 
(#34293) (#35375)
3eeb83ff110 is described below

commit 3eeb83ff1104595e8397f7bb7a6bc512b36284f2
Author: seawinde <[email protected]>
AuthorDate: Fri May 24 19:47:16 2024 +0800

    [test](fix) Fix test check fail when test nested mv hit (#34293) (#35375)
    
    pick from master commit id: d20b18f pr: #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]

Reply via email to