Updating a Standalone FTS5 Row Replaces Terms
@prranitarora▲ 11 net votes
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.