A transaction isolation level indicating that dirty reads, non-repeatable reads and phantom
reads are prevented. This level includes the prohibitions in
TRANSACTION_REPEATABLE_READ and further prohibits the situation where one
transaction reads all rows that satisfy a WHERE condition, a second transaction
inserts a row that satisfies that WHERE condition, and the first transaction
rereads for the same condition, retrieving the additional "phantom" row in the second read.
A transaction isolation level indicating that dirty reads, non-repeatable reads and phantom reads are prevented. This level includes the prohibitions in
TRANSACTION_REPEATABLE_READ
and further prohibits the situation where one transaction reads all rows that satisfy aWHERE
condition, a second transaction inserts a row that satisfies thatWHERE
condition, and the first transaction rereads for the same condition, retrieving the additional "phantom" row in the second read.