Isolation levels

From: Razvan Socol <rsocol_at_gmail.com>
Date: 15 May 2007 08:15:56 -0700
Message-ID: <1179242156.504604.114710@e51g2000hsg.googlegroups.com>

Please read the following posts by Craig Freedman, member of the SQL Server query execution team:

http://blogs.msdn.com/craigfr/archive/2007/04/25/read-committed-isolation-level.aspx
http://blogs.msdn.com/craigfr/archive/2007/05/02/query-plans-and-read-committed-isolation-level.aspx
http://blogs.msdn.com/craigfr/archive/2007/05/09/repeatable-read-isolation-level.aspx

Is the behaviour described in these posts the *correct* behaviour, as defined by ANSI SQL standards, considering the Read Committed and Repetable Read isolation levels, respectively ? Do other DBMS-s behave the same way ? I am aware that the behaviour would be different if we use snapshot isolation, but I'm interested how things *should* work without snapshot isolation.

I'd like some responses from people who know really well the ANSI SQL standard and the isolation levels defined in it.

Razvan Received on Tue May 15 2007 - 10:15:56 CDT