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
commit a371a1060344af44c58a7d4005d43d3fab2f5fbe
Author: morrySnow <101034200+morrys...@users.noreply.github.com>
AuthorDate: Tue Feb 27 22:23:23 2024 +0800
[fix](Nereids) let time type coercion same with legacy planner (#31472)
---
.../main/java/org/apache/doris/catalog/PrimitiveType.java | 4 ++++
regression-test/suites/nereids_syntax_p0/type_cast.groovy | 12 ++++++++++++
2 files changed, 16 insertions(+)
diff --git
a/fe/fe-common/src/main/java/org/apache/doris/catalog/PrimitiveType.java
b/fe/fe-common/src/main/java/org/apache/doris/catalog/PrimitiveType.java
index cc51a28a413..33168654e10 100644
--- a/fe/fe-common/src/main/java/org/apache/doris/catalog/PrimitiveType.java
+++ b/fe/fe-common/src/main/java/org/apache/doris/catalog/PrimitiveType.java
@@ -607,11 +607,15 @@ public enum PrimitiveType {
builder.put(TIME, TIME);
builder.put(TIME, TIMEV2);
builder.put(TIME, DOUBLE);
+ builder.put(TIME, VARCHAR);
+ builder.put(TIME, STRING);
//TIMEV2
builder.put(TIMEV2, TIME);
builder.put(TIMEV2, TIMEV2);
builder.put(TIMEV2, DOUBLE);
+ builder.put(TIMEV2, VARCHAR);
+ builder.put(TIMEV2, STRING);
implicitCastMap = builder.build();
}
diff --git a/regression-test/suites/nereids_syntax_p0/type_cast.groovy
b/regression-test/suites/nereids_syntax_p0/type_cast.groovy
index 26300b6201e..c2ea0369317 100644
--- a/regression-test/suites/nereids_syntax_p0/type_cast.groovy
+++ b/regression-test/suites/nereids_syntax_p0/type_cast.groovy
@@ -52,4 +52,16 @@ suite("type_cast") {
sql("select '12' = id from (select '1' as id)a")
result([[false]])
}
+
+ sql """
+ drop table if exists test_time_cast_to_string;
+ """
+
+ sql """
+ create table test_time_cast_to_string (id int) distributed by random
properties('replication_num'='1');
+ """
+
+ sql """
+ select concat('a', sec_to_time(id)) from test_time_cast_to_string;
+ """
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
