Re: [Firebird-devel] Cursor stability in READ COMMITTED transactions

[Dmitry Y. <fir...@ya...>]

28.06.2014 11:54, Mark Rotteveel wrote:

> As far as I understood, the cursor stability fix was about changes made
> by the statement to its own data (eg an UPDATE or DELETE).

The fix was about changes made by statements located underneath the 
cursor (e.g. for select + insert/update/delete inside, with regular 
searched updates/deletes and select-based inserts belonging to the same 
category).

> The text I quoted defines significant changes as "if and only if it
> is independent of CR, and, had it been committed before CR was opened,
> would have caused the sequence of rows in the result set descriptor of
> CR to be different in any respect"

Here "independent" means everything but positioned update/delete, so it 
includes both "stacked" cases we fixed and "sequential" cases.


Dmitry