Dear all,
I have some problems with https://github.com/aperi2007/libstringmetrics
. For example:
When I use "similarity" in qgrams_distance, I get good results. But when
I use "metric", it works only if it is only once in the query. When
there are 2 different usages, they somehow interfere together. Is this
the right place where to report such problem?
> sqlite3
SQLite version 3.8.8.3 2015-02-25 13:29:11
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> select load_extension("libstringmetrics.dll");
sqlite> 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, "roubal" as lastname ) b
...> ;
Milan|Milan|Roubal|roubal|100.0|62.5
sqlite> select a.firstname, b.firstname, a.lastname, b.lastname,
...> stringmetrics("qgrams_distance","metric",a.firstname,
b.firstname,"") first_dist,
...> stringmetrics("qgrams_distance","metric",a.lastname,
b.lastname,"") last_dist
...> from
...> (select "Milan" as firstname, "Roubal" as lastname ) a,
...> (select "Milan" as firstname, "roubal" as lastname ) b
...> ;
Milan|Milan|Roubal|roubal|6|6
sqlite> select a.firstname, b.firstname, a.lastname, b.lastname,
...> stringmetrics("qgrams_distance","metric",a.firstname,
b.firstname,"") first_dist
...> from
...> (select "Milan" as firstname, "Roubal" as lastname ) a,
...> (select "Milan" as firstname, "roubal" as lastname ) b
...> ;
Milan|Milan|Roubal|roubal|0
Thank you
Best Regards
Milan
