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 Wed, 12 Dec 2007 22:00:44 GMT

    [ https://issues.apache.org/jira/browse/DERBY-2998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12551121
] 

Daniel John Debrunner commented on DERBY-2998:
----------------------------------------------

Is there a write-up on what this issue is planning to produce?
The linked to wiki page clearly shows the syntax but most of the current examples in the test
(and in most comments in this issue) do not follow that syntax.

E.g.  select row_number(), t1.* from t1

I understand that it's a work in progress, but is the final aim to support more than

  ROW_NUMBER() OVER <window name or specification>

and hence have non-standard expressions? Or are the non-standard examples just a interim development
step that will be removed before any release?

http://wiki.apache.org/db-derby/OLAPRowNumber

> 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