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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
