This is an automated email from the ASF dual-hosted git repository.
morrysnow 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 a5d9aca7ba [test](Nereids) enable G-K and L-Q scalar function
regression test cases (#16169)
a5d9aca7ba is described below
commit a5d9aca7ba0f8563505f8b0a26bcf40cbea3b0e4
Author: AKIRA <33112463+kikyou1...@users.noreply.github.com>
AuthorDate: Fri Feb 3 21:18:43 2023 +0800
[test](Nereids) enable G-K and L-Q scalar function regression test cases
(#16169)
1. delete invalid signature of nvl function
2. fix some test cases that failed because of malformed function name
---
.../nereids_function_p0/scalar_function/G-K.out | 240 +++++++
.../nereids_function_p0/scalar_function/L-Q.out | 690 +++++++++++++++++++++
.../nereids_function_p0/scalar_function/G-K.groovy | 33 +-
.../nereids_function_p0/scalar_function/L-Q.groovy | 93 ++-
4 files changed, 992 insertions(+), 64 deletions(-)
diff --git a/regression-test/data/nereids_function_p0/scalar_function/G-K.out
b/regression-test/data/nereids_function_p0/scalar_function/G-K.out
index ff87dc13e7..f0cb9efd8d 100644
--- a/regression-test/data/nereids_function_p0/scalar_function/G-K.out
+++ b/regression-test/data/nereids_function_p0/scalar_function/G-K.out
@@ -434,6 +434,21 @@ C
2012-03-11T12:00
2012-03-12T13:00
+-- !sql --
+\N
+2012-03-01T00:00
+2012-03-02T00:00
+2012-03-03T00:00
+2012-03-04T00:00
+2012-03-05T00:00
+2012-03-06T00:00
+2012-03-07T00:00
+2012-03-08T00:00
+2012-03-09T00:00
+2012-03-10T00:00
+2012-03-11T00:00
+2012-03-12T00:00
+
-- !sql --
\N
2012-03-01T01:00:01
@@ -494,6 +509,36 @@ C
2012-03-11T13:00
2012-03-13T00:00
+-- !sql --
+\N
+2012-03-01T00:00
+2012-03-02T00:00
+2012-03-03T00:00
+2012-03-04T00:00
+2012-03-05T00:00
+2012-03-06T00:00
+2012-03-07T00:00
+2012-03-08T00:00
+2012-03-09T00:00
+2012-03-10T00:00
+2012-03-11T00:00
+2012-03-12T00:00
+
+-- !sql --
+\N
+2012-03-01T00:00
+2012-03-02T00:00
+2012-03-03T00:00
+2012-03-04T00:00
+2012-03-05T04:00
+2012-03-06T00:00
+2012-03-07T03:00
+2012-03-08T00:00
+2012-03-09T00:00
+2012-03-10T04:00
+2012-03-11T02:00
+2012-03-12T00:00
+
-- !sql --
\N
2012-03-01T01:00:01
@@ -524,6 +569,21 @@ C
2012-03-11T11:10:11
2012-03-12T12:11:12
+-- !sql --
+\N
+2012-03-01T00:00
+2012-03-02T00:00
+2012-03-03T00:00
+2012-03-04T00:00
+2012-03-05T00:00
+2012-03-06T00:00
+2012-03-07T00:00
+2012-03-08T00:00
+2012-03-09T00:00
+2012-03-10T00:00
+2012-03-11T00:00
+2012-03-12T00:00
+
-- !sql --
\N
2012-03-01T01:00
@@ -554,6 +614,21 @@ C
2012-03-11T11:00
2012-03-12T12:00
+-- !sql --
+\N
+2012-03-01T00:00
+2012-03-02T00:00
+2012-03-03T00:00
+2012-03-04T00:00
+2012-03-05T00:00
+2012-03-06T00:00
+2012-03-07T00:00
+2012-03-08T00:00
+2012-03-09T00:00
+2012-03-10T00:00
+2012-03-11T00:00
+2012-03-12T00:00
+
-- !sql --
\N
2012-03-01T01:00:01
@@ -614,6 +689,36 @@ C
2012-03-11T02:00
2012-03-12T12:00
+-- !sql --
+\N
+2012-03-01T00:00
+2012-03-02T00:00
+2012-03-03T00:00
+2012-03-04T00:00
+2012-03-05T00:00
+2012-03-06T00:00
+2012-03-07T00:00
+2012-03-08T00:00
+2012-03-09T00:00
+2012-03-10T00:00
+2012-03-11T00:00
+2012-03-12T00:00
+
+-- !sql --
+\N
+2012-03-01T00:00
+2012-03-02T00:00
+2012-03-03T00:00
+2012-03-04T00:00
+2012-03-04T23:00
+2012-03-06T00:00
+2012-03-06T20:00
+2012-03-08T00:00
+2012-03-09T00:00
+2012-03-09T18:00
+2012-03-10T15:00
+2012-03-12T00:00
+
-- !sql --
\N
2012-03-01T01:00:01
@@ -644,6 +749,81 @@ C
2012-03-11T11:10:11
2012-03-12T12:11:12
+-- !sql --
+\N
+2012-03-01T00:00
+2012-03-02T00:00
+2012-03-03T00:00
+2012-03-04T00:00
+2012-03-05T00:00
+2012-03-06T00:00
+2012-03-07T00:00
+2012-03-08T00:00
+2012-03-09T00:00
+2012-03-10T00:00
+2012-03-11T00:00
+2012-03-12T00:00
+
+-- !sql --
+\N
+2012-03-01T02:00:01
+2012-03-02T04:01:02
+2012-03-03T06:02:03
+2012-03-04T08:03:04
+2012-03-05T10:04:05
+2012-03-06T12:05:06
+2012-03-07T14:06:07
+2012-03-08T16:07:08
+2012-03-09T18:08:09
+2012-03-10T20:09:10
+2012-03-11T22:10:11
+2012-03-13T00:11:12
+
+-- !sql --
+\N
+2012-03-01T02:00:01
+2012-03-02T04:01:02
+2012-03-03T06:02:03
+2012-03-04T08:03:04
+2012-03-05T10:04:05
+2012-03-06T12:05:06
+2012-03-07T14:06:07
+2012-03-08T16:07:08
+2012-03-09T18:08:09
+2012-03-10T20:09:10
+2012-03-11T22:10:11
+2012-03-13T00:11:12
+
+-- !sql --
+\N
+2012-03-01T01:00
+2012-03-02T02:00
+2012-03-03T03:00
+2012-03-04T04:00
+2012-03-05T05:00
+2012-03-06T06:00
+2012-03-07T07:00
+2012-03-08T08:00
+2012-03-09T09:00
+2012-03-10T10:00
+2012-03-11T11:00
+2012-03-12T12:00
+
+-- !sql --
+\N
+2012-03-01T01:00
+2012-03-02T02:00
+2012-03-03T03:00
+2012-03-04T04:00
+2012-03-05T05:00
+2012-03-06T06:00
+2012-03-07T07:00
+2012-03-08T08:00
+2012-03-09T09:00
+2012-03-10T10:00
+2012-03-11T11:00
+2012-03-12T12:00
+
-- !sql --
\N
0
@@ -779,6 +959,66 @@ C
0
0
+-- !sql --
+\N
+2012-03-01T00:00:01
+2012-03-02T00:01:02
+2012-03-03T00:02:03
+2012-03-04T00:03:04
+2012-03-05T00:04:05
+2012-03-06T00:05:06
+2012-03-07T00:06:07
+2012-03-08T00:07:08
+2012-03-09T00:08:09
+2012-03-10T00:09:10
+2012-03-11T00:10:11
+2012-03-12T00:11:12
+
+-- !sql --
+\N
+2012-03-01T00:00:01
+2012-03-02T00:01:02
+2012-03-03T00:02:03
+2012-03-04T00:03:04
+2012-03-05T00:04:05
+2012-03-06T00:05:06
+2012-03-07T00:06:07
+2012-03-08T00:07:08
+2012-03-09T00:08:09
+2012-03-10T00:09:10
+2012-03-11T00:10:11
+2012-03-12T00:11:12
+
+-- !sql --
+\N
+2012-02-29T23:00
+2012-03-01T22:00
+2012-03-02T21:00
+2012-03-03T20:00
+2012-03-04T19:00
+2012-03-05T18:00
+2012-03-06T17:00
+2012-03-07T16:00
+2012-03-08T15:00
+2012-03-09T14:00
+2012-03-10T13:00
+2012-03-11T12:00
+
+-- !sql --
+\N
+2012-02-29T23:00
+2012-03-01T22:00
+2012-03-02T21:00
+2012-03-03T20:00
+2012-03-04T19:00
+2012-03-05T18:00
+2012-03-06T17:00
+2012-03-07T16:00
+2012-03-08T15:00
+2012-03-09T14:00
+2012-03-10T13:00
+2012-03-11T12:00
+
-- !sql --
Null
Varchar11
diff --git a/regression-test/data/nereids_function_p0/scalar_function/L-Q.out
b/regression-test/data/nereids_function_p0/scalar_function/L-Q.out
index 9626ce8e16..3c28424602 100644
--- a/regression-test/data/nereids_function_p0/scalar_function/L-Q.out
+++ b/regression-test/data/nereids_function_p0/scalar_function/L-Q.out
@@ -464,6 +464,21 @@ string3
string3
string3
+-- !sql --
+\N
+0001-01-01
+0002-01-02
+0003-01-03
+0004-01-04
+0005-01-05
+0006-01-06
+0007-01-07
+0008-01-08
+0009-01-09
+0010-01-10
+0011-01-11
+0012-01-12
+
-- !sql --
xxxx
xxxxxxxnn
@@ -647,6 +662,36 @@ dc5f80c371451aa4fc81c930adc64f60
9e6dc8685bf3c1b338f2011ace904887
9e6dc8685bf3c1b338f2011ace904887
+-- !sql --
+37a6259cc0c1dae299a7866489dff0bd
+8507af7854a1ef7feca8e5cdbce5e613
+8507af7854a1ef7feca8e5cdbce5e613
+8507af7854a1ef7feca8e5cdbce5e613
+8507af7854a1ef7feca8e5cdbce5e613
+dc5f80c371451aa4fc81c930adc64f60
+dc5f80c371451aa4fc81c930adc64f60
+dc5f80c371451aa4fc81c930adc64f60
+dc5f80c371451aa4fc81c930adc64f60
+73c837059107caff646284f85ac126c3
+73c837059107caff646284f85ac126c3
+73c837059107caff646284f85ac126c3
+73c837059107caff646284f85ac126c3
+
+-- !sql --
+37a6259cc0c1dae299a7866489dff0bd
+34b577be20fbc15477aadb9a08101ff9
+34b577be20fbc15477aadb9a08101ff9
+34b577be20fbc15477aadb9a08101ff9
+34b577be20fbc15477aadb9a08101ff9
+91c0c59c8f6fc9aa2dc99a89f2fd0ab5
+91c0c59c8f6fc9aa2dc99a89f2fd0ab5
+91c0c59c8f6fc9aa2dc99a89f2fd0ab5
+91c0c59c8f6fc9aa2dc99a89f2fd0ab5
+9e6dc8685bf3c1b338f2011ace904887
+9e6dc8685bf3c1b338f2011ace904887
+9e6dc8685bf3c1b338f2011ace904887
+9e6dc8685bf3c1b338f2011ace904887
+
-- !sql --
\N
0
@@ -1022,6 +1067,66 @@ dc5f80c371451aa4fc81c930adc64f60
2012-03-11T00:00
2012-03-12T00:00
+-- !sql --
+\N
+2012-03-01T01:01:01
+2012-03-02T02:03:02
+2012-03-03T03:05:03
+2012-03-04T04:07:04
+2012-03-05T05:09:05
+2012-03-06T06:11:06
+2012-03-07T07:13:07
+2012-03-08T08:15:08
+2012-03-09T09:17:09
+2012-03-10T10:19:10
+2012-03-11T11:21:11
+2012-03-12T12:23:12
+
+-- !sql --
+\N
+2012-03-01T01:01:01
+2012-03-02T02:03:02
+2012-03-03T03:05:03
+2012-03-04T04:07:04
+2012-03-05T05:09:05
+2012-03-06T06:11:06
+2012-03-07T07:13:07
+2012-03-08T08:15:08
+2012-03-09T09:17:09
+2012-03-10T10:19:10
+2012-03-11T11:21:11
+2012-03-12T12:23:12
+
+-- !sql --
+\N
+2012-03-01T00:01
+2012-03-02T00:02
+2012-03-03T00:03
+2012-03-04T00:04
+2012-03-05T00:05
+2012-03-06T00:06
+2012-03-07T00:07
+2012-03-08T00:08
+2012-03-09T00:09
+2012-03-10T00:10
+2012-03-11T00:11
+2012-03-12T00:12
+
+-- !sql --
+\N
+2012-03-01T00:01
+2012-03-02T00:02
+2012-03-03T00:03
+2012-03-04T00:04
+2012-03-05T00:05
+2012-03-06T00:06
+2012-03-07T00:07
+2012-03-08T00:08
+2012-03-09T00:09
+2012-03-10T00:10
+2012-03-11T00:11
+2012-03-12T00:12
+
-- !sql --
\N
0
@@ -1157,6 +1262,66 @@ dc5f80c371451aa4fc81c930adc64f60
0
0
+-- !sql --
+\N
+2012-03-01T00:59:01
+2012-03-02T01:59:02
+2012-03-03T02:59:03
+2012-03-04T03:59:04
+2012-03-05T04:59:05
+2012-03-06T05:59:06
+2012-03-07T06:59:07
+2012-03-08T07:59:08
+2012-03-09T08:59:09
+2012-03-10T09:59:10
+2012-03-11T10:59:11
+2012-03-12T11:59:12
+
+-- !sql --
+\N
+2012-03-01T00:59:01
+2012-03-02T01:59:02
+2012-03-03T02:59:03
+2012-03-04T03:59:04
+2012-03-05T04:59:05
+2012-03-06T05:59:06
+2012-03-07T06:59:07
+2012-03-08T07:59:08
+2012-03-09T08:59:09
+2012-03-10T09:59:10
+2012-03-11T10:59:11
+2012-03-12T11:59:12
+
+-- !sql --
+\N
+2012-02-29T23:59
+2012-03-01T23:58
+2012-03-02T23:57
+2012-03-03T23:56
+2012-03-04T23:55
+2012-03-05T23:54
+2012-03-06T23:53
+2012-03-07T23:52
+2012-03-08T23:51
+2012-03-09T23:50
+2012-03-10T23:49
+2012-03-11T23:48
+
+-- !sql --
+\N
+2012-02-29T23:59
+2012-03-01T23:58
+2012-03-02T23:57
+2012-03-03T23:56
+2012-03-04T23:55
+2012-03-05T23:54
+2012-03-06T23:53
+2012-03-07T23:52
+2012-03-08T23:51
+2012-03-09T23:50
+2012-03-10T23:49
+2012-03-11T23:48
+
-- !sql --
\N
1.00
@@ -1622,6 +1787,111 @@ dc5f80c371451aa4fc81c930adc64f60
2012-03-11
2012-03-12
+-- !sql --
+\N
+March
+March
+March
+March
+March
+March
+March
+March
+March
+March
+March
+March
+
+-- !sql --
+\N
+March
+March
+March
+March
+March
+March
+March
+March
+March
+March
+March
+March
+
+-- !sql --
+\N
+March
+March
+March
+March
+March
+March
+March
+March
+March
+March
+March
+March
+
+-- !sql --
+\N
+2012-04-01T01:00:01
+2012-05-02T02:01:02
+2012-06-03T03:02:03
+2012-07-04T04:03:04
+2012-08-05T05:04:05
+2012-09-06T06:05:06
+2012-10-07T07:06:07
+2012-11-08T08:07:08
+2012-12-09T09:08:09
+2013-01-10T10:09:10
+2013-02-11T11:10:11
+2013-03-12T12:11:12
+
+-- !sql --
+\N
+2012-04-01T01:00:01
+2012-05-02T02:01:02
+2012-06-03T03:02:03
+2012-07-04T04:03:04
+2012-08-05T05:04:05
+2012-09-06T06:05:06
+2012-10-07T07:06:07
+2012-11-08T08:07:08
+2012-12-09T09:08:09
+2013-01-10T10:09:10
+2013-02-11T11:10:11
+2013-03-12T12:11:12
+
+-- !sql --
+\N
+2012-04-01
+2012-05-02
+2012-06-03
+2012-07-04
+2012-08-05
+2012-09-06
+2012-10-07
+2012-11-08
+2012-12-09
+2013-01-10
+2013-02-11
+2013-03-12
+
+-- !sql --
+\N
+2012-04-01
+2012-05-02
+2012-06-03
+2012-07-04
+2012-08-05
+2012-09-06
+2012-10-07
+2012-11-08
+2012-12-09
+2013-01-10
+2013-02-11
+2013-03-12
+
-- !sql --
\N
0
@@ -1727,6 +1997,126 @@ dc5f80c371451aa4fc81c930adc64f60
0
0
+-- !sql --
+\N
+2012-02-01T01:00:01
+2012-01-02T02:01:02
+2011-12-03T03:02:03
+2011-11-04T04:03:04
+2011-10-05T05:04:05
+2011-09-06T06:05:06
+2011-08-07T07:06:07
+2011-07-08T08:07:08
+2011-06-09T09:08:09
+2011-05-10T10:09:10
+2011-04-11T11:10:11
+2011-03-12T12:11:12
+
+-- !sql --
+\N
+2012-02-01T01:00:01
+2012-01-02T02:01:02
+2011-12-03T03:02:03
+2011-11-04T04:03:04
+2011-10-05T05:04:05
+2011-09-06T06:05:06
+2011-08-07T07:06:07
+2011-07-08T08:07:08
+2011-06-09T09:08:09
+2011-05-10T10:09:10
+2011-04-11T11:10:11
+2011-03-12T12:11:12
+
+-- !sql --
+\N
+2012-02-01
+2012-01-02
+2011-12-03
+2011-11-04
+2011-10-05
+2011-09-06
+2011-08-07
+2011-07-08
+2011-06-09
+2011-05-10
+2011-04-11
+2011-03-12
+
+-- !sql --
+\N
+2012-02-01
+2012-01-02
+2011-12-03
+2011-11-04
+2011-10-05
+2011-09-06
+2011-08-07
+2011-07-08
+2011-06-09
+2011-05-10
+2011-04-11
+2011-03-12
+
+-- !sql --
+-460753941
+1382328699
+1382328699
+1382328699
+1382328699
+-216074155
+-216074155
+-216074155
+-216074155
+-1704245912
+-1704245912
+-1704245912
+-1704245912
+
+-- !sql --
+-460753941
+1105201137
+1105201137
+1105201137
+1105201137
+466065876
+466065876
+466065876
+466065876
+-1328370272
+-1328370272
+-1328370272
+-1328370272
+
+-- !sql --
+-202406785360068664
+8683832286507167489
+8683832286507167489
+8683832286507167489
+8683832286507167489
+8582507899476528269
+8582507899476528269
+8582507899476528269
+8582507899476528269
+3951582574031518507
+3951582574031518507
+3951582574031518507
+3951582574031518507
+
+-- !sql --
+-202406785360068664
+-7629742527255288609
+-7629742527255288609
+-7629742527255288609
+-7629742527255288609
+6540042322033322577
+6540042322033322577
+6540042322033322577
+6540042322033322577
+-2588750725983543588
+-2588750725983543588
+-2588750725983543588
+-2588750725983543588
+
-- !sql --
\N
-1
@@ -1802,6 +2192,231 @@ true
true
true
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+
+-- !sql --
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+
-- !sql --
false
false
@@ -1982,6 +2597,36 @@ true
2012-03-11T11:10:11
2012-03-12T12:11:12
+-- !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
+2012-03-01T01:00:01
+2012-03-02T02:01:02
+2012-03-03T03:02:03
+2012-03-04T04:03:04
+2012-03-05T05:04:05
+2012-03-06T06:05:06
+2012-03-07T07:06:07
+2012-03-08T08:07:08
+2012-03-09T09:08:09
+2012-03-10T10:09:10
+2012-03-11T11:10:11
+2012-03-12T12:11:12
+
-- !sql --
\N
2012-03-01T01:00:01
@@ -1997,6 +2642,21 @@ true
2012-03-11T11:10:11
2012-03-12T12:11:12
+-- !sql --
+\N
+2012-03-01T00:00
+2012-03-02T00:00
+2012-03-03T00:00
+2012-03-04T00:00
+2012-03-05T00:00
+2012-03-06T00:00
+2012-03-07T00:00
+2012-03-08T00:00
+2012-03-09T00:00
+2012-03-10T00:00
+2012-03-11T00:00
+2012-03-12T00:00
+
-- !sql --
\N
2012-03-01T01:00:01
@@ -2133,6 +2793,36 @@ string3
1.2
-- !sql --
+\N
+0.7943282347242815
+0.7247796636776955
+0.696845301935949
+0.6931448431551464
+0.7071067811865476
+0.7360219228178333
+0.779055912670449
+0.8365116420730186
+0.9095325760829622
+1.0
+1.1105342410545758
+1.2445647472039776
+
+-- !sql --
+\N
+0.7943282347242815
+0.7247796636776955
+0.696845301935949
+0.6931448431551464
+0.7071067811865476
+0.7360219228178333
+0.779055912670449
+0.8365116420730186
+0.9095325760829622
+1.0
+1.1105342410545758
+1.2445647472039776
+
+-- !sql --
diff --git
a/regression-test/suites/nereids_function_p0/scalar_function/G-K.groovy
b/regression-test/suites/nereids_function_p0/scalar_function/G-K.groovy
index d66424ec47..ab072953af 100644
--- a/regression-test/suites/nereids_function_p0/scalar_function/G-K.groovy
+++ b/regression-test/suites/nereids_function_p0/scalar_function/G-K.groovy
@@ -51,38 +51,37 @@ suite("nereids_scalar_fn_2") {
qt_sql "select hour_ceil(kdtm) from fn_test order by kdtm"
qt_sql "select hour_ceil(kdtmv2s1) from fn_test order by kdtmv2s1"
// core
- // qt_sql "select hour_ceil(kdtv2) from fn_test order by kdtv2"
+ qt_sql "select hour_ceil(kdtv2) from fn_test order by kdtv2"
qt_sql "select hour_ceil(kdtm, kdtm) from fn_test order by kdtm, kdtm"
qt_sql "select hour_ceil(kdtm, kint) from fn_test order by kdtm, kint"
qt_sql "select hour_ceil(kdtmv2s1, kdtmv2s1) from fn_test order by
kdtmv2s1, kdtmv2s1"
qt_sql "select hour_ceil(kdtmv2s1, kint) from fn_test order by kdtmv2s1,
kint"
// core
- // qt_sql "select hour_ceil(kdtv2, kdtv2) from fn_test order by kdtv2,
kdtv2"
- // qt_sql "select hour_ceil(kdtv2, kint) from fn_test order by kdtv2, kint"
+ qt_sql "select hour_ceil(kdtv2, kdtv2) from fn_test order by kdtv2, kdtv2"
+ qt_sql "select hour_ceil(kdtv2, kint) from fn_test order by kdtv2, kint"
qt_sql "select hour_ceil(kdtm, kint, kdtm) from fn_test order by kdtm,
kint, kdtm"
qt_sql "select hour_ceil(kdtmv2s1, kint, kdtmv2s1) from fn_test order by
kdtmv2s1, kint, kdtmv2s1"
// core
- // qt_sql "select hour_ceil(kdtv2, kint, kdtv2) from fn_test order by
kdtv2, kint, kdtv2"
+ qt_sql "select hour_ceil(kdtv2, kint, kdtv2) from fn_test order by kdtv2,
kint, kdtv2"
qt_sql "select hour_floor(kdtm) from fn_test order by kdtm"
qt_sql "select hour_floor(kdtmv2s1) from fn_test order by kdtmv2s1"
// core
- // qt_sql "select hour_floor(kdtv2) from fn_test order by kdtv2"
+ qt_sql "select hour_floor(kdtv2) from fn_test order by kdtv2"
qt_sql "select hour_floor(kdtm, kdtm) from fn_test order by kdtm, kdtm"
qt_sql "select hour_floor(kdtm, kint) from fn_test order by kdtm, kint"
qt_sql "select hour_floor(kdtmv2s1, kdtmv2s1) from fn_test order by
kdtmv2s1, kdtmv2s1"
qt_sql "select hour_floor(kdtmv2s1, kint) from fn_test order by kdtmv2s1,
kint"
// core
- // qt_sql "select hour_floor(kdtv2, kdtv2) from fn_test order by kdtv2,
kdtv2"
- // qt_sql "select hour_floor(kdtv2, kint) from fn_test order by kdtv2,
kint"
+ qt_sql "select hour_floor(kdtv2, kdtv2) from fn_test order by kdtv2,
kdtv2"
+ qt_sql "select hour_floor(kdtv2, kint) from fn_test order by kdtv2, kint"
qt_sql "select hour_floor(kdtm, kint, kdtm) from fn_test order by kdtm,
kint, kdtm"
qt_sql "select hour_floor(kdtmv2s1, kint, kdtmv2s1) from fn_test order by
kdtmv2s1, kint, kdtmv2s1"
// core
- // qt_sql "select hour_floor(kdtv2, kint, kdtv2) from fn_test order by
kdtv2, kint, kdtv2"
- // cannot find function
- // qt_sql "select hours_add(kdtm, kint) from fn_test order by kdtm, kint"
- // qt_sql "select hours_add(kdtmv2s1, kint) from fn_test order by
kdtmv2s1, kint"
- // qt_sql "select hours_add(kdt, kint) from fn_test order by kdt, kint"
- // qt_sql "select hours_add(kdtv2, kint) from fn_test order by kdtv2, kint"
+ qt_sql "select hour_floor(kdtv2, kint, kdtv2) from fn_test order by
kdtv2, kint, kdtv2"
+ qt_sql "select hours_add(kdtm, kint) from fn_test order by kdtm, kint"
+ qt_sql "select hours_add(kdtmv2s1, kint) from fn_test order by kdtmv2s1,
kint"
+ qt_sql "select hours_add(kdt, kint) from fn_test order by kdt, kint"
+ qt_sql "select hours_add(kdtv2, kint) from fn_test order by kdtv2, kint"
qt_sql "select hours_diff(kdtm, kdtm) from fn_test order by kdtm, kdtm"
qt_sql "select hours_diff(kdtmv2s1, kdtmv2s1) from fn_test order by
kdtmv2s1, kdtmv2s1"
qt_sql "select hours_diff(kdtv2, kdtmv2s1) from fn_test order by kdtv2,
kdtmv2s1"
@@ -93,10 +92,10 @@ suite("nereids_scalar_fn_2") {
qt_sql "select hours_diff(kdtmv2s1, kdtm) from fn_test order by kdtmv2s1,
kdtm"
qt_sql "select hours_diff(kdtm, kdtmv2s1) from fn_test order by kdtm,
kdtmv2s1"
// cannot find function
- // qt_sql "select hours_sub(kdtm, kint) from fn_test order by kdtm, kint"
- // qt_sql "select hours_sub(kdtmv2s1, kint) from fn_test order by
kdtmv2s1, kint"
- // qt_sql "select hours_sub(kdt, kint) from fn_test order by kdt, kint"
- // qt_sql "select hours_sub(kdtv2, kint) from fn_test order by kdtv2, kint"
+ qt_sql "select hours_sub(kdtm, kint) from fn_test order by kdtm, kint"
+ qt_sql "select hours_sub(kdtmv2s1, kint) from fn_test order by kdtmv2s1,
kint"
+ qt_sql "select hours_sub(kdt, kint) from fn_test order by kdt, kint"
+ qt_sql "select hours_sub(kdtv2, kint) from fn_test order by kdtv2, kint"
qt_sql "select initcap(kvchrs1) from fn_test order by kvchrs1"
qt_sql "select instr(kvchrs1, kvchrs1) from fn_test order by kvchrs1,
kvchrs1"
qt_sql "select instr(kstr, kstr) from fn_test order by kstr, kstr"
diff --git
a/regression-test/suites/nereids_function_p0/scalar_function/L-Q.groovy
b/regression-test/suites/nereids_function_p0/scalar_function/L-Q.groovy
index 16f0708ce7..10b02e2aec 100644
--- a/regression-test/suites/nereids_function_p0/scalar_function/L-Q.groovy
+++ b/regression-test/suites/nereids_function_p0/scalar_function/L-Q.groovy
@@ -60,7 +60,7 @@ suite("nereids_scalar_fn_3") {
qt_sql "select ltrim(kvchrs1) from fn_test order by kvchrs1"
qt_sql "select ltrim(kstr) from fn_test order by kstr"
// cannot find function
- // qt_sql "select make_date(kint, kint) from fn_test order by kint, kint"
+ qt_sql "select makedate(kint, kint) from fn_test order by kint, kint"
qt_sql "select mask(kvchrs1) from fn_test order by kvchrs1"
qt_sql "select mask(kstr) from fn_test order by kstr"
qt_sql "select mask_first_n(kvchrs1) from fn_test order by kvchrs1"
@@ -75,8 +75,8 @@ suite("nereids_scalar_fn_3") {
qt_sql "select md5(kvchrs1) from fn_test order by kvchrs1"
qt_sql "select md5(kstr) from fn_test order by kstr"
// cannot find function
- // qt_sql "select md5_sum(kvchrs1) from fn_test order by kvchrs1"
- // qt_sql "select md5_sum(kstr) from fn_test order by kstr"
+ qt_sql "select md5sum(kvchrs1) from fn_test order by kvchrs1"
+ qt_sql "select md5sum(kstr) from fn_test order by kstr"
qt_sql "select minute(kdtm) from fn_test order by kdtm"
qt_sql "select minute(kdtmv2s1) from fn_test order by kdtmv2s1"
qt_sql "select minute(kdtv2) from fn_test order by kdtv2"
@@ -111,10 +111,10 @@ suite("nereids_scalar_fn_3") {
// core
qt_sql "select minute_floor(kdtv2, kint, kdtv2) from fn_test order by
kdtv2, kint, kdtv2"
// cannot find function
- // qt_sql "select minutes_add(kdtm, kint) from fn_test order by kdtm, kint"
- // qt_sql "select minutes_add(kdtmv2s1, kint) from fn_test order by
kdtmv2s1, kint"
- // qt_sql "select minutes_add(kdt, kint) from fn_test order by kdt, kint"
- // qt_sql "select minutes_add(kdtv2, kint) from fn_test order by kdtv2,
kint"
+ qt_sql "select minutes_add(kdtm, kint) from fn_test order by kdtm, kint"
+ qt_sql "select minutes_add(kdtmv2s1, kint) from fn_test order by kdtmv2s1,
kint"
+ qt_sql "select minutes_add(kdt, kint) from fn_test order by kdt, kint"
+ qt_sql "select minutes_add(kdtv2, kint) from fn_test order by kdtv2, kint"
qt_sql "select minutes_diff(kdtm, kdtm) from fn_test order by kdtm, kdtm"
qt_sql "select minutes_diff(kdtmv2s1, kdtmv2s1) from fn_test order by
kdtmv2s1, kdtmv2s1"
qt_sql "select minutes_diff(kdtv2, kdtmv2s1) from fn_test order by kdtv2,
kdtmv2s1"
@@ -125,10 +125,10 @@ suite("nereids_scalar_fn_3") {
qt_sql "select minutes_diff(kdtmv2s1, kdtm) from fn_test order by
kdtmv2s1, kdtm"
qt_sql "select minutes_diff(kdtm, kdtmv2s1) from fn_test order by kdtm,
kdtmv2s1"
// cannot find function
- // qt_sql "select minutes_sub(kdtm, kint) from fn_test order by kdtm, kint"
- // qt_sql "select minutes_sub(kdtmv2s1, kint) from fn_test order by
kdtmv2s1, kint"
- // qt_sql "select minutes_sub(kdt, kint) from fn_test order by kdt, kint"
- // qt_sql "select minutes_sub(kdtv2, kint) from fn_test order by kdtv2,
kint"
+ qt_sql "select minutes_sub(kdtm, kint) from fn_test order by kdtm, kint"
+ qt_sql "select minutes_sub(kdtmv2s1, kint) from fn_test order by kdtmv2s1,
kint"
+ qt_sql "select minutes_sub(kdt, kint) from fn_test order by kdt, kint"
+ qt_sql "select minutes_sub(kdtv2, kint) from fn_test order by kdtv2, kint"
qt_sql "select money_format(kbint) from fn_test order by kbint"
qt_sql "select money_format(klint) from fn_test order by klint"
qt_sql "select money_format(kdbl) from fn_test order by kdbl"
@@ -161,14 +161,13 @@ suite("nereids_scalar_fn_3") {
qt_sql "select month_floor(kdtm, kint, kdtm) from fn_test order by kdtm,
kint, kdtm"
qt_sql "select month_floor(kdtmv2s1, kint, kdtmv2s1) from fn_test order by
kdtmv2s1, kint, kdtmv2s1"
qt_sql "select month_floor(kdtv2, kint, kdtv2) from fn_test order by
kdtv2, kint, kdtv2"
- // cannot find function
- // qt_sql "select month_name(kdtm) from fn_test order by kdtm"
- // qt_sql "select month_name(kdtmv2s1) from fn_test order by kdtmv2s1"
- // qt_sql "select month_name(kdtv2) from fn_test order by kdtv2"
- // qt_sql "select months_add(kdtm, kint) from fn_test order by kdtm, kint"
- // qt_sql "select months_add(kdtmv2s1, kint) from fn_test order by
kdtmv2s1, kint"
- // qt_sql "select months_add(kdt, kint) from fn_test order by kdt, kint"
- // qt_sql "select months_add(kdtv2, kint) from fn_test order by kdtv2,
kint"
+ qt_sql "select monthname(kdtm) from fn_test order by kdtm"
+ qt_sql "select monthname(kdtmv2s1) from fn_test order by kdtmv2s1"
+ qt_sql "select monthname(kdtv2) from fn_test order by kdtv2"
+ qt_sql "select months_add(kdtm, kint) from fn_test order by kdtm, kint"
+ qt_sql "select months_add(kdtmv2s1, kint) from fn_test order by kdtmv2s1,
kint"
+ qt_sql "select months_add(kdt, kint) from fn_test order by kdt, kint"
+ qt_sql "select months_add(kdtv2, kint) from fn_test order by kdtv2, kint"
qt_sql "select months_diff(kdtm, kdtm) from fn_test order by kdtm, kdtm"
qt_sql "select months_diff(kdtmv2s1, kdtmv2s1) from fn_test order by
kdtmv2s1, kdtmv2s1"
qt_sql "select months_diff(kdtv2, kdtmv2s1) from fn_test order by kdtv2,
kdtmv2s1"
@@ -180,14 +179,14 @@ suite("nereids_scalar_fn_3") {
qt_sql "select months_diff(kdtmv2s1, kdtm) from fn_test order by kdtmv2s1,
kdtm"
qt_sql "select months_diff(kdtm, kdtmv2s1) from fn_test order by kdtm,
kdtmv2s1"
// cannot find function
- // qt_sql "select months_sub(kdtm, kint) from fn_test order by kdtm, kint"
- // qt_sql "select months_sub(kdtmv2s1, kint) from fn_test order by
kdtmv2s1, kint"
- // qt_sql "select months_sub(kdt, kint) from fn_test order by kdt, kint"
- // qt_sql "select months_sub(kdtv2, kint) from fn_test order by kdtv2,
kint"
- // qt_sql "select murmur_hash332(kvchrs1) from fn_test order by kvchrs1"
- // qt_sql "select murmur_hash332(kstr) from fn_test order by kstr"
- // qt_sql "select murmur_hash364(kvchrs1) from fn_test order by kvchrs1"
- // qt_sql "select murmur_hash364(kstr) from fn_test order by kstr"
+ qt_sql "select months_sub(kdtm, kint) from fn_test order by kdtm, kint"
+ qt_sql "select months_sub(kdtmv2s1, kint) from fn_test order by kdtmv2s1,
kint"
+ qt_sql "select months_sub(kdt, kint) from fn_test order by kdt, kint"
+ qt_sql "select months_sub(kdtv2, kint) from fn_test order by kdtv2, kint"
+ qt_sql "select murmur_hash3_32(kvchrs1) from fn_test order by kvchrs1"
+ qt_sql "select murmur_hash3_32(kstr) from fn_test order by kstr"
+ qt_sql "select murmur_hash3_64(kvchrs1) from fn_test order by kvchrs1"
+ qt_sql "select murmur_hash3_64(kstr) from fn_test order by kstr"
qt_sql "select negative(kbint) from fn_test order by kbint"
qt_sql "select negative(kdbl) from fn_test order by kdbl"
qt_sql "select negative(kdcmls1) from fn_test order by kdcmls1"
@@ -197,21 +196,21 @@ suite("nereids_scalar_fn_3") {
// core
// qt_sql "select now(kint) from fn_test order by kint"
// cannot find function
- // qt_sql "select null_if(kbool, kbool) from fn_test order by kbool, kbool"
- // qt_sql "select null_if(ktint, ktint) from fn_test order by ktint, ktint"
- // qt_sql "select null_if(ksint, ksint) from fn_test order by ksint, ksint"
- // qt_sql "select null_if(kint, kint) from fn_test order by kint, kint"
- // qt_sql "select null_if(kbint, kbint) from fn_test order by kbint, kbint"
- // qt_sql "select null_if(klint, klint) from fn_test order by klint, klint"
- // qt_sql "select null_if(kfloat, kfloat) from fn_test order by kfloat,
kfloat"
- // qt_sql "select null_if(kdbl, kdbl) from fn_test order by kdbl, kdbl"
- // qt_sql "select null_if(kdtm, kdtm) from fn_test order by kdtm, kdtm"
- // qt_sql "select null_if(kdt, kdt) from fn_test order by kdt, kdt"
- // qt_sql "select null_if(kdtmv2s1, kdtmv2s1) from fn_test order by
kdtmv2s1, kdtmv2s1"
- // qt_sql "select null_if(kdtv2, kdtv2) from fn_test order by kdtv2, kdtv2"
- // qt_sql "select null_if(kdcmls1, kdcmls1) from fn_test order by kdcmls1,
kdcmls1"
- // qt_sql "select null_if(kvchrs1, kvchrs1) from fn_test order by kvchrs1,
kvchrs1"
- // qt_sql "select null_if(kstr, kstr) from fn_test order by kstr, kstr"
+ qt_sql "select nullif(kbool, kbool) from fn_test order by kbool, kbool"
+ qt_sql "select nullif(ktint, ktint) from fn_test order by ktint, ktint"
+ qt_sql "select nullif(ksint, ksint) from fn_test order by ksint, ksint"
+ qt_sql "select nullif(kint, kint) from fn_test order by kint, kint"
+ qt_sql "select nullif(kbint, kbint) from fn_test order by kbint, kbint"
+ qt_sql "select nullif(klint, klint) from fn_test order by klint, klint"
+ qt_sql "select nullif(kfloat, kfloat) from fn_test order by kfloat, kfloat"
+ qt_sql "select nullif(kdbl, kdbl) from fn_test order by kdbl, kdbl"
+ qt_sql "select nullif(kdtm, kdtm) from fn_test order by kdtm, kdtm"
+ qt_sql "select nullif(kdt, kdt) from fn_test order by kdt, kdt"
+ qt_sql "select nullif(kdtmv2s1, kdtmv2s1) from fn_test order by kdtmv2s1,
kdtmv2s1"
+ qt_sql "select nullif(kdtv2, kdtv2) from fn_test order by kdtv2, kdtv2"
+ qt_sql "select nullif(kdcmls1, kdcmls1) from fn_test order by kdcmls1,
kdcmls1"
+ qt_sql "select nullif(kvchrs1, kvchrs1) from fn_test order by kvchrs1,
kvchrs1"
+ qt_sql "select nullif(kstr, kstr) from fn_test order by kstr, kstr"
qt_sql "select null_or_empty(kvchrs1) from fn_test order by kvchrs1"
qt_sql "select null_or_empty(kstr) from fn_test order by kstr"
qt_sql "select nvl(kbool, kbool) from fn_test order by kbool, kbool"
@@ -225,12 +224,12 @@ suite("nereids_scalar_fn_3") {
qt_sql "select nvl(kdt, kdt) from fn_test order by kdt, kdt"
qt_sql "select nvl(kdtm, kdtm) from fn_test order by kdtm, kdtm"
// result error
- // qt_sql "select nvl(kdt, kdtm) from fn_test order by kdt, kdtm"
+ qt_sql "select nvl(kdt, kdtm) from fn_test order by kdt, kdtm"
qt_sql "select nvl(kdtm, kdt) from fn_test order by kdtm, kdt"
qt_sql "select nvl(kdtmv2s1, kdtmv2s1) from fn_test order by kdtmv2s1,
kdtmv2s1"
// result error
- // qt_sql "select nvl(kdtv2, kdtmv2s1) from fn_test order by kdtv2,
kdtmv2s1"
- // qt_sql "select nvl(kdtmv2s1, kdtv2) from fn_test order by kdtmv2s1,
kdtv2"
+ qt_sql "select nvl(kdtv2, kdtmv2s1) from fn_test order by kdtv2, kdtmv2s1"
+ qt_sql "select nvl(kdtmv2s1, kdtv2) from fn_test order by kdtmv2s1, kdtv2"
qt_sql "select nvl(kdcmls1, kdcmls1) from fn_test order by kdcmls1,
kdcmls1"
// function nvl(bitmap, bitmap) is unsupported for the test suite.
qt_sql "select nvl(kvchrs1, kvchrs1) from fn_test order by kvchrs1,
kvchrs1"
@@ -248,8 +247,8 @@ suite("nereids_scalar_fn_3") {
// core
// qt_sql "select positive(kdcmls1) from fn_test order by kdcmls1"
// data out of double range
- // qt_sql "select pow(kdbl, kdbl) from fn_test order by kdbl, kdbl"
- // qt_sql "select power(kdbl, kdbl) from fn_test order by kdbl, kdbl"
+ qt_sql "select pow(kdbl, kdbl) from fn_test order by kdbl, kdbl"
+ qt_sql "select power(kdbl, kdbl) from fn_test order by kdbl, kdbl"
qt_sql "select protocol(kstr) from fn_test order by kstr"
// function quantile_percent(quantilestate, float) is unsupported for the test
suite.
qt_sql "select quarter(kdtm) from fn_test order by kdtm"
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
