[doris] branch branch-1.2-lts updated: [Bug](delete) fix the delete ignore char case (#18991)

[jakevin]

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

jakevin pushed a commit to branch branch-1.2-lts
in repository https://gitbox.apache.org/repos/asf/doris.git


The following commit(s) were added to refs/heads/branch-1.2-lts by this push:
     new 1534ad286b [Bug](delete) fix the delete ignore char case (#18991)
1534ad286b is described below

commit 1534ad286b8264d5e722acd02158d76a9dc202c7
Author: HappenLee <happen...@hotmail.com>
AuthorDate: Mon Apr 24 16:11:51 2023 +0800

    [Bug](delete) fix the delete ignore char case (#18991)
---
 fe/fe-core/src/main/java/org/apache/doris/load/DeleteHandler.java | 3 ++-
 regression-test/suites/delete_p0/test_delete.groovy               | 2 +-
 2 files changed, 3 insertions(+), 2 deletions(-)

diff --git a/fe/fe-core/src/main/java/org/apache/doris/load/DeleteHandler.java 
b/fe/fe-core/src/main/java/org/apache/doris/load/DeleteHandler.java
index aea4c3b324..eded68a554 100644
--- a/fe/fe-core/src/main/java/org/apache/doris/load/DeleteHandler.java
+++ b/fe/fe-core/src/main/java/org/apache/doris/load/DeleteHandler.java
@@ -415,7 +415,8 @@ public class DeleteHandler implements Writable {
             throws AnalysisException {
         ColumnRange result = ColumnRange.create();
         Type type =
-                table.getBaseSchema().stream().filter(c -> 
c.getName().equals(colName)).findFirst().get().getType();
+                table.getBaseSchema().stream().filter(c -> 
c.getName().equalsIgnoreCase(colName))
+                        .findFirst().get().getType();
 
         boolean hasRange = false;
         for (Predicate predicate : conditions) {
diff --git a/regression-test/suites/delete_p0/test_delete.groovy 
b/regression-test/suites/delete_p0/test_delete.groovy
index e142ae7da5..ff3c9b0fbe 100644
--- a/regression-test/suites/delete_p0/test_delete.groovy
+++ b/regression-test/suites/delete_p0/test_delete.groovy
@@ -116,6 +116,6 @@ suite("test_delete") {
        """
     sql """ insert into tb_test1 values ('2022-10-01', 123); """
     qt_sql9 """select * from tb_test1;"""
-    sql """ delete from tb_test1 where dt = '20221001'; """
+    sql """ delete from tb_test1 where DT = '20221001'; """
     qt_sql10 """select * from tb_test1;"""
 }


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