Changeset: 9e50777bf8a9 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/9e50777bf8a9
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 output.
diffs (151 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
@@ -49664,19 +49664,19 @@ 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[:int],
X_2:bat[:lng])
-SQLinsertonly_persist;
+persist_unlogged
+unsafe pattern sql.persist_unlogged() (X_0:bat[:str], X_1:bat[:int],
X_2:bat[:lng])
+SQLpersist_unlogged;
Persist deltas on append only tables in current schema
sql
-insertonly_persist
-unsafe pattern sql.insertonly_persist(X_0:str) (X_1:bat[:str], X_2:bat[:int],
X_3:bat[:lng])
-SQLinsertonly_persist;
+persist_unlogged
+unsafe pattern sql.persist_unlogged(X_0:str) (X_1:bat[:str], X_2:bat[:int],
X_3:bat[:lng])
+SQLpersist_unlogged;
Persist deltas on append only tables in schema s
sql
-insertonly_persist
-unsafe pattern sql.insertonly_persist(X_0:str, X_1:str) (X_2:bat[:str],
X_3:bat[:int], X_4:bat[:lng])
-SQLinsertonly_persist;
+persist_unlogged
+unsafe pattern sql.persist_unlogged(X_0:str, X_1:str) (X_2:bat[:str],
X_3:bat[:int], X_4:bat[:lng])
+SQLpersist_unlogged;
Persist deltas on append only table in schema s table t
sql
lag
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
@@ -38069,19 +38069,19 @@ 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[:int],
X_2:bat[:lng])
-SQLinsertonly_persist;
+persist_unlogged
+unsafe pattern sql.persist_unlogged() (X_0:bat[:str], X_1:bat[:int],
X_2:bat[:lng])
+SQLpersist_unlogged;
Persist deltas on append only tables in current schema
sql
-insertonly_persist
-unsafe pattern sql.insertonly_persist(X_0:str) (X_1:bat[:str], X_2:bat[:int],
X_3:bat[:lng])
-SQLinsertonly_persist;
+persist_unlogged
+unsafe pattern sql.persist_unlogged(X_0:str) (X_1:bat[:str], X_2:bat[:int],
X_3:bat[:lng])
+SQLpersist_unlogged;
Persist deltas on append only tables in schema s
sql
-insertonly_persist
-unsafe pattern sql.insertonly_persist(X_0:str, X_1:str) (X_2:bat[:str],
X_3:bat[:int], X_4:bat[:lng])
-SQLinsertonly_persist;
+persist_unlogged
+unsafe pattern sql.persist_unlogged(X_0:str, X_1:str) (X_2:bat[:str],
X_3:bat[:int], X_4:bat[:lng])
+SQLpersist_unlogged;
Persist deltas on append only table in schema s table t
sql
lag
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,9 +1817,9 @@ 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\"
int, \"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", "int", 32,
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", "insertonly_persist", "SYSTEM", "create
function sys.insertonly_persist(sname string) returns table(\"table\" string,
\"table_id\" int, \"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",
"int", 32, 0, "out", "rowcount", "bigint", 64, 0,
"out", "sname", "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 ]
-[ "sys.functions", "sys", "insertonly_persist", "SYSTEM", "create
function sys.insertonly_persist(sname string, tname string) returns
table(\"table\" string, \"table_id\" int, \"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", "int", 32, 0, "out", "rowcount",
"bigint", 64, 0, "out", "sname", "clob", 0, 0,
"in", "tname", "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", "persist_unlogged", "SYSTEM", "create
function sys.persist_unlogged() returns table(\"table\" string, \"table_id\"
int, \"rowcount\" bigint) external name sql.persist_unlogged;", "sql",
"MAL", "Function returning a table", true, false, false, true, NULL,
"table", "clob", 0, 0, "out", "table_id", "int", 32,
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", "persist_unlogged", "SYSTEM", "create
function sys.persist_unlogged(sname string) returns table(\"table\" string,
\"table_id\" int, \"rowcount\" bigint) external name sql.persist_unlogged;",
"sql", "MAL", "Function returning a table", true, false, false,
true, NULL, "table", "clob", 0, 0, "out", "table_id",
"int", 32, 0, "out", "rowcount", "bigint", 64, 0,
"out", "sname", "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 ]
+[ "sys.functions", "sys", "persist_unlogged", "SYSTEM", "create
function sys.persist_unlogged(sname string, tname string) returns
table(\"table\" string, \"table_id\" int, \"rowcount\" bigint) external name
sql.persist_unlogged;", "sql", "MAL", "Function returning a table", true,
false, false, true, NULL, "table", "clob", 0, 0, "out",
"table_id", "int", 32, 0, "out", "rowcount", "bigint",
64, 0, "out", "sname", "clob", 0, 0, "in",
"tname", "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", "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 ]
@@ -4529,9 +4529,9 @@ 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", "insertonly_persist", "public",
"EXECUTE", "monetdb", 0 ]
-[ "grant on function", "sys", "insertonly_persist", "public",
"EXECUTE", "monetdb", 0 ]
+[ "grant on function", "sys", "persist_unlogged", "public",
"EXECUTE", "monetdb", 0 ]
+[ "grant on function", "sys", "persist_unlogged", "public",
"EXECUTE", "monetdb", 0 ]
+[ "grant on function", "sys", "persist_unlogged", "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,9 +1797,9 @@ 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\"
int, \"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", "int", 32,
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", "insertonly_persist", "SYSTEM", "create
function sys.insertonly_persist(sname string) returns table(\"table\" string,
\"table_id\" int, \"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",
"int", 32, 0, "out", "rowcount", "bigint", 64, 0,
"out", "sname", "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 ]
-[ "sys.functions", "sys", "insertonly_persist", "SYSTEM", "create
function sys.insertonly_persist(sname string, tname string) returns
table(\"table\" string, \"table_id\" int, \"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", "int", 32, 0, "out", "rowcount",
"bigint", 64, 0, "out", "sname", "clob", 0, 0,
"in", "tname", "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", "persist_unlogged", "SYSTEM", "create
function sys.persist_unlogged() returns table(\"table\" string, \"table_id\"
int, \"rowcount\" bigint) external name sql.persist_unlogged;", "sql",
"MAL", "Function returning a table", true, false, false, true, NULL,
"table", "clob", 0, 0, "out", "table_id", "int", 32,
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", "persist_unlogged", "SYSTEM", "create
function sys.persist_unlogged(sname string) returns table(\"table\" string,
\"table_id\" int, \"rowcount\" bigint) external name sql.persist_unlogged;",
"sql", "MAL", "Function returning a table", true, false, false,
true, NULL, "table", "clob", 0, 0, "out", "table_id",
"int", 32, 0, "out", "rowcount", "bigint", 64, 0,
"out", "sname", "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 ]
+[ "sys.functions", "sys", "persist_unlogged", "SYSTEM", "create
function sys.persist_unlogged(sname string, tname string) returns
table(\"table\" string, \"table_id\" int, \"rowcount\" bigint) external name
sql.persist_unlogged;", "sql", "MAL", "Function returning a table", true,
false, false, true, NULL, "table", "clob", 0, 0, "out",
"table_id", "int", 32, 0, "out", "rowcount", "bigint",
64, 0, "out", "sname", "clob", 0, 0, "in",
"tname", "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", "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 ]
@@ -4311,9 +4311,9 @@ 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", "insertonly_persist", "public",
"EXECUTE", "monetdb", 0 ]
-[ "grant on function", "sys", "insertonly_persist", "public",
"EXECUTE", "monetdb", 0 ]
+[ "grant on function", "sys", "persist_unlogged", "public",
"EXECUTE", "monetdb", 0 ]
+[ "grant on function", "sys", "persist_unlogged", "public",
"EXECUTE", "monetdb", 0 ]
+[ "grant on function", "sys", "persist_unlogged", "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,9 +1836,9 @@ 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\"
int, \"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", "int", 32,
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", "insertonly_persist", "SYSTEM", "create
function sys.insertonly_persist(sname string) returns table(\"table\" string,
\"table_id\" int, \"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",
"int", 32, 0, "out", "rowcount", "bigint", 64, 0,
"out", "sname", "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 ]
-[ "sys.functions", "sys", "insertonly_persist", "SYSTEM", "create
function sys.insertonly_persist(sname string, tname string) returns
table(\"table\" string, \"table_id\" int, \"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", "int", 32, 0, "out", "rowcount",
"bigint", 64, 0, "out", "sname", "clob", 0, 0,
"in", "tname", "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", "persist_unlogged", "SYSTEM", "create
function sys.persist_unlogged() returns table(\"table\" string, \"table_id\"
int, \"rowcount\" bigint) external name sql.persist_unlogged;", "sql",
"MAL", "Function returning a table", true, false, false, true, NULL,
"table", "clob", 0, 0, "out", "table_id", "int", 32,
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", "persist_unlogged", "SYSTEM", "create
function sys.persist_unlogged(sname string) returns table(\"table\" string,
\"table_id\" int, \"rowcount\" bigint) external name sql.persist_unlogged;",
"sql", "MAL", "Function returning a table", true, false, false,
true, NULL, "table", "clob", 0, 0, "out", "table_id",
"int", 32, 0, "out", "rowcount", "bigint", 64, 0,
"out", "sname", "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 ]
+[ "sys.functions", "sys", "persist_unlogged", "SYSTEM", "create
function sys.persist_unlogged(sname string, tname string) returns
table(\"table\" string, \"table_id\" int, \"rowcount\" bigint) external name
sql.persist_unlogged;", "sql", "MAL", "Function returning a table", true,
false, false, true, NULL, "table", "clob", 0, 0, "out",
"table_id", "int", 32, 0, "out", "rowcount", "bigint",
64, 0, "out", "sname", "clob", 0, 0, "in",
"tname", "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", "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 ]
@@ -4648,9 +4648,9 @@ 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", "insertonly_persist", "public",
"EXECUTE", "monetdb", 0 ]
-[ "grant on function", "sys", "insertonly_persist", "public",
"EXECUTE", "monetdb", 0 ]
+[ "grant on function", "sys", "persist_unlogged", "public",
"EXECUTE", "monetdb", 0 ]
+[ "grant on function", "sys", "persist_unlogged", "public",
"EXECUTE", "monetdb", 0 ]
+[ "grant on function", "sys", "persist_unlogged", "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
