This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch branch-2.1
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/branch-2.1 by this push:
new 52455ed6d56 branch-2.1: [opt](cache) enhance cache key computation by
removing comments and trimming SQL input #46099 (#46472)
52455ed6d56 is described below
commit 52455ed6d5624d64baf1165139a5057c3403721e
Author: github-actions[bot]
<41898282+github-actions[bot]@users.noreply.github.com>
AuthorDate: Tue Jan 7 13:39:48 2025 +0800
branch-2.1: [opt](cache) enhance cache key computation by removing comments
and trimming SQL input #46099 (#46472)
Cherry-picked from #46099
Co-authored-by: York Cao <[email protected]>
---
fe/fe-core/src/main/java/org/apache/doris/nereids/SqlCacheContext.java | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
diff --git
a/fe/fe-core/src/main/java/org/apache/doris/nereids/SqlCacheContext.java
b/fe/fe-core/src/main/java/org/apache/doris/nereids/SqlCacheContext.java
index 45a4c1d50d5..364c8bcab65 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/nereids/SqlCacheContext.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/nereids/SqlCacheContext.java
@@ -26,6 +26,7 @@ import org.apache.doris.datasource.CatalogIf;
import org.apache.doris.mysql.FieldInfo;
import org.apache.doris.mysql.privilege.DataMaskPolicy;
import org.apache.doris.mysql.privilege.RowFilterPolicy;
+import org.apache.doris.nereids.parser.NereidsParser;
import org.apache.doris.nereids.trees.expressions.Expression;
import org.apache.doris.nereids.trees.expressions.Variable;
import org.apache.doris.nereids.util.Utils;
@@ -349,7 +350,7 @@ public class SqlCacheContext {
/** doComputeCacheKeyMd5 */
public synchronized PUniqueId doComputeCacheKeyMd5(Set<Variable>
usedVariables) {
- StringBuilder cacheKey = new StringBuilder(originSql);
+ StringBuilder cacheKey = new
StringBuilder(NereidsParser.removeCommentAndTrimBlank(originSql.trim()));
for (Entry<FullTableName, String> entry : usedViews.entrySet()) {
cacheKey.append("|")
.append(entry.getKey())
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
