[
https://issues.apache.org/jira/browse/CALCITE-806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14632642#comment-14632642
]
Vladimir Sitnikov commented on CALCITE-806:
-------------------------------------------
Please check https://github.com/vlsi/incubator-calcite/commits/806-row-number.
It just converts bounds as described above.
I'm not sure which validation should be added if any.
PS. I would like to avoid adding code to existing test methods. Having separate
tests helps to isolate&debug things.
> ROW_NUMBER should emit distinct values
> --------------------------------------
>
> Key: CALCITE-806
> URL: https://issues.apache.org/jira/browse/CALCITE-806
> Project: Calcite
> Issue Type: Bug
> Reporter: Julian Hyde
> Assignee: Julian Hyde
> Fix For: next
>
>
> ROW_NUMBER should emit distinct values even for rows that have identical sort
> keys, or if there is no sort key. (This is distinct from RANK and DENSE_RANK,
> which emit the same value for rows with the same sort key.)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
