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