Skip to content
RED SAGSkills
medium10 pts · first answer countsconcurrencysql

Optimistic lock update hits 0 rows

Your service saves a document with this statement and the database reports "UPDATE 0". What does that mean?

UPDATE documents
SET body = $1, version = version + 1
WHERE id = $2 AND version = $3;
Choose one answer