"insert or replace" doesn't trigger updating of the FTS index but only 'rebuild' do it:
sqlite> .s address_fts0 CREATE VIRTUAL TABLE "address_fts0" USING fts4(content="view_address_exists", "sys_title:hash"); sqlite> select rowid,"sys_title:hash" from address_fts0 where "sys_title:hash" match 'e7d4683bb2'; rowid|sys_title:hash 64402|e9b4d0bcb5 sqlite> insert or replace into "address_fts0" (rowid, "sys_title:hash") select rowid,"sys_title:hash" from "view_address_exists" where sys_id=64402; sqlite> select rowid,"sys_title:hash" from address_fts0 where "sys_title:hash" match 'e7d4683bb2'; rowid|sys_title:hash 64402|e9b4d0bcb5 sqlite> INSERT INTO address_fts0(address_fts0) VALUES('rebuild'); sqlite> select count(*) from address_fts0 where "sys_title:hash" match 'e7d4683bb2'; count(*) 0 -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users