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>:
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
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
_______________________________________________
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
