Thanks. Is there a difference between these statements with respect results, performance etc. or are both statements describe the same thing?
a) SELECT * FROM NamesFTS WHERE FTS MATCH 'LastName:alpha FirstNames:beta'; b) SELECT * FROM NamesFTS WHERE LastName MATCH 'alpha' AND FirstNames MATCH 'beta'; Regards, Hartwig > Am 2019-11-01 um 07:55 schrieb Dan Kennedy <danielk1...@gmail.com > <mailto:danielk1...@gmail.com>>: > > > On 1/11/62 03:03, mailing lists wrote: >> Hi Dan, >> >> I did not know that. What was the reason that it did not work before 3.30? > > > The implementation of the xBestIndex method of fts3/4, and fts5 prior to > 3.30.0, only allowed a single MATCH constraint to be processed and passed > through to xFilter. Fts5 now uses a more complicated method to pass > constraints between those two methods, which allows the details of multiple > MATCH constraints to be passed through. > > Dan. > > > > >> >> Regards, >> Hartwig >> >>> Am 2019-10-31 um 19:16 schrieb Dan Kennedy <danielk1...@gmail.com >>> <mailto:danielk1...@gmail.com>>: >>> >>> >>> On 1/11/62 00:32, mailing lists wrote: >>>> For normal tables I can use something like: >>>> >>>> SELECT * FROM Names WHERE FirstNames=? AND or OR LastName=?; >>>> >>>> For FTS tables I can only use >>>> >>>> SELECT * FROM FTSNames WHERE FirstNames MATCH ? OR LastName MATCH ?; AND >>>> is not supported (still do not know why) >>>> >>>> Is there any possibility to use prepared statements for FTS tables with an >>>> AND condition? I like to prevent code injection. >>> As of 3.30.0, should work with FTS5. >>> >>> Dan. >>> >>> >>>> Regards, >>>> Hartwig >>>> >>>> _______________________________________________ >>>> sqlite-users mailing list >>>> sqlite-users@mailinglists.sqlite.org >>>> <mailto:sqlite-users@mailinglists.sqlite.org> >>>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >>> _______________________________________________ >>> sqlite-users mailing list >>> sqlite-users@mailinglists.sqlite.org >>> <mailto:sqlite-users@mailinglists.sqlite.org> >>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@mailinglists.sqlite.org >> <mailto:sqlite-users@mailinglists.sqlite.org> >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> <http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > <mailto:sqlite-users@mailinglists.sqlite.org> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > <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
