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