recall

← recall

phantom read term

transaction re-reads same query, gets different rows

Variant of write skew at the predicate level. New row appears (or disappears) between two queries within a transaction. Repeatable Read prevents row-level changes; Serializable prevents phantoms.

topics: consistency, databases

references: