Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <22727195.1188995373265.JavaMail.root@brutus>
Date: Wed, 5 Sep 2007 05:29:33 -0700 (PDT)
From: "Thomas Nielsen (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-2998) Add support for ROW_NUMBER() window
 function
In-Reply-To: <14732006.1186647103190.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

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

In ResultSetList.generateCore() - the method that actually does the work - I now handle the case of a RownumberColumnNode instance, and attempt to invoke the incrementor function in RowNumberAggregator over in exec. RowNumberAggregator extends SystemAggregator as of now. 

When execution gets to GenericPreparedStatement.getActivation() my "select row_number() from t;" fails with:

ERROR XBCM2: Cannot create an instance of generated class org.apache.derby.exe.ac601a400fx0114xd591xad7axffffe275b2700.
ERROR XJ001: Java exception: '(class: org/apache/derby/exe/ac601a400fx0114xd591xad7axffffe275b2700, method: e1 signature: ()Ljava/lang/Object;) Incompatible object argument for function call: java.lang.VerifyError'.

>From what I can tell this means I'm either missing a generated class, or I'm passing the wrong type of argument to my RowNumberAggregator incrementor method?

It would probably be good idea move the handling from ResultSetList.generateCore()  to RowNumberColumnNode.generateExpression()? 
And the incrementor would perhaps be better placed in BaseAcitvation instead?

Right now I feel like pounding nails with a shovel - you just know there's a better tool available for the job, you just have to find it...

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