Databases
Bug Report
Wallet double-spend under READ COMMITTED: a lost update between SELECT and UPDATE
Two withdrawals hit the same wallet within milliseconds, both saw enough balance, and the user spent more than they had. The code ran inside a transaction, but READ COMMITTED does not protect a read-then-write. We compare atomic updates, row locks and stricter isolation.