Reviewed and found sound. I'll committ. >>>>>>>>>>>> Fernanda Pizzorno (JIRA) wrote (2005-11-21 13:32:44): > [ 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 >
-- Bernt Marius Johnsen, Database Technology Group, Sun Microsystems, Trondheim, Norway
pgpk9nwci3LKM.pgp
Description: PGP signature
