Hi Jens, the MATCH operator is not inside an OR expression. The MATCH operator is in an AND expression, only the rowid request is in an OR expression.
Regards, Hartwig PS: In FTS5 since version 3.30.1 also the MATCH operator is allowed in OR statements (try SELECT PlayersFTS.rowid FROM PlayersFTS WHERE (PlayersFTS MATCH 'LastName:B') OR (PlayersFTS MATCH 'FirstNames:2');) > Am 2020-01-23 um 17:51 schrieb Jens Alfke <j...@mooseyard.com>: > > >> On Jan 23, 2020, at 6:47 AM, mailing lists <mailingli...@skywind.eu> wrote: >> >> The following SELECT statement fails with the error "unable to use function >> MATCH in the requested context": > > This is an annoying but documented limitation of FTS, not a bug. The MATCH > operator can’t be used inside an OR expression. It has to be at top-level or > in an AND. > > —Jens > _______________________________________________ > 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
