Subject Re: [firebird-support] READ ONLY READ COMMITTED and consistency
Author Ann W. Harrison
Michael Ludwig wrote:
> In a transaction configured with READ ONLY READ COMMITTED, is it
> possible to see just part of a commit?
>

Yes, of course. That's what the READ COMMITTED mode does - reads
the most recent version of a record at the time of the read.
If you read the same record twice, you may see different values.
If you count the same set of records twice, you may get different
numbers. That's why I recommend REPEATABLE READ, which, in
Firebird is not only repeatable, but excludes phantoms.

Good luck,

Ann