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

[James Taylor (JIRA)]

     [ 
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)