Phantom Reads

Difficulty: Advanced

Question

What is a Phantom Read?

Answer

When a transaction reads a set of rows, then another transaction INSERTS a new row that fits the criteria, so when the first transaction reads again, it sees a 'phantom' row.

Concepts covered

Isolation Levels