db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel John Debrunner (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2998) Add support for ROW_NUMBER() window function
Date Thu, 13 Dec 2007 18:20:43 GMT

    [ 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.


Mime
View raw message