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 f8513dee2a [fix](Nereids): fix regression test in A-F.out (#16260)
f8513dee2a is described below
commit f8513dee2ac95744662233de3a6fc488c470a8d4
Author: jakevin <jakevin...@gmail.com>
AuthorDate: Wed Feb 1 18:19:40 2023 +0800
[fix](Nereids): fix regression test in A-F.out (#16260)
---
.../nereids_function_p0/scalar_function/A-F.out | 48 ++++++++++++++++++----
.../nereids_function_p0/scalar_function/A-F.groovy | 8 ++--
2 files changed, 42 insertions(+), 14 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 88bc3d91f4..e279c1ba5f 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
@@ -122,10 +122,10 @@
-- !sql --
\N
1.4706289056333368
-1.369438406004566
-1.2661036727794992
+1.3694384060045657
+1.266103672779499
1.1592794807274085
-1.0471975511965979
+1.0471975511965976
0.9272952180016123
0.7953988301841436
0.6435011087932843
@@ -376,15 +376,15 @@ nan
-- !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
@@ -2054,6 +2054,36 @@ Monday
1.1105342410545758
1.2445647472039776
+-- !sql --
+\N
+0.0
+0.0
+0.0
+0.0
+0.0
+1.0
+1.0
+1.0
+1.0
+1.0
+1.0
+1.0
+
+-- !sql --
+\N
+0.1
+0.2
+0.3
+0.4
+0.5
+0.6
+0.7
+0.8
+0.9
+1.0
+1.1
+1.2
+
-- !sql --
\N
0.31622776601683794
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 e04d3a6c3b..22190c8566 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
@@ -76,7 +76,6 @@ suite("nereids_scalar_fn_1") {
qt_sql "select coalesce(kdtmv2s1) from fn_test order by kdtmv2s1"
qt_sql "select coalesce(kdtv2) from fn_test order by kdtv2"
qt_sql "select coalesce(kdcmls1) from fn_test order by kdcmls1"
- // function coalesce(bitmap) is unsupported for the test suite.
qt_sql "select coalesce(kvchrs1) from fn_test order by kvchrs1"
qt_sql "select coalesce(kstr) from fn_test order by kstr"
qt_sql "select concat(kvchrs1) from fn_test order by kvchrs1"
@@ -93,8 +92,7 @@ suite("nereids_scalar_fn_1") {
sql "select current_date() from fn_test"
sql "select current_time() from fn_test"
sql "select current_timestamp() from fn_test"
- // core
- // qt_sql "select current_timestamp(kint) from fn_test order by kint"
+ sql "select current_timestamp(coalesce(kint, 0)) from fn_test"
sql "select current_user() from fn_test"
sql "select curtime() from fn_test"
sql "select database() from fn_test"
@@ -180,8 +178,8 @@ suite("nereids_scalar_fn_1") {
qt_sql "select domain(kstr) from fn_test order by kstr"
qt_sql "select domain_without_www(kstr) from fn_test order by kstr"
qt_sql "select dpow(kdbl, kdbl) from fn_test order by kdbl, kdbl"
- // qt_sql "select dround(kdbl) from fn_test order by kdbl"
- // qt_sql "select dround(kdbl, kint) from fn_test order by kdbl, kint"
+ qt_sql "select dround(kdbl) from fn_test order by kdbl"
+ qt_sql "select dround(kdbl, 2) from fn_test order by kdbl, kint"
qt_sql "select dsqrt(kdbl) from fn_test order by kdbl"
qt_sql "select e() from fn_test"
// result error
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
