phantom read

RU: фантомное чтение

A SQL-standard concurrency anomaly where a transaction re-executes a range query and finds rows that did not exist on the first execution because another transaction inserted or deleted them in between. One of the three anomalies defined by the SQL standard; prevented by REPEATABLE READ or SERIALIZABLE isolation.