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 5d7e804a612 [fix](Nereids) check avg in correctness_p0 (#25533)
5d7e804a612 is described below
commit 5d7e804a612176360354596f1adb7797feef15c4
Author: 谢健 <[email protected]>
AuthorDate: Fri Oct 20 14:12:06 2023 +0800
[fix](Nereids) check avg in correctness_p0 (#25533)
---
regression-test/data/correctness_p0/test_avg.out | 10 ++++++++--
regression-test/suites/correctness_p0/test_avg.groovy | 4 +++-
2 files changed, 11 insertions(+), 3 deletions(-)
diff --git a/regression-test/data/correctness_p0/test_avg.out
b/regression-test/data/correctness_p0/test_avg.out
index cc4e2ae2ba1..3bd471dd563 100644
--- a/regression-test/data/correctness_p0/test_avg.out
+++ b/regression-test/data/correctness_p0/test_avg.out
@@ -1,6 +1,12 @@
-- This file is automatically generated. You should know what you did if you
want to edit this
--- !select --
-9.18181818181868E14
+-- !sum --
+90900000000004950
+
+-- !count --
+99
+
+-- !avg --
+9.181818181818681E14
-- !select2 --
\N \N
diff --git a/regression-test/suites/correctness_p0/test_avg.groovy
b/regression-test/suites/correctness_p0/test_avg.groovy
index 5c2c8923d0e..5d9b9b7e6f9 100644
--- a/regression-test/suites/correctness_p0/test_avg.groovy
+++ b/regression-test/suites/correctness_p0/test_avg.groovy
@@ -37,7 +37,9 @@ suite("test_avg") {
for (i in range(1, 100)) {
sql """ INSERT INTO ${tableName} values (10000000000000${i}) """
}
- qt_select """ SELECT AVG(c_bigint) FROM ${tableName} """
+ qt_sum """ SELECT SUM(c_bigint) FROM ${tableName} """
+ qt_count """ SELECT COUNT(c_bigint) FROM ${tableName} """
+ qt_avg """ SELECT AVG(c_bigint) FROM ${tableName} """
sql""" DROP TABLE IF EXISTS ${tableName} """
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
