On 04/18/2017 02:00 AM, Jonathan Gaillard wrote:
I have a db where I have a query returning results from something I believe is deleted already from a FTS5 table. This is a normal FTS5 table, not a contentless one so I used the normal DELETE.Only after I run: INSERT INTO MyFTSTable(MyFTSTable, rank) VALUES('automerge', 0); INSERT INTO MyFTSTable(MyFTSTable, rank) VALUES('merge', 500); Does the query then start returning the results without the deleted items. Is this normal fts behavior?
Doesn't sound right. Can you share a database that demonstrates the problem? Dan. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
