Skip to content

FTS5 colon filter crash in memory search #2

@aj-nt

Description

@aj-nt

Bug

FTS5 interprets word:... patterns in MATCH queries as column filters. Since memories_fts only has a content column, any search term containing a colon (e.g., layer:4, agent:primary, http://localhost) crashes with "no such column".

Location

  • tools/memory_tool.pyMemoryStore.search() method

Fix (already applied)

Commit 1f1339f on dogfood: wrap MATCH query terms in double quotes + LIKE fallback. However, this should be ported upstream or at minimum have a regression test.

Impact

Any memory search containing colons fails with an unhandled sqlite3 error. This includes URLs, key:value pairs, and any technical terms with colons.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingmemoryMemory system bugs and improvements

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions