1, submitted under the isolation level of reading:



2, under the repeatable read isolation level:



3, question:




So the question comes, what kind of phenomenon is the phantom read?

CodePudding user response:

Dirty read and illusions of similarities and differences, is simply this:
Dirty read is the current transaction to other transactions uncommitted data (change),
Phantom read is the current transaction to other transactions submitted data (add or delete),