medium10 pts · first answer countstransactionsoptimistic-locking
Version check updates no rows
An app uses optimistic locking. It read a profile with version = 7 and now runs the statement below, which reports 0 rows updated. What does it mean?
UPDATE profiles SET name = $1, version = version + 1 WHERE id = $2 AND version = 7;
Discussion 0
Join free to post in the discussion.
Related questions
- Durability in ACIDDatabase Administrator
- Why a write-ahead log existsDatabase Administrator
- What ROLLBACK undoesDatabase Administrator
- What C in ACID meansDatabase Administrator
- What I in ACID meansDatabase Administrator
- Statements without BEGINDatabase Administrator
- What a phantom read isDatabase Administrator
- PostgreSQL default isolationDatabase Administrator