Re: 'Official' definition of ACID compliance?

On 1/5/06, Peter Eisentraut <peter_e@gmx.net> wrote:
> Am Donnerstag, 5. Januar 2006 17:01 schrieb Scott Marlowe:
> > The C stands for consistency.  Consistency means that only valid data
> > can be written to the database.  MySQL fails this test precisely because
> > it does / can write inconsistent data to the database.  Note that even
> > the latest version, 5.0.xx, by default, inserts a truncated number on
> > overflow.
>
> That's not at all what the C is about.  The C criterion means that a
> transaction transfers the database from one consistent state to another.  To
> my knowledge, MySQL does that.  On its way there, it silently alters data
> that would violate this consistency criterion, but this does not affect the
> fulfillment of the ACID criteria.
>

so the problem is that MySQL _forces_ a consistent state but in the
process it violates the integrity of the data

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)