Changeset: 8e542bf18a8b for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/8e542bf18a8b
Modified Files:
        clients/Tests/MAL-signatures-hge.test
        clients/Tests/MAL-signatures.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: insertonly
Log Message:

Approve tests.


diffs (84 lines):

diff --git a/clients/Tests/MAL-signatures-hge.test 
b/clients/Tests/MAL-signatures-hge.test
--- a/clients/Tests/MAL-signatures-hge.test
+++ b/clients/Tests/MAL-signatures-hge.test
@@ -49634,6 +49634,11 @@ unsafe pattern sql.include(X_0:str):void
 SQLinclude;
 Compile and execute a sql statements on the file
 sql
+insertonly_persist
+unsafe pattern sql.insertonly_persist() (X_0:bat[:str], X_1:bat[:lng], 
X_2:bat[:lng]) 
+SQLinsertonly_persist;
+Persist changes to new data on append only tables.
+sql
 lag
 pattern sql.lag(X_0:any_1, X_1:any, X_2:any_1, X_3:bit, X_4:bit):any_1 
 SQLlag;
diff --git a/clients/Tests/MAL-signatures.test 
b/clients/Tests/MAL-signatures.test
--- a/clients/Tests/MAL-signatures.test
+++ b/clients/Tests/MAL-signatures.test
@@ -39664,3 +39664,8 @@ command xml.xml(X_0:str):xml
 XMLstr2xml;
 Cast the string to an xml compliant string
 
