This is an automated email from the ASF dual-hosted git repository.
huajianlan 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 d61d2cbfa57 [fix](nereids) fix unstable test of sql cache (#56264)
d61d2cbfa57 is described below
commit d61d2cbfa57f2273831e1e6f02945f3cdf702183
Author: 924060929 <[email protected]>
AuthorDate: Mon Sep 22 15:35:41 2025 +0800
[fix](nereids) fix unstable test of sql cache (#56264)
fix unstable test of sql cache
---
regression-test/suites/nereids_p0/cache/parse_sql_from_sql_cache.groovy | 2 ++
.../mv/union_all_compensate/union_all_compensate.groovy | 2 ++
.../mv/union_rewrite_grace_big/union_rewrite_grace_big.groovy | 2 ++
3 files changed, 6 insertions(+)
diff --git
a/regression-test/suites/nereids_p0/cache/parse_sql_from_sql_cache.groovy
b/regression-test/suites/nereids_p0/cache/parse_sql_from_sql_cache.groovy
index 8c6d02aa179..f73b6004437 100644
--- a/regression-test/suites/nereids_p0/cache/parse_sql_from_sql_cache.groovy
+++ b/regression-test/suites/nereids_p0/cache/parse_sql_from_sql_cache.groovy
@@ -80,6 +80,8 @@ suite("parse_sql_from_sql_cache") {
def dbName = (sql "select database()")[0][0].toString()
sql "ADMIN SET ALL FRONTENDS CONFIG
('cache_last_version_interval_second' = '0')"
+ sql "ADMIN SET ALL FRONTENDS CONFIG ('sql_cache_manage_num' = '10000')"
+ sql "ADMIN SET ALL FRONTENDS CONFIG ('expire_sql_cache_in_fe_second' =
'300')"
// make sure if the table has been dropped, the cache should
invalidate,
// so we should retry multiple times to check
diff --git
a/regression-test/suites/nereids_rules_p0/mv/union_all_compensate/union_all_compensate.groovy
b/regression-test/suites/nereids_rules_p0/mv/union_all_compensate/union_all_compensate.groovy
index 06bad149429..b9ebbd9a458 100644
---
a/regression-test/suites/nereids_rules_p0/mv/union_all_compensate/union_all_compensate.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/union_all_compensate/union_all_compensate.groovy
@@ -24,6 +24,8 @@ suite("union_all_compensate") {
sql "SET ignore_shape_nodes='PhysicalDistribute,PhysicalProject'"
sql "set enable_sql_cache=true"
sql "ADMIN SET ALL FRONTENDS CONFIG
('cache_last_version_interval_second' = '0')"
+ sql "ADMIN SET ALL FRONTENDS CONFIG ('sql_cache_manage_num' = '10000')"
+ sql "ADMIN SET ALL FRONTENDS CONFIG ('expire_sql_cache_in_fe_second' =
'300')"
sql """
drop table if exists test_table1
diff --git
a/regression-test/suites/nereids_rules_p0/mv/union_rewrite_grace_big/union_rewrite_grace_big.groovy
b/regression-test/suites/nereids_rules_p0/mv/union_rewrite_grace_big/union_rewrite_grace_big.groovy
index c970f970fe2..613c9152aac 100644
---
a/regression-test/suites/nereids_rules_p0/mv/union_rewrite_grace_big/union_rewrite_grace_big.groovy
+++
b/regression-test/suites/nereids_rules_p0/mv/union_rewrite_grace_big/union_rewrite_grace_big.groovy
@@ -26,6 +26,8 @@ suite("union_rewrite_grace_big") {
sql "set runtime_filter_mode=OFF"
sql "set enable_sql_cache=true"
sql "ADMIN SET ALL FRONTENDS CONFIG
('cache_last_version_interval_second' = '0')"
+ sql "ADMIN SET ALL FRONTENDS CONFIG ('sql_cache_manage_num' = '10000')"
+ sql "ADMIN SET ALL FRONTENDS CONFIG ('expire_sql_cache_in_fe_second' =
'300')"
sql """
drop table if exists orders
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
