Changeset: 87b41df7ef70 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/87b41df7ef70
Modified Files:
sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
sql/test/emptydb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/emptydb-upgrade/Tests/upgrade.stable.out
sql/test/emptydb-upgrade/Tests/upgrade.stable.out.int128
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
sql/test/testdb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out
sql/test/testdb-previous-upgrade/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out
sql/test/testdb-upgrade-chain/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade-hge/Tests/upgrade.stable.out.int128
sql/test/testdb-upgrade/Tests/upgrade.stable.out
sql/test/testdb-upgrade/Tests/upgrade.stable.out.int128
Branch: txtsim-imp
Log Message:
Approve output.
diffs (truncated from 819 to 300 lines):
diff --git
a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
---
a/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++
b/sql/test/emptydb-previous-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -616,11 +616,14 @@ create function sys.levenshtein(x string
returns int external name txtsim.levenshtein;
grant execute on function levenshtein(string, string, int, int, int) to public;
create filter function sys.maxlevenshtein(x string, y string, k int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
create filter function sys.maxlevenshtein(x string, y string, k int, insdel
int, rep int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
+create function sys.jarowinkler(x string, y string)
+returns double external name txtsim.jarowinkler;
+grant execute on function jarowinkler(string, string) to public;
create filter function minjarowinkler(x string, y string, threshold double)
-external name txtsim."minjarowinkler";
+external name txtsim.minjarowinkler;
create function sys.dameraulevenshtein(x string, y string)
returns int external name txtsim.dameraulevenshtein;
grant execute on function dameraulevenshtein(string, string) to public;
@@ -678,7 +681,7 @@ create filter function sys.contains(x st
external name str."contains";
create filter function sys.contains(x string, y string, icase boolean)
external name str."contains";
-update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'editdistance', 'editdistance2',
'soundex', 'difference', 'qgramnormalize', 'similarity') and schema_id = 2000
and type = 1;
+update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'jarowinkler', 'editdistance',
'editdistance2', 'soundex', 'difference', 'qgramnormalize', 'similarity') and
schema_id = 2000 and type = 1;
update sys.functions set system = true where system <> true and name in
('maxlevenshtein', 'minjarowinkler') and schema_id = 2000 and type = 4;
update sys.functions set system = true where system <> true and name in
('asciify', 'startswith', 'endswith', 'contains') and schema_id = 2000 and type
= 1;
update sys.functions set system = true where system <> true and name in
('startswith', 'endswith', 'contains') and schema_id = 2000 and type = 4;
diff --git a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out
@@ -616,11 +616,14 @@ create function sys.levenshtein(x string
returns int external name txtsim.levenshtein;
grant execute on function levenshtein(string, string, int, int, int) to public;
create filter function sys.maxlevenshtein(x string, y string, k int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
create filter function sys.maxlevenshtein(x string, y string, k int, insdel
int, rep int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
+create function sys.jarowinkler(x string, y string)
+returns double external name txtsim.jarowinkler;
+grant execute on function jarowinkler(string, string) to public;
create filter function minjarowinkler(x string, y string, threshold double)
-external name txtsim."minjarowinkler";
+external name txtsim.minjarowinkler;
create function sys.dameraulevenshtein(x string, y string)
returns int external name txtsim.dameraulevenshtein;
grant execute on function dameraulevenshtein(string, string) to public;
@@ -678,7 +681,7 @@ create filter function sys.contains(x st
external name str."contains";
create filter function sys.contains(x string, y string, icase boolean)
external name str."contains";
-update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'editdistance', 'editdistance2',
'soundex', 'difference', 'qgramnormalize', 'similarity') and schema_id = 2000
and type = 1;
+update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'jarowinkler', 'editdistance',
'editdistance2', 'soundex', 'difference', 'qgramnormalize', 'similarity') and
schema_id = 2000 and type = 1;
update sys.functions set system = true where system <> true and name in
('maxlevenshtein', 'minjarowinkler') and schema_id = 2000 and type = 4;
update sys.functions set system = true where system <> true and name in
('asciify', 'startswith', 'endswith', 'contains') and schema_id = 2000 and type
= 1;
update sys.functions set system = true where system <> true and name in
('startswith', 'endswith', 'contains') and schema_id = 2000 and type = 4;
diff --git
a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-previous-upgrade-chain/Tests/upgrade.stable.out.int128
@@ -685,11 +685,14 @@ create function sys.levenshtein(x string
returns int external name txtsim.levenshtein;
grant execute on function levenshtein(string, string, int, int, int) to public;
create filter function sys.maxlevenshtein(x string, y string, k int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
create filter function sys.maxlevenshtein(x string, y string, k int, insdel
int, rep int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
+create function sys.jarowinkler(x string, y string)
+returns double external name txtsim.jarowinkler;
+grant execute on function jarowinkler(string, string) to public;
create filter function minjarowinkler(x string, y string, threshold double)
-external name txtsim."minjarowinkler";
+external name txtsim.minjarowinkler;
create function sys.dameraulevenshtein(x string, y string)
returns int external name txtsim.dameraulevenshtein;
grant execute on function dameraulevenshtein(string, string) to public;
@@ -747,7 +750,7 @@ create filter function sys.contains(x st
external name str."contains";
create filter function sys.contains(x string, y string, icase boolean)
external name str."contains";
-update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'editdistance', 'editdistance2',
'soundex', 'difference', 'qgramnormalize', 'similarity') and schema_id = 2000
and type = 1;
+update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'jarowinkler', 'editdistance',
'editdistance2', 'soundex', 'difference', 'qgramnormalize', 'similarity') and
schema_id = 2000 and type = 1;
update sys.functions set system = true where system <> true and name in
('maxlevenshtein', 'minjarowinkler') and schema_id = 2000 and type = 4;
update sys.functions set system = true where system <> true and name in
('asciify', 'startswith', 'endswith', 'contains') and schema_id = 2000 and type
= 1;
update sys.functions set system = true where system <> true and name in
('startswith', 'endswith', 'contains') and schema_id = 2000 and type = 4;
diff --git
a/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-previous-upgrade-hge/Tests/upgrade.stable.out.int128
@@ -610,11 +610,14 @@ create function sys.levenshtein(x string
returns int external name txtsim.levenshtein;
grant execute on function levenshtein(string, string, int, int, int) to public;
create filter function sys.maxlevenshtein(x string, y string, k int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
create filter function sys.maxlevenshtein(x string, y string, k int, insdel
int, rep int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
+create function sys.jarowinkler(x string, y string)
+returns double external name txtsim.jarowinkler;
+grant execute on function jarowinkler(string, string) to public;
create filter function minjarowinkler(x string, y string, threshold double)
-external name txtsim."minjarowinkler";
+external name txtsim.minjarowinkler;
create function sys.dameraulevenshtein(x string, y string)
returns int external name txtsim.dameraulevenshtein;
grant execute on function dameraulevenshtein(string, string) to public;
@@ -672,7 +675,7 @@ create filter function sys.contains(x st
external name str."contains";
create filter function sys.contains(x string, y string, icase boolean)
external name str."contains";
-update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'editdistance', 'editdistance2',
'soundex', 'difference', 'qgramnormalize', 'similarity') and schema_id = 2000
and type = 1;
+update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'jarowinkler', 'editdistance',
'editdistance2', 'soundex', 'difference', 'qgramnormalize', 'similarity') and
schema_id = 2000 and type = 1;
update sys.functions set system = true where system <> true and name in
('maxlevenshtein', 'minjarowinkler') and schema_id = 2000 and type = 4;
update sys.functions set system = true where system <> true and name in
('asciify', 'startswith', 'endswith', 'contains') and schema_id = 2000 and type
= 1;
update sys.functions set system = true where system <> true and name in
('startswith', 'endswith', 'contains') and schema_id = 2000 and type = 4;
diff --git a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
--- a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out
@@ -610,11 +610,14 @@ create function sys.levenshtein(x string
returns int external name txtsim.levenshtein;
grant execute on function levenshtein(string, string, int, int, int) to public;
create filter function sys.maxlevenshtein(x string, y string, k int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
create filter function sys.maxlevenshtein(x string, y string, k int, insdel
int, rep int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
+create function sys.jarowinkler(x string, y string)
+returns double external name txtsim.jarowinkler;
+grant execute on function jarowinkler(string, string) to public;
create filter function minjarowinkler(x string, y string, threshold double)
-external name txtsim."minjarowinkler";
+external name txtsim.minjarowinkler;
create function sys.dameraulevenshtein(x string, y string)
returns int external name txtsim.dameraulevenshtein;
grant execute on function dameraulevenshtein(string, string) to public;
@@ -672,7 +675,7 @@ create filter function sys.contains(x st
external name str."contains";
create filter function sys.contains(x string, y string, icase boolean)
external name str."contains";
-update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'editdistance', 'editdistance2',
'soundex', 'difference', 'qgramnormalize', 'similarity') and schema_id = 2000
and type = 1;
+update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'jarowinkler', 'editdistance',
'editdistance2', 'soundex', 'difference', 'qgramnormalize', 'similarity') and
schema_id = 2000 and type = 1;
update sys.functions set system = true where system <> true and name in
('maxlevenshtein', 'minjarowinkler') and schema_id = 2000 and type = 4;
update sys.functions set system = true where system <> true and name in
('asciify', 'startswith', 'endswith', 'contains') and schema_id = 2000 and type
= 1;
update sys.functions set system = true where system <> true and name in
('startswith', 'endswith', 'contains') and schema_id = 2000 and type = 4;
diff --git a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-previous-upgrade/Tests/upgrade.stable.out.int128
@@ -679,11 +679,14 @@ create function sys.levenshtein(x string
returns int external name txtsim.levenshtein;
grant execute on function levenshtein(string, string, int, int, int) to public;
create filter function sys.maxlevenshtein(x string, y string, k int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
create filter function sys.maxlevenshtein(x string, y string, k int, insdel
int, rep int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
+create function sys.jarowinkler(x string, y string)
+returns double external name txtsim.jarowinkler;
+grant execute on function jarowinkler(string, string) to public;
create filter function minjarowinkler(x string, y string, threshold double)
-external name txtsim."minjarowinkler";
+external name txtsim.minjarowinkler;
create function sys.dameraulevenshtein(x string, y string)
returns int external name txtsim.dameraulevenshtein;
grant execute on function dameraulevenshtein(string, string) to public;
@@ -741,7 +744,7 @@ create filter function sys.contains(x st
external name str."contains";
create filter function sys.contains(x string, y string, icase boolean)
external name str."contains";
-update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'editdistance', 'editdistance2',
'soundex', 'difference', 'qgramnormalize', 'similarity') and schema_id = 2000
and type = 1;
+update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'jarowinkler', 'editdistance',
'editdistance2', 'soundex', 'difference', 'qgramnormalize', 'similarity') and
schema_id = 2000 and type = 1;
update sys.functions set system = true where system <> true and name in
('maxlevenshtein', 'minjarowinkler') and schema_id = 2000 and type = 4;
update sys.functions set system = true where system <> true and name in
('asciify', 'startswith', 'endswith', 'contains') and schema_id = 2000 and type
= 1;
update sys.functions set system = true where system <> true and name in
('startswith', 'endswith', 'contains') and schema_id = 2000 and type = 4;
diff --git a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain-hge/Tests/upgrade.stable.out.int128
@@ -286,11 +286,14 @@ create function sys.levenshtein(x string
returns int external name txtsim.levenshtein;
grant execute on function levenshtein(string, string, int, int, int) to public;
create filter function sys.maxlevenshtein(x string, y string, k int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
create filter function sys.maxlevenshtein(x string, y string, k int, insdel
int, rep int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
+create function sys.jarowinkler(x string, y string)
+returns double external name txtsim.jarowinkler;
+grant execute on function jarowinkler(string, string) to public;
create filter function minjarowinkler(x string, y string, threshold double)
-external name txtsim."minjarowinkler";
+external name txtsim.minjarowinkler;
create function sys.dameraulevenshtein(x string, y string)
returns int external name txtsim.dameraulevenshtein;
grant execute on function dameraulevenshtein(string, string) to public;
@@ -348,7 +351,7 @@ create filter function sys.contains(x st
external name str."contains";
create filter function sys.contains(x string, y string, icase boolean)
external name str."contains";
-update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'editdistance', 'editdistance2',
'soundex', 'difference', 'qgramnormalize', 'similarity') and schema_id = 2000
and type = 1;
+update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'jarowinkler', 'editdistance',
'editdistance2', 'soundex', 'difference', 'qgramnormalize', 'similarity') and
schema_id = 2000 and type = 1;
update sys.functions set system = true where system <> true and name in
('maxlevenshtein', 'minjarowinkler') and schema_id = 2000 and type = 4;
update sys.functions set system = true where system <> true and name in
('asciify', 'startswith', 'endswith', 'contains') and schema_id = 2000 and type
= 1;
update sys.functions set system = true where system <> true and name in
('startswith', 'endswith', 'contains') and schema_id = 2000 and type = 4;
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out
@@ -286,11 +286,14 @@ create function sys.levenshtein(x string
returns int external name txtsim.levenshtein;
grant execute on function levenshtein(string, string, int, int, int) to public;
create filter function sys.maxlevenshtein(x string, y string, k int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
create filter function sys.maxlevenshtein(x string, y string, k int, insdel
int, rep int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
+create function sys.jarowinkler(x string, y string)
+returns double external name txtsim.jarowinkler;
+grant execute on function jarowinkler(string, string) to public;
create filter function minjarowinkler(x string, y string, threshold double)
-external name txtsim."minjarowinkler";
+external name txtsim.minjarowinkler;
create function sys.dameraulevenshtein(x string, y string)
returns int external name txtsim.dameraulevenshtein;
grant execute on function dameraulevenshtein(string, string) to public;
@@ -348,7 +351,7 @@ create filter function sys.contains(x st
external name str."contains";
create filter function sys.contains(x string, y string, icase boolean)
external name str."contains";
-update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'editdistance', 'editdistance2',
'soundex', 'difference', 'qgramnormalize', 'similarity') and schema_id = 2000
and type = 1;
+update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'jarowinkler', 'editdistance',
'editdistance2', 'soundex', 'difference', 'qgramnormalize', 'similarity') and
schema_id = 2000 and type = 1;
update sys.functions set system = true where system <> true and name in
('maxlevenshtein', 'minjarowinkler') and schema_id = 2000 and type = 4;
update sys.functions set system = true where system <> true and name in
('asciify', 'startswith', 'endswith', 'contains') and schema_id = 2000 and type
= 1;
update sys.functions set system = true where system <> true and name in
('startswith', 'endswith', 'contains') and schema_id = 2000 and type = 4;
diff --git a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.int128
@@ -355,11 +355,14 @@ create function sys.levenshtein(x string
returns int external name txtsim.levenshtein;
grant execute on function levenshtein(string, string, int, int, int) to public;
create filter function sys.maxlevenshtein(x string, y string, k int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
create filter function sys.maxlevenshtein(x string, y string, k int, insdel
int, rep int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
+create function sys.jarowinkler(x string, y string)
+returns double external name txtsim.jarowinkler;
+grant execute on function jarowinkler(string, string) to public;
create filter function minjarowinkler(x string, y string, threshold double)
-external name txtsim."minjarowinkler";
+external name txtsim.minjarowinkler;
create function sys.dameraulevenshtein(x string, y string)
returns int external name txtsim.dameraulevenshtein;
grant execute on function dameraulevenshtein(string, string) to public;
@@ -417,7 +420,7 @@ create filter function sys.contains(x st
external name str."contains";
create filter function sys.contains(x string, y string, icase boolean)
external name str."contains";
-update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'editdistance', 'editdistance2',
'soundex', 'difference', 'qgramnormalize', 'similarity') and schema_id = 2000
and type = 1;
+update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'jarowinkler', 'editdistance',
'editdistance2', 'soundex', 'difference', 'qgramnormalize', 'similarity') and
schema_id = 2000 and type = 1;
update sys.functions set system = true where system <> true and name in
('maxlevenshtein', 'minjarowinkler') and schema_id = 2000 and type = 4;
update sys.functions set system = true where system <> true and name in
('asciify', 'startswith', 'endswith', 'contains') and schema_id = 2000 and type
= 1;
update sys.functions set system = true where system <> true and name in
('startswith', 'endswith', 'contains') and schema_id = 2000 and type = 4;
diff --git
a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
--- a/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
+++ b/sql/test/emptydb-upgrade-chain/Tests/upgrade.stable.out.ppc64.int128
@@ -355,11 +355,14 @@ create function sys.levenshtein(x string
returns int external name txtsim.levenshtein;
grant execute on function levenshtein(string, string, int, int, int) to public;
create filter function sys.maxlevenshtein(x string, y string, k int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
create filter function sys.maxlevenshtein(x string, y string, k int, insdel
int, rep int)
-external name txtsim."maxlevenshtein";
+external name txtsim.maxlevenshtein;
+create function sys.jarowinkler(x string, y string)
+returns double external name txtsim.jarowinkler;
+grant execute on function jarowinkler(string, string) to public;
create filter function minjarowinkler(x string, y string, threshold double)
-external name txtsim."minjarowinkler";
+external name txtsim.minjarowinkler;
create function sys.dameraulevenshtein(x string, y string)
returns int external name txtsim.dameraulevenshtein;
grant execute on function dameraulevenshtein(string, string) to public;
@@ -417,7 +420,7 @@ create filter function sys.contains(x st
external name str."contains";
create filter function sys.contains(x string, y string, icase boolean)
external name str."contains";
-update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'editdistance', 'editdistance2',
'soundex', 'difference', 'qgramnormalize', 'similarity') and schema_id = 2000
and type = 1;
+update sys.functions set system = true where system <> true and name in
('levenshtein', 'dameraulevenshtein', 'jarowinkler', 'editdistance',
'editdistance2', 'soundex', 'difference', 'qgramnormalize', 'similarity') and
schema_id = 2000 and type = 1;
update sys.functions set system = true where system <> true and name in
('maxlevenshtein', 'minjarowinkler') and schema_id = 2000 and type = 4;
update sys.functions set system = true where system <> true and name in
('asciify', 'startswith', 'endswith', 'contains') and schema_id = 2000 and type
= 1;
update sys.functions set system = true where system <> true and name in
('startswith', 'endswith', 'contains') and schema_id = 2000 and type = 4;
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
