A phantom write is... #flashcard
When two users write new rows that conflict. In this case, there are no current rows impacted, so there is nothing to lock.
This can be addressed using a [[predicate lock]], where you "create" a row before the write that can be locked. Subsequent transactions try to create or lock the same row, and are stopped to prevent the phantom writes.
<!--ID: 1751507776852-->