UPDATE:
Looking at src/sql/backends/monet5/LSST/Tests/lsst_htmxmatch.sql, it seems
that the syntax I need is indeed
where [t.name] maxlevenshtein [f.name, 2]
However, now I suspect that the problem is that my join was implemented as:
str
STRdistjoin_levenshtein(bat *r1, bat *r2, const bat *lid, const bat *rid,
const int *k)
and not as STRdistjoin_levenshtein*subjoin*
Is this needed in Jul2015? And do I need also the subselect version?
Is there any guideline to help? I find all these subjoin/subselect
implementations rather unfriendly ;)
Roberto
On 8 January 2016 at 15:01, Roberto Cornacchia wrote: Hi there, I'm a bit struggling with the syntax for filter function, after it changed
from Oct2014 to Jul2015.
I have looked at the release notes, but they don't seem to even mention
this change of syntax. This used to work in Oct2014: create filter function maxlevenshtein(s1 string, s2 string, k int)
external name str."distjoin_levenshtein"; select t.name, f.name
from sys.tables t, sys.functions f
where t.name maxlevenshtein(2) f.name; In Jul2015, if I look at Niels' comment in
https://www.monetdb.org/bugzilla/show_bug.cgi?id=3702 , it should be
something similar to select t.name, f.name
from sys.tables t, sys.functions f
where [t.name] maxlevenshtein [f.name, 2]; But this is still not right. How should it be? And should I change the SQL
/ MAL / C interface of the function as well? Thanks,