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

[Lavrenty Eskin (JIRA)]

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

Lavrenty Eskin updated PHOENIX-1708:
------------------------------------
    Description: 
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

  was:
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


> 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
>            Reporter: Lavrenty Eskin
>            Priority: Critical
>
> 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)