|Subject||RE: [firebird-support] READ ONLY READ COMMITTED and consistency|
> > > Is it possible for my RO/RC transaction to see one of the twoNo I mean transaction. The transaction where your initial select is executed
> > > rows affected by the intervening UPDATE in its state before the
> > > intervening COMMIT, and the other in its state after that COMMIT?
> > No - you select transaction is started before the update and will
> > see data committed to that point. It will never see the updated from
> > subsequent update until it commits and re-reads
> I think you mean SELECT *statement*, not *transaction*?
will continue to see only the records which existed at the time the
>only if you commit the intervening transaction
> Because for a READ COMMITTED transaction, it is not true. My SELECT is
> only one of possibly several statements inside a transaction, and by
> specifying an isolation level of READ COMMITTED I accept to see new
> record versions of subsequently committed transactions:
> Is it possible for my RO/RC transaction to see one of the two rowsi.e. you said 'before the commit'.
> affected by the intervening UPDATE in its state
> before the intervening COMMIT, and the other in its state after
> that COMMIT?
I read this to mean before the commit of the update. in which case my
response stands, if this is a wrong interpretation and you mean "before the
commit of the select statement transaction, then that's different.