Imperial-Computing-Notes icon indicating copy to clipboard operation
Imperial-Computing-Notes copied to clipboard
verified publisher icon OliverKillane

Phantom Read definition inconsistencies

Open avzh1 opened this issue 2 years ago • 1 comments

image

avzh1 avatar Mar 21 '23 18:03 avzh1

Will improve the definition -> though I need to read a bit more (SELECT .. WHERE ... changing implies a tuple was changed -> non-repeatable read, but the bag of tuples returned has changed -> phantom read? This is a hard one)

I will overhaul transactions post-exams and get official answers on this. Currently the definitions feel hazy at best.

OliverKillane avatar Mar 22 '23 09:03 OliverKillane