Skip to main content

Module operator

ff_backend_sqlite::queries

Module operator 

Source
Expand description

SQL statements for Wave 9 operator-control ops (RFC-023 Phase 3.2).

Mirrors ff-backend-postgres/src/operator.rs. SQLite-specific translations:

  • jsonb_set(raw_fields, '{k}', to_jsonb($::text)) → json_set(raw_fields, '$.k', ?). raw_fields is TEXT JSON (JSON1), not JSONB.
  • raw_fields->>'replay_count' → json_extract(raw_fields, '$.replay_count'). Cast to INTEGER happens via SQLite’s implicit numeric coercion inside arithmetic.
  • FOR NO KEY UPDATE / FOR UPDATE are no-ops — the enclosing BEGIN IMMEDIATE holds the RESERVED lock for the full read-modify-write window.
  • ExecutionId UUIDs are bound as 16-byte BLOBs (see backend::split_exec_id), not stringified UUIDs as on PG.