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

Reply via email to