Using the example from the documentation at https://www.sqlite.org/fts5.html
I thought this worked in a previous version.
CREATE TABLE tbl(a INTEGER PRIMARY KEY, b, c);
CREATE VIRTUAL TABLE fts_idx USING fts5(b, c, content='tbl', content_rowid='a');
CREATE TRIGGER tbl_ai AFTER INSERT ON tbl BEGIN
? INSERT INTO fts_idx(rowid, b, c) VALUES (new.a, new.b, new.c);
END;
CREATE TRIGGER tbl_ad AFTER DELETE ON tbl BEGIN
? INSERT INTO fts_idx(fts_idx, rowid, b, c) VALUES('delete', old.a, old.b,
old.c);
END;
CREATE TRIGGER tbl_au AFTER UPDATE ON tbl BEGIN
? INSERT INTO fts_idx(fts_idx, rowid, b, c) VALUES('delete', old.a, old.b,
old.c);
? INSERT INTO fts_idx(rowid, b, c) VALUES (new.a, new.b, new.c);
END;
REPLACE INTO tbl VALUES(1,'foo','bar');
Error: near line 14: SQL logic error or missing database
