All pastes #196165 Raw Edit

Unnamed

public text v1 · immutable
·published 2006-10-10 11:26 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 UNCOMMITTED
SELECT x FROM y = ???? (1)
SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ
SELECT x FROM y = ???? (2)