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, technically, a non-repeatable read?

April 26, 2017non-repeatable read Technically

0

Posted

What is, technically, a non-repeatable read?

1 Answer

0

Posted

Location: http://www.jguru.com/faq/view.jsp?EID=59026 Created: May 29, 2000 Modified: 2000-05-29 00:11:45.433 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 reads a row, then another transaction updates or deletes the row and commits, the first transaction, on re-read, gets modified data or no data. This is an inconsistency problem within a transaction and addressed by isolation levels.