Changeset: c2a598ff9f4a for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c2a598ff9f4a
Modified Files:
clients/Tests/MAL-signatures.stable.out
clients/Tests/MAL-signatures.stable.out.int128
clients/Tests/SQL-dump.stable.out
clients/Tests/SQL-dump.stable.out.int128
Branch: orderidx
Log Message:
approve tests
diffs (truncated from 513 to 300 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
@@ -51083,10 +51083,18 @@ command profiler.setheartbeat(b:int):voi
address CMDsetHeartbeat;
comment Set heart beat performance tracing
+command profiler.stoptrace(path:str):void
+address CMDstopTracePath;
+comment Stop collecting trace information
+
command profiler.stoptrace():void
address CMDstopTrace;
comment Stop collecting trace information
+command profiler.starttrace(path:str):void
+address CMDstartTracePath;
+comment Start collecting trace information and keep around in 'path' directory
+
command profiler.starttrace():void
address CMDstartTrace;
comment Start collecting trace information
@@ -51099,6 +51107,10 @@ pattern profiler.start():void
address CMDstartProfiler;
comment Start offline performance profiling
+pattern querylog.append(q:str,pipe:str,usr:str,tick:timestamp):void
+address QLOGappend;
+comment Add a new query call to the query log
+
pattern
querylog.call(tick1:timestamp,tick2:timestamp,arg:str,tuples:wrd,xtime:lng,rtime:lng,cpu:int,iowait:int):void
address QLOGcall;
comment Add a new query call to the query log
@@ -51123,10 +51135,6 @@ command querylog.enable(threshold:int):v
address QLOGenableThreshold;
comment Turn on the query logger
-pattern querylog.insert(q:str,pipe:str,usr:str,tick:timestamp):void
-address QLOGinsert;
-comment Add a new query call to the query log
-
command querylog.isset():int
address QLOGissetFcn;
comment Return status of query logger
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
@@ -51080,10 +51080,18 @@ command profiler.setheartbeat(b:int):voi
address CMDsetHeartbeat;
comment Set heart beat performance tracing
+command profiler.stoptrace(path:str):void
+address CMDstopTracePath;
+comment Stop collecting trace information
+
command profiler.stoptrace():void
address CMDstopTrace;
comment Stop collecting trace information
+command profiler.starttrace(path:str):void
+address CMDstartTracePath;
+comment Start collecting trace information and keep around in 'path' directory
+
command profiler.starttrace():void
address CMDstartTrace;
comment Start collecting trace information
@@ -51096,6 +51104,10 @@ pattern profiler.start():void
address CMDstartProfiler;
comment Start offline performance profiling
+pattern querylog.append(q:str,pipe:str,usr:str,tick:timestamp):void
+address QLOGappend;
+comment Add a new query call to the query log
+
pattern
querylog.call(tick1:timestamp,tick2:timestamp,arg:str,tuples:wrd,xtime:lng,rtime:lng,cpu:int,iowait:int):void
address QLOGcall;
comment Add a new query call to the query log
@@ -51120,10 +51132,6 @@ command querylog.enable(threshold:int):v
address QLOGenableThreshold;
comment Turn on the query logger
-pattern querylog.insert(q:str,pipe:str,usr:str,tick:timestamp):void
-address QLOGinsert;
-comment Add a new query call to the query log
-
command querylog.isset():int
address QLOGissetFcn;
comment Return status of query logger
diff --git a/clients/Tests/SQL-dump.stable.out
b/clients/Tests/SQL-dump.stable.out
--- a/clients/Tests/SQL-dump.stable.out
+++ b/clients/Tests/SQL-dump.stable.out
@@ -139,6 +139,7 @@ Ready.
\dSf sys."columnsize"
\dSf sys."contains"
\dSf sys."corr"
+\dSf sys."createorderindex"
\dSf sys."date_to_str"
\dSf sys."db_users"
\dSf sys."debug"
@@ -160,6 +161,7 @@ Ready.
\dSf sys."dependencies_tables_on_views"
\dSf sys."dependencies_views_on_functions"
\dSf sys."dependencies_views_on_triggers"
+\dSf sys."droporderindex"
\dSf sys."env"
\dSf sys."environment"
\dSf sys."epoch"
@@ -449,6 +451,7 @@ SYSTEM FUNCTION sys.cosh
SYSTEM FUNCTION sys.cot
SYSTEM FUNCTION sys.count
SYSTEM FUNCTION sys.count_no_nil
+SYSTEM FUNCTION sys.createorderindex
SYSTEM FUNCTION sys.curdate
SYSTEM FUNCTION sys.current_date
SYSTEM FUNCTION sys.current_time
@@ -482,6 +485,7 @@ SYSTEM FUNCTION sys.dependencies_views_
SYSTEM FUNCTION sys.dependencies_views_on_triggers
SYSTEM FUNCTION sys.diff
SYSTEM FUNCTION sys.difference
+SYSTEM FUNCTION sys.droporderindex
SYSTEM FUNCTION sys.editdistance
SYSTEM FUNCTION sys.editdistance2
SYSTEM FUNCTION sys.env
@@ -817,7 +821,7 @@ CREATE TABLE "sys"."schemas" ("id" INTEG
CREATE TABLE "sys"."sequences" ("id" INTEGER, "schema_id" INTEGER, "name"
VARCHAR(256), "start" BIGINT, "minvalue" BIGINT, "maxvalue" BIGINT, "increment"
BIGINT, "cacheinc" BIGINT, "cycle" BOOLEAN);
CREATE TABLE "sys"."spatial_ref_sys" ("srid" INTEGER NOT NULL, "auth_name"
VARCHAR(256), "auth_srid" INTEGER, "srtext" VARCHAR(2048), "proj4text"
VARCHAR(2048), CONSTRAINT "spatial_ref_sys_srid_pkey" PRIMARY KEY ("srid"));
CREATE TABLE "sys"."statistics" ("column_id" INTEGER, "type" CHARACTER LARGE
OBJECT, "width" INTEGER, "stamp" TIMESTAMP, "sample" BIGINT, "count" BIGINT,
"unique" BIGINT, "nils" BIGINT, "minval" CHARACTER LARGE OBJECT, "maxval"
CHARACTER LARGE OBJECT, "sorted" BOOLEAN);
-CREATE TABLE "sys"."storagemodelinput" ("schema" CHARACTER LARGE OBJECT,
"table" CHARACTER LARGE OBJECT, "column" CHARACTER LARGE OBJECT, "type"
CHARACTER LARGE OBJECT, "typewidth" INTEGER, "count" BIGINT, "distinct" BIGINT,
"atomwidth" INTEGER, "reference" BOOLEAN, "sorted" BOOLEAN);
+CREATE TABLE "sys"."storagemodelinput" ("schema" CHARACTER LARGE OBJECT,
"table" CHARACTER LARGE OBJECT, "column" CHARACTER LARGE OBJECT, "type"
CHARACTER LARGE OBJECT, "typewidth" INTEGER, "count" BIGINT, "distinct" BIGINT,
"atomwidth" INTEGER, "reference" BOOLEAN, "sorted" BOOLEAN, "orderidx" BIGINT);
CREATE TABLE "sys"."systemfunctions" ("function_id" INTEGER);
CREATE TABLE "sys"."table_types" ("table_type_id" SMALLINT NOT NULL,
"table_type_name" VARCHAR(25) NOT NULL, CONSTRAINT
"table_types_table_type_id_pkey" PRIMARY KEY ("table_type_id"), CONSTRAINT
"table_types_table_type_name_unique" UNIQUE ("table_type_name"));
CREATE TABLE "sys"."triggers" ("id" INTEGER, "name" VARCHAR(1024), "table_id"
INTEGER, "time" SMALLINT, "orientation" SMALLINT, "event" SMALLINT, "old_name"
VARCHAR(1024), "new_name" VARCHAR(1024), "condition" VARCHAR(2048), "statement"
VARCHAR(2048));
@@ -885,6 +889,7 @@ create function dependencies_tables_on_t
create function dependencies_tables_on_views() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
t.name, v.name, 'DEP_VIEW' from tables as t, tables as v, dependencies as dep
where t.id = dep.id and v.id = dep.depend_id and dep.depend_type = 5 and v.type
= 1);
create function dependencies_views_on_functions() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
v.name, f.name, 'DEP_FUNC' from functions as f, tables as v, dependencies as
dep where v.id = dep.id and f.id = dep.depend_id and dep.depend_type = 7 and
v.type = 1);
create function dependencies_views_on_triggers() returns table (sch
varchar(100), usr varchar(100), dep_type varchar(32)) return table (select
v.name, tri.name, 'DEP_TRIGGER' from tables as v, triggers as tri, dependencies
as dep where dep.id = v.id and dep.depend_id =tri.id and dep.depend_type = 8
and v.type = 1);
+create procedure sys.droporderindex(sys string, tab string, col string)
external name sql.droporderindex;
CREATE FUNCTION env () RETURNS TABLE(name varchar(1024), value varchar(2048))
EXTERNAL NAME sql.sql_environment;
create function sys.environment() returns table ("name" string, value string)
external name sql.sql_environment;
create function sys."epoch"(sec bigint) returns timestamp external name
timestamp."epoch";
@@ -1155,12 +1160,12 @@ create aggregate stddev_samp(val time) r
create aggregate stddev_samp(val timestamp) returns double external name
"aggr"."stdev";
create procedure sys.stop(tag int) external name sql.sysmon_stop;
create procedure sys.stop(tag bigint) external name sql.sysmon_stop;
-create function sys."storage"() returns table ("schema" string, "table"
string, "column" string, "type" string, "mode" string, location string, "count"
bigint, typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash
boolean, imprints bigint, sorted boolean) external name sql."storage";
-create function sys."storage"(sname string) returns table ("schema" string,
"table" string, "column" string, "type" string, "mode" string, location string,
"count" bigint, typewidth int, columnsize bigint, heapsize bigint, hashes
bigint, phash boolean, imprints bigint, sorted boolean) external name
sql."storage";
-create function sys."storage"(sname string, tname string) returns table
("schema" string, "table" string, "column" string, "type" string, "mode"
string, location string, "count" bigint, typewidth int, columnsize bigint,
heapsize bigint, hashes bigint, phash boolean, imprints bigint, sorted boolean)
external name sql."storage";
-create function sys."storage"(sname string, tname string, cname string)
returns table ("schema" string, "table" string, "column" string, "type" string,
"mode" string, location string, "count" bigint, typewidth int, columnsize
bigint, heapsize bigint, hashes bigint, phash boolean, imprints bigint, sorted
boolean) external name sql."storage";
-create function sys.storagemodel() returns table ("schema" string, "table"
string, "column" string, "type" string, "count" bigint, columnsize bigint,
heapsize bigint, hashes bigint, imprints bigint, sorted boolean) begin return
select i."schema", i."table", i."column", i."type", i."count",
columnsize(i."type", i.count, i."distinct"), heapsize(i."type", i."distinct",
i."atomwidth"), hashsize(i."reference", i."count"),
imprintsize(i."count",i."type"), i.sorted from sys.storagemodelinput i; end;
-create procedure sys.storagemodelinit() begin delete from
sys.storagemodelinput; insert into sys.storagemodelinput select x."schema",
x."table", x."column", x."type", x.typewidth, x.count, 0, x.typewidth, false,
x.sorted from sys."storage"() x; update sys.storagemodelinput set reference =
true where concat(concat("schema","table"), "column") in (select
concat(concat("fkschema"."name", "fktable"."name"), "fkkeycol"."name") from
"sys"."keys" as "fkkey", "sys"."objects" as "fkkeycol", "sys"."tables" as
"fktable", "sys"."schemas" as "fkschema" where "fktable"."id" =
"fkkey"."table_id" and "fkkey"."id" = "fkkeycol"."id" and "fkschema"."id" =
"fktable"."schema_id" and "fkkey"."rkey" > -1); update sys.storagemodelinput
set "distinct" = "count" where "type" = 'varchar' or "type"='clob'; end;
+create function sys."storage"() returns table ("schema" string, "table"
string, "column" string, "type" string, "mode" string, location string, "count"
bigint, typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash
boolean, imprints bigint, sorted boolean, orderidx bigint) external name
sql."storage";
+create function sys."storage"(sname string) returns table ("schema" string,
"table" string, "column" string, "type" string, "mode" string, location string,
"count" bigint, typewidth int, columnsize bigint, heapsize bigint, hashes
bigint, phash boolean, imprints bigint, sorted boolean, orderidx bigint)
external name sql."storage";
+create function sys."storage"(sname string, tname string) returns table
("schema" string, "table" string, "column" string, "type" string, "mode"
string, location string, "count" bigint, typewidth int, columnsize bigint,
heapsize bigint, hashes bigint, phash boolean, imprints bigint, sorted boolean,
orderidx bigint) external name sql."storage";
+create function sys."storage"(sname string, tname string, cname string)
returns table ("schema" string, "table" string, "column" string, "type" string,
"mode" string, location string, "count" bigint, typewidth int, columnsize
bigint, heapsize bigint, hashes bigint, phash boolean, imprints bigint, sorted
boolean, orderidx bigint) external name sql."storage";
+create function sys.storagemodel() returns table ("schema" string, "table"
string, "column" string, "type" string, "count" bigint, columnsize bigint,
heapsize bigint, hashes bigint, imprints bigint, sorted boolean, orderidx
bigint) begin return select i."schema", i."table", i."column", i."type",
i."count", columnsize(i."type", i.count, i."distinct"), heapsize(i."type",
i."distinct", i."atomwidth"), hashsize(i."reference", i."count"),
imprintsize(i."count",i."type"), i.sorted, i.orderidx from
sys.storagemodelinput i; end;
+create procedure sys.storagemodelinit() begin delete from
sys.storagemodelinput; insert into sys.storagemodelinput select x."schema",
x."table", x."column", x."type", x.typewidth, x.count, 0, x.typewidth, false,
x.sorted, x.orderidx from sys."storage"() x; update sys.storagemodelinput set
reference = true where concat(concat("schema","table"), "column") in (select
concat(concat("fkschema"."name", "fktable"."name"), "fkkeycol"."name") from
"sys"."keys" as "fkkey", "sys"."objects" as "fkkeycol", "sys"."tables" as
"fktable", "sys"."schemas" as "fkschema" where "fktable"."id" =
"fkkey"."table_id" and "fkkey"."id" = "fkkeycol"."id" and "fkschema"."id" =
"fktable"."schema_id" and "fkkey"."rkey" > -1); update sys.storagemodelinput
set "distinct" = "count" where "type" = 'varchar' or "type"='clob'; end;
create function str_to_date(s string, format string) returns date external
name mtime."str_to_date";
create function str_to_time(s string, format string) returns time external
name mtime."str_to_time";
create function str_to_timestamp(s string, format string) returns timestamp
external name mtime."str_to_timestamp";
@@ -1648,6 +1653,7 @@ drop function pcre_replace(string, strin
[ "storage", "phash", "boolean", 1, 0, NULL, true,
11, NULL ]
[ "storage", "imprints", "bigint", 64, 0, NULL, true,
12, NULL ]
[ "storage", "sorted", "boolean", 1, 0, NULL, true,
13, NULL ]
+[ "storage", "orderidx", "bigint", 64, 0, NULL, true,
14, NULL ]
[ "storagemodel", "schema", "clob", 0, 0, NULL, true,
0, NULL ]
[ "storagemodel", "table", "clob", 0, 0, NULL, true,
1, NULL ]
[ "storagemodel", "column", "clob", 0, 0, NULL, true,
2, NULL ]
@@ -1658,6 +1664,7 @@ drop function pcre_replace(string, strin
[ "storagemodel", "hashes", "bigint", 64, 0, NULL,
true, 7, NULL ]
[ "storagemodel", "imprints", "bigint", 64, 0, NULL,
true, 8, NULL ]
[ "storagemodel", "sorted", "boolean", 1, 0, NULL,
true, 9, NULL ]
+[ "storagemodel", "orderidx", "bigint", 64, 0, NULL,
true, 10, NULL ]
[ "storagemodelinput", "schema", "clob", 0, 0, NULL, true,
0, NULL ]
[ "storagemodelinput", "table", "clob", 0, 0, NULL, true,
1, NULL ]
[ "storagemodelinput", "column", "clob", 0, 0, NULL, true,
2, NULL ]
@@ -1668,6 +1675,7 @@ drop function pcre_replace(string, strin
[ "storagemodelinput", "atomwidth", "int", 32, 0, NULL, true,
7, NULL ]
[ "storagemodelinput", "reference", "boolean", 1, 0, NULL,
true, 8, NULL ]
[ "storagemodelinput", "sorted", "boolean", 1, 0, NULL,
true, 9, NULL ]
+[ "storagemodelinput", "orderidx", "bigint", 64, 0, NULL,
true, 10, NULL ]
[ "systemfunctions", "function_id", "int", 32, 0, NULL, true,
0, NULL ]
[ "table_types", "table_type_id", "smallint", 16, 0,
NULL, false, 0, NULL ]
[ "table_types", "table_type_name", "varchar", 25, 0,
NULL, false, 1, NULL ]
@@ -1740,7 +1748,7 @@ drop function pcre_replace(string, strin
% .s, .f, .L, .f, .f, .f, .f, .f, .f # table_name
% name, name, query, mod, language, type, side_effect,
varres, vararg # name
% varchar, varchar, varchar, varchar, int, int,
boolean, boolean, boolean # type
-% 8, 35, 794, 9, 1, 1, 5, 5, 5 # length
+% 8, 35, 806, 9, 1, 1, 5, 5, 5 # length
[ "bam", "bam_drop_file", "create procedure
bam.bam_drop_file(file_id bigint, dbschema smallint) external name
bam.bam_drop_file;", "bam", 1, 2, true, false, false ]
[ "bam", "bam_export", "create procedure bam.bam_export(output_path
string) external name bam.bam_export;", "bam", 1, 2, true,
false, false ]
[ "bam", "bam_flag", "create function bam.bam_flag(flag smallint,
name string) returns boolean external name bam.bam_flag;", "bam", 1, 1,
false, false, false ]
@@ -1904,6 +1912,7 @@ drop function pcre_replace(string, strin
[ "sys", "cot", "cot", "mmath", 0, 1, false, false,
false ]
[ "sys", "count", "count", "aggr", 0, 3, false,
false, false ]
[ "sys", "count_no_nil", "count_no_nil", "aggr", 0, 3, false,
false, false ]
+[ "sys", "createorderindex", "create procedure
sys.createorderindex(sys string, tab string, col string) external name
sql.createorderindex;", "sql", 1, 2, true, false, false ]
[ "sys", "curdate", "current_date", "mtime", 0, 1,
false, false, false ]
[ "sys", "current_date", "current_date", "mtime", 0, 1,
false, false, false ]
[ "sys", "current_time", "current_time", "mtime", 0, 1,
false, false, false ]
@@ -1943,6 +1952,7 @@ drop function pcre_replace(string, strin
[ "sys", "difference", "stringdiff", "txtsim", 0, 1,
false, false, false ]
[ "sys", "difference", "stringdiff", "txtsim", 0, 1,
false, false, false ]
[ "sys", "difference", "stringdiff", "txtsim", 0, 1,
false, false, false ]
+[ "sys", "droporderindex", "create procedure
sys.droporderindex(sys string, tab string, col string) external name
sql.droporderindex;", "sql", 1, 2, true, false, false ]
[ "sys", "editdistance", "editdistance", "txtsim", 0, 1,
false, false, false ]
[ "sys", "editdistance", "editdistance", "txtsim", 0, 1,
false, false, false ]
[ "sys", "editdistance", "editdistance", "txtsim", 0, 1,
false, false, false ]
@@ -3279,12 +3289,12 @@ drop function pcre_replace(string, strin
[ "sys", "stddev_samp", "create aggregate stddev_samp(val wrd) returns
double external name \"aggr\".\"stdev\";", "aggr", 1, 3, false,
false, false ]
[ "sys", "stop", "create procedure sys.stop(tag bigint) external name
sql.sysmon_stop;", "sql", 1, 2, true, false, false ]
[ "sys", "stop", "create procedure sys.stop(tag int) external name
sql.sysmon_stop;", "sql", 1, 2, true, false, false ]
-[ "sys", "storage", "create function sys.\"storage\"() returns
table (\"schema\" string, \"table\" string, \"column\" string, \"type\" string,
\"mode\" string, location string, \"count\" bigint, typewidth int, columnsize
bigint, heapsize bigint, hashes bigint, phash boolean, imprints bigint, sorted
boolean) external name sql.\"storage\";", "sql", 1, 5, false,
false, false ]
-[ "sys", "storage", "create function sys.\"storage\"(sname string)
returns table (\"schema\" string, \"table\" string, \"column\" string, \"type\"
string, \"mode\" string, location string, \"count\" bigint, typewidth int,
columnsize bigint, heapsize bigint, hashes bigint, phash boolean, imprints
bigint, sorted boolean) external name sql.\"storage\";", "sql", 1, 5,
false, false, false ]
-[ "sys", "storage", "create function sys.\"storage\"(sname string,
tname string) returns table (\"schema\" string, \"table\" string, \"column\"
string, \"type\" string, \"mode\" string, location string, \"count\" bigint,
typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash
boolean, imprints bigint, sorted boolean) external name sql.\"storage\";",
"sql", 1, 5, false, false, false ]
-[ "sys", "storage", "create function sys.\"storage\"(sname string,
tname string, cname string) returns table (\"schema\" string, \"table\" string,
\"column\" string, \"type\" string, \"mode\" string, location string, \"count\"
bigint, typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash
boolean, imprints bigint, sorted boolean) external name sql.\"storage\";",
"sql", 1, 5, false, false, false ]
-[ "sys", "storagemodel", "create function sys.storagemodel() returns
table (\"schema\" string, \"table\" string, \"column\" string, \"type\" string,
\"count\" bigint, columnsize bigint, heapsize bigint, hashes bigint, imprints
bigint, sorted boolean) begin return select i.\"schema\", i.\"table\",
i.\"column\", i.\"type\", i.\"count\", columnsize(i.\"type\", i.count,
i.\"distinct\"), heapsize(i.\"type\", i.\"distinct\", i.\"atomwidth\"),
hashsize(i.\"reference\", i.\"count\"), imprintsize(i.\"count\",i.\"type\"),
i.sorted from sys.storagemodelinput i; end;", "user", 2, 5,
false, false, false ]
-[ "sys", "storagemodelinit", "create procedure
sys.storagemodelinit() begin delete from sys.storagemodelinput; insert into
sys.storagemodelinput select x.\"schema\", x.\"table\", x.\"column\",
x.\"type\", x.typewidth, x.count, 0, x.typewidth, false, x.sorted from
sys.\"storage\"() x; update sys.storagemodelinput set reference = true where
concat(concat(\"schema\",\"table\"), \"column\") in (select
concat(concat(\"fkschema\".\"name\", \"fktable\".\"name\"),
\"fkkeycol\".\"name\") from \"sys\".\"keys\" as \"fkkey\", \"sys\".\"objects\"
as \"fkkeycol\", \"sys\".\"tables\" as \"fktable\", \"sys\".\"schemas\" as
\"fkschema\" where \"fktable\".\"id\" = \"fkkey\".\"table_id\" and
\"fkkey\".\"id\" = \"fkkeycol\".\"id\" and \"fkschema\".\"id\" =
\"fktable\".\"schema_id\" and \"fkkey\".\"rkey\" > -1); update
sys.storagemodelinput set \"distinct\" = \"count\" where \"type\" = 'varchar'
or \"type\"='clob'; end;", "user", 2, 2, true, false, false ]
+[ "sys", "storage", "create function sys.\"storage\"() returns
table (\"schema\" string, \"table\" string, \"column\" string, \"type\" string,
\"mode\" string, location string, \"count\" bigint, typewidth int, columnsize
bigint, heapsize bigint, hashes bigint, phash boolean, imprints bigint, sorted
boolean, orderidx bigint) external name sql.\"storage\";", "sql", 1,
5, false, false, false ]
+[ "sys", "storage", "create function sys.\"storage\"(sname string)
returns table (\"schema\" string, \"table\" string, \"column\" string, \"type\"
string, \"mode\" string, location string, \"count\" bigint, typewidth int,
columnsize bigint, heapsize bigint, hashes bigint, phash boolean, imprints
bigint, sorted boolean, orderidx bigint) external name sql.\"storage\";",
"sql", 1, 5, false, false, false ]
+[ "sys", "storage", "create function sys.\"storage\"(sname string,
tname string) returns table (\"schema\" string, \"table\" string, \"column\"
string, \"type\" string, \"mode\" string, location string, \"count\" bigint,
typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash
boolean, imprints bigint, sorted boolean, orderidx bigint) external name
sql.\"storage\";", "sql", 1, 5, false, false, false ]
+[ "sys", "storage", "create function sys.\"storage\"(sname string,
tname string, cname string) returns table (\"schema\" string, \"table\" string,
\"column\" string, \"type\" string, \"mode\" string, location string, \"count\"
bigint, typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash
boolean, imprints bigint, sorted boolean, orderidx bigint) external name
sql.\"storage\";", "sql", 1, 5, false, false, false ]
+[ "sys", "storagemodel", "create function sys.storagemodel() returns
table (\"schema\" string, \"table\" string, \"column\" string, \"type\" string,
\"count\" bigint, columnsize bigint, heapsize bigint, hashes bigint, imprints
bigint, sorted boolean, orderidx bigint) begin return select i.\"schema\",
i.\"table\", i.\"column\", i.\"type\", i.\"count\", columnsize(i.\"type\",
i.count, i.\"distinct\"), heapsize(i.\"type\", i.\"distinct\",
i.\"atomwidth\"), hashsize(i.\"reference\", i.\"count\"),
imprintsize(i.\"count\",i.\"type\"), i.sorted, i.orderidx from
sys.storagemodelinput i; end;", "user", 2, 5, false, false, false
]
+[ "sys", "storagemodelinit", "create procedure
sys.storagemodelinit() begin delete from sys.storagemodelinput; insert into
sys.storagemodelinput select x.\"schema\", x.\"table\", x.\"column\",
x.\"type\", x.typewidth, x.count, 0, x.typewidth, false, x.sorted, x.orderidx
from sys.\"storage\"() x; update sys.storagemodelinput set reference = true
where concat(concat(\"schema\",\"table\"), \"column\") in (select
concat(concat(\"fkschema\".\"name\", \"fktable\".\"name\"),
\"fkkeycol\".\"name\") from \"sys\".\"keys\" as \"fkkey\", \"sys\".\"objects\"
as \"fkkeycol\", \"sys\".\"tables\" as \"fktable\", \"sys\".\"schemas\" as
\"fkschema\" where \"fktable\".\"id\" = \"fkkey\".\"table_id\" and
\"fkkey\".\"id\" = \"fkkeycol\".\"id\" and \"fkschema\".\"id\" =
\"fktable\".\"schema_id\" and \"fkkey\".\"rkey\" > -1); update
sys.storagemodelinput set \"distinct\" = \"count\" where \"type\" = 'varchar'
or \"type\"='clob'; end;", "user", 2, 2, true, false, false
]
[ "sys", "str_to_date", "create function str_to_date(s string, format
string) returns date external name mtime.\"str_to_date\";", "mtime",
1, 1, false, false, false ]
[ "sys", "str_to_time", "create function str_to_time(s string, format
string) returns time external name mtime.\"str_to_time\";", "mtime",
1, 1, false, false, false ]
[ "sys", "str_to_timestamp", "create function str_to_timestamp(s
string, format string) returns timestamp external name
mtime.\"str_to_timestamp\";", "mtime", 1, 1, false,
false, false ]
@@ -3544,6 +3554,7 @@ drop function pcre_replace(string, strin
[ "sys", "cot", "arg_1", "real", 24, 0, 1, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 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", "count", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 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", "count_no_nil", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 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", "createorderindex", "tab", "clob", 0, 0, 1,
"col", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, 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", "curdate", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 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", "current_date", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 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", "current_time", NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
@@ -3583,6 +3594,7 @@ drop function pcre_replace(string, strin
[ "sys", "difference", "arg_1", "char", 0, 0, 1,
"arg_2", "char", 0, 0, 1, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "difference", "arg_1", "clob", 0, 0, 1,
"arg_2", "clob", 0, 0, 1, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "difference", "arg_1", "varchar", 0, 0,
1, "arg_2", "varchar", 0, 0, 1, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "droporderindex", "tab", "clob", 0, 0, 1,
"col", "clob", 0, 0, 1, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, 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", "editdistance", "arg_1", "char", 0, 0, 1,
"arg_2", "char", 0, 0, 1, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "editdistance", "arg_1", "clob", 0, 0, 1,
"arg_2", "clob", 0, 0, 1, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "editdistance", "arg_1", "varchar", 0, 0,
1, "arg_2", "varchar", 0, 0, 1, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL ]
@@ -4919,11 +4931,11 @@ drop function pcre_replace(string, strin
[ "sys", "stddev_samp", "val", "wrd", 64, 0, 1, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, 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", "stop", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, 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", "stop", NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, 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", "storage", "table", "clob", 0, 0, 0,
"column", "clob", 0, 0, 0, "type", "clob", 0, 0,
0, "mode", "clob", 0, 0, 0, "location", "clob", 0,
0, 0, "count", "bigint", 64, 0, 0,
"typewidth", "int", 32, 0, 0, "columnsize", "bigint",
64, 0, 0, "heapsize", "bigint", 64, 0, 0,
"hashes", "bigint", 64, 0, 0, "phash",
"boolean", 1, 0, 0, "imprints", "bigint", 64,
0, 0, "sorted", "boolean", 1, 0, 0, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ]
-[ "sys", "storage", "table", "clob", 0, 0, 0,
"column", "clob", 0, 0, 0, "type", "clob", 0, 0,
0, "mode", "clob", 0, 0, 0, "location", "clob", 0,
0, 0, "count", "bigint", 64, 0, 0,
"typewidth", "int", 32, 0, 0, "columnsize", "bigint",
64, 0, 0, "heapsize", "bigint", 64, 0, 0,
"hashes", "bigint", 64, 0, 0, "phash",
"boolean", 1, 0, 0, "imprints", "bigint", 64,
0, 0, "sorted", "boolean", 1, 0, 0,
"sname", "clob", 0, 0, 1, NULL, NULL, NULL, NULL,
NULL ]
-[ "sys", "storage", "table", "clob", 0, 0, 0,
"column", "clob", 0, 0, 0, "type", "clob", 0, 0,
0, "mode", "clob", 0, 0, 0, "location", "clob", 0,
0, 0, "count", "bigint", 64, 0, 0,
"typewidth", "int", 32, 0, 0, "columnsize", "bigint",
64, 0, 0, "heapsize", "bigint", 64, 0, 0,
"hashes", "bigint", 64, 0, 0, "phash",
"boolean", 1, 0, 0, "imprints", "bigint", 64,
0, 0, "sorted", "boolean", 1, 0, 0,
"sname", "clob", 0, 0, 1, "tname", "clob", 0,
0, 1 ]
-[ "sys", "storage", "table", "clob", 0, 0, 0,
"column", "clob", 0, 0, 0, "type", "clob", 0, 0,
0, "mode", "clob", 0, 0, 0, "location", "clob", 0,
0, 0, "count", "bigint", 64, 0, 0,
"typewidth", "int", 32, 0, 0, "columnsize", "bigint",
64, 0, 0, "heapsize", "bigint", 64, 0, 0,
"hashes", "bigint", 64, 0, 0, "phash",
"boolean", 1, 0, 0, "imprints", "bigint", 64,
0, 0, "sorted", "boolean", 1, 0, 0,
"sname", "clob", 0, 0, 1, "tname", "clob", 0,
0, 1 ]
-[ "sys", "storagemodel", "table", "clob", 0, 0, 0,
"column", "clob", 0, 0, 0, "type", "clob", 0, 0,
0, "count", "bigint", 64, 0, 0, "columnsize",
"bigint", 64, 0, 0, "heapsize", "bigint", 64,
0, 0, "hashes", "bigint", 64, 0, 0,
"imprints", "bigint", 64, 0, 0, "sorted",
"boolean", 1, 0, 0, NULL, NULL, NULL, NULL, NULL,
NULL, 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", "storage", "table", "clob", 0, 0, 0,
"column", "clob", 0, 0, 0, "type", "clob", 0, 0,
0, "mode", "clob", 0, 0, 0, "location", "clob", 0,
0, 0, "count", "bigint", 64, 0, 0,
"typewidth", "int", 32, 0, 0, "columnsize", "bigint",
64, 0, 0, "heapsize", "bigint", 64, 0, 0,
"hashes", "bigint", 64, 0, 0, "phash",
"boolean", 1, 0, 0, "imprints", "bigint", 64,
0, 0, "sorted", "boolean", 1, 0, 0,
"orderidx", "bigint", 64, 0, 0, NULL, NULL, NULL,
NULL, NULL ]
+[ "sys", "storage", "table", "clob", 0, 0, 0,
"column", "clob", 0, 0, 0, "type", "clob", 0, 0,
0, "mode", "clob", 0, 0, 0, "location", "clob", 0,
0, 0, "count", "bigint", 64, 0, 0,
"typewidth", "int", 32, 0, 0, "columnsize", "bigint",
64, 0, 0, "heapsize", "bigint", 64, 0, 0,
"hashes", "bigint", 64, 0, 0, "phash",
"boolean", 1, 0, 0, "imprints", "bigint", 64,
0, 0, "sorted", "boolean", 1, 0, 0,
"orderidx", "bigint", 64, 0, 0, "sname", "clob",
0, 0, 1 ]
+[ "sys", "storage", "table", "clob", 0, 0, 0,
"column", "clob", 0, 0, 0, "type", "clob", 0, 0,
0, "mode", "clob", 0, 0, 0, "location", "clob", 0,
0, 0, "count", "bigint", 64, 0, 0,
"typewidth", "int", 32, 0, 0, "columnsize", "bigint",
64, 0, 0, "heapsize", "bigint", 64, 0, 0,
"hashes", "bigint", 64, 0, 0, "phash",
"boolean", 1, 0, 0, "imprints", "bigint", 64,
0, 0, "sorted", "boolean", 1, 0, 0,
"orderidx", "bigint", 64, 0, 0, "sname", "clob",
0, 0, 1 ]
+[ "sys", "storage", "table", "clob", 0, 0, 0,
"column", "clob", 0, 0, 0, "type", "clob", 0, 0,
0, "mode", "clob", 0, 0, 0, "location", "clob", 0,
0, 0, "count", "bigint", 64, 0, 0,
"typewidth", "int", 32, 0, 0, "columnsize", "bigint",
64, 0, 0, "heapsize", "bigint", 64, 0, 0,
"hashes", "bigint", 64, 0, 0, "phash",
"boolean", 1, 0, 0, "imprints", "bigint", 64,
0, 0, "sorted", "boolean", 1, 0, 0,
"orderidx", "bigint", 64, 0, 0, "sname", "clob",
0, 0, 1 ]
+[ "sys", "storagemodel", "table", "clob", 0, 0, 0,
"column", "clob", 0, 0, 0, "type", "clob", 0, 0,
0, "count", "bigint", 64, 0, 0, "columnsize",
"bigint", 64, 0, 0, "heapsize", "bigint", 64,
0, 0, "hashes", "bigint", 64, 0, 0,
"imprints", "bigint", 64, 0, 0, "sorted",
"boolean", 1, 0, 0, "orderidx", "bigint", 64,
0, 0, NULL, 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", "storagemodelinit", NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, 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", "str_to_date", "s", "clob", 0, 0, 1,
"format", "clob", 0, 0, 1, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, 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", "str_to_time", "s", "clob", 0, 0, 1,
"format", "clob", 0, 0, 1, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
NULL ]
@@ -5189,6 +5201,7 @@ drop function pcre_replace(string, strin
[ "sys", "storagemodelinput", "column", "sys", "storagemodel",
"FUNC_DEPENDENCY" ]
[ "sys", "storagemodelinput", "count", "sys", "storagemodel",
"FUNC_DEPENDENCY" ]
[ "sys", "storagemodelinput", "distinct", "sys", "storagemodel",
"FUNC_DEPENDENCY" ]
+[ "sys", "storagemodelinput", "orderidx", "sys", "storagemodel",
"FUNC_DEPENDENCY" ]
[ "sys", "storagemodelinput", "reference", "sys", "storagemodel",
"FUNC_DEPENDENCY" ]
[ "sys", "storagemodelinput", "schema", "sys", "storagemodel",
"FUNC_DEPENDENCY" ]
[ "sys", "storagemodelinput", "sorted", "sys", "storagemodel",
"FUNC_DEPENDENCY" ]
@@ -5198,6 +5211,7 @@ drop function pcre_replace(string, strin
[ "sys", "storagemodelinput", "column", "sys",
"storagemodelinit", "PROC_DEPENDENCY" ]
[ "sys", "storagemodelinput", "count", "sys",
"storagemodelinit", "PROC_DEPENDENCY" ]
[ "sys", "storagemodelinput", "distinct", "sys",
"storagemodelinit", "PROC_DEPENDENCY" ]
+[ "sys", "storagemodelinput", "orderidx", "sys",
"storagemodelinit", "PROC_DEPENDENCY" ]
[ "sys", "storagemodelinput", "reference", "sys",
"storagemodelinit", "PROC_DEPENDENCY" ]
[ "sys", "storagemodelinput", "schema", "sys",
"storagemodelinit", "PROC_DEPENDENCY" ]
[ "sys", "storagemodelinput", "sorted", "sys",
"storagemodelinit", "PROC_DEPENDENCY" ]
@@ -5629,6 +5643,7 @@ drop function pcre_replace(string, strin
[ "cot" ]
[ "count" ]
[ "count_no_nil" ]
+[ "createorderindex" ]
[ "curdate" ]
[ "current_date" ]
[ "current_time" ]
@@ -5668,6 +5683,7 @@ drop function pcre_replace(string, strin
[ "difference" ]
[ "difference" ]
[ "difference" ]
+[ "droporderindex" ]
[ "editdistance" ]
[ "editdistance" ]
[ "editdistance" ]
diff --git a/clients/Tests/SQL-dump.stable.out.int128
b/clients/Tests/SQL-dump.stable.out.int128
--- a/clients/Tests/SQL-dump.stable.out.int128
+++ b/clients/Tests/SQL-dump.stable.out.int128
@@ -135,6 +135,7 @@ Ready.
\dSf sys."columnsize"
\dSf sys."contains"
\dSf sys."corr"
+\dSf sys."createorderindex"
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
