db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "A B (JIRA)" <j...@apache.org>
Subject [jira] Issue Comment Edited: (DERBY-2998) Add support for ROW_NUMBER() window function
Date Fri, 29 Feb 2008 23:35:51 GMT

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

army edited comment on DERBY-2998 at 2/29/08 3:35 PM:
-----------------------------------------------------

Committed d2998-19.diff and d2998-test9.diff both with svn # 632494:

  URL: http://svn.apache.org/viewvc?rev=632494&view=rev

In addition to the follow-up work mentioned in my previous comment, I also noticed one more
thing that requires investigation.  The following query fails with an ArrayIndexOutOfBounds
exception while trying to print the query plan (i.e. after the query is executed, and only
if "logQueryPlan" is set to true):

 select count(*) from
  (select i, row_number() over () from t1
    union all
   select distinct row_number() over(), row_number() over() from t1) x(a, b);

If I remove the "DISTINCT" or else replace one of the row_number() columns in the SELECT DISTINCT
query with a simple column reference, the query plan is generated correctly.  Pretty minor
in the grand scheme of things, but I thought I'd mention it.

Thanks for all of your work on this, Thomas!

      was (Author: army):
    Committed d2998-19.diff and d9998-test9.diff both with svn # 632494:

  URL: http://svn.apache.org/viewvc?rev=632494&view=rev

In addition to the follow-up work mentioned in my previous comment, I also noticed one more
thing that requires investigation.  The following query fails with an ArrayIndexOutOfBounds
exception while trying to print the query plan (i.e. after the query is executed, and only
if "logQueryPlan" is set to true):

 select count(*) from
  (select i, row_number() over () from t1
    union all
   select distinct row_number() over(), row_number() over() from t1) x(a, b);

If I remove the "DISTINCT" or else replace one of the row_number() columns in the SELECT DISTINCT
query with a simple column reference, the query plan is generated correctly.  Pretty minor
in the grand scheme of things, but I thought I'd mention it.

Thanks for all of your work on this, Thomas!
  
> 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-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
>
>
> 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