[ http://issues.apache.org/jira/browse/DERBY-517?page=all ]

Fernanda Pizzorno updated DERBY-517:
------------------------------------

    Attachment: DERBY-517-2.diff
                DERBY-517-2.stat

I seems like I had forgotten a "svn add", sorry :).

> ResultSet - relative(int rows) behaves different in embedded and 
> client/server mode when the positioning before the first row or after the 
> last row.
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-517
>          URL: http://issues.apache.org/jira/browse/DERBY-517
>      Project: Derby
>         Type: Bug
>   Components: Network Client
>     Reporter: Fernanda Pizzorno
>     Assignee: Fernanda Pizzorno
>  Attachments: DERBY-517-2.diff, DERBY-517-2.stat, DERBY-517.diff, 
> DERBY-517.stat
>
> RecordSet - relative(int rows) behaves different in embedded and 
> client/server mode when the positioning before the first row or after the 
> last row.
> The embedded driver shows the behaviour described in the JDBC 3.0 
> specification, returning false and postitioning in either before first or 
> after last. While the client/server driver returns true and 
> incrementing/decrementing the current row by "rows" and not setting the 
> position to either before first of after last.
> I have run a test with a result set with 10 rows, where I positioned in row 5 
> and moved +20 and - 20 using relative(int rows). With the embedded driver the 
> method returned false, the current row was set to 0 and isAfterLast() and 
> isBeforeFirst() returned true (for +20 and -20 respectively). With the 
> client/server driver the method returned true, the current row was set to 25 
> and -15 (for +20 and -20 respectively) and isAfterLast() and isBeforeFirst() 
> returned false.
> I have also run a test as the first one but running next() 5 times instead of 
> absolute(5) for postitioning in row 5, and then relative(20) produced the 
> expected results with the client/server driver.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

Reply via email to