|Subject||RE: [firebird-support] READ ONLY READ COMMITTED and consistency|
>I say again:
> True for REPEATABLE READ and SNAPSHOT TABLE STABILITY isolation levels,
> not true for READ COMMITTED. A RC transaction sees everything that is
> committed in the database, at all times. Perhaps you are confusing
> this with what *the application* sees in its client-side
> buffers....your Delphi datasets, for example, will continue to display
> what was stored in their buffers until you requery.
> Is it possible for my RO/RC transaction to see one of the two rowsintervening
> affected by the intervening UPDATE in its state *****before the
> COMMIT****, and the other in its state after that COMMIT?My answer is no and you agree with me (above) - An RC transaction sees what
He's asking if you see it BEFORE the commit.
So a select statement will NOT see something which is NOT committed.