Quantcast

FTS5 not working

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

FTS5 not working

Domingo Alvarez Duarte
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';

===

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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: FTS5 not working

Dan Kennedy-4
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
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Loading...