To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=102625
User oj changed the following: What |Old value |New value ================================================================================ Status|UNCONFIRMED |RESOLVED -------------------------------------------------------------------------------- Resolution| |FIXED -------------------------------------------------------------------------------- ------- Additional comments from o...@openoffice.org Mon Dec 6 08:55:44 +0000 2010 ------- The reason why we need the first one is to fetch the complete row. The requering of a row should now only happen when you move the cursor to a place where the cursor from the rowset already was. The rowset uses a forward only cursor. The keyset which is used below the rowset fetch rows by key but only when needed. This I changed. In former versions all rows was refetched even the the cursor from the rowset was still valid. So in our case the first fetch like "select * from key = ?" only happen when you move the cursor to a position where the forward-only cursor from the rowset already visited and the position is not in the window (fetch size). A second way to go would be to check if the cursor from the rowset can be moved back and forward. But history shows that some cursor say "yes we can", but the don't ;-) In my test no call was done for "select * from y where key = ?" when displaying the table. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org