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
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
