@MichaelC: the update statement with the case in it seems syntactically correct, but it updates ALL rows in the table, not just those where the condition is met.

MyRocks supports both shared and exclusive row locks. MyRocks uses the lock manager from the RocksDB library to support locking rows during updates within a transaction. INSERT and UPDATE statements ...