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] Updated: (DERBY-2998) Add support for ROW_NUMBER() window function
Date Tue, 20 Nov 2007 10:12:43 GMT

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

Thomas Nielsen updated DERBY-2998:

    Attachment: d2998-3.diff

Attaching a new, working, but still not properly optimized, patch for the ROW_NUMBER() implementation.

This patch inserts a OLAPNode in the QueryTree, and generates an OLAPResultSet fetching rows
from any given source ResultSet. The implementation of OLAPNode and OLAPResultSet is based
on IndexToBaseRowNode and IndexRowToBaseRowResultSet respectively.

The missing optimization is due to the restriction (whereClause) not being properly recognized
or passed to the inner select in the ROW_NUMBER() construct:
   select * from (select row_number() as r, t.* from t) as tr where r <= N;

The code in OLAPResultSet will check the restriction for all rows it sees, if defined.

As of now, the whereClause is changed to wherePredicates before passing them to the inner
Select. But for the inner select each Predicate in the wherePredicates have (Prediacte.)scoped=false.

Patch still not intended for commit...

> 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-3.diff, d2998-3.stat, row_number_prototype-2c.diff, row_number_prototype-2c.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.

View raw message