Michelle Caisse wrote:
The Derby Developer's Guide states:
Rows inserted to the table may become visible in the result set. (p. 57)
If the inserted row satisfies the query predicate, it may become
visible in the result set. (p. 58)
What does "may" mean? Are there no circumstances in which the insert is
guaranteed to become visible in the result set?
-- Michelle
This looks similar to a discussion on derby-dev for update operations
and open cursors a few months back:
http://www.nabble.com/Updating-rows-with-an-open-cursor...what-is-the-expected-behavior--t3908926.html#a11083342
In that discussion, it became clear that the cursor would return rows
that satisfied the query at the time the row was retrieved. That could
be any point in time between the cursor creation and when the cursor
reached that record in the result set. Hence, updates *may* be visible
to open cursors, but with no guarantees.
--
Jørgen Løland
