[ 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