Re: what is a phantom read ?
gk wrote:
--
Lew
Light a man a fire and you warm him for an hour.
Set a man on fire and you warm him for the rest of his life.
Don't quote sigs.
Don't quote sigs.
Do trim your posts.
Don't quote sigs.
Pay attention to what you're posting. Be conscious, and show some effort.
Don't quote sigs.
Does PHANTOM READ and NON REPEATABLE READ are same thing ?
http://en.wikipedia.org/wiki/Isolation_(database_systems)
I read in Jguru.com about NON REPEATEABLE READ as follows
"....One of the ISO-ANSI SQL defined "phenomena" that can occur with
concurrent transactions. If one transaction reads a row, then another
transaction updates or deletes the row and commits, the first
transaction, on re-read, gets modified data or no data. This is an
inconsistency problem within a transaction and addressed by isolation
levels...."
BUT this is similar to PHANTOM READ we discussed so far !
Does NON REPEATEABLE READ and PHANTOM READ are same thing ? I don't
find the difference.
The Wikipedia article up at the start of this thread addresses your question.
http://en.wikipedia.org/wiki/Isolation_(database_systems)
"Repeatable reads (phantom reads)"
On 05/20/2010 09:14 AM, Jeff Higgins wrote:
Did you read the entire article?
<http://en.wikipedia.org/wiki/Isolation_(database_systems)>
--
Lew
Don't quote sigs.