whether it qualified for the result set or not — until COMMIT. This prevents non-repeatable reads and phantom reads, but at a significant cost: you're locking rows you don't even care about.