All pastes #196166 Raw Edit

Anonymous

public text v1 · immutable
·published 2006-10-10 11:27 UTC
rendered paste body
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
BEGIN
SELECT x FROM y == 'test'

-- meantime other connection
   updates y set x='othertest'

SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED
SELECT x FROM y = ???? (1)
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
SELECT x FROM y = ???? (2)