+insertonly_persist
+unsafe pattern sql.insertonly_persist() (X_0:bat[:str], X_1:bat[:lng], 
X_2:bat[:lng]) 
+SQLinsertonly_persist;
+Persist changes to new data on append only tables.
+sql
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
@@ -1817,6 +1817,7 @@ select 'null in fkeys.delete_action', de
 [ "sys.functions",     "sys",  "insert",       "SYSTEM",       "insert",       
"str",  "Internal C",   "Scalar function",      false,  false,  false,  false,  
NULL,   "res_0",        "char", 0,      0,      "out",  "arg_1",        "char", 
0,      0,      "in",   "arg_2",        "int",  32,     0,      "in",   
"arg_3",        "int",  32,     0,      "in",   "arg_4",        "char", 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    ]
 [ "sys.functions",     "sys",  "insert",       "SYSTEM",       "insert",       
"str",  "Internal C",   "Scalar function",      false,  false,  false,  false,  
NULL,   "res_0",        "clob", 0,      0,      "out",  "arg_1",        "clob", 
0,      0,      "in",   "arg_2",        "int",  32,     0,      "in",   
"arg_3",        "int",  32,     0,      "in",   "arg_4",        "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    ]
 [ "sys.functions",     "sys",  "insert",       "SYSTEM",       "insert",       
"str",  "Internal C",   "Scalar function",      false,  false,  false,  false,  
NULL,   "res_0",        "varchar",      0,      0,      "out",  "arg_1",        
"varchar",      0,      0,      "in",   "arg_2",        "int",  32,     0,      
"in",   "arg_3",        "int",  32,     0,      "in",   "arg_4",        
"varchar",      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    
]
+[ "sys.functions",     "sys",  "insertonly_persist",   "SYSTEM",       "create 
function sys.insertonly_persist() returns table(\"table\" string, \"table_id\" 
bigint, \"rowcount\" bigint) external name sql.insertonly_persist;",     "sql", 
 "MAL",  "Function returning a table",   true,   false,  false,  true,   NULL,  
 "table",        "clob", 0,      0,      "out",  "table_id",     "bigint",      
 64,     0,      "out",  "rowcount",     "bigint",       64,     0,      "out", 
 NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,  
 NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,  
 NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,  
 NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,  
 NULL,   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",  "internaltransform",    "SYSTEM",       "create 
function internaltransform(geom geometry, srid_src integer, srid_dest integer, 
proj4_src string, proj4_dest string) returns geometry external name 
geom.\"Transform\";",        "geom", "MAL",  "Scalar function",      false,  
false,  false,  true,   NULL,   "result",       "geometry",     0,      0,      
"out",  "geom", "geometry",     0,      0,      "in",   "srid_src",     "int",  
32,     0,      "in",   "srid_dest",    "int",  32,     0,      "in",   
"proj4_src",    "clob", 0,      0,      "in",   "proj4_dest",   "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    ]
 [ "sys.functions",     "sys",  "isaurl",       "SYSTEM",       "create 
function isaurl(theurl string) returns bool external name url.\"isaURL\";",     
"url",  "MAL",  "Scalar function",      false,  false,  false,  true,   NULL,   
"result",       "boolean",      1,      0,      "out",  "theurl",       "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",  "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    ]
@@ -4526,6 +4527,7 @@ select 'null in fkeys.delete_action', de
 [ "grant on function", "sys",  "hostmask",     "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "hot_snapshot", ".snapshot",    "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "hot_snapshot", ".snapshot",    "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "insertonly_persist",   "public",       
"EXECUTE",      "monetdb",      0       ]
 [ "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       ]
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
@@ -1797,6 +1797,7 @@ select 'null in fkeys.delete_action', de
 [ "sys.functions",     "sys",  "insert",       "SYSTEM",       "insert",       
"str",  "Internal C",   "Scalar function",      false,  false,  false,  false,  
NULL,   "res_0",        "char", 0,      0,      "out",  "arg_1",        "char", 
0,      0,      "in",   "arg_2",        "int",  32,     0,      "in",   
"arg_3",        "int",  32,     0,      "in",   "arg_4",        "char", 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    ]
 [ "sys.functions",     "sys",  "insert",       "SYSTEM",       "insert",       
"str",  "Internal C",   "Scalar function",      false,  false,  false,  false,  
NULL,   "res_0",        "clob", 0,      0,      "out",  "arg_1",        "clob", 
0,      0,      "in",   "arg_2",        "int",  32,     0,      "in",   
"arg_3",        "int",  32,     0,      "in",   "arg_4",        "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    ]
 [ "sys.functions",     "sys",  "insert",       "SYSTEM",       "insert",       
"str",  "Internal C",   "Scalar function",      false,  false,  false,  false,  
NULL,   "res_0",        "varchar",      0,      0,      "out",  "arg_1",        
"varchar",      0,      0,      "in",   "arg_2",        "int",  32,     0,      
"in",   "arg_3",        "int",  32,     0,      "in",   "arg_4",        
"varchar",      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    
]
+[ "sys.functions",     "sys",  "insertonly_persist",   "SYSTEM",       "create 
function sys.insertonly_persist() returns table(\"table\" string, \"table_id\" 
bigint, \"rowcount\" bigint) external name sql.insertonly_persist;",     "sql", 
 "MAL",  "Function returning a table",   true,   false,  false,  true,   NULL,  
 "table",        "clob", 0,      0,      "out",  "table_id",     "bigint",      
 64,     0,      "out",  "rowcount",     "bigint",       64,     0,      "out", 
 NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,  
 NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,  
 NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,  
 NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,  
 NULL,   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",  "isaurl",       "SYSTEM",       "create 
function isaurl(theurl string) returns bool external name url.\"isaURL\";",     
"url",  "MAL",  "Scalar function",      false,  false,  false,  true,   NULL,   
"result",       "boolean",      1,      0,      "out",  "theurl",       "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",  "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    ]
@@ -4308,6 +4309,7 @@ select 'null in fkeys.delete_action', de
 [ "grant on function", "sys",  "hostmask",     "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "hot_snapshot", ".snapshot",    "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "hot_snapshot", ".snapshot",    "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "insertonly_persist",   "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       ]
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
@@ -1836,6 +1836,7 @@ select 'null in fkeys.delete_action', de
 [ "sys.functions",     "sys",  "insert",       "SYSTEM",       "insert",       
"str",  "Internal C",   "Scalar function",      false,  false,  false,  false,  
NULL,   "res_0",        "char", 0,      0,      "out",  "arg_1",        "char", 
0,      0,      "in",   "arg_2",        "int",  32,     0,      "in",   
"arg_3",        "int",  32,     0,      "in",   "arg_4",        "char", 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    ]
 [ "sys.functions",     "sys",  "insert",       "SYSTEM",       "insert",       
"str",  "Internal C",   "Scalar function",      false,  false,  false,  false,  
NULL,   "res_0",        "clob", 0,      0,      "out",  "arg_1",        "clob", 
0,      0,      "in",   "arg_2",        "int",  32,     0,      "in",   
"arg_3",        "int",  32,     0,      "in",   "arg_4",        "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    ]
 [ "sys.functions",     "sys",  "insert",       "SYSTEM",       "insert",       
"str",  "Internal C",   "Scalar function",      false,  false,  false,  false,  
NULL,   "res_0",        "varchar",      0,      0,      "out",  "arg_1",        
"varchar",      0,      0,      "in",   "arg_2",        "int",  32,     0,      
"in",   "arg_3",        "int",  32,     0,      "in",   "arg_4",        
"varchar",      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    
]
+[ "sys.functions",     "sys",  "insertonly_persist",   "SYSTEM",       "create 
function sys.insertonly_persist() returns table(\"table\" string, \"table_id\" 
bigint, \"rowcount\" bigint) external name sql.insertonly_persist;",     "sql", 
 "MAL",  "Function returning a table",   true,   false,  false,  true,   NULL,  
 "table",        "clob", 0,      0,      "out",  "table_id",     "bigint",      
 64,     0,      "out",  "rowcount",     "bigint",       64,     0,      "out", 
 NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,  
 NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,  
 NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,  
 NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,   NULL,  
 NULL,   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",  "internaltransform",    "SYSTEM",       "create 
function internaltransform(geom geometry, srid_src integer, srid_dest integer, 
proj4_src string, proj4_dest string) returns geometry external name 
geom.\"Transform\";",        "geom", "MAL",  "Scalar function",      false,  
false,  false,  true,   NULL,   "result",       "geometry",     0,      0,      
"out",  "geom", "geometry",     0,      0,      "in",   "srid_src",     "int",  
32,     0,      "in",   "srid_dest",    "int",  32,     0,      "in",   
"proj4_src",    "clob", 0,      0,      "in",   "proj4_dest",   "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    ]
 [ "sys.functions",     "sys",  "isaurl",       "SYSTEM",       "create 
function isaurl(theurl string) returns bool external name url.\"isaURL\";",     
"url",  "MAL",  "Scalar function",      false,  false,  false,  true,   NULL,   
"result",       "boolean",      1,      0,      "out",  "theurl",       "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",  "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    ]
@@ -4645,6 +4646,7 @@ select 'null in fkeys.delete_action', de
 [ "grant on function", "sys",  "hostmask",     "public",       "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "hot_snapshot", ".snapshot",    "EXECUTE",      
"monetdb",      0       ]
 [ "grant on function", "sys",  "hot_snapshot", ".snapshot",    "EXECUTE",      
"monetdb",      0       ]
+[ "grant on function", "sys",  "insertonly_persist",   "public",       
"EXECUTE",      "monetdb",      0       ]
 [ "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       ]
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org

Reply via email to