From: Ann W. Harrison
Date: April 1 2009 2:24pm
Subject: Re: statement-level atomicity
List-Archive: http://lists.mysql.com/falcon/659
Message-Id: <49D37925.6090706@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset=ISO-8859-1
Content-Transfer-Encoding: 7BIT

Jim Starkey wrote:
> "Repeatable read" and "read committed", definition, are not consistent 
> and not isolated, so, no, they aren't ACID.
> 

Jim's talking about the standard form of Repeatable Read which has
phantoms - newly committed records will be seen, though no records
that have been read will be deleted or updated.  The MVCC version of
repeatable read is repeatable.

Cheers,

Ann