> On Jul 11, 2017, at 10:35 AM, Richard Hipp <[email protected]> wrote: > > Generally speaking, FTS4 (and FTS3 and FTS5) requires no more than one > MATCH operator in the WHERE clause for each FTS4 table in the FROM > clause, and that one MATCH operator must be a conjunct.
By “conjunct” you mean it’s ANDed with the remaining query terms? Is this documented? I was looking through the FTS3/4 docs this morning but didn’t see anything about restrictions on use of MATCH expressions. Thanks for the explanation. I think we’ll have to push this restriction up through our API to limit the ways in which the application can specify FTS queries. —Jens _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
