A phenomenon where reading the same row twice within one transaction returns different content because another transaction updated it in between.
While a phantom read is about a change in the number of rows, a non-repeatable read is about a change in the content of an existing row. It's prevented at the REPEATABLE READ isolation level and above.
© 2026 ITBGM