This is an automated email from the ASF dual-hosted git repository.
hello-stephen 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 1450d6b8c60 [fix](test) fix flaky case in variables_persist test_mtmv
(#64365)
1450d6b8c60 is described below
commit 1450d6b8c60d4c86b3ec6d7939f192ce1dc9d9f1
Author: feiniaofeiafei <[email protected]>
AuthorDate: Wed Jun 10 20:32:43 2026 +0800
[fix](test) fix flaky case in variables_persist test_mtmv (#64365)
Problem Summary:
`test_mtmv` checked `where_mv not chose` after setting
`enable_decimal256=false`, but this is cost/statistics dependent. The
optimizer may still choose `where_mv` as a covering scan and recompute
`f1 * f2` from `f1/f2`.
---
regression-test/suites/query_p0/variables_persist/test_mtmv.groovy | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/regression-test/suites/query_p0/variables_persist/test_mtmv.groovy
b/regression-test/suites/query_p0/variables_persist/test_mtmv.groovy
index 254ac07ba17..e59300ae5c8 100644
--- a/regression-test/suites/query_p0/variables_persist/test_mtmv.groovy
+++ b/regression-test/suites/query_p0/variables_persist/test_mtmv.groovy
@@ -141,14 +141,14 @@ suite("test_mtmv") {
sql """
select t1.f1*t1.f2, t1.f1, t1.f2 from
test_decimal_mul_overflow_for_mv t1 where t1.f1>1;
"""
- contains "where_mv chose"
+ contains "final projections: __multiply_0"
}
sql "set enable_decimal256=false;"
explain {
sql """
select t1.f1*t1.f2, t1.f1, t1.f2 from
test_decimal_mul_overflow_for_mv t1 where t1.f1>1;
"""
- contains "where_mv not chose"
+ notContains "final projections: __multiply_0"
}
sql "drop materialized view if exists where_mv;"
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
