On 2015-03-12 00:33, Simon Slavin wrote:
>> On 11 Mar 2015, at 10:54pm, Milan Roubal <roubal at keyserver.cz> wrote:
>>
>> .load ./libstringmetrics.so
>> select a.firstname, b.firstname, a.lastname, b.lastname,
>> stringmetrics("qgrams_distance","similarity",a.firstname,
>> b.firstname,"") first_dist,
>> stringmetrics("qgrams_distance","similarity",a.lastname,
>> b.lastname,"") last_dist
>> from
>> (select "Milan" as firstname, "Roubal" as lastname ) a,
>> (select "Milan" as firstname, "RoubalRoubalRoubalRo" as lastname ) b
>
> Do any of these crash ?
>
> SELECT stringmetrics("qgrams_distance","similarity","Milan",
> "Milan","");
>
pass
>
> SELECT stringmetrics("qgrams_distance","similarity","Roubal",
> "RoubalRoubalRoubalRo","");
>
crash
> select stringmetrics("qgrams_distance","similarity",a.firstname,
> b.firstname,"") first_dist
> from
> (select "Milan" as firstname, "Roubal" as lastname ) a,
> (select "Milan" as firstname, "RoubalRoubalRoubalRo" as lastname ) b;
>
pass
>
> select stringmetrics("qgrams_distance","similarity",a.lastname,
> b.lastname,"") last_dist
> from
> (select "Milan" as firstname, "Roubal" as lastname ) a,
> (select "Milan" as firstname, "RoubalRoubalRoubalRo" as lastname ) b;
>
crash
Thank you
Milan
