With ICU extension does not work "NOT ..." construction. Below the example from FTS3 documentation:
sqlite> CREATE VIRTUAL TABLE docs USING fts3(); sqlite> INSERT INTO docs(docid, content) VALUES(1, 'a database is a software system'); sqlite> INSERT INTO docs(docid, content) VALUES(2, 'sqlite is a software system'); sqlite> INSERT INTO docs(docid, content) VALUES(3, 'sqlite is a database'); sqlite> SELECT * FROM docs WHERE docs MATCH 'database NOT sqlite'; a database is a software system sqlite> SELECT * FROM docs WHERE docs MATCH 'NOT sqlite'; Error: malformed MATCH expression: [NOT sqlite] Without ICU this work fine. Please check this on upstream version becouse I use some patches for FTS3 extension. -- 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