[
https://issues.apache.org/jira/browse/TRAFODION-3284?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
David Wayne Birdsall resolved TRAFODION-3284.
---------------------------------------------
Resolution: Fixed
Fix Version/s: 2.4
> SUM aggregate overflow criteria are inconsistent with rest of product
> ---------------------------------------------------------------------
>
> Key: TRAFODION-3284
> URL: https://issues.apache.org/jira/browse/TRAFODION-3284
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: David Wayne Birdsall
> Assignee: David Wayne Birdsall
> Priority: Major
> Fix For: 2.4
>
> Time Spent: 40m
> Remaining Estimate: 0h
>
> The following script demonstrates the problem:
> {quote}drop table if exists t;
> create table t (
> c1 float,
> c2 double precision,
> c3 float,
> c4 double precision
> );
> insert into t values (-1.234, -1.234, -1.42085740198313120E-309,
> -1.42085740198313120E-309);
> select * from t;
> select avg(c1) from t;
> select avg(c2) from t;
> select avg(c3) from t;
> select avg(c4) from t;
> select count(c1) from t;
> select count(c2) from t;
> select count(c3) from t;
> select count(c4) from t;
> select max(c1) from t;
> select max(c2) from t;
> select max(c3) from t;
> select max(c4) from t;
> select min(c1) from t;
> select min(c2) from t;
> select min(c3) from t;
> select min(c4) from t;
> select stddev(c1) from t;
> select stddev(c2) from t;
> select stddev(c3) from t;
> select stddev(c4) from t;
> select sum(c1) from t;
> select sum(c2) from t;
> select sum(c3) from t;
> select sum(c4) from t;
> select variance(c1) from t;
> select variance(c2) from t;
> select variance(c3) from t;
> select variance(c4) from t;
> {quote}
>
> When run, the AVG, SUM, STDDEV and VARIANCE aggregates report error 8411
> (floating point overflow) on columns C3 and C4. For STDDEV and VARIANCE this
> is correct, since calculating these aggregates requires squaring the column
> value. For SUM and AVG, we are merely summing the value, which should not
> cause an overflow.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
