On 03/15/2017 06:00 AM, Domingo Alvarez Duarte wrote:
Hello !
I just downloaded the
http://www.sqlite.org/snapshot/sqlite-snapshot-201703062044.tar.gz
compiled it with fts5 enabled and then tested it with this:
===
CREATE VIRTUAL TABLE email USING fts5(body);
insert into email(body) values('hello over there');
select rowid, body from email where body match 'over';
With FTS5, the left hand side of the match operator must be the table
name, not a column. So you can do:
SELECT rowid, body FROM email WHERE email MATCH ('body:over');
or
SELECT rowid, body FROM email('body:over');
Dan.
===
And get this:
===
sqlite3 < test-fts.sql
Error: near line 3: unable to use function MATCH in the requested context
===
Cheers !
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users