This is an automated email from the ASF dual-hosted git repository.
hellostephen 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 3898b1e1476 [test](sqlcache)fix sql cache test case (#58079)
3898b1e1476 is described below
commit 3898b1e147640e241029bac8336c895e40784130
Author: zfr95 <[email protected]>
AuthorDate: Tue Nov 18 14:42:31 2025 +0800
[test](sqlcache)fix sql cache test case (#58079)
[test](sqlcache)fix sql cache test case
Add a step to wait until the materialized view has finished updating
---
.../suites/nereids_p0/cache/mtmv_with_sql_cache.groovy | 17 ++++++++---------
1 file changed, 8 insertions(+), 9 deletions(-)
diff --git a/regression-test/suites/nereids_p0/cache/mtmv_with_sql_cache.groovy
b/regression-test/suites/nereids_p0/cache/mtmv_with_sql_cache.groovy
index 16831a003f5..fdcf4dbb131 100644
--- a/regression-test/suites/nereids_p0/cache/mtmv_with_sql_cache.groovy
+++ b/regression-test/suites/nereids_p0/cache/mtmv_with_sql_cache.groovy
@@ -260,7 +260,7 @@ suite("mtmv_with_sql_cache") {
on t1.id = t2.id
"""
def mtmv_sql4 = """
- select t1.id as id, t1.value as value1
+ select t1.id as id, t1.value as value1
from ${tb_name1} as t1
left join ${tb_name2} as t2
on t1.id = t2.id
@@ -374,7 +374,7 @@ suite("mtmv_with_sql_cache") {
on t1.id = t2.id
"""
def mtmv_sql4 = """
- select t1.id as id, t1.value as value1
+ select t1.id as id, t1.value as value1
from ${tb_name1} as t1
left join ${tb_name2} as t2
on t1.id = t2.id
@@ -476,7 +476,7 @@ suite("mtmv_with_sql_cache") {
on t1.id = t2.id
"""
def mtmv_sql4 = """
- select t1.id as id, t1.value as value1
+ select t1.id as id, t1.value as value1
from ${tb_name1} as t1
left join ${tb_name2} as t2
on t1.id = t2.id
@@ -544,7 +544,6 @@ suite("mtmv_with_sql_cache") {
assertHasCache nested_mtmv_sql1
}
}),
-
extraThread("testRefreshCompleteMtmv", {
retryTestSqlCache(3, 1000) {
def prefix_str = "test_refresh_complete_mtmv_"
@@ -629,6 +628,7 @@ suite("mtmv_with_sql_cache") {
// refresh mtmv complete
sql "REFRESH MATERIALIZED VIEW ${mv_name1}
complete;"
+ waitingMTMVTaskFinishedByMvName(mv_name1)
assertNoCache "select * from ${mv_name1}"
assertNoCache mtmv_sql1
assertHasCache "select * from ${nested_mv_name1}"
@@ -667,7 +667,7 @@ suite("mtmv_with_sql_cache") {
on t1.id = t2.id
"""
def mtmv_sql4 = """
- select t1.id as id, t1.value as value1
+ select t1.id as id, t1.value as value1
from ${tb_name1} as t1
left join ${tb_name2} as t2
on t1.id = t2.id
@@ -774,7 +774,7 @@ suite("mtmv_with_sql_cache") {
on t1.id = t2.id
"""
def mtmv_sql4 = """
- select t1.id as id, t1.value as value1
+ select t1.id as id, t1.value as value1
from ${tb_name1} as t1
left join ${tb_name2} as t2
on t1.id = t2.id
@@ -876,13 +876,13 @@ suite("mtmv_with_sql_cache") {
on t1.id = t2.id
"""
def mtmv_sql3 = """
- select t2.id as id, t1.value as value1
+ select t2.id as id, t1.value as value1
from ${tb_name1} as t1
right join ${tb_name2} as t2
on t1.id = t2.id
"""
def mtmv_sql4 = """
- select t1.id as id, t1.value as value1
+ select t1.id as id, t1.value as value1
from ${tb_name1} as t1
left join ${tb_name2} as t2
on t1.id = t2.id
@@ -961,7 +961,6 @@ suite("mtmv_with_sql_cache") {
assertHasCache nested_mtmv_sql1
}
})
-
).get()
}
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
