A phantom read occurs when, in the course of a transaction, two identical queries are executed, and the collection of rows returned by the second query is different from the first. This can occur when range locks are not acquired on performing a SELECT.
How can a Phantom read be a problem ever ?
In my view when data is chnaged , the second query will definately return new things .
Can anybody let me know this , why this is said to be a problem ??
0
