This is an automated email from the ASF dual-hosted git repository.
jakevin 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 b11d056fe5 [fix](Nereids): fix function name. (#16188)
b11d056fe5 is described below
commit b11d056fe5208f4188fbf8022ab313bfb29e0a89
Author: jakevin <[email protected]>
AuthorDate: Sun Jan 29 15:21:24 2023 +0800
[fix](Nereids): fix function name. (#16188)
---
.../nereids_function_p0/scalar_function/A-F.out | 312 ++++++++++++++++++++-
.../nereids_function_p0/scalar_function/A-F.groovy | 43 ++-
2 files changed, 326 insertions(+), 29 deletions(-)
diff --git a/regression-test/data/nereids_function_p0/scalar_function/A-F.out
b/regression-test/data/nereids_function_p0/scalar_function/A-F.out
index 07c9ac1fbb..db57a5129b 100644
--- a/regression-test/data/nereids_function_p0/scalar_function/A-F.out
+++ b/regression-test/data/nereids_function_p0/scalar_function/A-F.out
@@ -346,15 +346,15 @@
-- !sql --
\N
-0.46415888336127786
-0.5848035476425731
-0.6694329500821694
-0.7368062997280772
+0.4641588833612779
+0.5848035476425733
+0.6694329500821695
+0.7368062997280773
0.7937005259840998
0.8434326653017492
0.8879040017426008
-0.9283177667225557
-0.9654893846056297
+0.9283177667225558
+0.9654893846056298
1.0
1.0322801154563672
1.0626585691826111
@@ -809,6 +809,111 @@ varchar13
2012-03-11
2012-03-12
+-- !sql --
+\N
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+
+-- !sql --
+\N
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+
+-- !sql --
+\N
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+
+-- !sql --
+\N
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+
+-- !sql --
+\N
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+
+-- !sql --
+\N
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+
+-- !sql --
+\N
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+0
+
-- !sql --
\N
2006-01-02 12:00:00
@@ -899,6 +1004,21 @@ varchar13
\N
\N
+-- !sql --
+\N
+2012-03-01
+2012-03-02
+2012-03-03
+2012-03-04
+2012-03-05
+2012-03-06
+2012-03-07
+2012-03-08
+2012-03-09
+2012-03-10
+2012-03-11
+2012-03-12
+
-- !sql --
\N
1
@@ -1274,6 +1394,186 @@ varchar13
2012-03-11
2012-03-12
+-- !sql --
+\N
+Thursday
+Friday
+Saturday
+Sunday
+Monday
+Tuesday
+Wednesday
+Thursday
+Friday
+Saturday
+Sunday
+Monday
+
+-- !sql --
+\N
+Thursday
+Friday
+Saturday
+Sunday
+Monday
+Tuesday
+Wednesday
+Thursday
+Friday
+Saturday
+Sunday
+Monday
+
+-- !sql --
+\N
+Thursday
+Friday
+Saturday
+Sunday
+Monday
+Tuesday
+Wednesday
+Thursday
+Friday
+Saturday
+Sunday
+Monday
+
+-- !sql --
+\N
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+11
+12
+
+-- !sql --
+\N
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+11
+12
+
+-- !sql --
+\N
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+11
+12
+
+-- !sql --
+\N
+5
+6
+7
+1
+2
+3
+4
+5
+6
+7
+1
+2
+
+-- !sql --
+\N
+5
+6
+7
+1
+2
+3
+4
+5
+6
+7
+1
+2
+
+-- !sql --
+\N
+5
+6
+7
+1
+2
+3
+4
+5
+6
+7
+1
+2
+
+-- !sql --
+\N
+61
+62
+63
+64
+65
+66
+67
+68
+69
+70
+71
+72
+
+-- !sql --
+\N
+61
+62
+63
+64
+65
+66
+67
+68
+69
+70
+71
+72
+
+-- !sql --
+\N
+61
+62
+63
+64
+65
+66
+67
+68
+69
+70
+71
+72
+
-- !sql --
\N
2012-03-02T01:00:01
diff --git
a/regression-test/suites/nereids_function_p0/scalar_function/A-F.groovy
b/regression-test/suites/nereids_function_p0/scalar_function/A-F.groovy
index fed0492cb7..174437f9fa 100644
--- a/regression-test/suites/nereids_function_p0/scalar_function/A-F.groovy
+++ b/regression-test/suites/nereids_function_p0/scalar_function/A-F.groovy
@@ -120,22 +120,20 @@ suite("nereids_scalar_fn_1") {
sql "select database() from fn_test"
qt_sql "select date(kdtm) from fn_test order by kdtm"
qt_sql "select date(kdtmv2s1) from fn_test order by kdtmv2s1"
- // cannot find function
- // qt_sql "select date_diff(kdtm, kdtm) from fn_test order by kdtm, kdtm"
- // qt_sql "select date_diff(kdtmv2s1, kdtmv2s1) from fn_test order by
kdtmv2s1, kdtmv2s1"
- // qt_sql "select date_diff(kdtmv2s1, kdtv2) from fn_test order by
kdtmv2s1, kdtv2"
- // qt_sql "select date_diff(kdtv2, kdtmv2s1) from fn_test order by kdtv2,
kdtmv2s1"
- // qt_sql "select date_diff(kdtv2, kdtv2) from fn_test order by kdtv2,
kdtv2"
- // qt_sql "select date_diff(kdtmv2s1, kdtm) from fn_test order by
kdtmv2s1, kdtm"
- // qt_sql "select date_diff(kdtv2, kdtm) from fn_test order by kdtv2, kdtm"
+ qt_sql "select datediff(kdtm, kdtm) from fn_test order by kdtm, kdtm"
+ qt_sql "select datediff(kdtmv2s1, kdtmv2s1) from fn_test order by
kdtmv2s1, kdtmv2s1"
+ qt_sql "select datediff(kdtmv2s1, kdtv2) from fn_test order by kdtmv2s1,
kdtv2"
+ qt_sql "select datediff(kdtv2, kdtmv2s1) from fn_test order by kdtv2,
kdtmv2s1"
+ qt_sql "select datediff(kdtv2, kdtv2) from fn_test order by kdtv2, kdtv2"
+ qt_sql "select datediff(kdtmv2s1, kdtm) from fn_test order by kdtmv2s1,
kdtm"
+ qt_sql "select datediff(kdtv2, kdtm) from fn_test order by kdtv2, kdtm"
qt_sql "select date_format(kdtm, '2006-01-02 12:00:00') from fn_test order
by kdtm"
qt_sql "select date_format(kdt, '2006-01-02') from fn_test order by kdt"
qt_sql "select date_format(kdtmv2s1, '2006-01-02 12:00:00') from fn_test
order by kdtmv2s1"
qt_sql "select date_format(kdtv2, '2006-01-02') from fn_test order by
kdtv2"
qt_sql "select date_trunc(kdtm, kvchrs1) from fn_test order by kdtm,
kvchrs1"
qt_sql "select date_trunc(kdtmv2s1, kvchrs1) from fn_test order by
kdtmv2s1, kvchrs1"
- // cannot find function
- // qt_sql "select date_v2(kdtmv2s1) from fn_test order by kdtmv2s1"
+ qt_sql "select datev2(kdtmv2s1) from fn_test order by kdtmv2s1"
qt_sql "select day(kdtm) from fn_test order by kdtm"
qt_sql "select day(kdtmv2s1) from fn_test order by kdtmv2s1"
qt_sql "select day(kdtv2) from fn_test order by kdtv2"
@@ -165,19 +163,18 @@ suite("nereids_scalar_fn_1") {
// qt_sql "select day_floor(kdtm, kint, kdtm) from fn_test order by kdtm,
kint, kdtm"
qt_sql "select day_floor(kdtmv2s1, kint, kdtmv2s1) from fn_test order by
kdtmv2s1, kint, kdtmv2s1"
qt_sql "select day_floor(kdtv2, kint, kdtv2) from fn_test order by kdtv2,
kint, kdtv2"
- // cannot find function
- // qt_sql "select day_name(kdtm) from fn_test order by kdtm"
- // qt_sql "select day_name(kdtmv2s1) from fn_test order by kdtmv2s1"
- // qt_sql "select day_name(kdtv2) from fn_test order by kdtv2"
- // qt_sql "select day_of_month(kdtm) from fn_test order by kdtm"
- // qt_sql "select day_of_month(kdtmv2s1) from fn_test order by kdtmv2s1"
- // qt_sql "select day_of_month(kdtv2) from fn_test order by kdtv2"
- // qt_sql "select day_of_week(kdtm) from fn_test order by kdtm"
- // qt_sql "select day_of_week(kdtmv2s1) from fn_test order by kdtmv2s1"
- // qt_sql "select day_of_week(kdtv2) from fn_test order by kdtv2"
- // qt_sql "select day_of_year(kdtm) from fn_test order by kdtm"
- // qt_sql "select day_of_year(kdtmv2s1) from fn_test order by kdtmv2s1"
- // qt_sql "select day_of_year(kdtv2) from fn_test order by kdtv2"
+ qt_sql "select dayname(kdtm) from fn_test order by kdtm"
+ qt_sql "select dayname(kdtmv2s1) from fn_test order by kdtmv2s1"
+ qt_sql "select dayname(kdtv2) from fn_test order by kdtv2"
+ qt_sql "select dayofmonth(kdtm) from fn_test order by kdtm"
+ qt_sql "select dayofmonth(kdtmv2s1) from fn_test order by kdtmv2s1"
+ qt_sql "select dayofmonth(kdtv2) from fn_test order by kdtv2"
+ qt_sql "select dayofweek(kdtm) from fn_test order by kdtm"
+ qt_sql "select dayofweek(kdtmv2s1) from fn_test order by kdtmv2s1"
+ qt_sql "select dayofweek(kdtv2) from fn_test order by kdtv2"
+ qt_sql "select dayofyear(kdtm) from fn_test order by kdtm"
+ qt_sql "select dayofyear(kdtmv2s1) from fn_test order by kdtmv2s1"
+ qt_sql "select dayofyear(kdtv2) from fn_test order by kdtv2"
qt_sql "select days_add(kdtm, kint) from fn_test order by kdtm, kint"
qt_sql "select days_add(kdtmv2s1, kint) from fn_test order by kdtmv2s1,
kint"
qt_sql "select days_add(kdt, kint) from fn_test order by kdt, kint"
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
