Changeset: 8a2620f314f9 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/8a2620f314f9
Modified Files:
        monetdb5/modules/mal/Tests/txtsim_jarowinkler.test
        monetdb5/modules/mal/Tests/txtsim_levenshtein.test
        sql/test/emptydb/Tests/check.stable.out
        sql/test/emptydb/Tests/check.stable.out.32bit
        sql/test/emptydb/Tests/check.stable.out.int128
Branch: txtsim-imp
Log Message:

Fix tests and approve output


diffs (140 lines):

diff --git a/monetdb5/modules/mal/Tests/txtsim_jarowinkler.test 
b/monetdb5/modules/mal/Tests/txtsim_jarowinkler.test
--- a/monetdb5/modules/mal/Tests/txtsim_jarowinkler.test
+++ b/monetdb5/modules/mal/Tests/txtsim_jarowinkler.test
@@ -13,33 +13,32 @@ insert into bar values ('joHan'),('aajAn
 query TT rowsort
 select * from foo,bar where [foo.x] minjarowinkler [bar.x, 1];
 ----
-(empty)
 
 query TT rowsort
 select * from foo,bar where [foo.x] minjarowinkler [bar.x, 0.5];
 ----
-robert
-rOObert
-john
-aajAne
 jane
 aajAne
-robert
+jane
 joHan
 john
+aajAne
+john
 joHan
-jane
+robert
 joHan
+robert
+rOObert
 
 query TT rowsort
 select * from foo,bar where [foo.x] minjarowinkler [bar.x, 0.8];
 ----
-robert
-rOObert
 jane
 aajAne
 john
 joHan
+robert
+rOObert
 
 statement ok
 drop table foo;
diff --git a/monetdb5/modules/mal/Tests/txtsim_levenshtein.test 
b/monetdb5/modules/mal/Tests/txtsim_levenshtein.test
--- a/monetdb5/modules/mal/Tests/txtsim_levenshtein.test
+++ b/monetdb5/modules/mal/Tests/txtsim_levenshtein.test
@@ -27,24 +27,24 @@ statement ok
 insert into bar values ('joHan'),('aajAne'),('rOObert')
 
 query TT rowsort
-select * from foo,bar where [foo.x] maxlevenshtein [bar.x, 2];
+select * from foo,bar where [foo.x] maxlevenshtein [bar.x, 2]
 ----
+john
+joHan
 robert
 rOObert
-john
-joHan
 
 query TT rowsort
-select * from foo,bar where [foo.x] maxlevenshtein [bar.x, 4];
+select * from foo,bar where [foo.x] maxlevenshtein [bar.x, 4]
 ----
+jane
+aajAne
+jane
+joHan
+john
+joHan
 robert
 rOObert
-jane
-aajAne
-john
-joHan
-jane
-joHan
 
 statement ok
 drop table foo;
diff --git a/sql/test/emptydb/Tests/check.stable.out 
b/sql/test/emptydb/Tests/check.stable.out
--- a/sql/test/emptydb/Tests/check.stable.out
+++ b/sql/test/emptydb/Tests/check.stable.out
@@ -1702,6 +1702,7 @@ select 'null in fkeys.delete_action', de
 [ "sys.functions",     "sys",  "isauuid",      "SYSTEM",       "create 
function sys.isauuid(s string) returns boolean external name 
uuid.\"isaUUID\";",        "uuid", "MAL",  "Scalar function",      false,  
false,  false,  true,   NULL,   "result",       "boolean",      1,      0,      
"out",  "s",    "clob", 0,      0,      "in",   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL    ]
 [ "sys.functions",     "sys",  "isnotnull",    "SYSTEM",       "isnotnil",     
"calc", "Internal C",   "Scalar function",      false,  false,  false,  true,   
NULL,   "res_0",        "boolean",      1,      0,      "out",  "arg_1",        
"any",  0,      0,      "in",   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL    ]
 [ "sys.functions",     "sys",  "isnull",       "SYSTEM",       "isnil",        
"calc", "Internal C",   "Scalar function",      false,  false,  false,  true,   
NULL,   "res_0",        "boolean",      1,      0,      "out",  "arg_1",        
"any",  0,      0,      "in",   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL    ]
+[ "sys.functions",     "sys",  "jarowinkler",  "SYSTEM",       "create 
function sys.jarowinkler(x string, y string) returns double external name 
txtsim.jarowinkler;", "txtsim",       "MAL",  "Scalar function",      false,  
false,  false,  true,   NULL,   "result",       "double",       53,     0,      
"out",  "x",    "clob", 0,      0,      "in",   "y",    "clob", 0,      0,      
"in",   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL    ]
 [ "sys.functions",     "sys",  "lag",  "SYSTEM",       "lag",  "sql",  
"Internal C",   "Analytic function",    false,  false,  false,  true,   NULL,   
"res_0",        "any",  0,      0,      "out",  "arg_1",        "any",  0,      
0,      "in",   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL    ]
 [ "sys.functions",     "sys",  "lag",  "SYSTEM",       "lag",  "sql",  
"Internal C",   "Analytic function",    false,  false,  false,  true,   NULL,   
"res_0",        "any",  0,      0,      "out",  "arg_1",        "any",  0,      
0,      "in",   "arg_2",        "bigint",       64,     0,      "in",   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL    ]
 [ "sys.functions",     "sys",  "lag",  "SYSTEM",       "lag",  "sql",  
"Internal C",   "Analytic function",    false,  false,  false,  true,   NULL,   
"res_0",        "any",  0,      0,      "out",  "arg_1",        "any",  0,      
0,      "in",   "arg_2",        "bigint",       64,     0,      "in",   
"arg_3",        "any",  0,      0,      "in",   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL    ]
@@ -4308,6 +4309,7 @@ select 'null in fkeys.delete_action', de
 [ "grant on function", "sys",  "internaltransform",    "public",       
"EXECUTE",      "monetdb",      0       ]
 [ "grant on function", "sys",  "isaurl",       "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "isauuid",      "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "jarowinkler",  "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "left_shift",   "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "left_shift_assign",    "public",       
"EXECUTE",      "monetdb",      0       ]
 [ "grant on function", "sys",  "levenshtein",  "public",       "EXECUTE",      
"monetdb",      0       ]
diff --git a/sql/test/emptydb/Tests/check.stable.out.32bit 
b/sql/test/emptydb/Tests/check.stable.out.32bit
--- a/sql/test/emptydb/Tests/check.stable.out.32bit
+++ b/sql/test/emptydb/Tests/check.stable.out.32bit
@@ -1702,6 +1702,7 @@ select 'null in fkeys.delete_action', de
 [ "sys.functions",     "sys",  "isauuid",      "SYSTEM",       "create 
function sys.isauuid(s string) returns boolean external name 
uuid.\"isaUUID\";",        "uuid", "MAL",  "Scalar function",      false,  
false,  false,  true,   NULL,   "result",       "boolean",      1,      0,      
"out",  "s",    "clob", 0,      0,      "in",   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL    ]
 [ "sys.functions",     "sys",  "isnotnull",    "SYSTEM",       "isnotnil",     
"calc", "Internal C",   "Scalar function",      false,  false,  false,  true,   
NULL,   "res_0",        "boolean",      1,      0,      "out",  "arg_1",        
"any",  0,      0,      "in",   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL    ]
 [ "sys.functions",     "sys",  "isnull",       "SYSTEM",       "isnil",        
"calc", "Internal C",   "Scalar function",      false,  false,  false,  true,   
NULL,   "res_0",        "boolean",      1,      0,      "out",  "arg_1",        
"any",  0,      0,      "in",   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL    ]
+[ "sys.functions",     "sys",  "jarowinkler",  "SYSTEM",       "create 
function sys.jarowinkler(x string, y string) returns double external name 
txtsim.jarowinkler;", "txtsim",       "MAL",  "Scalar function",      false,  
false,  false,  true,   NULL,   "result",       "double",       53,     0,      
"out",  "x",    "clob", 0,      0,      "in",   "y",    "clob", 0,      0,      
"in",   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL    ]
 [ "sys.functions",     "sys",  "lag",  "SYSTEM",       "lag",  "sql",  
"Internal C",   "Analytic function",    false,  false,  false,  true,   NULL,   
"res_0",        "any",  0,      0,      "out",  "arg_1",        "any",  0,      
0,      "in",   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL    ]
 [ "sys.functions",     "sys",  "lag",  "SYSTEM",       "lag",  "sql",  
"Internal C",   "Analytic function",    false,  false,  false,  true,   NULL,   
"res_0",        "any",  0,      0,      "out",  "arg_1",        "any",  0,      
0,      "in",   "arg_2",        "bigint",       64,     0,      "in",   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL    ]
 [ "sys.functions",     "sys",  "lag",  "SYSTEM",       "lag",  "sql",  
"Internal C",   "Analytic function",    false,  false,  false,  true,   NULL,   
"res_0",        "any",  0,      0,      "out",  "arg_1",        "any",  0,      
0,      "in",   "arg_2",        "bigint",       64,     0,      "in",   
"arg_3",        "any",  0,      0,      "in",   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL    ]
@@ -4308,6 +4309,7 @@ select 'null in fkeys.delete_action', de
 [ "grant on function", "sys",  "internaltransform",    "public",       
"EXECUTE",      "monetdb",      0       ]
 [ "grant on function", "sys",  "isaurl",       "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "isauuid",      "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "jarowinkler",  "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "left_shift",   "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "left_shift_assign",    "public",       
"EXECUTE",      "monetdb",      0       ]
 [ "grant on function", "sys",  "levenshtein",  "public",       "EXECUTE",      
"monetdb",      0       ]
diff --git a/sql/test/emptydb/Tests/check.stable.out.int128 
b/sql/test/emptydb/Tests/check.stable.out.int128
--- a/sql/test/emptydb/Tests/check.stable.out.int128
+++ b/sql/test/emptydb/Tests/check.stable.out.int128
@@ -1721,6 +1721,7 @@ select 'null in fkeys.delete_action', de
 [ "sys.functions",     "sys",  "isauuid",      "SYSTEM",       "create 
function sys.isauuid(s string) returns boolean external name 
uuid.\"isaUUID\";",        "uuid", "MAL",  "Scalar function",      false,  
false,  false,  true,   NULL,   "result",       "boolean",      1,      0,      
"out",  "s",    "clob", 0,      0,      "in",   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL    ]
 [ "sys.functions",     "sys",  "isnotnull",    "SYSTEM",       "isnotnil",     
"calc", "Internal C",   "Scalar function",      false,  false,  false,  true,   
NULL,   "res_0",        "boolean",      1,      0,      "out",  "arg_1",        
"any",  0,      0,      "in",   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL    ]
 [ "sys.functions",     "sys",  "isnull",       "SYSTEM",       "isnil",        
"calc", "Internal C",   "Scalar function",      false,  false,  false,  true,   
NULL,   "res_0",        "boolean",      1,      0,      "out",  "arg_1",        
"any",  0,      0,      "in",   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL    ]
+[ "sys.functions",     "sys",  "jarowinkler",  "SYSTEM",       "create 
function sys.jarowinkler(x string, y string) returns double external name 
txtsim.jarowinkler;", "txtsim",       "MAL",  "Scalar function",      false,  
false,  false,  true,   NULL,   "result",       "double",       53,     0,      
"out",  "x",    "clob", 0,      0,      "in",   "y",    "clob", 0,      0,      
"in",   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL    ]
 [ "sys.functions",     "sys",  "lag",  "SYSTEM",       "lag",  "sql",  
"Internal C",   "Analytic function",    false,  false,  false,  true,   NULL,   
"res_0",        "any",  0,      0,      "out",  "arg_1",        "any",  0,      
0,      "in",   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL    ]
 [ "sys.functions",     "sys",  "lag",  "SYSTEM",       "lag",  "sql",  
"Internal C",   "Analytic function",    false,  false,  false,  true,   NULL,   
"res_0",        "any",  0,      0,      "out",  "arg_1",        "any",  0,      
0,      "in",   "arg_2",        "bigint",       64,     0,      "in",   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL    ]
 [ "sys.functions",     "sys",  "lag",  "SYSTEM",       "lag",  "sql",  
"Internal C",   "Analytic function",    false,  false,  false,  true,   NULL,   
"res_0",        "any",  0,      0,      "out",  "arg_1",        "any",  0,      
0,      "in",   "arg_2",        "bigint",       64,     0,      "in",   
"arg_3",        "any",  0,      0,      "in",   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   
NULL,   NULL,   NULL,   NULL,   NULL,   NULL    ]
@@ -4427,6 +4428,7 @@ select 'null in fkeys.delete_action', de
 [ "grant on function", "sys",  "internaltransform",    "public",       
"EXECUTE",      "monetdb",      0       ]
 [ "grant on function", "sys",  "isaurl",       "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "isauuid",      "public",       "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "jarowinkler",  "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "left_shift",   "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "left_shift_assign",    "public",       
"EXECUTE",      "monetdb",      0       ]
 [ "grant on function", "sys",  "levenshtein",  "public",       "EXECUTE",      
"monetdb",      0       ]
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org

Reply via email to