dcsimg

What is a phantom insert?

Joe Sam Shirah

One of the ISO-ANSI SQL defined "phenomena" that can occur with concurrent transactions. If one transaction selects a set of rows, then another transaction inserts rows that meet the same criteria, when the first transaction re-executes the query, a different set results. This is an inconsistency problem within a transaction and addressed by isolation levels.