Re: BUG(?) in FTS5
mailing lists <mailinglists-/[email protected]>
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
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 <[email protected]>: > > >> On Jan 23, 2020, at 6:47 AM, mailing lists <[email protected]> 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users