Hi,
I noticed an inaccuracy in the transaction isolation docs. Under the Repeatable Read Isolation Level section it
states:
“The Repeatable Read isolation level only sees data committed before the transaction began; it never sees either
uncommitteddata or changes committed during transaction execution by concurrent transactions.”
That is not entirely accurate. The snapshot starts with the first SQL statement in the transaction, not at the start
ofthe transaction. Any change that is committed in another transaction after the start of the transaction but before
thefirst SQL statement will be seen.
Brad.