[arrow-datafusion] branch main updated: Add Decimal256 sqllogictests for SUM, MEDIAN and COUNT aggregate expressions (#7889)

[dheres]

This is an automated email from the ASF dual-hosted git repository.

dheres pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/arrow-datafusion.git


The following commit(s) were added to refs/heads/main by this push:
     new d6d324444a Add Decimal256 sqllogictests for SUM, MEDIAN and COUNT 
aggregate expressions (#7889)
d6d324444a is described below

commit d6d324444a6695852966c2513c66027e59dbec5e
Author: Liang-Chi Hsieh <vii...@gmail.com>
AuthorDate: Sat Oct 21 03:27:29 2023 -0700

    Add Decimal256 sqllogictests for SUM, MEDIAN and COUNT aggregate 
expressions (#7889)
    
    * Add Decimal256 sqllogictests test for SUM aggregate
    
    * Add median and avg sqllogictests tests
    
    * Remove duplicate
    
    * Add count test
---
 datafusion/sqllogictest/test_files/decimal.slt | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)

diff --git a/datafusion/sqllogictest/test_files/decimal.slt 
b/datafusion/sqllogictest/test_files/decimal.slt
index 87a846c077..c220a5fc9a 100644
--- a/datafusion/sqllogictest/test_files/decimal.slt
+++ b/datafusion/sqllogictest/test_files/decimal.slt
@@ -701,5 +701,24 @@ select arrow_typeof(max(c1)), max(c1) from 
decimal256_simple where c4=false;
 ----
 Decimal256(50, 6) 0.00005
 
+query TR
+select arrow_typeof(sum(c1)), sum(c1) from decimal256_simple;
+----
+Decimal256(60, 6) 0.00055
+
+query TR
+select arrow_typeof(median(c1)), median(c1) from decimal256_simple;
+----
+Decimal256(50, 6) 0.00004
+
+query IR
+select count(*),c1 from decimal256_simple group by c1 order by c1;
+----
+1 0.00001
+2 0.00002
+3 0.00003
+4 0.00004
+5 0.00005
+
 statement ok
 drop table decimal256_simple;