You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by yi...@apache.org on 2022/06/25 14:29:38 UTC
[doris] branch master updated: [docs] Add regression test for weekday function (#10253)
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 69134fb3f2 [docs] Add regression test for weekday function (#10253)
69134fb3f2 is described below
commit 69134fb3f2b85e96c87ad2fe86d4658d6a72ae20
Author: Hong Liu <84...@qq.com>
AuthorDate: Sat Jun 25 22:29:32 2022 +0800
[docs] Add regression test for weekday function (#10253)
---
.../query/sql_functions/datetime_functions/test_date_function.out | 6 ++++++
.../sql_functions/datetime_functions/test_date_function.groovy | 7 ++++---
regression-test/suites/schema_change/test_schema_change.groovy | 4 ++--
3 files changed, 12 insertions(+), 5 deletions(-)
diff --git a/regression-test/data/query/sql_functions/datetime_functions/test_date_function.out b/regression-test/data/query/sql_functions/datetime_functions/test_date_function.out
index 4450f258c3..25b2d58cb3 100644
--- a/regression-test/data/query/sql_functions/datetime_functions/test_date_function.out
+++ b/regression-test/data/query/sql_functions/datetime_functions/test_date_function.out
@@ -266,6 +266,12 @@ February
-- !sql --
27
+-- !sql --
+1
+
+-- !sql --
+1
+
-- !sql --
8
diff --git a/regression-test/suites/query/sql_functions/datetime_functions/test_date_function.groovy b/regression-test/suites/query/sql_functions/datetime_functions/test_date_function.groovy
index e0de899e07..b963ab7870 100644
--- a/regression-test/suites/query/sql_functions/datetime_functions/test_date_function.groovy
+++ b/regression-test/suites/query/sql_functions/datetime_functions/test_date_function.groovy
@@ -21,9 +21,9 @@ suite("test_date_function", "query") {
def tableName = "test_date_function"
sql """ SET enable_vectorized_engine = TRUE; """
-
+ sql """ DROP TABLE IF EXISTS ${tableName} """
sql """
- CREATE TABLE ${tableName} (
+ CREATE TABLE IF NOT EXISTS ${tableName} (
test_datetime datetime NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(test_datetime)
@@ -236,7 +236,8 @@ suite("test_date_function", "query") {
qt_sql """ select week('2020-7-1',1) """
// WEEKDAY
- //TODO add WEEKDAY case
+ qt_sql """ select weekday('2019-06-25'); """
+ qt_sql """ select weekday(cast(20190625 as date)); """
// WEEKOFYEAR
qt_sql """ select weekofyear('2008-02-20 00:00:00') """
diff --git a/regression-test/suites/schema_change/test_schema_change.groovy b/regression-test/suites/schema_change/test_schema_change.groovy
index 76d9db4722..a9be3a270c 100644
--- a/regression-test/suites/schema_change/test_schema_change.groovy
+++ b/regression-test/suites/schema_change/test_schema_change.groovy
@@ -26,7 +26,7 @@ suite("test_schema_change", "schema_change") {
sql """ DROP TABLE IF EXISTS ${tbName} """
sql """
- CREATE TABLE ${tbName}
+ CREATE TABLE IF NOT EXISTS ${tbName}
(
event_day DATE,
siteid INT DEFAULT '10',
@@ -55,7 +55,7 @@ suite("test_schema_change", "schema_change") {
sql """ DROP TABLE ${tbName} """
break
} else {
- sleep(1000)
+ sleep(2000)
if (max_try_time < 1){
assertEquals(1,2)
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org