Transactions

Dirty Read

English

Overview

A phenomenon where a transaction reads changes made by another transaction that hasn't been committed yet.

Details

If the original transaction is later rolled back, the reading transaction ends up having read data that never actually existed. This can only happen at the lowest isolation level, READ UNCOMMITTED, and is prevented at normal isolation levels.

More Database terms