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

Julian Hyde updated CALCITE-1931:
---------------------------------
    Summary: Change the return type of RANK, NTILE and other aggregate 
functions  (was: rank/ntile/etc. functions should not always return INTEGER)

> Change the return type of RANK, NTILE and other aggregate functions
> -------------------------------------------------------------------
>
>                 Key: CALCITE-1931
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1931
>             Project: Calcite
>          Issue Type: Bug
>          Components: core
>            Reporter: MinJi Kim
>            Assignee: Julian Hyde
>
> For example, rank() and percent_rank() both return INTEGER.  For rank(), it 
> would be better to return BIGINT; for percent_rank(), we should actually 
> return double or float since it is a percent value.  There are other rank 
> functions that should return floating number instead of integer.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to