Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Phantom Read definition inconsistencies #12

Open
avzh1 opened this issue Mar 21, 2023 · 1 comment
Open

Phantom Read definition inconsistencies #12

avzh1 opened this issue Mar 21, 2023 · 1 comment
Labels
60029 - Data Processing Systems Needs Improvement Confusing or poorly detailed content or diagrams

Comments

@avzh1
Copy link

avzh1 commented Mar 21, 2023

image
@OliverKillane OliverKillane added 60029 - Data Processing Systems Needs Improvement Confusing or poorly detailed content or diagrams labels Mar 22, 2023
@OliverKillane
Copy link
Owner

OliverKillane commented Mar 22, 2023 •
edited
Loading

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 OliverKillane mentioned this issue Oct 1, 2023
Open
6 tasks
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
60029 - Data Processing Systems Needs Improvement Confusing or poorly detailed content or diagrams
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@avzh1 @OliverKillane