This is an automated email from the ASF dual-hosted git repository.

huajianlan pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git


The following commit(s) were added to refs/heads/branch-2.0 by this push:
     new aac38b6b2a0 [enhancement](Optimizer) optimize delete statement can not 
do partition prune when column is not lower case  (#41215)
aac38b6b2a0 is described below

commit aac38b6b2a08cab9183a61e5765c6b70d0176fa7
Author: 924060929 <924060...@qq.com>
AuthorDate: Thu Oct 17 18:03:14 2024 +0800

    [enhancement](Optimizer) optimize delete statement can not do partition 
prune when column is not lower case  (#41215)
    
    optimize delete statement can not do partition prune when column is not
    lower case
    
    for example, this sql will send finishRealtimePush rpc for all
    partitions, but we only want to process one partition
    ```sql
    delete from tbl where Dt = '2024-01-01'
    ```
---
 .../src/main/java/org/apache/doris/planner/PartitionPrunerV2Base.java   | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git 
a/fe/fe-core/src/main/java/org/apache/doris/planner/PartitionPrunerV2Base.java 
b/fe/fe-core/src/main/java/org/apache/doris/planner/PartitionPrunerV2Base.java
index 1d9f163ca80..6b34f037411 100644
--- 
a/fe/fe-core/src/main/java/org/apache/doris/planner/PartitionPrunerV2Base.java
+++ 
b/fe/fe-core/src/main/java/org/apache/doris/planner/PartitionPrunerV2Base.java
@@ -108,7 +108,7 @@ public abstract class PartitionPrunerV2Base implements 
PartitionPruner {
     public Collection<Long> prune() throws AnalysisException {
         Map<Column, FinalFilters> columnToFilters = Maps.newHashMap();
         for (Column column : partitionColumns) {
-            ColumnRange columnRange = columnNameToRange.get(column.getName());
+            ColumnRange columnRange = 
columnNameToRange.get(column.getName().toLowerCase());
             if (columnRange == null) {
                 columnToFilters.put(column, FinalFilters.noFilters());
             } else {


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org

Reply via email to