6 questions
1
vote
1
answer
298
views
Unclear about how repeatable-read works in RDBMS [duplicate]
I'm uncertain about how repeatable-read operates in RDBMS. I initially thought it functions similarly to Git branching, where an exact copy of the current database is utilized. However, I'm puzzled by ...
- 619
1
vote
1
answer
1k
views
Next-key lock explication - Primary key for range
I have the following query, and I wanted to use the diagram to CONFIRM IF I UNDERSTAND IT RIGHT:
SELECT * FROM table WHERE pk > 99;
"pk" is the primary key
I am having trouble ...
user19481364
4
votes
2
answers
1k
views
"Non-repeatable read" and "phantom read" occur with 'SERIALIZABLE' isolation level (MySQL)
I experimented if non-repeatable read and phantom read occur or not with SERIALIZABLE on MySQL but against my expectation, both non-repeatable read and phantom read actually occurred with SERIALIZABLE....
- 43.5k
0
votes
2
answers
1k
views
How to enforce a phantom read in PostgreSQL?
I'm currently writing an article about different transaction isolation levels and want to show the dirty read / non-repeatable read / phantom read.
Dirty reads are impossible to show as PostgreSQL ...
- 139k
10
votes
3
answers
6k
views
PostgreSQL's Repeatable Read Allows Phantom Reads But its document says that it does not allow
I have a problem with Postgresql repeatable read isolation level.
I did make an experiment about repeatable read isolation level's behavior when phantom read occurred.
Postgresql's manual says "...
- 185
31
votes
9
answers
18k
views
How to produce "phantom read" in REPEATABLE READ? (MySQL)
Using "repeatable read", it should be possible to produce a phantom read, but how? I need it for an example teaching CS-students.
I think that I must make a "SELECT ... WHERE x<=888&...
- 4,115