Dan Kennedy <danielk1...@gmail.com> wrote: On 10/06/2017 11:58 PM, Richard Hipp wrote: > >> On 10/6/17, Jens Alfke <j...@mooseyard.com> wrote: >> >>> Thanks for posting this — my adaptation of that sample code in my project >>> had the same bug. >>> >>> I’m not sure how the SQL in your application gets generated, but if you >>> allow untrusted SQL, it’s still possible to create a query that can cause >>> the rank function to crash. >>> >> We (developers) have already made a note to update the code example in >> the documentation to include lots of validity checking on the >> matchinfo() blob. >> > > New version on the draft website here: > > http://sqlite.org/draft/fts3.html#appendix_a > > Any further bug reports or feedback welcome! > > Dan.
A few corrections on this page about FTS (hopefully not too nit-picky): 1) === BEGIN QUOTE === -- ("driver" may also appear in the title, but this alone will not satisfy the. -- query criteria). === END QUOTE === There should not be a dot in "the." 2) === BEGIN QUOTE === putting the keyword "NEAR" between two phrase === END QUOTE === two phase -> two phrases 3) === BEGIN QUOTE === The do not influence the results === END QUOTE === The do no -> They do not... Regards Dominique _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users