This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-4.0
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-4.0 by this push:
new d871ebeeb1b branch-4.0: [test](sqlcache)fix sql cache test case #58079
(#60848)
d871ebeeb1b is described below
commit d871ebeeb1b6f7ca65f4993964d8f064d36134b0
Author: github-actions[bot]
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Fri Feb 27 11:31:15 2026 +0800
branch-4.0: [test](sqlcache)fix sql cache test case #58079 (#60848)
Cherry-picked from #58079
Co-authored-by: zfr95 <[email protected]>
---
.../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]
