[
https://issues.apache.org/jira/browse/DERBY-2998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12563671#action_12563671
]
Rick Hillegas commented on DERBY-2998:
--------------------------------------
Hi Thomas,
Thanks for the latest patch. I have applied it and can see that the following
query runs correctly:
select *
from
(
select row_number() over () as r, t.* from t
) tout
order by r;
but the following query generates an error:
select *
from
(
select row_number() over () as r, t.* from t
) tout
where r > 2;
ERROR XJ001: Java exception: 'ASSERT FAILED sourceResultSetNumber expected to
be >= 0 for null.R: org.apache.derby.shared.common.sanity.AssertFailure'.
But, of course, you already know this. What kind of feedback do you want on
this patch? Thanks.
> 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-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
>
>
> 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.
