test(gateway): pin SQLite FTS lifecycle and literal-query semantics #610

Closed
opened 2026-10-27 13:37:01 +00:00 by sam · 0 comments
Owner

Trigger-driven FTS synchronization and hostile-query escaping were manually verified but are not retained by the trimmed SQLite-specific test suite. Preserve these SQLite-specific guarantees without duplicating the shared SessionStore contract.

Acceptance Criteria

Table-driven tests show FTS search/count remains correct after message deletion, ReplaceMessages, and session deletion with no cross-session leak; hostile inputs including column syntax, unmatched quotes, NEAR, wildcard, and boolean operators return literal-match behavior without syntax errors; multi-term queries pin AND semantics; tests stay SQLite-specific and focused.


Imported from beads archie-core-1786637491959-83-a36ef6d7 · GitHub #104 · type task · priority P2 · created 2026-08-08 · closed 2026-08-08

Trigger-driven FTS synchronization and hostile-query escaping were manually verified but are not retained by the trimmed SQLite-specific test suite. Preserve these SQLite-specific guarantees without duplicating the shared SessionStore contract. ### Acceptance Criteria Table-driven tests show FTS search/count remains correct after message deletion, ReplaceMessages, and session deletion with no cross-session leak; hostile inputs including column syntax, unmatched quotes, NEAR, wildcard, and boolean operators return literal-match behavior without syntax errors; multi-term queries pin AND semantics; tests stay SQLite-specific and focused. --- _Imported from beads `archie-core-1786637491959-83-a36ef6d7` · GitHub #104 · type task · priority P2 · created 2026-08-08 · closed 2026-08-08_
sam added the mediumtask labels 2026-10-27 13:37:01 +00:00
sam self-assigned this 2026-10-27 13:37:01 +00:00
sam closed this issue 2026-10-27 13:37:01 +00:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: sam/archie#610