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]