What is Dirty Read, Phantom Read, and Non-repeatable Read?

Answer: Dirty read, phantom read, and non-repeatable read are problems of concurrent transactions.

• Dirty read: Transaction A reads data that has been modified by transaction B but has not been submitted, and transaction B is rolled back.
• Phantom read: If the same data is read in two consecutive periods, inconsistent results may occur.
• Non-repeatable read: The data queried twice in the same transaction is different.