You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2016/01/24 21:14:39 UTC

[jira] [Resolved] (PHOENIX-1708) SUM aggregation on DECIMAL(X,Y) leads to DECIMAL(0,0)

     [ https://issues.apache.org/jira/browse/PHOENIX-1708?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Taylor resolved PHOENIX-1708.
-----------------------------------
    Resolution: Duplicate

Duplicate of PHOENIX-2536

> SUM aggregation on DECIMAL(X,Y) leads to DECIMAL(0,0)
> -----------------------------------------------------
>
>                 Key: PHOENIX-1708
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1708
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.3.0
>            Reporter: Lavrenty Eskin
>            Priority: Critical
>             Fix For: 4.8.0
>
>
> T1.VAL has DECIMAL(8,2) datatype
> select T1.VAL from T1;  <<== return getScale()=2, getPrecision()=8
> select sum(T1.VAL) from T1; <<== return getScale()=0, getPrecision()=0
> Returned value of sum(T1.VAL) = 1,025,554.24



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)