Details
- 
    
Bug
 - 
    Status: Closed (View Workflow)
 - 
    
Minor
 - 
    Resolution: Duplicate
 - 
    1.0.1
 - 
    None
 
Description
Build tested:
getsoftwareinfo Fri Jun 17 17:03:28 2016
Name        : mariadb-columnstore-platform  Relocations: (not relocatable)
Version     : 1.0                               Vendor: MariaDB Corporation Ab
Release     : 1                             Build Date: Mon 13 Jun 2016 06:50:26 PM CDT
Install Date: Fri 17 Jun 2016 10:53:22 AM CDT      Build Host: srvbuilder
Group       : Applications                  Source RPM: mariadb-columnstore-1.0-1.src.rpm
MariaDB [mytest]> select cfloat from datatypetestm;
-------------                                    
| cfloat | 
-------------
| -3.40287e18 | 
| -3.40287e18 | 
| -3.40286e18 | 
| -3.40286e18 | 
| -3.40286e18 | 
| 3.40286e18 | 
| 3.40286e18 | 
| 3.40286e18 | 
| 3.40287e18 | 
| 3.40287e18 | 
| 0 | 
-------------
11 rows in set (0.02 sec)
MariaDB [mytest]> select SUM(CFLOAT) from datatypetestm;
--------------                                   
| SUM(CFLOAT) | 
--------------
| 274877906944 | 
--------------
1 row in set (0.01 sec)
MariaDB [mytest]> select AVG(CFLOAT) from datatypetestm;
-------------                                    
| AVG(CFLOAT) | 
-------------
| 24988901376 | 
-------------
1 row in set (0.01 sec)
Both MariaDB and InfiniDB return 0.
Attachments
Issue Links
- duplicates
 - 
                    
MCOL-1822 Change the default to use double when overflow occurs in SUM() and AVG()
-         
 - Closed
 
 -         
 
- relates to
 - 
                    
MDEV-11307 sum() and avg() return incorrect result for float when calculation overflows float range
-         
 - Confirmed
 
 -