You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by ga...@apache.org on 2023/10/25 04:54:45 UTC
[doris] branch master updated: [testcases](datetime) temporarily remove str_to_date related case (#25877)
This is an automated email from the ASF dual-hosted git repository.
gabriellee 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 7ca3f7100f8 [testcases](datetime) temporarily remove str_to_date related case (#25877)
7ca3f7100f8 is described below
commit 7ca3f7100f8ab1b6f65f2217a0912902598a7353
Author: zclllyybb <zh...@selectdb.com>
AuthorDate: Wed Oct 25 12:54:38 2023 +0800
[testcases](datetime) temporarily remove str_to_date related case (#25877)
---
.../datetime_functions/test_date_function.out | 27 ----------------------
.../datetime_functions/test_date_function.out | 27 ----------------------
.../datetime_functions/test_date_function.groovy | 26 ++++++++++-----------
.../datetime_functions/test_date_function.groovy | 26 ++++++++++-----------
4 files changed, 26 insertions(+), 80 deletions(-)
diff --git a/regression-test/data/nereids_p0/sql_functions/datetime_functions/test_date_function.out b/regression-test/data/nereids_p0/sql_functions/datetime_functions/test_date_function.out
index 34c466cb71b..cf7098d567b 100644
--- a/regression-test/data/nereids_p0/sql_functions/datetime_functions/test_date_function.out
+++ b/regression-test/data/nereids_p0/sql_functions/datetime_functions/test_date_function.out
@@ -228,24 +228,6 @@ February
-- !sql --
67890
--- !sql --
-2014-12-21T12:34:56
-
--- !sql --
-2014-12-21T12:34:56
-
--- !sql --
-2014-12-21T12:34:56.789
-
--- !sql --
-2023-07-05T02:09:55.880
-
--- !sql --
-2004-10-18
-
--- !sql --
-2020-09-01T00:00
-
-- !sql --
2020-01-01T00:00
@@ -446,15 +428,6 @@ true
-- !sql --
2022 31 4
--- !sql --
-\N
-
--- !sql --
-2022-07-12T20:00:45
-
--- !sql --
-2018-04-02T15:03:28
-
-- !sql --
19 19 21 22 23 24 25 26
diff --git a/regression-test/data/query_p0/sql_functions/datetime_functions/test_date_function.out b/regression-test/data/query_p0/sql_functions/datetime_functions/test_date_function.out
index 9858f809ea0..d67cdee1d83 100644
--- a/regression-test/data/query_p0/sql_functions/datetime_functions/test_date_function.out
+++ b/regression-test/data/query_p0/sql_functions/datetime_functions/test_date_function.out
@@ -266,24 +266,6 @@ February
-- !sql --
767890
--- !sql --
-2014-12-21T12:34:56
-
--- !sql --
-2014-12-21T12:34:56
-
--- !sql --
-2014-12-21T12:34:56.789
-
--- !sql --
-2023-07-05T02:09:55.880
-
--- !sql --
-2004-10-18
-
--- !sql --
-2020-09-01T00:00
-
-- !sql_year_floor --
2023-01-01
@@ -490,15 +472,6 @@ true
-- !sql --
2022 31 4
--- !sql --
-\N
-
--- !sql --
-2022-07-12T20:00:45
-
--- !sql --
-2018-04-02T15:03:28
-
-- !sql --
19 19 21 22 23 24 25 26
diff --git a/regression-test/suites/nereids_p0/sql_functions/datetime_functions/test_date_function.groovy b/regression-test/suites/nereids_p0/sql_functions/datetime_functions/test_date_function.groovy
index 13add305b65..4a144d62a8f 100644
--- a/regression-test/suites/nereids_p0/sql_functions/datetime_functions/test_date_function.groovy
+++ b/regression-test/suites/nereids_p0/sql_functions/datetime_functions/test_date_function.groovy
@@ -299,16 +299,16 @@ suite("test_date_function") {
qt_sql """ select microsecond(cast('1999-01-02 10:11:12.067890' as datetimev2(6))); """
// STR_TO_DATE
- sql """ truncate table ${tableName} """
- sql """ insert into ${tableName} values ("2014-12-21 12:34:56") """
- qt_sql """ select str_to_date(test_datetime, '%Y-%m-%d %H:%i:%s') from ${tableName}; """
- qt_sql """ select str_to_date("2014-12-21 12:34%3A56", '%Y-%m-%d %H:%i%%3A%s'); """
- qt_sql """ select str_to_date("2014-12-21 12:34:56.789 PM", '%Y-%m-%d %h:%i:%s.%f %p'); """
- qt_sql """ select str_to_date('2023-07-05T02:09:55.880Z','%Y-%m-%dT%H:%i:%s.%fZ') """
- qt_sql """ select str_to_date('200442 Monday', '%X%V %W') """
- sql """ truncate table ${tableName} """
- sql """ insert into ${tableName} values ("2020-09-01") """
- qt_sql """ select str_to_date(test_datetime, "%Y-%m-%d %H:%i:%s") from ${tableName};"""
+ // sql """ truncate table ${tableName} """
+ // sql """ insert into ${tableName} values ("2014-12-21 12:34:56") """
+ // qt_sql """ select str_to_date(test_datetime, '%Y-%m-%d %H:%i:%s') from ${tableName}; """
+ // qt_sql """ select str_to_date("2014-12-21 12:34%3A56", '%Y-%m-%d %H:%i%%3A%s'); """
+ // qt_sql """ select str_to_date("2014-12-21 12:34:56.789 PM", '%Y-%m-%d %h:%i:%s.%f %p'); """
+ // qt_sql """ select str_to_date('2023-07-05T02:09:55.880Z','%Y-%m-%dT%H:%i:%s.%fZ') """
+ // qt_sql """ select str_to_date('200442 Monday', '%X%V %W') """
+ // sql """ truncate table ${tableName} """
+ // sql """ insert into ${tableName} values ("2020-09-01") """
+ // qt_sql """ select str_to_date(test_datetime, "%Y-%m-%d %H:%i:%s") from ${tableName};"""
// TIME_ROUND
qt_sql """ SELECT YEAR_FLOOR('20200202000000') """
@@ -441,9 +441,9 @@ suite("test_date_function") {
sql """ drop table ${tableName} """
qt_sql """ select date_format('2022-08-04', '%X %V %w'); """
- qt_sql """ select STR_TO_DATE('Tue Jul 12 20:00:45 CST 2022', '%a %b %e %H:%i:%s %Y'); """
- qt_sql """ select STR_TO_DATE('Tue Jul 12 20:00:45 CST 2022', '%a %b %e %T CST %Y'); """
- qt_sql """ select STR_TO_DATE('2018-4-2 15:3:28','%Y-%m-%d %H:%i:%s'); """
+ // qt_sql """ select STR_TO_DATE('Tue Jul 12 20:00:45 CST 2022', '%a %b %e %H:%i:%s %Y'); """
+ // qt_sql """ select STR_TO_DATE('Tue Jul 12 20:00:45 CST 2022', '%a %b %e %T CST %Y'); """
+ // qt_sql """ select STR_TO_DATE('2018-4-2 15:3:28','%Y-%m-%d %H:%i:%s'); """
qt_sql """ select length(cast(now() as string)), length(cast(now(0) as string)), length(cast(now(1) as string)),
length(cast(now(2) as string)), length(cast(now(3) as string)), length(cast(now(4) as string)),
diff --git a/regression-test/suites/query_p0/sql_functions/datetime_functions/test_date_function.groovy b/regression-test/suites/query_p0/sql_functions/datetime_functions/test_date_function.groovy
index 2dc1834c717..7ff1afe6445 100644
--- a/regression-test/suites/query_p0/sql_functions/datetime_functions/test_date_function.groovy
+++ b/regression-test/suites/query_p0/sql_functions/datetime_functions/test_date_function.groovy
@@ -328,16 +328,16 @@ suite("test_date_function") {
qt_sql """ select microsecond(cast('1999-01-02 10:11:12.767890' as datetimev2(6))) """
// STR_TO_DATE
- sql """ truncate table ${tableName} """
- sql """ insert into ${tableName} values ("2014-12-21 12:34:56") """
- qt_sql """ select str_to_date(test_datetime, '%Y-%m-%d %H:%i:%s') from ${tableName}; """
- qt_sql """ select str_to_date("2014-12-21 12:34%3A56", '%Y-%m-%d %H:%i%%3A%s'); """
- qt_sql """ select str_to_date("2014-12-21 12:34:56.789 PM", '%Y-%m-%d %h:%i:%s.%f %p'); """
- qt_sql """ select str_to_date('2023-07-05T02:09:55.880Z','%Y-%m-%dT%H:%i:%s.%fZ') """
- qt_sql """ select str_to_date('200442 Monday', '%X%V %W') """
- sql """ truncate table ${tableName} """
- sql """ insert into ${tableName} values ("2020-09-01") """
- qt_sql """ select str_to_date(test_datetime, "%Y-%m-%d %H:%i:%s") from ${tableName};"""
+ // sql """ truncate table ${tableName} """
+ // sql """ insert into ${tableName} values ("2014-12-21 12:34:56") """
+ // qt_sql """ select str_to_date(test_datetime, '%Y-%m-%d %H:%i:%s') from ${tableName}; """
+ // qt_sql """ select str_to_date("2014-12-21 12:34%3A56", '%Y-%m-%d %H:%i%%3A%s'); """
+ // qt_sql """ select str_to_date("2014-12-21 12:34:56.789 PM", '%Y-%m-%d %h:%i:%s.%f %p'); """
+ // qt_sql """ select str_to_date('2023-07-05T02:09:55.880Z','%Y-%m-%dT%H:%i:%s.%fZ') """
+ // qt_sql """ select str_to_date('200442 Monday', '%X%V %W') """
+ // sql """ truncate table ${tableName} """
+ // sql """ insert into ${tableName} values ("2020-09-01") """
+ // qt_sql """ select str_to_date(test_datetime, "%Y-%m-%d %H:%i:%s") from ${tableName};"""
// TIME_ROUND
qt_sql_year_floor """ select year_floor(cast('2023-04-28' as date)); """
@@ -471,9 +471,9 @@ suite("test_date_function") {
sql """ drop table ${tableName} """
qt_sql """ select date_format('2022-08-04', '%X %V %w'); """
- qt_sql """ select STR_TO_DATE('Tue Jul 12 20:00:45 CST 2022', '%a %b %e %H:%i:%s %Y'); """
- qt_sql """ select STR_TO_DATE('Tue Jul 12 20:00:45 CST 2022', '%a %b %e %T CST %Y'); """
- qt_sql """ select STR_TO_DATE('2018-4-2 15:3:28','%Y-%m-%d %H:%i:%s'); """
+ // qt_sql """ select STR_TO_DATE('Tue Jul 12 20:00:45 CST 2022', '%a %b %e %H:%i:%s %Y'); """
+ // qt_sql """ select STR_TO_DATE('Tue Jul 12 20:00:45 CST 2022', '%a %b %e %T CST %Y'); """
+ // qt_sql """ select STR_TO_DATE('2018-4-2 15:3:28','%Y-%m-%d %H:%i:%s'); """
qt_sql """ select length(cast(now() as string)), length(cast(now(0) as string)), length(cast(now(1) as string)),
length(cast(now(2) as string)), length(cast(now(3) as string)), length(cast(now(4) as string)),
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org