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.
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 <[hidden email]>:
>> On Jan 23, 2020, at 6:47 AM, mailing lists <[hidden email]> 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.
> sqlite-users mailing list
> [hidden email] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users