Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is a phantom insert?

April 26, 2017insert Phantom

0

Posted

What is a phantom insert?

1 Answer

0

Posted

Location: http://www.jguru.com/faq/view.jsp?EID=59028 Created: May 29, 2000 Modified: 2000-05-29 00:12:34.473 Author: Joe Sam Shirah (http://www.jguru.com/guru/viewbio.jsp?EID=42100) 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.