Advertisement
Guest User

Untitled

a guest
Apr 24th, 2014
35
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.49 KB | None | 0 0
  1. SESSION 1 SESSION 2
  2. -------------------------------- --------------------------------------
  3. SELECT count(*) FROM test;
  4. => 10
  5. INSERT INTO test VALUES ('x');
  6.  
  7. SELECT count(*) FROM test;
  8. => 10 with read committed/serializable
  9. => 11 with read uncommited (dirty read)
  10. COMMIT;
  11.  
  12. SELECT count(*) FROM test;
  13. => 10 with serializable
  14. => 11 with read uncommitted/read committed
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement