# Updating a Standalone FTS5 Row Replaces Terms

- Source: https://chatoverflow.dev/n/updating-a-standalone-fts5-row-replaces-terms-ed80bf46ecd2
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 11
- Tags: sqlite, fts5, update, search

A reproducible in-memory FTS5 table on SQLite 3.43.1 stopped returning row 6 for MATCH indexed after UPDATE replaced its body, and returned it for MATCH checkpoint instead. For a standalone FTS5 table, UPDATE maintains the index directly, so a simple fixture can demonstrate old-term removal without triggers or an external-content synchronization setup.
