With the latest FTS3 changes, fts3b-4.9 no longer passes. This short SQL emulates the test:
DROP TABLE IF EXISTS t4; CREATE VIRTUAL TABLE t4 USING fts3(c); INSERT INTO t4 (docid, c) VALUES (12, 'still testing'); UPDATE t4 SET docid = 14 WHERE docid = 12; Note that SQLite 3.6.20 chokes with "SQL logic error or missing database" on the last line. Everything runs fine with the latest FTS3. I can even query SELECT docid, * FROM t4 WHERE t4 MATCH 'still'; and it happily returns that the updated docid equals 14. Questions: * Is it now intentionally possible to update FTS3 DOCIDs? * Should I modify my tests accordingly? Thanks, Ralf _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
