A phenomenon where running the same query twice within one transaction returns a different number of rows because another transaction committed in between.
If another transaction inserts and commits a new row after the first query runs, that row appears like a "phantom" in the second query's results. It can be prevented using the SERIALIZABLE isolation level, which is stricter than REPEATABLE READ.
© 2026 ITBGM