[
https://issues.apache.org/jira/browse/CALCITE-1931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16119151#comment-16119151
]
Julian Hyde commented on CALCITE-1931:
--------------------------------------
That makes sense. Thanks for doing the research. Let me know when you have a
commit ready for review.
> rank/ntile/etc. functions should not always return INTEGER
> ----------------------------------------------------------
>
> 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)
