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

yiguolei 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 71f7e9e185 [test](cast func) add test for cast float text to int when 
nereids is on #19517
71f7e9e185 is described below

commit 71f7e9e18561379ce96c63166849283eeea6a822
Author: abmdocrt <[email protected]>
AuthorDate: Thu May 11 08:24:54 2023 +0800

    [test](cast func) add test for cast float text to int when nereids is on 
#19517
---
 .../data/nereids_p0/sql_functions/cast_function/test_cast_function.out | 3 +++
 .../nereids_p0/sql_functions/cast_function/test_cast_function.groovy   | 1 +
 2 files changed, 4 insertions(+)

diff --git 
a/regression-test/data/nereids_p0/sql_functions/cast_function/test_cast_function.out
 
b/regression-test/data/nereids_p0/sql_functions/cast_function/test_cast_function.out
index 410a0dca01..1f9c69b366 100644
--- 
a/regression-test/data/nereids_p0/sql_functions/cast_function/test_cast_function.out
+++ 
b/regression-test/data/nereids_p0/sql_functions/cast_function/test_cast_function.out
@@ -17,6 +17,9 @@
 -- !sql --
 20
 
+-- !sql --
+1
+
 -- !sql_null_cast_bitmap --
 true
 
diff --git 
a/regression-test/suites/nereids_p0/sql_functions/cast_function/test_cast_function.groovy
 
b/regression-test/suites/nereids_p0/sql_functions/cast_function/test_cast_function.groovy
index b10a7e5bb9..a1ff874377 100644
--- 
a/regression-test/suites/nereids_p0/sql_functions/cast_function/test_cast_function.groovy
+++ 
b/regression-test/suites/nereids_p0/sql_functions/cast_function/test_cast_function.groovy
@@ -24,6 +24,7 @@ suite("test_cast_function") {
     qt_sql """ select cast ("0.0000031417" as datetime) """
     qt_sql """ select cast (NULL AS CHAR(1)); """
     qt_sql """ select cast ('20190101' AS CHAR(2)); """
+    qt_sql """ select cast ('1.23' AS int); """
     qt_sql_null_cast_bitmap """ select cast (case when BITMAP_EMPTY() is NULL 
then null else null end as bitmap) is NULL; """
 }
 


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to