[
https://issues.apache.org/jira/browse/DERBY-2998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12551568
]
Daniel John Debrunner commented on DERBY-2998:
----------------------------------------------
> do you believe that ROW_NUMBER OVER () is a non-standard use of ROW_NUMBER?
No idea, Mamta points out that the syntax grammar allows it. I haven't gone
through all the syntax and general rules in 6.10 & 7.11 to see if there are
additional conditions that would lead an empty window specification to be
invalid.
(e.g. the syntax grammar for routine creation allows multiple LANGUAGE clauses,
but the rules specify "at most one" language clause, so the syntax grammar is
not the final say on if a statement is valid or not)
> Add support for ROW_NUMBER() window function
> --------------------------------------------
>
> Key: DERBY-2998
> URL: https://issues.apache.org/jira/browse/DERBY-2998
> Project: Derby
> Issue Type: Sub-task
> Components: SQL
> Reporter: Thomas Nielsen
> Assignee: Thomas Nielsen
> Priority: Minor
> Attachments: d2998-4.diff, d2998-4.stat, d2998-5.diff, d2998-5.stat,
> d2998-6.diff, d2998-6.stat, d2998-test.diff, d2998-test.stat,
> d2998-test2.diff, d2998-test2.stat
>
>
> As part of implementing the overall OLAP Operations features of SQL
> (DERBY-581), implement the ROW_NUMBER() window function.
> More information about this feature is available at
> http://wiki.apache.org/db-derby/OLAPRowNumber
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
