db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "OLAPRowNumber" by ThomasNielsen
Date Thu, 09 Aug 2007 08:14:46 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by ThomasNielsen:
http://wiki.apache.org/db-derby/OLAPRowNumber

------------------------------------------------------------------------------
  
  In this example the ROW_NUMBER function is used to limit the query as soon as the first
N rows have been determined.
  
+ == Current Implementation ==
+ 
+ The ROW_NUMBER() window function is currently not implemented, and thereby not supported.
+ 
+ == Proposed Changes ==
+ ''DRAFT''
+ 
+ Conceptually the steps needed are
+  * The new syntax must be added to the SQL grammar 
+  * Each node in the query tree should be decorated with a {{{RowNumberNode()}}}
+  * A row number should be assigned to the Derby {{{ResultSet}}} after (during?) ordering/grouping.
+ 

Mime
View raw message