phantom read

one transaction modifies rows matching a predicate that another ongoing transaction had read (P3)

“A phantom appeared when a row matching the WHERE clause was inserted mid-transaction.”