Changeset: fe1a311b9c97 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/fe1a311b9c97
Modified Files:
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
Branch: strheapvacuum
Log Message:
Approve some tests.
diffs (279 lines):
diff --git a/clients/Tests/MAL-signatures.stable.out
b/clients/Tests/MAL-signatures.stable.out
--- a/clients/Tests/MAL-signatures.stable.out
+++ b/clients/Tests/MAL-signatures.stable.out
@@ -637,6 +637,7 @@
[ "bat", "getRole", "command bat.getRole(X_0:bat[:any_1]):str ",
"BKCgetRole;", "Returns the rolename of the head column of a BAT." ]
[ "bat", "getSequenceBase", "command
bat.getSequenceBase(X_0:bat[:any_1]):oid ", "BKCgetSequenceBase;", "Get the
sequence base for the void column of a BAT." ]
[ "bat", "getSize", "command bat.getSize(X_0:bat[:any_1]):lng ",
"BKCgetSize;", "Calculate the actual size of the BAT descriptor, heaps, hashes
and imprint indices in bytes\nrounded to the memory page size (see
bbp.getPageSize())." ]
+[ "bat", "getVHeapSize", "command bat.getVHeapSize(X_0:bat[:any_1]):lng
", "BKCgetVHeapSize;", "Calculate the vheap size for string bats"
]
[ "bat", "getorderidx", "pattern
bat.getorderidx(X_0:bat[:any_1]):bat[:oid] ", "OIDXgetorderidx;", "Return
the order index if it exists" ]
[ "bat", "hasorderidx", "pattern bat.hasorderidx(X_0:bat[:any_1]):bit
", "OIDXhasorderidx;", "Return true if order index exists" ]
[ "bat", "imprints", "command bat.imprints(X_0:bat[:bte]):void ",
"CMDBATimprints;", "" ]
@@ -689,6 +690,7 @@
[ "bat", "setPersistent", "command
bat.setPersistent(X_0:bat[:any_1]):void ", "BKCsetPersistent;", "Make
the BAT persistent." ]
[ "bat", "setTransient", "command bat.setTransient(X_0:bat[:any_1]):void
", "BKCsetTransient;", "Make the BAT transient. Returns \nboolean
which indicates if the\nBAT administration has indeed changed." ]
[ "bat", "single", "pattern bat.single(X_0:any_1):bat[:any_1] ",
"CMDBATsingle;", "Create a BAT with a single elemenet" ]
+[ "bat", "vacuum", "command bat.vacuum(X_0:bat[:str]):bat[:str] ",
"CMDBATvacuum;", "" ]
[ "bataggr", "allnotequal", "pattern bataggr.allnotequal(X_0:bat[:any_1],
X_1:bat[:any_1]):bit ", "SQLallnotequal;", "" ]
[ "bataggr", "anyequal", "pattern bataggr.anyequal(X_0:bat[:any_1],
X_1:bat[:any_1]):bat[:bit] ", "SQLanyequal;", "" ]
[ "bataggr", "exist", "pattern bataggr.exist(X_0:any_1):bat[:bit] ",
"SQLexist;", "" ]
@@ -9427,6 +9429,7 @@
[ "sql", "stdevp", "pattern sql.stdevp(X_0:int, X_1:bit, X_2:bit,
X_3:int, X_4:oid, X_5:oid):dbl ", "SQLstddev_pop;", "return the
standard deviation population of groups" ]
[ "sql", "stdevp", "pattern sql.stdevp(X_0:lng, X_1:bit, X_2:bit,
X_3:int, X_4:oid, X_5:oid):dbl ", "SQLstddev_pop;", "return the
standard deviation population of groups" ]
[ "sql", "stdevp", "pattern sql.stdevp(X_0:sht, X_1:bit, X_2:bit,
X_3:int, X_4:oid, X_5:oid):dbl ", "SQLstddev_pop;", "return the
standard deviation population of groups" ]
+[ "sql", "stop_vacuum", "pattern sql.stop_vacuum(X_0:str, X_1:str,
X_2:str):void ", "SQLstr_column_stop_vacuum;", "stop auto vacuum" ]
[ "sql", "storage", "pattern sql.storage() (X_0:bat[:str],
X_1:bat[:str], X_2:bat[:str], X_3:bat[:str], X_4:bat[:str], X_5:bat[:str],
X_6:bat[:lng], X_7:bat[:int], X_8:bat[:lng], X_9:bat[:lng], X_10:bat[:lng],
X_11:bat[:bit], X_12:bat[:lng], X_13:bat[:bit], X_14:bat[:bit], X_15:bat[:bit],
X_16:bat[:lng]) ", "sql_storage;", "return a table with storage
information " ]
[ "sql", "storage", "pattern sql.storage(X_0:str) (X_1:bat[:str],
X_2:bat[:str], X_3:bat[:str], X_4:bat[:str], X_5:bat[:str], X_6:bat[:str],
X_7:bat[:lng], X_8:bat[:int], X_9:bat[:lng], X_10:bat[:lng], X_11:bat[:lng],
X_12:bat[:bit], X_13:bat[:lng], X_14:bat[:bit], X_15:bat[:bit], X_16:bat[:bit],
X_17:bat[:lng]) ", "sql_storage;", "return a table with storage
information for a particular schema " ]
[ "sql", "storage", "pattern sql.storage(X_0:str, X_1:str)
(X_2:bat[:str], X_3:bat[:str], X_4:bat[:str], X_5:bat[:str], X_6:bat[:str],
X_7:bat[:str], X_8:bat[:lng], X_9:bat[:int], X_10:bat[:lng], X_11:bat[:lng],
X_12:bat[:lng], X_13:bat[:bit], X_14:bat[:lng], X_15:bat[:bit], X_16:bat[:bit],
X_17:bat[:bit], X_18:bat[:lng]) ", "sql_storage;", "return a table with
storage information for a particular table" ]
@@ -9455,6 +9458,8 @@
[ "sql", "update", "pattern sql.update(X_0:int, X_1:str, X_2:str,
X_3:str, X_4:any, X_5:any):int ", "mvc_update_wrap;", "Update the
values of the column tname.cname. Returns sequence number for order
dependence)" ]
[ "sql", "update_schemas", "unsafe pattern
sql.update_schemas():void ", "SYSupdate_schemas;", "Procedure triggered on
update of the sys.schemas table" ]
[ "sql", "update_tables", "unsafe pattern
sql.update_tables():void ", "SYSupdate_tables;", "Procedure triggered on
update of the sys._tables table" ]
+[ "sql", "vacuum", "pattern sql.vacuum(X_0:str, X_1:str, X_2:str,
X_3:int):void ", "SQLstr_column_auto_vacuum;", "auto vacuum string column
with interval(sec)" ]
+[ "sql", "vacuum", "pattern sql.vacuum(X_0:str, X_1:str,
X_2:str):void ", "SQLstr_column_vacuum;", "vacuum a string column"
]
[ "sql", "variance", "pattern sql.variance(X_0:bte, X_1:bit,
X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl ", "SQLvar_samp;", "return the
variance sample of groups" ]
[ "sql", "variance", "pattern sql.variance(X_0:dbl, X_1:bit,
X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl ", "SQLvar_samp;", "return the
variance sample of groups" ]
[ "sql", "variance", "pattern sql.variance(X_0:flt, X_1:bit,
X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl ", "SQLvar_samp;", "return the
variance sample of groups" ]
diff --git a/clients/Tests/MAL-signatures.stable.out.int128
b/clients/Tests/MAL-signatures.stable.out.int128
--- a/clients/Tests/MAL-signatures.stable.out.int128
+++ b/clients/Tests/MAL-signatures.stable.out.int128
@@ -750,6 +750,7 @@
[ "bat", "getRole", "command bat.getRole(X_0:bat[:any_1]):str ",
"BKCgetRole;", "Returns the rolename of the head column of a BAT." ]
[ "bat", "getSequenceBase", "command
bat.getSequenceBase(X_0:bat[:any_1]):oid ", "BKCgetSequenceBase;", "Get the
sequence base for the void column of a BAT." ]
[ "bat", "getSize", "command bat.getSize(X_0:bat[:any_1]):lng ",
"BKCgetSize;", "Calculate the actual size of the BAT descriptor, heaps, hashes
and imprint indices in bytes\nrounded to the memory page size (see
bbp.getPageSize())." ]
+[ "bat", "getVHeapSize", "command bat.getVHeapSize(X_0:bat[:any_1]):lng
", "BKCgetVHeapSize;", "Calculate the vheap size for string bats"
]
[ "bat", "getorderidx", "pattern
bat.getorderidx(X_0:bat[:any_1]):bat[:oid] ", "OIDXgetorderidx;", "Return
the order index if it exists" ]
[ "bat", "hasorderidx", "pattern bat.hasorderidx(X_0:bat[:any_1]):bit
", "OIDXhasorderidx;", "Return true if order index exists" ]
[ "bat", "imprints", "command bat.imprints(X_0:bat[:bte]):void ",
"CMDBATimprints;", "" ]
@@ -804,6 +805,7 @@
[ "bat", "setPersistent", "command
bat.setPersistent(X_0:bat[:any_1]):void ", "BKCsetPersistent;", "Make
the BAT persistent." ]
[ "bat", "setTransient", "command bat.setTransient(X_0:bat[:any_1]):void
", "BKCsetTransient;", "Make the BAT transient. Returns \nboolean
which indicates if the\nBAT administration has indeed changed." ]
[ "bat", "single", "pattern bat.single(X_0:any_1):bat[:any_1] ",
"CMDBATsingle;", "Create a BAT with a single elemenet" ]
+[ "bat", "vacuum", "command bat.vacuum(X_0:bat[:str]):bat[:str] ",
"CMDBATvacuum;", "" ]
[ "bataggr", "allnotequal", "pattern bataggr.allnotequal(X_0:bat[:any_1],
X_1:bat[:any_1]):bit ", "SQLallnotequal;", "" ]
[ "bataggr", "anyequal", "pattern bataggr.anyequal(X_0:bat[:any_1],
X_1:bat[:any_1]):bat[:bit] ", "SQLanyequal;", "" ]
[ "bataggr", "exist", "pattern bataggr.exist(X_0:any_1):bat[:bit] ",
"SQLexist;", "" ]
@@ -12739,6 +12741,7 @@
[ "sql", "stdevp", "pattern sql.stdevp(X_0:int, X_1:bit, X_2:bit,
X_3:int, X_4:oid, X_5:oid):dbl ", "SQLstddev_pop;", "return the
standard deviation population of groups" ]
[ "sql", "stdevp", "pattern sql.stdevp(X_0:lng, X_1:bit, X_2:bit,
X_3:int, X_4:oid, X_5:oid):dbl ", "SQLstddev_pop;", "return the
standard deviation population of groups" ]
[ "sql", "stdevp", "pattern sql.stdevp(X_0:sht, X_1:bit, X_2:bit,
X_3:int, X_4:oid, X_5:oid):dbl ", "SQLstddev_pop;", "return the
standard deviation population of groups" ]
+[ "sql", "stop_vacuum", "pattern sql.stop_vacuum(X_0:str, X_1:str,
X_2:str):void ", "SQLstr_column_stop_vacuum;", "stop auto vacuum" ]
[ "sql", "storage", "pattern sql.storage() (X_0:bat[:str],
X_1:bat[:str], X_2:bat[:str], X_3:bat[:str], X_4:bat[:str], X_5:bat[:str],
X_6:bat[:lng], X_7:bat[:int], X_8:bat[:lng], X_9:bat[:lng], X_10:bat[:lng],
X_11:bat[:bit], X_12:bat[:lng], X_13:bat[:bit], X_14:bat[:bit], X_15:bat[:bit],
X_16:bat[:lng]) ", "sql_storage;", "return a table with storage
information " ]
[ "sql", "storage", "pattern sql.storage(X_0:str) (X_1:bat[:str],
X_2:bat[:str], X_3:bat[:str], X_4:bat[:str], X_5:bat[:str], X_6:bat[:str],
X_7:bat[:lng], X_8:bat[:int], X_9:bat[:lng], X_10:bat[:lng], X_11:bat[:lng],
X_12:bat[:bit], X_13:bat[:lng], X_14:bat[:bit], X_15:bat[:bit], X_16:bat[:bit],
X_17:bat[:lng]) ", "sql_storage;", "return a table with storage
information for a particular schema " ]
[ "sql", "storage", "pattern sql.storage(X_0:str, X_1:str)
(X_2:bat[:str], X_3:bat[:str], X_4:bat[:str], X_5:bat[:str], X_6:bat[:str],
X_7:bat[:str], X_8:bat[:lng], X_9:bat[:int], X_10:bat[:lng], X_11:bat[:lng],
X_12:bat[:lng], X_13:bat[:bit], X_14:bat[:lng], X_15:bat[:bit], X_16:bat[:bit],
X_17:bat[:bit], X_18:bat[:lng]) ", "sql_storage;", "return a table with
storage information for a particular table" ]
@@ -12772,6 +12775,8 @@
[ "sql", "update", "pattern sql.update(X_0:int, X_1:str, X_2:str,
X_3:str, X_4:any, X_5:any):int ", "mvc_update_wrap;", "Update the
values of the column tname.cname. Returns sequence number for order
dependence)" ]
[ "sql", "update_schemas", "unsafe pattern
sql.update_schemas():void ", "SYSupdate_schemas;", "Procedure triggered on
update of the sys.schemas table" ]
[ "sql", "update_tables", "unsafe pattern
sql.update_tables():void ", "SYSupdate_tables;", "Procedure triggered on
update of the sys._tables table" ]
+[ "sql", "vacuum", "pattern sql.vacuum(X_0:str, X_1:str, X_2:str,
X_3:int):void ", "SQLstr_column_auto_vacuum;", "auto vacuum string column
with interval(sec)" ]
+[ "sql", "vacuum", "pattern sql.vacuum(X_0:str, X_1:str,
X_2:str):void ", "SQLstr_column_vacuum;", "vacuum a string column"
]
[ "sql", "variance", "pattern sql.variance(X_0:bte, X_1:bit,
X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl ", "SQLvar_samp;", "return the
variance sample of groups" ]
[ "sql", "variance", "pattern sql.variance(X_0:dbl, X_1:bit,
X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl ", "SQLvar_samp;", "return the
variance sample of groups" ]
[ "sql", "variance", "pattern sql.variance(X_0:flt, X_1:bit,
X_2:bit, X_3:int, X_4:oid, X_5:oid):dbl ", "SQLvar_samp;", "return the
variance sample of groups" ]
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
@@ -363,6 +363,7 @@
\dSf sys."stddev_pop"
\dSf sys."stddev_samp"
\dSf sys."stop"
+\dSf sys."stop_vacuum"
\dSf sys."stopsession"
\dSf sys."storage"
\dSf sys."storagemodelinit"
@@ -376,6 +377,7 @@
\dSf sys."tracelog"
\dSf sys."user_statistics"
\dSf sys."uuid"
+\dSf sys."vacuum"
\dSf sys."var"
\dSf sys."var_pop"
\dSf sys."var_samp"
@@ -910,6 +912,7 @@ SYSTEM WINDOW sys.stddev_pop
SYSTEM AGGREGATE sys.stddev_samp
SYSTEM WINDOW sys.stddev_samp
SYSTEM PROCEDURE sys.stop
+SYSTEM PROCEDURE sys.stop_vacuum
SYSTEM PROCEDURE sys.stopsession
SYSTEM FUNCTION sys.storage
SYSTEM PROCEDURE sys.storagemodelinit
@@ -937,6 +940,7 @@ SYSTEM FUNCTION sys.upper
SYSTEM FUNCTION sys.user_statistics
SYSTEM FUNCTION sys.usweekofyear
SYSTEM FUNCTION sys.uuid
+SYSTEM PROCEDURE sys.vacuum
SYSTEM FUNCTION sys.var
SYSTEM AGGREGATE sys.var_pop
SYSTEM WINDOW sys.var_pop
@@ -1456,6 +1460,7 @@ create window stddev_samp(val real) retu
create window stddev_samp(val smallint) returns double external name
"sql"."stdev";
create window stddev_samp(val tinyint) returns double external name
"sql"."stdev";
create procedure sys.stop(tag bigint) external name sysmon.stop;
+create procedure sys.stop_vacuum(sname string, tname string, cname string)
external name sql.stop_vacuum;
create procedure sys.stopsession("sessionid" int) external name
clients.stopsession;
create function sys."storage"() returns table ("schema" varchar(1024), "table"
varchar(1024), "column" varchar(1024), "type" varchar(1024), "mode"
varchar(15), location varchar(1024), "count" bigint, typewidth int, columnsize
bigint, heapsize bigint, hashes bigint, phash boolean, "imprints" bigint,
sorted boolean, revsorted boolean, "unique" boolean, orderidx bigint) external
name sql."storage";
create function sys."storage"(sname varchar(1024)) returns table ("schema"
varchar(1024), "table" varchar(1024), "column" varchar(1024), "type"
varchar(1024), "mode" varchar(15), location varchar(1024), "count" bigint,
typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash
boolean, "imprints" bigint, sorted boolean, revsorted boolean, "unique"
boolean, orderidx bigint) external name sql."storage";
@@ -1473,6 +1478,8 @@ create function sys.tracelog() returns t
create function sys.user_statistics() returns table(username string,
querycount bigint, totalticks bigint, started timestamp, finished timestamp,
maxticks bigint, maxquery string) external name sysmon.user_statistics;
create function sys.uuid() returns uuid external name uuid."new";
create function sys.uuid(d int) returns uuid external name uuid."new";
+create procedure sys.vacuum(sname string, tname string, cname string) external
name sql.vacuum;
+create procedure sys.vacuum(sname string, tname string, cname string, interval
int) external name sql.vacuum;
create function "sys"."var"() returns table("schema" string, "name" string,
"type" string, "value" string) external name "sql"."sql_variables";
create aggregate var_pop(val bigint) returns double external name
"aggr"."variancep";
create aggregate var_pop(val double) returns double external name
"aggr"."variancep";
@@ -4052,6 +4059,7 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "stddev_samp", "SYSTEM", "create window
stddev_samp(val smallint) returns double external name \"sql\".\"stdev\";",
"sql", "MAL", "Analytic function", false, false, false, true,
"result", "double", 53, 0, "out", "val", "smallint",
16, 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", "stddev_samp", "SYSTEM", "create window
stddev_samp(val tinyint) returns double external name \"sql\".\"stdev\";",
"sql", "MAL", "Analytic function", false, false, false, true,
"result", "double", 53, 0, "out", "val", "tinyint",
8, 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", "stop", "SYSTEM", "create procedure
sys.stop(tag bigint) external name sysmon.stop;", "sysmon", "MAL",
"Procedure", true, false, false, true, "tag", "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, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "stop_vacuum", "SYSTEM", "create
procedure sys.stop_vacuum(sname string, tname string, cname string) external
name sql.stop_vacuum;", "sql", "MAL", "Procedure", true, false,
false, true, "sname", "clob", 0, 0, "in", "tname",
"clob", 0, 0, "in", "cname", "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", "stopsession", "SYSTEM", "create
procedure sys.stopsession(\"sessionid\" int) external name
clients.stopsession;", "clients", "MAL", "Procedure", true,
false, false, true, "sessionid", "int", 32, 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, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "storage", "SYSTEM", "create
function sys.\"storage\"() returns table (\"schema\" varchar(1024), \"table\"
varchar(1024), \"column\" varchar(1024), \"type\" varchar(1024), \"mode\"
varchar(15), location varchar(1024), \"count\" bigint, typewidth int,
columnsize bigint, heapsize bigint, hashes bigint, phash boolean, \"imprints\"
bigint, sorted boolean, revsorted boolean, \"unique\" boolean, orderidx bigint)
external name sql.\"storage\";", "sql", "MAL", "Function returning a
table", true, false, false, true, "schema", "varchar", 1024,
0, "out", "table", "varchar", 1024, 0, "out",
"column", "varchar", 1024, 0, "out", "type", "varchar",
1024, 0, "out", "mode", "varchar", 15, 0, "out",
"location", "varchar", 1024, 0, "out", "count",
"bigint", 64, 0, "out", "typewidth", "int", 32, 0,
"out", "columnsize", "bigint", 64, 0, "out", "heapsize",
"bigint", 64, 0, "out", "hashes", "bigint", 64,
0, "out", "phash", "boolean", 1, 0, "out",
"imprints", "bigint", 64, 0, "out
", "sorted", "boolean", 1, 0, "out", "revsorted",
"boolean", 1, 0, "out", "unique", "boolean", 1,
0, "out" ]
[ "sys.functions", "sys", "storage", "SYSTEM", "create
function sys.\"storage\"(sname varchar(1024)) returns table (\"schema\"
varchar(1024), \"table\" varchar(1024), \"column\" varchar(1024), \"type\"
varchar(1024), \"mode\" varchar(15), location varchar(1024), \"count\" bigint,
typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash
boolean, \"imprints\" bigint, sorted boolean, revsorted boolean, \"unique\"
boolean, orderidx bigint) external name sql.\"storage\";", "sql",
"MAL", "Function returning a table", false, false, false, true,
"schema", "varchar", 1024, 0, "out", "table",
"varchar", 1024, 0, "out", "column", "varchar", 1024,
0, "out", "type", "varchar", 1024, 0, "out", "mode",
"varchar", 15, 0, "out", "location", "varchar", 1024,
0, "out", "count", "bigint", 64, 0, "out",
"typewidth", "int", 32, 0, "out", "columnsize", "bigint",
64, 0, "out", "heapsize", "bigint", 64, 0, "out",
"hashes", "bigint", 64, 0, "out", "phash",
"boolean", 1, 0, "out", "imprints", "
bigint", 64, 0, "out", "sorted", "boolean", 1,
0, "out", "revsorted", "boolean", 1, 0, "out",
"unique", "boolean", 1, 0, "out" ]
@@ -4132,6 +4140,8 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "usweekofyear", "SYSTEM", "usweekofyear",
"mtime", "Internal C", "Scalar function", false, false, false,
false, "res_0", "int", 32, 0, "out", "arg_1", "date",
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", "uuid", "SYSTEM", "create function
sys.uuid() returns uuid external name uuid.\"new\";", "uuid", "MAL", "Scalar
function", true, false, false, true, "result", "uuid", 0,
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, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "uuid", "SYSTEM", "create function
sys.uuid(d int) returns uuid external name uuid.\"new\";", "uuid", "MAL",
"Scalar function", false, false, false, true, "result", "uuid",
0, 0, "out", "d", "int", 32, 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", "vacuum", "SYSTEM", "create
procedure sys.vacuum(sname string, tname string, cname string) external name
sql.vacuum;", "sql", "MAL", "Procedure", true, false, false,
true, "sname", "clob", 0, 0, "in", "tname", "clob",
0, 0, "in", "cname", "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", "vacuum", "SYSTEM", "create
procedure sys.vacuum(sname string, tname string, cname string, interval int)
external name sql.vacuum;", "sql", "MAL", "Procedure", true,
false, false, true, "sname", "clob", 0, 0, "in",
"tname", "clob", 0, 0, "in", "cname", "clob", 0,
0, "in", "interval", "int", 32, 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", "var", "SYSTEM", "create function
\"sys\".\"var\"() returns table(\"schema\" string, \"name\" string, \"type\"
string, \"value\" string) external name \"sql\".\"sql_variables\";",
"sql", "SQL", "Function returning a table", false, false, false, true,
"schema", "clob", 0, 0, "out", "name", "clob", 0, 0,
"out", "type", "clob", 0, 0, "out", "value", "clob", 0,
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 ]
[ "sys.functions", "sys", "var_pop", "SYSTEM", "create
aggregate var_pop(val bigint) returns double external name
\"aggr\".\"variancep\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, "result", "double", 53, 0, "out",
"val", "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, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "var_pop", "SYSTEM", "create
aggregate var_pop(val double) returns double external name
\"aggr\".\"variancep\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, "result", "double", 53, 0, "out",
"val", "double", 53, 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 ]
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
@@ -363,6 +363,7 @@
\dSf sys."stddev_pop"
\dSf sys."stddev_samp"
\dSf sys."stop"
+\dSf sys."stop_vacuum"
\dSf sys."stopsession"
\dSf sys."storage"
\dSf sys."storagemodelinit"
@@ -376,6 +377,7 @@
\dSf sys."tracelog"
\dSf sys."user_statistics"
\dSf sys."uuid"
+\dSf sys."vacuum"
\dSf sys."var"
\dSf sys."var_pop"
\dSf sys."var_samp"
@@ -910,6 +912,7 @@ SYSTEM WINDOW sys.stddev_pop
SYSTEM AGGREGATE sys.stddev_samp
SYSTEM WINDOW sys.stddev_samp
SYSTEM PROCEDURE sys.stop
+SYSTEM PROCEDURE sys.stop_vacuum
SYSTEM PROCEDURE sys.stopsession
SYSTEM FUNCTION sys.storage
SYSTEM PROCEDURE sys.storagemodelinit
@@ -937,6 +940,7 @@ SYSTEM FUNCTION sys.upper
SYSTEM FUNCTION sys.user_statistics
SYSTEM FUNCTION sys.usweekofyear
SYSTEM FUNCTION sys.uuid
+SYSTEM PROCEDURE sys.vacuum
SYSTEM FUNCTION sys.var
SYSTEM AGGREGATE sys.var_pop
SYSTEM WINDOW sys.var_pop
@@ -1456,6 +1460,7 @@ create window stddev_samp(val real) retu
create window stddev_samp(val smallint) returns double external name
"sql"."stdev";
create window stddev_samp(val tinyint) returns double external name
"sql"."stdev";
create procedure sys.stop(tag bigint) external name sysmon.stop;
+create procedure sys.stop_vacuum(sname string, tname string, cname string)
external name sql.stop_vacuum;
create procedure sys.stopsession("sessionid" int) external name
clients.stopsession;
create function sys."storage"() returns table ("schema" varchar(1024), "table"
varchar(1024), "column" varchar(1024), "type" varchar(1024), "mode"
varchar(15), location varchar(1024), "count" bigint, typewidth int, columnsize
bigint, heapsize bigint, hashes bigint, phash boolean, "imprints" bigint,
sorted boolean, revsorted boolean, "unique" boolean, orderidx bigint) external
name sql."storage";
create function sys."storage"(sname varchar(1024)) returns table ("schema"
varchar(1024), "table" varchar(1024), "column" varchar(1024), "type"
varchar(1024), "mode" varchar(15), location varchar(1024), "count" bigint,
typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash
boolean, "imprints" bigint, sorted boolean, revsorted boolean, "unique"
boolean, orderidx bigint) external name sql."storage";
@@ -1473,6 +1478,8 @@ create function sys.tracelog() returns t
create function sys.user_statistics() returns table(username string,
querycount bigint, totalticks bigint, started timestamp, finished timestamp,
maxticks bigint, maxquery string) external name sysmon.user_statistics;
create function sys.uuid() returns uuid external name uuid."new";
create function sys.uuid(d int) returns uuid external name uuid."new";
+create procedure sys.vacuum(sname string, tname string, cname string) external
name sql.vacuum;
+create procedure sys.vacuum(sname string, tname string, cname string, interval
int) external name sql.vacuum;
create function "sys"."var"() returns table("schema" string, "name" string,
"type" string, "value" string) external name "sql"."sql_variables";
create aggregate var_pop(val bigint) returns double external name
"aggr"."variancep";
create aggregate var_pop(val double) returns double external name
"aggr"."variancep";
@@ -4051,6 +4058,7 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "stddev_samp", "SYSTEM", "create window
stddev_samp(val smallint) returns double external name \"sql\".\"stdev\";",
"sql", "MAL", "Analytic function", false, false, false, true,
"result", "double", 53, 0, "out", "val", "smallint",
16, 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", "stddev_samp", "SYSTEM", "create window
stddev_samp(val tinyint) returns double external name \"sql\".\"stdev\";",
"sql", "MAL", "Analytic function", false, false, false, true,
"result", "double", 53, 0, "out", "val", "tinyint",
8, 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", "stop", "SYSTEM", "create procedure
sys.stop(tag bigint) external name sysmon.stop;", "sysmon", "MAL",
"Procedure", true, false, false, true, "tag", "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, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "stop_vacuum", "SYSTEM", "create
procedure sys.stop_vacuum(sname string, tname string, cname string) external
name sql.stop_vacuum;", "sql", "MAL", "Procedure", true, false,
false, true, "sname", "clob", 0, 0, "in", "tname",
"clob", 0, 0, "in", "cname", "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", "stopsession", "SYSTEM", "create
procedure sys.stopsession(\"sessionid\" int) external name
clients.stopsession;", "clients", "MAL", "Procedure", true,
false, false, true, "sessionid", "int", 32, 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, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "storage", "SYSTEM", "create
function sys.\"storage\"() returns table (\"schema\" varchar(1024), \"table\"
varchar(1024), \"column\" varchar(1024), \"type\" varchar(1024), \"mode\"
varchar(15), location varchar(1024), \"count\" bigint, typewidth int,
columnsize bigint, heapsize bigint, hashes bigint, phash boolean, \"imprints\"
bigint, sorted boolean, revsorted boolean, \"unique\" boolean, orderidx bigint)
external name sql.\"storage\";", "sql", "MAL", "Function returning a
table", true, false, false, true, "schema", "varchar", 1024,
0, "out", "table", "varchar", 1024, 0, "out",
"column", "varchar", 1024, 0, "out", "type", "varchar",
1024, 0, "out", "mode", "varchar", 15, 0, "out",
"location", "varchar", 1024, 0, "out", "count",
"bigint", 64, 0, "out", "typewidth", "int", 32, 0,
"out", "columnsize", "bigint", 64, 0, "out", "heapsize",
"bigint", 64, 0, "out", "hashes", "bigint", 64,
0, "out", "phash", "boolean", 1, 0, "out",
"imprints", "bigint", 64, 0, "out
", "sorted", "boolean", 1, 0, "out", "revsorted",
"boolean", 1, 0, "out", "unique", "boolean", 1,
0, "out" ]
[ "sys.functions", "sys", "storage", "SYSTEM", "create
function sys.\"storage\"(sname varchar(1024)) returns table (\"schema\"
varchar(1024), \"table\" varchar(1024), \"column\" varchar(1024), \"type\"
varchar(1024), \"mode\" varchar(15), location varchar(1024), \"count\" bigint,
typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash
boolean, \"imprints\" bigint, sorted boolean, revsorted boolean, \"unique\"
boolean, orderidx bigint) external name sql.\"storage\";", "sql",
"MAL", "Function returning a table", false, false, false, true,
"schema", "varchar", 1024, 0, "out", "table",
"varchar", 1024, 0, "out", "column", "varchar", 1024,
0, "out", "type", "varchar", 1024, 0, "out", "mode",
"varchar", 15, 0, "out", "location", "varchar", 1024,
0, "out", "count", "bigint", 64, 0, "out",
"typewidth", "int", 32, 0, "out", "columnsize", "bigint",
64, 0, "out", "heapsize", "bigint", 64, 0, "out",
"hashes", "bigint", 64, 0, "out", "phash",
"boolean", 1, 0, "out", "imprints", "
bigint", 64, 0, "out", "sorted", "boolean", 1,
0, "out", "revsorted", "boolean", 1, 0, "out",
"unique", "boolean", 1, 0, "out" ]
@@ -4131,6 +4139,8 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "usweekofyear", "SYSTEM", "usweekofyear",
"mtime", "Internal C", "Scalar function", false, false, false,
false, "res_0", "int", 32, 0, "out", "arg_1", "date",
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", "uuid", "SYSTEM", "create function
sys.uuid() returns uuid external name uuid.\"new\";", "uuid", "MAL", "Scalar
function", true, false, false, true, "result", "uuid", 0,
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, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "uuid", "SYSTEM", "create function
sys.uuid(d int) returns uuid external name uuid.\"new\";", "uuid", "MAL",
"Scalar function", false, false, false, true, "result", "uuid",
0, 0, "out", "d", "int", 32, 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", "vacuum", "SYSTEM", "create
procedure sys.vacuum(sname string, tname string, cname string) external name
sql.vacuum;", "sql", "MAL", "Procedure", true, false, false,
true, "sname", "clob", 0, 0, "in", "tname", "clob",
0, 0, "in", "cname", "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", "vacuum", "SYSTEM", "create
procedure sys.vacuum(sname string, tname string, cname string, interval int)
external name sql.vacuum;", "sql", "MAL", "Procedure", true,
false, false, true, "sname", "clob", 0, 0, "in",
"tname", "clob", 0, 0, "in", "cname", "clob", 0,
0, "in", "interval", "int", 32, 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", "var", "SYSTEM", "create function
\"sys\".\"var\"() returns table(\"schema\" string, \"name\" string, \"type\"
string, \"value\" string) external name \"sql\".\"sql_variables\";",
"sql", "SQL", "Function returning a table", false, false, false, true,
"schema", "clob", 0, 0, "out", "name", "clob", 0, 0,
"out", "type", "clob", 0, 0, "out", "value", "clob", 0,
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 ]
[ "sys.functions", "sys", "var_pop", "SYSTEM", "create
aggregate var_pop(val bigint) returns double external name
\"aggr\".\"variancep\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, "result", "double", 53, 0, "out",
"val", "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, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "var_pop", "SYSTEM", "create
aggregate var_pop(val double) returns double external name
\"aggr\".\"variancep\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, "result", "double", 53, 0, "out",
"val", "double", 53, 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 ]
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
@@ -363,6 +363,7 @@
\dSf sys."stddev_pop"
\dSf sys."stddev_samp"
\dSf sys."stop"
+\dSf sys."stop_vacuum"
\dSf sys."stopsession"
\dSf sys."storage"
\dSf sys."storagemodelinit"
@@ -376,6 +377,7 @@
\dSf sys."tracelog"
\dSf sys."user_statistics"
\dSf sys."uuid"
+\dSf sys."vacuum"
\dSf sys."var"
\dSf sys."var_pop"
\dSf sys."var_samp"
@@ -910,6 +912,7 @@ SYSTEM WINDOW sys.stddev_pop
SYSTEM AGGREGATE sys.stddev_samp
SYSTEM WINDOW sys.stddev_samp
SYSTEM PROCEDURE sys.stop
+SYSTEM PROCEDURE sys.stop_vacuum
SYSTEM PROCEDURE sys.stopsession
SYSTEM FUNCTION sys.storage
SYSTEM PROCEDURE sys.storagemodelinit
@@ -937,6 +940,7 @@ SYSTEM FUNCTION sys.upper
SYSTEM FUNCTION sys.user_statistics
SYSTEM FUNCTION sys.usweekofyear
SYSTEM FUNCTION sys.uuid
+SYSTEM PROCEDURE sys.vacuum
SYSTEM FUNCTION sys.var
SYSTEM AGGREGATE sys.var_pop
SYSTEM WINDOW sys.var_pop
@@ -1472,6 +1476,7 @@ create window stddev_samp(val real) retu
create window stddev_samp(val smallint) returns double external name
"sql"."stdev";
create window stddev_samp(val tinyint) returns double external name
"sql"."stdev";
create procedure sys.stop(tag bigint) external name sysmon.stop;
+create procedure sys.stop_vacuum(sname string, tname string, cname string)
external name sql.stop_vacuum;
create procedure sys.stopsession("sessionid" int) external name
clients.stopsession;
create function sys."storage"() returns table ("schema" varchar(1024), "table"
varchar(1024), "column" varchar(1024), "type" varchar(1024), "mode"
varchar(15), location varchar(1024), "count" bigint, typewidth int, columnsize
bigint, heapsize bigint, hashes bigint, phash boolean, "imprints" bigint,
sorted boolean, revsorted boolean, "unique" boolean, orderidx bigint) external
name sql."storage";
create function sys."storage"(sname varchar(1024)) returns table ("schema"
varchar(1024), "table" varchar(1024), "column" varchar(1024), "type"
varchar(1024), "mode" varchar(15), location varchar(1024), "count" bigint,
typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash
boolean, "imprints" bigint, sorted boolean, revsorted boolean, "unique"
boolean, orderidx bigint) external name sql."storage";
@@ -1489,6 +1494,8 @@ create function sys.tracelog() returns t
create function sys.user_statistics() returns table(username string,
querycount bigint, totalticks bigint, started timestamp, finished timestamp,
maxticks bigint, maxquery string) external name sysmon.user_statistics;
create function sys.uuid() returns uuid external name uuid."new";
create function sys.uuid(d int) returns uuid external name uuid."new";
+create procedure sys.vacuum(sname string, tname string, cname string) external
name sql.vacuum;
+create procedure sys.vacuum(sname string, tname string, cname string, interval
int) external name sql.vacuum;
create function "sys"."var"() returns table("schema" string, "name" string,
"type" string, "value" string) external name "sql"."sql_variables";
create aggregate var_pop(val bigint) returns double external name
"aggr"."variancep";
create aggregate var_pop(val double) returns double external name
"aggr"."variancep";
@@ -4230,6 +4237,7 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "stddev_samp", "SYSTEM", "create window
stddev_samp(val smallint) returns double external name \"sql\".\"stdev\";",
"sql", "MAL", "Analytic function", false, false, false, true,
"result", "double", 53, 0, "out", "val", "smallint",
16, 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", "stddev_samp", "SYSTEM", "create window
stddev_samp(val tinyint) returns double external name \"sql\".\"stdev\";",
"sql", "MAL", "Analytic function", false, false, false, true,
"result", "double", 53, 0, "out", "val", "tinyint",
8, 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", "stop", "SYSTEM", "create procedure
sys.stop(tag bigint) external name sysmon.stop;", "sysmon", "MAL",
"Procedure", true, false, false, true, "tag", "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, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
+[ "sys.functions", "sys", "stop_vacuum", "SYSTEM", "create
procedure sys.stop_vacuum(sname string, tname string, cname string) external
name sql.stop_vacuum;", "sql", "MAL", "Procedure", true, false,
false, true, "sname", "clob", 0, 0, "in", "tname",
"clob", 0, 0, "in", "cname", "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", "stopsession", "SYSTEM", "create
procedure sys.stopsession(\"sessionid\" int) external name
clients.stopsession;", "clients", "MAL", "Procedure", true,
false, false, true, "sessionid", "int", 32, 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, NULL,
NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "storage", "SYSTEM", "create
function sys.\"storage\"() returns table (\"schema\" varchar(1024), \"table\"
varchar(1024), \"column\" varchar(1024), \"type\" varchar(1024), \"mode\"
varchar(15), location varchar(1024), \"count\" bigint, typewidth int,
columnsize bigint, heapsize bigint, hashes bigint, phash boolean, \"imprints\"
bigint, sorted boolean, revsorted boolean, \"unique\" boolean, orderidx bigint)
external name sql.\"storage\";", "sql", "MAL", "Function returning a
table", true, false, false, true, "schema", "varchar", 1024,
0, "out", "table", "varchar", 1024, 0, "out",
"column", "varchar", 1024, 0, "out", "type", "varchar",
1024, 0, "out", "mode", "varchar", 15, 0, "out",
"location", "varchar", 1024, 0, "out", "count",
"bigint", 64, 0, "out", "typewidth", "int", 32, 0,
"out", "columnsize", "bigint", 64, 0, "out", "heapsize",
"bigint", 64, 0, "out", "hashes", "bigint", 64,
0, "out", "phash", "boolean", 1, 0, "out",
"imprints", "bigint", 64, 0, "out
", "sorted", "boolean", 1, 0, "out", "revsorted",
"boolean", 1, 0, "out", "unique", "boolean", 1,
0, "out" ]
[ "sys.functions", "sys", "storage", "SYSTEM", "create
function sys.\"storage\"(sname varchar(1024)) returns table (\"schema\"
varchar(1024), \"table\" varchar(1024), \"column\" varchar(1024), \"type\"
varchar(1024), \"mode\" varchar(15), location varchar(1024), \"count\" bigint,
typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash
boolean, \"imprints\" bigint, sorted boolean, revsorted boolean, \"unique\"
boolean, orderidx bigint) external name sql.\"storage\";", "sql",
"MAL", "Function returning a table", false, false, false, true,
"schema", "varchar", 1024, 0, "out", "table",
"varchar", 1024, 0, "out", "column", "varchar", 1024,
0, "out", "type", "varchar", 1024, 0, "out", "mode",
"varchar", 15, 0, "out", "location", "varchar", 1024,
0, "out", "count", "bigint", 64, 0, "out",
"typewidth", "int", 32, 0, "out", "columnsize", "bigint",
64, 0, "out", "heapsize", "bigint", 64, 0, "out",
"hashes", "bigint", 64, 0, "out", "phash",
"boolean", 1, 0, "out", "imprints", "
bigint", 64, 0, "out", "sorted", "boolean", 1,
0, "out", "revsorted", "boolean", 1, 0, "out",
"unique", "boolean", 1, 0, "out" ]
@@ -4314,6 +4322,8 @@ select 'null in value_partitions.value',
[ "sys.functions", "sys", "usweekofyear", "SYSTEM", "usweekofyear",
"mtime", "Internal C", "Scalar function", false, false, false,
false, "res_0", "int", 32, 0, "out", "arg_1", "date",
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", "uuid", "SYSTEM", "create function
sys.uuid() returns uuid external name uuid.\"new\";", "uuid", "MAL", "Scalar
function", true, false, false, true, "result", "uuid", 0,
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, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "uuid", "SYSTEM", "create function
sys.uuid(d int) returns uuid external name uuid.\"new\";", "uuid", "MAL",
"Scalar function", false, false, false, true, "result", "uuid",
0, 0, "out", "d", "int", 32, 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", "vacuum", "SYSTEM", "create
procedure sys.vacuum(sname string, tname string, cname string) external name
sql.vacuum;", "sql", "MAL", "Procedure", true, false, false,
true, "sname", "clob", 0, 0, "in", "tname", "clob",
0, 0, "in", "cname", "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", "vacuum", "SYSTEM", "create
procedure sys.vacuum(sname string, tname string, cname string, interval int)
external name sql.vacuum;", "sql", "MAL", "Procedure", true,
false, false, true, "sname", "clob", 0, 0, "in",
"tname", "clob", 0, 0, "in", "cname", "clob", 0,
0, "in", "interval", "int", 32, 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", "var", "SYSTEM", "create function
\"sys\".\"var\"() returns table(\"schema\" string, \"name\" string, \"type\"
string, \"value\" string) external name \"sql\".\"sql_variables\";",
"sql", "SQL", "Function returning a table", false, false, false, true,
"schema", "clob", 0, 0, "out", "name", "clob", 0, 0,
"out", "type", "clob", 0, 0, "out", "value", "clob", 0,
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 ]
[ "sys.functions", "sys", "var_pop", "SYSTEM", "create
aggregate var_pop(val bigint) returns double external name
\"aggr\".\"variancep\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, "result", "double", 53, 0, "out",
"val", "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, NULL, NULL, NULL, NULL, NULL ]
[ "sys.functions", "sys", "var_pop", "SYSTEM", "create
aggregate var_pop(val double) returns double external name
\"aggr\".\"variancep\";", "aggr", "MAL", "Aggregate function", false,
false, false, true, "result", "double", 53, 0, "out",
"val", "double", 53, 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 ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
