> On 11 Mar 2015, at 4:56pm, Milan Roubal <roubal at keyserver.cz> wrote:
>
> I am also facing problem with sqlite closed by windows because of crash. On
> same data this query crash:
>
> select load_extension("libstringmetrics.dll");
> select a.vorname, b.vorname, a.nachname, b.nachname,
> stringmetrics("qgrams_distance","similarity",a.nachname, b.nachname, "")
> nach_dist
> from r2 a, allUsers b
> where
> a.vorname like 'r%' and b.vorname like 'r%' and
> round(nach_dist) between 50 and 100
> ;
>
> The first query is able to pass on some small sample, but not on all my data.
> I am trying to find what concrete string comparison is crashing it, but it is
> slow with crashes. Is there any way how to start logging the calls of the
> library to find the exact data that are causing the crash?
Try this command
select a.vorname, b.vorname, a.nachname, b.nachname,
55 nach_dist
from r2 a, allUsers b
where
a.vorname like 'r%' and b.vorname like 'r%' and
round(nach_dist) between 50 and 100
If it does not crash then the problem is in your stringmetrics library.
Simon.
