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

Julian Hyde resolved CALCITE-1931.
----------------------------------
       Resolution: Fixed
    Fix Version/s: 1.14.0

Fixed in http://git-wip-us.apache.org/repos/asf/calcite/commit/54ed57f8.

> 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
>             Fix For: 1.14.0
>
>
> RANK, NTILE etc. functions should not always return INTEGER. 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