Phantom Read

A phantom read occurs when repeating a predicate-based query in a transaction returns a different set of matching rows because another transaction changed the qualifying data. Repeating a count of open orders can reveal an additional order even though no previously returned row changed.

Prevention depends on the database’s isolation implementation, such as snapshot behavior or predicate-range locking. Locking only individual rows already returned may not protect the missing range.