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

Reply via email to