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.

0 Comments  (click to add your comment)
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.