This is an automated email from the ASF dual-hosted git repository.
kxiao pushed a commit to branch branch-2.0
in repository https://gitbox.apache.org/repos/asf/doris.git
commit 3d1f5b9052fcf81dba9328a221460f1f073b8000
Author: Gabriel <gabrielleeb...@gmail.com>
AuthorDate: Tue Aug 1 11:35:44 2023 +0800
[regression](fix) fix test_round case (#22441)
---
.../sql_functions/math_functions/test_round.out | 24 ----------------------
.../sql_functions/math_functions/test_round.groovy | 18 ----------------
2 files changed, 42 deletions(-)
diff --git
a/regression-test/data/query_p0/sql_functions/math_functions/test_round.out
b/regression-test/data/query_p0/sql_functions/math_functions/test_round.out
index 92b8def44b..162e5970db 100644
--- a/regression-test/data/query_p0/sql_functions/math_functions/test_round.out
+++ b/regression-test/data/query_p0/sql_functions/math_functions/test_round.out
@@ -116,27 +116,3 @@
-- !query --
0.000 0.000 0.000
--- !query --
-16.02
-
--- !query --
-16.02
-
--- !query --
-16.03
-
--- !query --
-16.02
-
--- !query --
-16.03
-
--- !query --
-16.02
-
--- !query --
-16.03
-
--- !query --
-16.02
-
diff --git
a/regression-test/suites/query_p0/sql_functions/math_functions/test_round.groovy
b/regression-test/suites/query_p0/sql_functions/math_functions/test_round.groovy
index a95bf4414c..f9b271b24b 100644
---
a/regression-test/suites/query_p0/sql_functions/math_functions/test_round.groovy
+++
b/regression-test/suites/query_p0/sql_functions/math_functions/test_round.groovy
@@ -138,22 +138,4 @@
qt_query """ select cast(round(sum(d1), 2) as decimalv3(27, 3)),
cast(round(sum(d2), 2) as decimalv3(27, 3)), cast(round(sum(d3),2) as
decimalv3(27, 3)) from ${tableName3} """
qt_query """ select cast(round(sum(d1), -2) as decimalv3(27, 3)),
cast(round(sum(d2), -2) as decimalv3(27, 3)), cast(round(sum(d3), -2) as
decimalv3(27, 3)) from ${tableName3} """
qt_query """ select cast(round(sum(d1), -4) as decimalv3(27, 3)),
cast(round(sum(d2), -4) as decimalv3(27, 3)), cast(round(sum(d3), -4) as
decimalv3(27, 3)) from ${tableName3} """
-
- sql """ ADMIN SET FRONTEND CONFIG ("enable_decimal_conversion" = "false");
"""
- sql """ ADMIN SET FRONTEND CONFIG ("disable_decimalv2" = "false"); """
- sql """ set experimental_enable_nereids_planner=false; """
- sql """ DROP TABLE IF EXISTS `test_decimalv2` """
- sql """ CREATE TABLE `test_decimalv2` ( id int, decimal_col DECIMAL(19,5))
ENGINE=OLAP duplicate KEY (id) DISTRIBUTED BY HASH(id) BUCKETS 1 PROPERTIES (
"replication_allocation" = "tag.location.default: 1"); """
- sql """ insert into test_decimalv2 values (1, 16.025); """
- sql """ set round_precise_decimalv2_value=false; """
- qt_query """ select round(decimal_col,2) from test_decimalv2; """
- qt_query """ select truncate(decimal_col,2) from test_decimalv2; """
- qt_query """ select ceil(decimal_col,2) from test_decimalv2; """
- qt_query """ select floor(decimal_col,2) from test_decimalv2; """
- sql """ set round_precise_decimalv2_value=true; """
- qt_query """ select round(decimal_col,2) from test_decimalv2; """
- qt_query """ select truncate(decimal_col,2) from test_decimalv2; """
- qt_query """ select ceil(decimal_col,2) from test_decimalv2; """
- qt_query """ select floor(decimal_col,2) from test_decimalv2; """
- sql """ ADMIN SET FRONTEND CONFIG ("enable_decimal_conversion" = "true");
"""
}
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
