[ https://issues.apache.org/jira/browse/CALCITE-1931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16119154#comment-16119154 ]
Julian Hyde commented on CALCITE-1931: -------------------------------------- One more thing. Can you add a paragraph to the release notes (HISTORY.md). Something like this: bq. Breaking change. Various aggregate functions that used to return INTEGER now return other types. RANK, DENSE_RANK and NTILE now return BIGINT; CUME_DIST and PERCENT_RANK now return DOUBLE. > 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)