Expand description
SQL statements for suspend + claim_resumed_execution ops (RFC-023 Phase 2b.2.1).
Mirrors ff-backend-postgres/src/suspend_ops.rs statement-by-
statement with SQLite-dialect adjustments (jsonb โ TEXT,
$n โ ?n, FOR UPDATE elided under single-writer BEGIN IMMEDIATE).
Constantsยง
- INSERT_
SUSPEND_ DEDUP_ SQL - SELECT_
ATTEMPT_ EPOCH_ SQL - SELECT_
ATTEMPT_ LEASE_ EPOCH_ SQL - SELECT_
EXEC_ ATTEMPT_ INDEX_ SQL - SELECT_
EXEC_ STATE_ FOR_ RESUME_ SQL - SELECT_
SUSPEND_ DEDUP_ SQL - SELECT_
SUSPENSION_ CONDITION_ AND_ MAP_ SQL - UPDATE_
ATTEMPT_ CLAIM_ RESUMED_ SQL - UPDATE_
ATTEMPT_ SUSPEND_ SQL - UPDATE_
EXEC_ CORE_ RESUMABLE_ SQL - UPDATE_
EXEC_ CORE_ RUNNING_ SQL - UPDATE_
EXEC_ CORE_ SUSPEND_ SQL - UPDATE_
SUSPENSION_ MEMBER_ MAP_ SQL - UPSERT_
SUSPENSION_ CURRENT_ SQL - Binds: 1=partition, 2=execution_id, 3=suspension_id, 4=suspended_at_ms, 5=timeout_at_ms, 6=reason_code, 7=condition_json, 8=timeout_behavior.