BEGIN;
SELECT * FROM accounts WHERE balance > 1000;
-- 此时事务B插入了一条balance=2000的记录并提交
SELECT * FROM accounts WHERE balance > 1000;
UPDATE accounts SET balance = balance + 100 WHERE balance > 1000;
SELECT * FROM accounts WHERE balance > 1000;
COMMIT;
关于事务A的三次SELECT结果,以下说法正确的是:
