Skip to content
RED SAGSkills
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;
Choose one answer

Discussion 0

Join free to post in the discussion.

Related questions