Cairn

FTS5 query sanitization: hyphens, operators, quoting

NousResearch/hermes-agent · cluster 1770 · agent

Data as of

7 open items. Fix merged in #1776. Check it covers your case.

The short answer

2open issues
5open PRs
16items grouped
Known?
Yes. 16 related items grouped here, 3 issues already closed.
Fix event
A fix was merged to main in PR #1776. Check it covers your case. No release data is tracked.
Tracker
The maintainers' tracker marks this partially resolved, deciding PR #1776. That is separate from the fix event.
Still open
2 issues and 5 PRs.

These issues and fixes all concern malformed or mishandled FTS5 queries involving hyphenated tokens, stacked/adjacent boolean operators, and dotted or special-character terms that cause silent empty results or crashes. The work spans session search, fact_store, and holographic memory components.

Open issues2

  • Issue#14024[Bug]: fact_store search action fails with "no such column" error on hyphenated queries (FTS5 tokenization)
  • Issue#56871session_search silently returns empty for stacked/adjacent FTS5 boolean operators (a AND OR b, AND NOT x)

Open PRs5

  • PR#14033fix(memory): sanitize holographic fact_store FTS queries
  • PR#14262fix(memory/holographic): sanitize hyphenated tokens in FTS5 queries
  • PR#14794fix(tools): auto-quote hyphenated tokens in fact_store FTS5 queries
  • PR#39663fix(memory): sanitize FTS5 queries to prevent crashes on hyphenated tokens (#14024)
  • PR#91075fix(state): collapse stacked/adjacent FTS5 boolean operators instead of a silent empty search

Fixes on record

Merged to main. A stamp counts the issues a fix is linked to.

  • #1776 fix: handle hyphenated FTS5 queries and preserve quoted literals

    merged to main

    files: hermes_state.py, tests/test_hermes_state.py

5 PRs closed without merging

From the close comments: closed without comment 2 · done elsewhere 1 · duplicate 1 · superseded by another PR 1

  • #1773 fix: handle hyphenated FTS5 queries and preserve quoted literals · closed without comment
  • #1777 fix(search): handle hyphenated queries and preserve quoted literals in FTS5 · done elsewhere → #1776
  • #7820 fix: sanitize hyphenated session-search FTS queries · closed without comment
  • #56872 fix(agent): collapse stacked FTS5 boolean operators in session search · superseded by another PR → #48212
  • #64209 fix(holographic): hyphenated-identifier search returned 0 results · duplicate → #14033, #14024, #39664
Closed issues · 3
  • Closed#1770session_search mishandles hyphenated FTS5 queries and strips quoted literals
  • Closed#7824Session search broad FTS query can fail on hyphenated OR terms
  • Closed#21102Holographic memory: `fact_store action="search"` silently returns 0 results when query contains FTS5 operator characters (e.g. hyphens)
How this cluster was grouped
  • Link evidence (partly structural links): some members are connected by structural evidence (shared changed files, or a closing/superseded reference); the rest are joined by an automated relevance judgement over their text.
  • Members outside that structural core may belong to a different underlying problem.
  • Pairwise link density 0.11: the share of item pairs that carry a link, counting a structural link in full and a relevance-only link at 0.36. 1.00 means every pair is linked.

Pick up a Lab task

Check whether a fix covers the open issues here, with your own agent. Bring back evidence for maintainers.

Open the Lab

At a glance

Subsystem
agent
Merged PRs
#1776
Closed issues
3
Attempts
5 PRs closed without merging
Fix link checked
17 Mar 2026. This confirmation is old and may be out of date (a revert or reopen would not have invalidated it here); re-verify.

For your agent

The same facts, typed.

cluster/1770.json
cluster/1770.md