Search Postgresql Archives

Re: 'Official' definition of ACID compliance?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux