You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by mo...@apache.org on 2024/02/28 13:03:54 UTC
(doris) branch branch-2.0 updated: [fix](Nereids) let time type coercion same with legacy planner (#31472) (#31543)
This is an automated email from the ASF dual-hosted git repository.
morrysnow 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 49e9f3acc78 [fix](Nereids) let time type coercion same with legacy planner (#31472) (#31543)
49e9f3acc78 is described below
commit 49e9f3acc78f4b59924d4c4451680821641d4703
Author: morrySnow <10...@users.noreply.github.com>
AuthorDate: Wed Feb 28 21:03:47 2024 +0800
[fix](Nereids) let time type coercion same with legacy planner (#31472) (#31543)
pick from master #31472
commit id a470cd32d1863b40909d6abff1c702069f857613
---
.../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 5805a88deff..7e231bb29e6 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
@@ -502,11 +502,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-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org