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:
Non-repeatable read(fuzzy read) is the read of committed…