apache
diff --git a/‎fe/fe-core/src/main/java/org/apache/doris/common/cache/NereidsSqlCacheManager.java
Copy file name to clipboardExpand all lines: fe/fe-core/src/main/java/org/apache/doris/common/cache/NereidsSqlCacheManager.java
+1-1Lines changed: 1 addition & 1 deletion b/‎fe/fe-core/src/main/java/org/apache/doris/common/cache/NereidsSqlCacheManager.java
Copy file name to clipboardExpand all lines: fe/fe-core/src/main/java/org/apache/doris/common/cache/NereidsSqlCacheManager.java
+1-1Lines changed: 1 addition & 1 deletion
diff --git a/‎regression-test/suites/mtmv_p0/test_mtmv_sql_cache_and_profile.groovy
Copy file name to clipboardExpand all lines: regression-test/suites/mtmv_p0/test_mtmv_sql_cache_and_profile.groovy
+3-1Lines changed: 3 additions & 1 deletion b/‎regression-test/suites/mtmv_p0/test_mtmv_sql_cache_and_profile.groovy
Copy file name to clipboardExpand all lines: regression-test/suites/mtmv_p0/test_mtmv_sql_cache_and_profile.groovy
+3-1Lines changed: 3 additions & 1 deletion
@@ -325,7 +325,7 @@ private boolean tablesOrDataChanged(Env env, SqlCacheContext sqlCacheContext) {
         // check table type and version
         for (Entry<FullTableName, TableVersion> scanTable : sqlCacheContext.getUsedTables().entrySet()) {
             TableVersion tableVersion = scanTable.getValue();
-            if (tableVersion.type != TableType.OLAP) {
+            if (tableVersion.type != TableType.OLAP && tableVersion.type != TableType.MATERIALIZED_VIEW) {
                 return true;
             }
             TableIf tableIf = findTableIf(env, scanTable.getKey());
 
@@ -63,12 +63,13 @@ suite("test_mtmv_sql_cache_and_profile", "mtmv") {
     waitingMTMVTaskFinished(jobName)
 
     sql """set enable_sql_cache=true;"""
+    sql "ADMIN SET FRONTEND CONFIG ('cache_last_version_interval_second' = '10')"
+    sleep(10 * 1000)
 
     long startTime = System.currentTimeMillis()
     long timeoutTimestamp = startTime + 5 * 60 * 1000
     def explain_res = ""
     while (System.currentTimeMillis() < timeoutTimestamp) {
-        sleep(5 * 1000)
         sql """select k2 from ${mvName} group by k2;"""
         try {
             explain_res = sql """explain plan select k2 from ${mvName} group by k2;"""
@@ -79,6 +80,7 @@ suite("test_mtmv_sql_cache_and_profile", "mtmv") {
         if (explain_res.toString().indexOf("LogicalSqlCache") != -1 || explain_res.toString().indexOf("PhysicalSqlCache") != -1) {
             break
         }
+        sleep(5 * 1000)
     }
     assertTrue(explain_res.toString().indexOf("LogicalSqlCache") != -1 || explain_res.toString().indexOf("PhysicalSqlCache") != -1)