db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Nielsen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2998) Add support for ROW_NUMBER() window function
Date Thu, 06 Mar 2008 17:58:58 GMT

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

Thomas Nielsen commented on DERBY-2998:
---------------------------------------

Amry, I don't think there's time to address that in the 10.4 timeframe. But I'll give it a
shot!

I created DERBY-3505 for the "#8 comment" about ROW_NUMBER() performance.  Whenever DERBY-3505
is fixed on trunk it can be ported to the 10.4 branch (no interface changes, only internal)
and the improved performance shipped with the next update release off the 10.4 branch?

> 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-10.diff, d2998-10.stat, d2998-11.diff, d2998-12.diff, d2998-12.stat,
d2998-13.diff, d2998-13.stat, d2998-14.diff, d2998-14.stat, d2998-15.diff, d2998-15.stat,
d2998-16.diff, d2998-16.stat, d2998-17.diff, d2998-17.stat, d2998-18.diff, d2998-18.stat,
d2998-19.diff, d2998-19.stat, d2998-4.diff, d2998-4.stat, d2998-5.diff, d2998-5.stat, d2998-6.diff,
d2998-6.stat, d2998-7.diff, d2998-7.stat, d2998-8.diff, d2998-8.stat, d2998-9-derby.log, d2998-9.diff,
d2998-9.stat, d2998-doc-1.diff, d2998-doc-1.stat, d2998-doc-2.diff, d2998-doc-2.stat, d2998-followup-2.diff,
d2998-followup-2.stat, d2998-followup-distinct.diff, d2998-followup-distinct.diff, d2998-followup-distinct.stat,
d2998-followup-doc3.diff, d2998-followup-doc3.stat, d2998-followup-issue1.diff, d2998-followup-issue1.stat,
d2998-followup-issue4.diff, d2998-followup-issue4.stat, d2998-followup-removeunused.diff,
d2998-followup-testsuite.diff, d2998-followup-testsuite.stat, d2998-test.diff, d2998-test.stat,
d2998-test2.diff, d2998-test2.stat, d2998-test3.diff, d2998-test3.stat, d2998-test4.diff,
d2998-test4.stat, d2998-test6.diff, d2998-test7.diff, d2998-test8.diff, d2998-test9.diff,
rreffuncrownumber.html
>
>
> 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
> DERBY-2998 implements 
>   - framework code for windows and window function result columns.
>   - the ROW_NUMBER() window function according to SQL2003
> but the implementation is limited by
>   - only supporting an empty, unnamed, inline window definition (i.e the full, unordered
resultset)
>   - not being fully optimized

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