[
https://issues.apache.org/jira/browse/CALCITE-806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14634156#comment-14634156
]
Vladimir Sitnikov commented on CALCITE-806:
-------------------------------------------
{quote}ROWS BETWEEN 3 PRECEDING AND 2 FOLLOWING is silently ignored?{quote}
I would rather follow the spec and throw a validation error in such case.
Why should we accept framing here? The spec does not allow it. It does not make
much sense, so I vote for throwing.
> 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)
