# NousResearch/hermes-agent · Fix unsafe LIKE pattern in FTS shadow table demotion

## Open now

- 1 issue, 1 PR open on GitHub.
- #109748: \[bug\] legacy FTS demotion selects tables by unescaped LIKE prefix and can DROP unrelated tables
- PR #109755: fix(state): demote legacy FTS shadows by exact whitelist, not unescaped LIKE prefix

A bug was identified where legacy FTS shadow table demotion used an unescaped LIKE prefix, risking unintended selection of unrelated tables. Fixes replace this with exact name or whitelist matching.

## TL;DR

- 3 member(s): 1 open issue(s), 0 closed issue(s), 1 open PR(s), 0 merged PR(s), 1 PR(s) closed without merging.
- No fix has been merged to main; one or more PRs were attempted (see below).
- **Recommended:** review the prior/competing PR(s) below. A fix was attempted but not merged; your case may extend or revive that work.

## Maintainer resolution verdict

- Internal-tracker verdict over this cluster's issue members: `unresolved`. This is distinct from the fix status above. Weigh it yourself.

## How this cluster was grouped

- Link evidence (`STRUCTURAL_SPANNING`): every member is connected by structural evidence: shared changed files, or a closing/superseded reference.
- Pairwise link density `0.67`: the share of member 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.

## Open related issues

- #109748: \[bug\] legacy FTS demotion selects tables by unescaped LIKE prefix and can DROP unrelated tables

## Prior & competing PRs

- **#109755: fix(state): demote legacy FTS shadows by exact whitelist, not unescaped LIKE prefix**. open
  - maintainer direction: category `silent_close`; implication `active`
  - files: `hermes_state_search.py`, `tests/test_fts_demote_selection_whitelist.py`
- **#119725: fix(state): demote FTS shadows by exact name, not unescaped LIKE prefix**. closed without merge
  - maintainer direction: category `superseded_by_pr`; implication `superseded`; refs `#109755`

## Fix status

- No merged fix on record.
- Subsystem: `agent`