Phantom Read
A transaction re-executes a query returning a set of rows that satisfy a search condition and finds that the set of rows satisfying the condition has changed due to another recently-committed transaction.
- Non-repeatable reads concern a single row being updated or deleted by another transaction
- Phantom reads involve new rows being added or existing rows being removed