Changeset: a7695cb46856 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a7695cb46856 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 (112 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 @@ -49635,9 +49635,14 @@ 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]) +unsafe pattern sql.insertonly_persist(X_0:str) (X_1:bat[:str], X_2:bat[:lng], X_3:bat[:lng]) SQLinsertonly_persist; -Persist changes to new data on append only tables. +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[:lng], X_4:bat[:lng]) +SQLinsertonly_persist; +Persist deltas on append only table in schema s table t. sql lag pattern sql.lag(X_0:any_1, X_1:any, X_2:any_1, X_3:bit, X_4:bit):any_1 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 @@ -38039,6 +38039,16 @@ 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:str) (X_1:bat[:str], X_2:bat[:lng], X_3:bat[:lng]) +SQLinsertonly_persist; +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[:lng], X_4:bat[:lng]) +SQLinsertonly_persist; +Persist deltas on append only table in schema s table t. +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; @@ -39664,8 +39674,3 @@ 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,7 +1817,8 @@ 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", "insertonly_persist", "SYSTEM", "create function sys.insertonly_persist(sname string) 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", "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\" 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", "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 ] @@ -4528,6 +4529,7 @@ select 'null in fkeys.delete_action', de [ "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", "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,7 +1797,8 @@ 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", "insertonly_persist", "SYSTEM", "create function sys.insertonly_persist(sname string) 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", "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\" 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", "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 ] @@ -4310,6 +4311,7 @@ select 'null in fkeys.delete_action', de [ "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", "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,7 +1836,8 @@ 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", "insertonly_persist", "SYSTEM", "create function sys.insertonly_persist(sname string) 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", "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\" 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", "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 ] @@ -4647,6 +4648,7 @@ select 'null in fkeys.delete_action', de [ "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", "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 -- [email protected] To unsubscribe send an email to [email protected]
