"Non-repeatable read" and "phantom read" occur with 'SERIALIZABLE' isolation level (MySQL)
I experimented if non-repeatable read and phantom read occur or not with SERIALIZABLE on MySQL but against my expectation, both non-repeatable read and phantom read actually occurred with SERIALIZABLE. These below are the definitions of non-repeatable read and phantom read:…