$ ./guess_the_languageSQL & Databases
SQL & Databases · medium · #28

Which anomaly did T1 experience?

T1: SELECT price FROM item WHERE id = 7;  -- 10
T2: UPDATE item SET price = 12 WHERE id = 7;
T2: COMMIT;
T1: SELECT price FROM item WHERE id = 7;  -- 12
  1. Non-repeatable read
  2. Phantom read
  3. Uncommitted dirty read
  4. Write skew on two rows
Re-reading the same row inside one transaction gave a different committed value; REPEATABLE READ prevents it.
Play SQL & Databases ▸