You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by ga...@apache.org on 2026/10/22 05:22:54 UTC

(doris) branch master updated: [fix](regression) Fix flaky materialized view load-open test (#67138)

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

gavinchou 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 e779124b5f6 [fix](regression) Fix flaky materialized view load-open test (#67138)
e779124b5f6 is described below

commit e779124b5f60533088730175957944819d22adcb
Author: Refrain <re...@gmail.com>
AuthorDate: Thu Oct 22 13:22:45 2026 +0800

    [fix](regression) Fix flaky materialized view load-open test (#67138)
    
    `test_materialized_view_load_open` used `createMV`, which waits for the
    latest materialized view job in the shared database. Under parallel
    suite execution, it can observe a concurrent job as `FINISHED` and
    execute `ADD COLUMN` while its own table is still in `ROLLUP` state.
    
    Replace all four calls with `create_sync_mv` so each materialized view
    creation waits for the job belonging to its base table.
---
 .../suites/rollup_p0/test_materialized_view_load_open.groovy   | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

diff --git a/regression-test/suites/rollup_p0/test_materialized_view_load_open.groovy b/regression-test/suites/rollup_p0/test_materialized_view_load_open.groovy
index 1a2fdf0d278..9aa15613695 100644
--- a/regression-test/suites/rollup_p0/test_materialized_view_load_open.groovy
+++ b/regression-test/suites/rollup_p0/test_materialized_view_load_open.groovy
@@ -128,10 +128,10 @@ suite("test_materialized_view_load_open", "rollup") {
             );
         """
     
-    createMV("CREATE materialized VIEW test_load_open AS SELECT k1 as a1 FROM ${tbName1} GROUP BY k1;")
-    createMV("CREATE materialized VIEW test_load_open_dynamic_partition AS SELECT k1 as a2 FROM ${tbName2} GROUP BY k1;")
-    createMV("CREATE materialized VIEW test_load_open_schema_change AS SELECT k1 as a3 FROM ${tbName3} GROUP BY k1;")
-    createMV("CREATE materialized VIEW test_load_open_dynamic_partition_schema_change AS SELECT k1 as a4 FROM ${tbName4} GROUP BY k1;")
+    create_sync_mv(context.dbName, tbName1, "test_load_open", "SELECT k1 as a1 FROM ${tbName1} GROUP BY k1;")
+    create_sync_mv(context.dbName, tbName2, "test_load_open_dynamic_partition", "SELECT k1 as a2 FROM ${tbName2} GROUP BY k1;")
+    create_sync_mv(context.dbName, tbName3, "test_load_open_schema_change", "SELECT k1 as a3 FROM ${tbName3} GROUP BY k1;")
+    create_sync_mv(context.dbName, tbName4, "test_load_open_dynamic_partition_schema_change", "SELECT k1 as a4 FROM ${tbName4} GROUP BY k1;")
 
     sql "insert into ${tbName1} values('2000-05-20', 1.5, 'test', 1);"
     sql "insert into ${tbName1} values('2010-05-20', 1.5, 'test', 1);"
@@ -157,4 +157,4 @@ suite("test_materialized_view_load_open", "rollup") {
     }
 
     qt_select "select * from test_materialized_view_load_open_schema_change order by 1,2,3,4;"
-}
\ No newline at end of file
+}


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org