We revisited Kleppmann’s
work on MySQL isolation
levels and found surprising behavior in 8.0.34.
MySQL’s REPEATABLE READ
not only exhibits G2-item, G-single, and lost update,
but also violates internal consistency and Monotonic Atomic
View. It satisfies neither Adya’s
Repeatable Read nor the ambiguous ANSI
SQL definition. We also discovered AWS RDS MySQL clusters routinely violate
Serializability at the SERIALIZABLE
isolation level.
MySQL 8.0.34
2023-12-18