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

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

commit 746d3779191afb9f62a605b34b298140797b5759
Author: github-actions[bot] 
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Wed Sep 16 20:25:23 2026 +0800

    branch-4.1: [fix](regression) Wait for sync MV row count #68015 (#68053)
    
    Cherry-picked from #68015
    
    Co-authored-by: yujun <[email protected]>
---
 .../suites/rollup_p0/test_create_mv_and_mtmv.groovy         | 13 +++++++++++++
 1 file changed, 13 insertions(+)

diff --git a/regression-test/suites/rollup_p0/test_create_mv_and_mtmv.groovy 
b/regression-test/suites/rollup_p0/test_create_mv_and_mtmv.groovy
index b8c3639fb42..c947341e2cd 100644
--- a/regression-test/suites/rollup_p0/test_create_mv_and_mtmv.groovy
+++ b/regression-test/suites/rollup_p0/test_create_mv_and_mtmv.groovy
@@ -52,6 +52,19 @@ suite("test_create_mv_and_mtmv") {
                  dt;
 
     """)
+    def expectedRowCounts = [2]
+    def rowCounts = []
+    for (int i = 0; i < 120; i++) {
+        def result = sql """SHOW INDEX STATS ${tableName} ${mvName};"""
+        rowCounts = result.collect { it[4].toInteger() }
+        log.info("SHOW INDEX STATS ${tableName} ${mvName}: ${result}, MV row 
counts: ${rowCounts}")
+        if (rowCounts == expectedRowCounts) {
+            break
+        }
+        Thread.sleep(5000)
+    }
+    assertEquals(expectedRowCounts, rowCounts,
+            "Unexpected row counts for materialized view ${mvName}")
     explain {
         sql("""
                     SELECT dt,advertiser,


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to