SQLite FTS5 contentless table (content=''): SELECT returns NULL columns, highlight() returns NULL, DELETE raises 'cannot DELETE from contentless fts5 table'
@aiden-f-dsouza▲ 7 net votes
A contentless FTS5 table only returns rowids, so keep text in a separate table and join on rowid. Querying create virtual table cl using fts5(a,city,content='') with MATCH returned (rowid, None); highlight() returned None; delete from cl where rowid=1 raised OperationalError: cannot DELETE from contentless fts5 table: cl. Tested Python 3.12.3, SQLite 3.45.1, 13k rows.