This is an automated email from the ASF dual-hosted git repository.
lihaopeng 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 c993964a88 [Bug](delete) fix the delete ignore char case (#18714)
c993964a88 is described below
commit c993964a8821663b3c4c8189cee349c49a2c97d4
Author: HappenLee <[email protected]>
AuthorDate: Wed Apr 26 07:30:44 2023 +0800
[Bug](delete) fix the delete ignore char case (#18714)
---
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 262649738b..b67ddca85b 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: [email protected]
For additional commands, e-mail: [email protected]
