Test check.SQL.py (id 350cc55cd57a) (err)
check.stable.out.int128.FILTERED 2018-12-07 00:56:42.747454487 +0100check.test.out.FILTERED 2018-12-07 00:56:42.994460762 +0100
1 Statistics about stdout of test 'check` in directory 'sql/test/emptydb-upgrade`: 1 1 Statistics about stdout of test 'check` in directory 'sql/test/emptydb-upgrade`: 1
2 5314 lines, 210131 words, 1370193 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5274 lines, 209370 words, 1363646 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5314 lines, 210131 words, 1370193 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5274 lines, 209370 words, 1363646 chars in lines not matching '^$|^(\| |)#` 3
4 # 5395 lines, 212570 words, 1387351 chars in all lines 4 ! 4 # 5355 lines, 211807 words, 1380837 chars in all lines 4
5 5 5 5
..................
# 10:17:18 >
130 \dSv sys.roles 130 130 \dSv sys.roles 130
131 \dSv sys.schemastorage 131 -
132 \dSv sys.sessions 132 131 \dSv sys.sessions 131
..................
# 10:17:18 >
136 \dSv sys.tables 136 135 \dSv sys.tables 135
137 \dSv sys.tablestorage 137 -
138 \dSv sys.tablestoragemodel 138 136 \dSv sys.tablestoragemodel 136
..................
# 10:17:18 >
349 \dSf sys."storage" 349 347 \dSf sys."storage" 347
+ 348 \dSf sys."storagemodel" 348
350 \dSf sys."storagemodelinit" 350 349 \dSf sys."storagemodelinit" 349
..................
# 10:17:18 >
441 SYSTEM VIEW sys.roles 441 440 SYSTEM VIEW sys.roles 440
442 SYSTEM VIEW sys.schemastorage 442 -
443 SYSTEM VIEW sys.sessions 443 441 SYSTEM VIEW sys.sessions 441
..................
# 10:17:18 >
447 SYSTEM VIEW sys.tables 447 445 SYSTEM VIEW sys.tables 445
448 SYSTEM VIEW sys.tablestorage 448 -
449 SYSTEM VIEW sys.tablestoragemodel 449 446 SYSTEM VIEW sys.tablestoragemodel 446
..................
# 10:17:18 >
811 SYSTEM FUNCTION sys.storage 811 808 SYSTEM FUNCTION sys.storage 808
+ 809 SYSTEM FUNCTION sys.storagemodel 809
812 SYSTEM PROCEDURE sys.storagemodelinit 812 810 SYSTEM PROCEDURE sys.storagemodelinit 810
..................
# 10:17:18 >
883 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, "revsorted" BOOLEAN); 883 881 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, "revsorted" BOOLEAN); 881
884 CREATE TABLE "sys"."storagemodelinput" ("schema" VARCHAR(1024) NOT NULL, "table" VARCHAR(1024) NOT NULL, "column" VARCHAR(1024) NOT NULL, "type" VARCHAR(1024) NOT NULL, "typewidth" INTEGER NOT NULL, "count" BIGINT NOT NULL, "distinct" BIGINT NOT NULL, "atomwidth" INTEGER NOT NULL, "reference" BOOLEAN NOT NULL DEFAULT false, "sorted" BOOLEAN, "unique" BOOLEAN, "isacolumn" BOOLEAN NOT NULL DEFAULT true); 884 ! 882 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, "revsorted" BOOLEAN, "unique" BOOLEAN, "orderidx" BIGINT); 882
885 CREATE TABLE "sys"."table_partitions" ("id" INTEGER, "table_id" INTEGER, "column_id" INTEGER, "expression" VARCHAR(2048), "type" TINYINT); 885 883 CREATE TABLE "sys"."table_partitions" ("id" INTEGER, "table_id" INTEGER, "column_id" INTEGER, "expression" VARCHAR(2048), "type" TINYINT); 883
..................
# 10:17:18 >
933 create view sys.roles as select id, name, grantor from sys.auths a where a.name not in (select u.name from sys.db_users() u); 933 931 create view sys.roles as select id, name, grantor from sys.auths a where a.name not in (select u.name from sys.db_users() u); 931
934 create view sys."schemastorage" as select "schema", count(*) as "storages", sum(columnsize) as columnsize, sum(heapsize) as heapsize, sum(hashes) as hashsize, sum("imprints") as imprintsize, sum(orderidx) as orderidxsize from sys."storage" group by "schema" order by "schema"; 934 -
935 create view sys.sessions as select * from sys.sessions(); 935 932 create view sys.sessions as select * from sys.sessions(); 932
936 create view sys."storage" as select * from sys."storage"() where ("schema", "table") in (select sch."name", tbl."name" from sys."tables" as tbl join sys."schemas" as sch on tbl.schema_id = sch.id where tbl."system" = false) order by "schema", "table", "column"; 936 - 933 create view sys."storage" as select * from sys."storage"(); 933
937 create view sys.storagemodel as select "schema", "table", "column", "type", "count", columnsize("type", "count") as columnsize, heapsize("type", "count", "distinct", "atomwidth") as heapsize, hashsize("reference", "count") as hashsize, case when isacolumn then imprintsize("type", "count") else 0 end as imprintsize, case when (isacolumn and not sorted) then cast(8 * "count" as bigint) else 0 end as orderidxsize, sorted, "unique", isacolumn from sys.storagemodelinput order by "schema", "table", "column"; 937 ! 934 create view sys.storagemodel as select * from sys.storagemodel(); 934
938 create view sys.systemfunctions as select id as function_id from sys.functions where system; 938 935 create view sys.systemfunctions as select id as function_id from sys.functions where system; 935
939 SELECT "id", "name", "schema_id", "query", CAST(CASE WHEN "system" THEN "type" + 10 ELSE (CASE WHEN "commit_action" = 0 THEN "type" ELSE "type" + 20 END) END AS SMALLINT) AS "type", "system", "commit_action", "access", CASE WHEN (NOT "system" AND "commit_action" > 0) THEN 1 ELSE 0 END AS "temporary" FROM "sys"."_tables" WHERE "type" <> 2 UNION ALL SELECT "id", "name", "schema_id", "query", CAST("type" + 30 AS SMALLINT) AS "type", "system", "commit_action", "access", 1 AS "temporary" FROM "tmp"."_tables"; 939 936 SELECT "id", "name", "schema_id", "query", CAST(CASE WHEN "system" THEN "type" + 10 ELSE (CASE WHEN "commit_action" = 0 THEN "type" ELSE "type" + 20 END) END AS SMALLINT) AS "type", "system", "commit_action", "access", CASE WHEN (NOT "system" AND "commit_action" > 0) THEN 1 ELSE 0 END AS "temporary" FROM "sys"."_tables" WHERE "type" <> 2 UNION ALL SELECT "id", "name", "schema_id", "query", CAST("type" + 30 AS SMALLINT) AS "type", "system", "commit_action", "access", 1 AS "temporary" FROM "tmp"."_tables"; 936
940 create view sys."tablestorage" as select "schema", "table", max("count") as "rowcount", count(*) as "storages", sum(columnsize) as columnsize, sum(heapsize) as heapsize, sum(hashes) as hashsize, sum("imprints") as imprintsize, sum(orderidx) as orderidxsize from sys."storage" group by "schema", "table" order by "schema", "table"; 940 ! 937 create view sys.tablestoragemodel as select "schema","table",max(count) as "count", sum(columnsize) as columnsize, sum(heapsize) as heapsize, sum(hashes) as hashes, sum("imprints") as "imprints", sum(case when sorted = false then 8 * count else 0 end) as auxiliary from sys.storagemodel() group by "schema","table"; 937
941 create view sys.tablestoragemodel as select "schema", "table", max("count") as "rowcount", count(*) as "storages", sum(columnsize("type", "count")) as columnsize, sum(heapsize("type", "count", "distinct", "atomwidth")) as heapsize, sum(hashsize("reference", "count")) as hashsize, sum(case when isacolumn then imprintsize("type", "count") else 0 end) as imprintsize, sum(case when (isacolumn and not sorted) then cast(8 * "count" as bigint) else 0 end) as orderidxsize from sys.storagemodelinput group by "schema", "table" order by "schema", "table"; 941 -
942 create view sys.tracelog as select * from sys.tracelog(); 942 938 create view sys.tracelog as select * from sys.tracelog(); 938
..................
# 10:17:18 >
953 create procedure sys.clearrejects() external name sql.copy_rejects_clear; 953 949 create procedure sys.clearrejects() external name sql.copy_rejects_clear; 949
954 create function sys.columnsize(tpe varchar(1024), count bigint) returns bigint begin if tpe in ('tinyint', 'boolean') then return count; end if; if tpe = 'smallint' then return 2 * count; end if; if tpe in ('int', 'real', 'date', 'time', 'timetz', 'sec_interval', 'month_interval') then return 4 * count; end if; if tpe in ('bigint', 'double', 'timestamp', 'timestamptz', 'inet', 'oid') then return 8 * count; end if; if tpe in ('hugeint', 'decimal', 'uuid', 'mbr') then return 16 * count; end if; if tpe in ('varchar', 'char', 'clob', 'json', 'url') then return 4 * count; end if; if tpe in ('blob', 'geometry', 'geometrya') then return 8 * count; end if; return 8 * count; end; 954 ! 950 create function sys.columnsize(nme string, i bigint, d bigint) returns bigint begin case when nme = 'boolean' then return i; when nme = 'char' then return 2*i; when nme = 'smallint' then return 2 * i; when nme = 'int' then return 4 * i; when nme = 'bigint' then return 8 * i; when nme = 'hugeint' then return 16 * i; when nme = 'timestamp' then return 8 * i; when nme = 'varchar' then case when cast(d as bigint) << 8 then return i; when cast(d as bigint) << 16 then return 2 * i; when cast(d as bigint) << 32 then return 4 * i; else return 8 * i; end case; else return 8 * i; end case; end; 950
955 create function contains(a geometry, x double, y double) returns boolean external name geom."Contains"; 955 951 create function contains(a geometry, x double, y double) returns boolean external name geom."Contains"; 951
..................
# 10:17:18 >
1015 create function has_z(info integer) returns integer external name geom."hasZ"; 1015 1011 create function has_z(info integer) returns integer external name geom."hasZ"; 1011
1016 create function sys.hashsize(b boolean, count bigint) returns bigint begin if b = true then return 8 * count; end if; return 0; end; 1016 ! 1012 create function sys.hashsize(b boolean, i bigint) returns bigint begin if b = true then return 8 * i; end if; return 0; end; 1012
1017 create function sys.heapsize(tpe varchar(1024), count bigint, distincts bigint, avgwidth int) returns bigint begin if tpe in ('varchar', 'char', 'clob', 'json', 'url') then return 8192 + ((avgwidth + 8) * distincts); end if; if tpe in ('blob', 'geometry', 'geometrya') then return 32 + (avgwidth * count); end if; return 0; end; 1017 ! 1013 create function sys.heapsize(tpe string, i bigint, w int) returns bigint begin if tpe <> 'varchar' and tpe <> 'clob' then return 0; end if; return 10240 + i * w; end; 1013
1018 create function "host" (p inet) returns clob external name inet."host"; 1018 1014 create function "host" (p inet) returns clob external name inet."host"; 1014
..................
# 10:17:18 >
1021 create filter function "ilike"(val string, pat string, esc string) external name algebra."ilike"; 1021 1017 create filter function "ilike"(val string, pat string, esc string) external name algebra."ilike"; 1017
1022 create function sys.imprintsize(tpe varchar(1024), count bigint) returns bigint begin if tpe in ('tinyint', 'boolean') then return cast(0.2 * count as bigint); end if; if tpe = 'smallint' then return cast(0.4 * count as bigint); end if; if tpe in ('int', 'real', 'date', 'time', 'timetz', 'sec_interval', 'month_interval') then return cast(0.8 * count as bigint); end if; if tpe in ('bigint', 'double', 'timestamp', 'timestamptz', 'inet', 'oid') then return cast(1.6 * count as bigint); end if; if tpe in ('hugeint', 'decimal', 'uuid', 'mbr') then return cast(3.2 * count as bigint); end if; return 0; end; 1022 ! 1018 create function sys.imprintsize(i bigint, nme string) returns bigint begin if nme = 'boolean' or nme = 'tinyint' or nme = 'smallint' or nme = 'int' or nme = 'bigint' or nme = 'hugeint' or nme = 'decimal' or nme = 'date' or nme = 'timestamp' or nme = 'real' or nme = 'double' then return cast(i * 0.12 as bigint); end if ; return 0; end; 1018
1023 create function internaltransform(geom geometry, srid_src integer, srid_dest integer, proj4_src string, proj4_dest string) returns geometry external name geom."Transform"; 1023 1019 create function internaltransform(geom geometry, srid_src integer, srid_dest integer, proj4_src string, proj4_dest string) returns geometry external name geom."Transform"; 1019
..................
# 10:17:18 >
1260 create procedure stopmaster() external name wlc.stopmaster; 1260 1256 create procedure stopmaster() external name wlc.stopmaster; 1256
1261 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"; 1261 ! 1257 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, revsorted boolean, "unique" boolean, orderidx bigint) external name sql."storage"; 1257
1262 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"; 1262 ! 1258 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, revsorted boolean, "unique" boolean, orderidx bigint) external name sql."storage"; 1258
1263 create function sys."storage"(sname varchar(1024), tname 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"; 1263 ! 1259 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, revsorted boolean, "unique" boolean, orderidx bigint) external name sql."storage"; 1259
1264 create function sys."storage"(sname varchar(1024), tname varchar(1024), cname 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"; 1264 ! 1260 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, revsorted boolean, "unique" boolean, orderidx bigint) external name sql."storage"; 1260
create procedure sys.storagemodelinit() begin delete from sys.storagemodelinput; insert into sys.storagemodelinput select "schema", "table", "column", "type", typewidth, "count", case when ("unique" or "type" in ('varchar', 'char', 'clob', 'json', 'url', 'blob', 'geometry', 'geometrya')) then "count" else 0 end, case when "count" > 0 and heapsize >= 8192 and "type" in ('varchar', 'char', 'clob', 'json', 'url') then cast((heapsize - 8192) / "count" as bigint) when "count" > 0 and heapsize >= 32 and "type" + 1261 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, revsorted boolean, "unique" 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.revsorted, i."unique", i.orderidx from sys.storagemodelinput i; end; 1261
1265 in ('blob', 'geometry', 'geometrya') then cast((heapsize - 32) / "count" as bigint) else typewidth end, false, case sorted when true then true else false end, "unique", true from sys."storage"; update sys.storagemodelinput set reference = true where ("schema", "table", "column") in (select 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 isacolumn = false where ("schema", "table", "column") not in (select sch."name", tbl."name", col."name" from sys."schemas" as sch, sys."tables" as tbl, sys."columns" as col where sch."id" = tbl."schema_id" and tbl."id" = col."table_id"); end; 1265 ! 1262 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.revsorted, x."unique", 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; 1262
1266 create function str_to_date(s string, format string) returns date external name mtime."str_to_date"; 1266 1263 create function str_to_date(s string, format string) returns date external name mtime."str_to_date"; 1263
..................
# .s, .t, .L10, .L12, .t,
1454 [ "sys", "schemas", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1454 1451 [ "sys", "schemas", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1451
1455 [ "sys", "schemastorage", "create view sys.\"schemastorage\" as select \"schema\", count(*) as \"storages\", sum(columnsize) as columnsize, sum(heapsize) as heapsize, sum(hashes) as hashsize, sum(\"imprints\") as imprintsize, sum(orderidx) as orderidxsize from sys.\"storage\" group by \"schema\" order by \"schema\";", "VIEW", true, "COMMIT", "WRITABLE" ] 1455 -
1456 [ "sys", "sequences", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1456 1452 [ "sys", "sequences", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1452
..................
# .s, .t, .L10, .L12, .t,
1459 [ "sys", "statistics", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1459 1455 [ "sys", "statistics", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1455
1460 [ "sys", "storage", "create view sys.\"storage\" as select * from sys.\"storage\"() where (\"schema\", \"table\") in (select sch.\"name\", tbl.\"name\" from sys.\"tables\" as tbl join sys.\"schemas\" as sch on tbl.schema_id = sch.id where tbl.\"system\" = false) order by \"schema\", \"table\", \"column\";", "VIEW", true, "COMMIT", "WRITABLE" ] 1460 ! 1456 [ "sys", "storage", "create view sys.\"storage\" as select * from sys.\"storage\"();", "VIEW", true, "COMMIT", "WRITABLE" ] 1456
1461 [ "sys", "storagemodel", "create view sys.storagemodel as select \"schema\", \"table\", \"column\", \"type\", \"count\", columnsize(\"type\", \"count\") as columnsize, heapsize(\"type\", \"count\", \"distinct\", \"atomwidth\") as heapsize, hashsize(\"reference\", \"count\") as hashsize, case when isacolumn then imprintsize(\"type\", \"count\") else 0 end as imprintsize, case when (isacolumn and not sorted) then cast(8 * \"count\" as bigint) else 0 end as orderidxsize, sorted, \"unique\", isacolumn from sys.storagemodelinput order by \"schema\", \"table\", \"column\";", "VIEW", true, "COMMIT", "WRITABLE" ] 1461 ! 1457 [ "sys", "storagemodel", "create view sys.storagemodel as select * from sys.storagemodel();", "VIEW", true, "COMMIT", "WRITABLE" ] 1457
1462 [ "sys", "storagemodelinput", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1462 1458 [ "sys", "storagemodelinput", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1458
..................
# .s, .t, .L10, .L12, .t,
1466 [ "sys", "tables", "SELECT \"id\", \"name\", \"schema_id\", \"query\", CAST(CASE WHEN \"system\" THEN \"type\" + 10 /* system table/view */ ELSE (CASE WHEN \"commit_action\" = 0 THEN \"type\" /* table/view */ ELSE \"type\" + 20 /* global temp table */ END) END AS SMALLINT) AS \"type\", \"system\", \"commit_action\", \"access\", CASE WHEN (NOT \"system\" AND \"commit_action\" > 0) THEN 1 ELSE 0 END AS \"temporary\" FROM \"sys\".\"_tables\" WHERE \"type\" <> 2 UNION ALL SELECT \"id\", \"name\", \"schema_id\", \"query\", CAST(\"type\" + 30 /* local temp table */ AS SMALLINT) AS \"type\", \"system\", \"commit_action\", \"access\", 1 AS \"temporary\" FROM \"tmp\".\"_tables\";", "VIEW", true, "COMMIT", "WRITABLE" ] 1466 1462 [ "sys", "tables", "SELECT \"id\", \"name\", \"schema_id\", \"query\", CAST(CASE WHEN \"system\" THEN \"type\" + 10 /* system table/view */ ELSE (CASE WHEN \"commit_action\" = 0 THEN \"type\" /* table/view */ ELSE \"type\" + 20 /* global temp table */ END) END AS SMALLINT) AS \"type\", \"system\", \"commit_action\", \"access\", CASE WHEN (NOT \"system\" AND \"commit_action\" > 0) THEN 1 ELSE 0 END AS \"temporary\" FROM \"sys\".\"_tables\" WHERE \"type\" <> 2 UNION ALL SELECT \"id\", \"name\", \"schema_id\", \"query\", CAST(\"type\" + 30 /* local temp table */ AS SMALLINT) AS \"type\", \"system\", \"commit_action\", \"access\", 1 AS \"temporary\" FROM \"tmp\".\"_tables\";", "VIEW", true, "COMMIT", "WRITABLE" ] 1462
1467 [ "sys", "tablestorage", "create view sys.\"tablestorage\" as select \"schema\", \"table\", max(\"count\") as \"rowcount\", count(*) as \"storages\", sum(columnsize) as columnsize, sum(heapsize) as heapsize, sum(hashes) as hashsize, sum(\"imprints\") as imprintsize, sum(orderidx) as orderidxsize from sys.\"storage\" group by \"schema\", \"table\" order by \"schema\", \"table\";", "VIEW", true, "COMMIT", "WRITABLE" ] 1467 ! 1463 [ "sys", "tablestoragemodel", "create view sys.tablestoragemodel as select \"schema\",\"table\",max(count) as \"count\", sum(columnsize) as columnsize, sum(heapsize) as heapsize, sum(hashes) as hashes, sum(\"imprints\") as \"imprints\", sum(case when sorted = false then 8 * count else 0 end) as auxiliary from sys.storagemodel() group by \"schema\",\"table\";", "VIEW", true, "COMMIT", "WRITABLE" ] 1463
1468 [ "sys", "tablestoragemodel", "create view sys.tablestoragemodel as select \"schema\", \"table\", max(\"count\") as \"rowcount\", count(*) as \"storages\", sum(columnsize(\"type\", \"count\")) as columnsize, sum(heapsize(\"type\", \"count\", \"distinct\", \"atomwidth\")) as heapsize, sum(hashsize(\"reference\", \"count\")) as hashsize, sum(case when isacolumn then imprintsize(\"type\", \"count\") else 0 end) as imprintsize, sum(case when (isacolumn and not sorted) then cast(8 * \"count\" as bigint) else 0 end) as orderidxsize from sys.storagemodelinput group by \"schema\", \"table\" order by \"schema\", \"table\";", "VIEW", true, "COMMIT", "WRITABLE" ] 1468 -
1469 [ "sys", "tracelog", "create view sys.tracelog as select * from sys.tracelog();", "VIEW", true, "COMMIT", "WRITABLE" ] 1469 1464 [ "sys", "tracelog", "create view sys.tracelog as select * from sys.tracelog();", "VIEW", true, "COMMIT", "WRITABLE" ] 1464
..................
#select t.name, c.name, c.type, c.type_d
1485 % varchar, varchar, varchar, int, int, varchar, boolean, int, varchar # type 1485 1480 % varchar, varchar, varchar, int, int, varchar, boolean, int, varchar # type 1480
1486 % 34, 26, 9, 5, 1, 5, 5, 2, 0 # length 1486 ! 1481 % 34, 26, 9, 5, 1, 0, 5, 2, 0 # length 1481
1487 [ "_columns", "id", "int", 32, 0, NULL, true, 0, NULL ] 1487 1482 [ "_columns", "id", "int", 32, 0, NULL, true, 0, NULL ] 1482
..................
#select t.name, c.name, c.type, c.type_d
1932 [ "schemas", "system", "boolean", 1, 0, NULL, true, 4, NULL ] 1932 1927 [ "schemas", "system", "boolean", 1, 0, NULL, true, 4, NULL ] 1927
1933 [ "schemastorage", "schema", "varchar", 1024, 0, NULL, true, 0, NULL ] 1933 -
1934 [ "schemastorage", "storages", "bigint", 64, 0, NULL, true, 1, NULL ] 1934 -
1935 [ "schemastorage", "columnsize", "bigint", 64, 0, NULL, true, 2, NULL ] 1935 -
1936 [ "schemastorage", "heapsize", "bigint", 64, 0, NULL, true, 3, NULL ] 1936 -
1937 [ "schemastorage", "hashsize", "bigint", 64, 0, NULL, true, 4, NULL ] 1937 -
1938 [ "schemastorage", "imprintsize", "bigint", 64, 0, NULL, true, 5, NULL ] 1938 -
1939 [ "schemastorage", "orderidxsize", "bigint", 64, 0, NULL, true, 6, NULL ] 1939 -
1940 [ "sequences", "id", "int", 32, 0, NULL, true, 0, NULL ] 1940 1928 [ "sequences", "id", "int", 32, 0, NULL, true, 0, NULL ] 1928
..................
#select t.name, c.name, c.type, c.type_d
1978 [ "statistics", "revsorted", "boolean", 1, 0, NULL, true, 11, NULL ] 1978 1966 [ "statistics", "revsorted", "boolean", 1, 0, NULL, true, 11, NULL ] 1966
1979 [ "storage", "schema", "varchar", 1024, 0, NULL, true, 0, NULL ] 1979 ! 1967 [ "storage", "schema", "clob", 0, 0, NULL, true, 0, NULL ] 1967
1980 [ "storage", "table", "varchar", 1024, 0, NULL, true, 1, NULL ] 1980 ! 1968 [ "storage", "table", "clob", 0, 0, NULL, true, 1, NULL ] 1968
1981 [ "storage", "column", "varchar", 1024, 0, NULL, true, 2, NULL ] 1981 ! 1969 [ "storage", "column", "clob", 0, 0, NULL, true, 2, NULL ] 1969
1982 [ "storage", "type", "varchar", 1024, 0, NULL, true, 3, NULL ] 1982 ! 1970 [ "storage", "type", "clob", 0, 0, NULL, true, 3, NULL ] 1970
1983 [ "storage", "mode", "varchar", 15, 0, NULL, true, 4, NULL ] 1983 ! 1971 [ "storage", "mode", "clob", 0, 0, NULL, true, 4, NULL ] 1971
1984 [ "storage", "location", "varchar", 1024, 0, NULL, true, 5, NULL ] 1984 ! 1972 [ "storage", "location", "clob", 0, 0, NULL, true, 5, NULL ] 1972
1985 [ "storage", "count", "bigint", 64, 0, NULL, true, 6, NULL ] 1985 1973 [ "storage", "count", "bigint", 64, 0, NULL, true, 6, NULL ] 1973
..................
#select t.name, c.name, c.type, c.type_d
1995 [ "storage", "orderidx", "bigint", 64, 0, NULL, true, 16, NULL ] 1995 1983 [ "storage", "orderidx", "bigint", 64, 0, NULL, true, 16, NULL ] 1983
1996 [ "storagemodel", "schema", "varchar", 1024, 0, NULL, true, 0, NULL ] 1996 ! 1984 [ "storagemodel", "schema", "clob", 0, 0, NULL, true, 0, NULL ] 1984
1997 [ "storagemodel", "table", "varchar", 1024, 0, NULL, true, 1, NULL ] 1997 ! 1985 [ "storagemodel", "table", "clob", 0, 0, NULL, true, 1, NULL ] 1985
1998 [ "storagemodel", "column", "varchar", 1024, 0, NULL, true, 2, NULL ] 1998 ! 1986 [ "storagemodel", "column", "clob", 0, 0, NULL, true, 2, NULL ] 1986
1999 [ "storagemodel", "type", "varchar", 1024, 0, NULL, true, 3, NULL ] 1999 ! 1987 [ "storagemodel", "type", "clob", 0, 0, NULL, true, 3, NULL ] 1987
2000 [ "storagemodel", "count", "bigint", 64, 0, NULL, true, 4, NULL ] 2000 1988 [ "storagemodel", "count", "bigint", 64, 0, NULL, true, 4, NULL ] 1988
..................
#select t.name, c.name, c.type, c.type_d
2002 [ "storagemodel", "heapsize", "bigint", 64, 0, NULL, true, 6, NULL ] 2002 1990 [ "storagemodel", "heapsize", "bigint", 64, 0, NULL, true, 6, NULL ] 1990
2003 [ "storagemodel", "hashsize", "bigint", 64, 0, NULL, true, 7, NULL ] 2003 ! 1991 [ "storagemodel", "hashes", "bigint", 64, 0, NULL, true, 7, NULL ] 1991
2004 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2004 ! 1992 [ "storagemodel", "imprints", "bigint", 64, 0, NULL, true, 8, NULL ] 1992
2005 [ "storagemodel", "orderidxsize", "bigint", 64, 0, NULL, true, 9, NULL ] 2005 ! 1993 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 9, NULL ] 1993
2006 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2006 ! 1994 [ "storagemodel", "revsorted", "boolean", 1, 0, NULL, true, 10, NULL ] 1994
2007 [ "storagemodel", "unique", "boolean", 1, 0, NULL, true, 11, NULL ] 2007 1995 [ "storagemodel", "unique", "boolean", 1, 0, NULL, true, 11, NULL ] 1995
2008 [ "storagemodel", "isacolumn", "boolean", 1, 0, NULL, true, 12, NULL ] 2008 ! 1996 [ "storagemodel", "orderidx", "bigint", 64, 0, NULL, true, 12, NULL ] 1996
2009 [ "storagemodelinput", "schema", "varchar", 1024, 0, NULL, false, 0, NULL ] 2009 ! 1997 [ "storagemodelinput", "schema", "clob", 0, 0, NULL, true, 0, NULL ] 1997
2010 [ "storagemodelinput", "table", "varchar", 1024, 0, NULL, false, 1, NULL ] 2010 ! 1998 [ "storagemodelinput", "table", "clob", 0, 0, NULL, true, 1, NULL ] 1998
2011 [ "storagemodelinput", "column", "varchar", 1024, 0, NULL, false, 2, NULL ] 2011 ! 1999 [ "storagemodelinput", "column", "clob", 0, 0, NULL, true, 2, NULL ] 1999
2012 [ "storagemodelinput", "type", "varchar", 1024, 0, NULL, false, 3, NULL ] 2012 ! 2000 [ "storagemodelinput", "type", "clob", 0, 0, NULL, true, 3, NULL ] 2000
2013 [ "storagemodelinput", "typewidth", "int", 32, 0, NULL, false, 4, NULL ] 2013 ! 2001 [ "storagemodelinput", "typewidth", "int", 32, 0, NULL, true, 4, NULL ] 2001
2014 [ "storagemodelinput", "count", "bigint", 64, 0, NULL, false, 5, NULL ] 2014 ! 2002 [ "storagemodelinput", "count", "bigint", 64, 0, NULL, true, 5, NULL ] 2002
2015 [ "storagemodelinput", "distinct", "bigint", 64, 0, NULL, false, 6, NULL ] 2015 ! 2003 [ "storagemodelinput", "distinct", "bigint", 64, 0, NULL, true, 6, NULL ] 2003
2016 [ "storagemodelinput", "atomwidth", "int", 32, 0, NULL, false, 7, NULL ] 2016 ! 2004 [ "storagemodelinput", "atomwidth", "int", 32, 0, NULL, true, 7, NULL ] 2004
2017 [ "storagemodelinput", "reference", "boolean", 1, 0, "false", false, 8, NULL ] 2017 ! 2005 [ "storagemodelinput", "reference", "boolean", 1, 0, NULL, true, 8, NULL ] 2005
2018 [ "storagemodelinput", "sorted", "boolean", 1, 0, NULL, true, 9, NULL ] 2018 2006 [ "storagemodelinput", "sorted", "boolean", 1, 0, NULL, true, 9, NULL ] 2006
2019 [ "storagemodelinput", "unique", "boolean", 1, 0, NULL, true, 10, NULL ] 2019 ! 2007 [ "storagemodelinput", "revsorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2007
2020 [ "storagemodelinput", "isacolumn", "boolean", 1, 0, "true", false, 11, NULL ] 2020 ! 2008 [ "storagemodelinput", "unique", "boolean", 1, 0, NULL, true, 11, NULL ] 2008
+ 2009 [ "storagemodelinput", "orderidx", "bigint", 64, 0, NULL, true, 12, NULL ] 2009
2021 [ "systemfunctions", "function_id", "int", 32, 0, NULL, true, 0, NULL ] 2021 2010 [ "systemfunctions", "function_id", "int", 32, 0, NULL, true, 0, NULL ] 2010
..................
#select t.name, c.name, c.type, c.type_d
2037 [ "tables", "temporary", "smallint", 16, 0, NULL, true, 8, NULL ] 2037 2026 [ "tables", "temporary", "smallint", 16, 0, NULL, true, 8, NULL ] 2026
2038 [ "tablestorage", "schema", "varchar", 1024, 0, NULL, true, 0, NULL ] 2038 ! 2027 [ "tablestoragemodel", "schema", "clob", 0, 0, NULL, true, 0, NULL ] 2027
2039 [ "tablestorage", "table", "varchar", 1024, 0, NULL, true, 1, NULL ] 2039 ! 2028 [ "tablestoragemodel", "table", "clob", 0, 0, NULL, true, 1, NULL ] 2028
2040 [ "tablestorage", "rowcount", "bigint", 64, 0, NULL, true, 2, NULL ] 2040 ! 2029 [ "tablestoragemodel", "count", "bigint", 64, 0, NULL, true, 2, NULL ] 2029
2041 [ "tablestorage", "storages", "bigint", 64, 0, NULL, true, 3, NULL ] 2041 ! 2030 [ "tablestoragemodel", "columnsize", "bigint", 64, 0, NULL, true, 3, NULL ] 2030
2042 [ "tablestorage", "columnsize", "bigint", 64, 0, NULL, true, 4, NULL ] 2042 ! 2031 [ "tablestoragemodel", "heapsize", "bigint", 64, 0, NULL, true, 4, NULL ] 2031
2043 [ "tablestorage", "heapsize", "bigint", 64, 0, NULL, true, 5, NULL ] 2043 ! 2032 [ "tablestoragemodel", "hashes", "bigint", 64, 0, NULL, true, 5, NULL ] 2032
2044 [ "tablestorage", "hashsize", "bigint", 64, 0, NULL, true, 6, NULL ] 2044 ! 2033 [ "tablestoragemodel", "imprints", "bigint", 64, 0, NULL, true, 6, NULL ] 2033
2045 [ "tablestorage", "imprintsize", "bigint", 64, 0, NULL, true, 7, NULL ] 2045 ! 2034 [ "tablestoragemodel", "auxiliary", "hugeint", 128, 0, NULL, true, 7, NULL ] 2034
2046 [ "tablestorage", "orderidxsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2046 -
2047 [ "tablestoragemodel", "schema", "varchar", 1024, 0, NULL, true, 0, NULL ] 2047 -
2048 [ "tablestoragemodel", "table", "varchar", 1024, 0, NULL, true, 1, NULL ] 2048 -
2049 [ "tablestoragemodel", "rowcount", "bigint", 64, 0, NULL, true, 2, NULL ] 2049 -
2050 [ "tablestoragemodel", "storages", "bigint", 64, 0, NULL, true, 3, NULL ] 2050 -
2051 [ "tablestoragemodel", "columnsize", "bigint", 64, 0, NULL, true, 4, NULL ] 2051 -
2052 [ "tablestoragemodel", "heapsize", "bigint", 64, 0, NULL, true, 5, NULL ] 2052 -
2053 [ "tablestoragemodel", "hashsize", "bigint", 64, 0, NULL, true, 6, NULL ] 2053 -
2054 [ "tablestoragemodel", "imprintsize", "bigint", 64, 0, NULL, true, 7, NULL ] 2054 -
2055 [ "tablestoragemodel", "orderidxsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2055 -
2056 [ "tracelog", "event", "int", 32, 0, NULL, true, 0, NULL ] 2056 2035 [ "tracelog", "event", "int", 32, 0, NULL, true, 0, NULL ] 2035
..................
# .s, .f, .L4, .L6, .f,
2131 % varchar, varchar, char, varchar, varchar, varchar, varchar, boolean, boolean, boolean, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char # type 2131 2110 % varchar, varchar, char, varchar, varchar, varchar, varchar, boolean, boolean, boolean, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char # type 2110
2132 % 8, 24, 6, 1362, 9, 10, 26, 5, 5, 5, 11, 14, 4, 1, 3, 16, 14, 4, 1, 3, 16, 14, 4, 1, 3, 27, 12, 4, 1, 3, 12, 7, 2, 1, 3, 10, 14, 4, 1, 3, 8, 14, 3, 1, 3, 9, 6, 2, 1, 3, 10, 6, 2, 1, 3, 8, 6, 2, 1, 3, 6, 6, 2, 1, 3, 6, 7, 2, 1, 3, 8, 6, 2, 1, 3, 6, 7, 1, 1, 3, 9, 7, 1, 1, 3, 6, 7, 1, 1, 3 # length 2132 ! 2111 % 8, 24, 6, 831, 9, 10, 26, 5, 5, 5, 11, 14, 4, 1, 3, 16, 14, 4, 1, 3, 16, 14, 3, 1, 3, 27, 12, 3, 1, 3, 12, 7, 2, 1, 3, 10, 14, 3, 1, 3, 8, 14, 3, 1, 3, 9, 6, 2, 1, 3, 10, 6, 2, 1, 3, 8, 7, 2, 1, 3, 9, 7, 2, 1, 3, 6, 7, 2, 1, 3, 8, 6, 2, 1, 3, 6, 7, 1, 1, 3, 9, 7, 1, 1, 3, 6, 7, 1, 1, 3 # length 2111
2133 [ "bam", "bam_drop_file", "SYSTEM", "create procedure bam.bam_drop_file(file_id bigint, dbschema smallint) external name bam.bam_drop_file;", "bam", "MAL", "Procedure", true, false, false, "file_id", "bigint", 64, 0, "in", "dbschema", "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 ] 2133 2112 [ "bam", "bam_drop_file", "SYSTEM", "create procedure bam.bam_drop_file(file_id bigint, dbschema smallint) external name bam.bam_drop_file;", "bam", "MAL", "Procedure", true, false, false, "file_id", "bigint", 64, 0, "in", "dbschema", "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 ] 2112
..................
# .s, .f, .L4, .L6, .f,
2296 [ "sys", "code", "SYSTEM", "unicode", "str", "Internal C", "Scalar function", false, false, false, "res_0", "varchar", 0, 0, "out", "arg_1", "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 ] 2296 2275 [ "sys", "code", "SYSTEM", "unicode", "str", "Internal C", "Scalar function", false, false, false, "res_0", "varchar", 0, 0, "out", "arg_1", "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 ] 2275
2297 [ "sys", "columnsize", "SYSTEM", "create function sys.columnsize(tpe varchar(1024), count bigint) returns bigint begin if tpe in ('tinyint', 'boolean') then return count; end if; if tpe = 'smallint' then return 2 * count; end if; if tpe in ('int', 'real', 'date', 'time', 'timetz', 'sec_interval', 'month_interval') then return 4 * count; end if; if tpe in ('bigint', 'double', 'timestamp', 'timestamptz', 'inet', 'oid') then return 8 * count; end if; if tpe in ('hugeint', 'decimal', 'uuid', 'mbr') then return 16 * count; end if; if tpe in ('varchar', 'char', 'clob', 'json', 'url') then return 4 * count; end if; if tpe in ('blob', 'geometry', 'geometrya') then return 8 * count; end if; return 8 * count; end;", "user", "SQL", "Scalar function", false, false, false, "result", "bigint", 64, 0, "out", "tpe", "varchar", 1024, 0, "in", "count", "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 ] 2297 ! 2276 [ "sys", "columnsize", "SYSTEM", "create function sys.columnsize(nme string, i bigint, d bigint) returns bigint begin case when nme = 'boolean' then return i; when nme = 'char' then return 2*i; when nme = 'smallint' then return 2 * i; when nme = 'int' then return 4 * i; when nme = 'bigint' then return 8 * i; when nme = 'hugeint' then return 16 * i; when nme = 'timestamp' then return 8 * i; when nme = 'varchar' then case when cast(d as bigint) << 8 then return i; when cast(d as bigint) << 16 then return 2 * i; when cast(d as bigint) << 32 then return 4 * i; else return 8 * i; end case; else return 8 * i; end case; end;", "user", "SQL", "Scalar function", false, false, false, "result", "bigint", 64, 0, "out", "nme", "clob", 0, 0, "in", "i", "bigint", 64, 0, "in", "d", "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 ] 2276
2298 [ "sys", "concat", "SYSTEM", "+", "calc", "Internal C", "Scalar function", false, false, false, "res_0", "char", 0, 0, "out", "arg_1", "char", 0, 0, "in", "arg_2", "char", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2298 2277 [ "sys", "concat", "SYSTEM", "+", "calc", "Internal C", "Scalar function", false, false, false, "res_0", "char", 0, 0, "out", "arg_1", "char", 0, 0, "in", "arg_2", "char", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2277
..................
# .s, .f, .L4, .L6, .f,
2405 [ "sys", "hash", "SYSTEM", "hash", "mkey", "Internal C", "Scalar function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "any", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2405 2384 [ "sys", "hash", "SYSTEM", "hash", "mkey", "Internal C", "Scalar function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "any", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2384
2406 [ "sys", "hashsize", "SYSTEM", "create function sys.hashsize(b boolean, count bigint) returns bigint begin if b = true then return 8 * count; end if; return 0; end;", "user", "SQL", "Scalar function", false, false, false, "result", "bigint", 64, 0, "out", "b", "boolean", 1, 0, "in", "count", "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 ] 2406 ! 2385 [ "sys", "hashsize", "SYSTEM", "create function sys.hashsize(b boolean, i bigint) returns bigint begin if b = true then return 8 * i; end if; return 0; end;", "user", "SQL", "Scalar function", false, false, false, "result", "bigint", 64, 0, "out", "b", "boolean", 1, 0, "in", "i", "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 ] 2385
2407 [ "sys", "heapsize", "SYSTEM", "create function sys.heapsize(tpe varchar(1024), count bigint, distincts bigint, avgwidth int) returns bigint begin if tpe in ('varchar', 'char', 'clob', 'json', 'url') then return 8192 + ((avgwidth + 8) * distincts); end if; if tpe in ('blob', 'geometry', 'geometrya') then return 32 + (avgwidth * count); end if; return 0; end;", "user", "SQL", "Scalar function", false, false, false, "result", "bigint", 64, 0, "out", "tpe", "varchar", 1024, 0, "in", "count", "bigint", 64, 0, "in", "distincts", "bigint", 64, 0, "in", "avgwidth", "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 ] 2407 ! 2386 [ "sys", "heapsize", "SYSTEM", "create function sys.heapsize(tpe string, i bigint, w int) returns bigint begin if tpe <> 'varchar' and tpe <> 'clob' then return 0; end if; return 10240 + i * w; end;", "user", "SQL", "Scalar function", false, false, false, "result", "bigint", 64, 0, "out", "tpe", "clob", 0, 0, "in", "i", "bigint", 64, 0, "in", "w", "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 ] 2386
2408 [ "sys", "host", "SYSTEM", "create function \"host\" (p inet) returns clob external name inet.\"host\";", "inet", "MAL", "Scalar function", false, false, false, "result", "clob", 0, 0, "out", "p", "inet", 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 ] 2408 2387 [ "sys", "host", "SYSTEM", "create function \"host\" (p inet) returns clob external name inet.\"host\";", "inet", "MAL", "Scalar function", false, false, false, "result", "clob", 0, 0, "out", "p", "inet", 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 ] 2387
..................
# .s, .f, .L4, .L6, .f,
2418 [ "sys", "ilike", "SYSTEM", "create filter function \"ilike\"(val string, pat string, esc string) external name algebra.\"ilike\";", "algebra", "MAL", "Filter function", false, false, false, "val", "clob", 0, 0, "in", "pat", "clob", 0, 0, "in", "esc", "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 ] 2418 2397 [ "sys", "ilike", "SYSTEM", "create filter function \"ilike\"(val string, pat string, esc string) external name algebra.\"ilike\";", "algebra", "MAL", "Filter function", false, false, false, "val", "clob", 0, 0, "in", "pat", "clob", 0, 0, "in", "esc", "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 ] 2397
2419 [ "sys", "imprintsize", "SYSTEM", "create function sys.imprintsize(tpe varchar(1024), count bigint) returns bigint begin if tpe in ('tinyint', 'boolean') then return cast(0.2 * count as bigint); end if; if tpe = 'smallint' then return cast(0.4 * count as bigint); end if; if tpe in ('int', 'real', 'date', 'time', 'timetz', 'sec_interval', 'month_interval') then return cast(0.8 * count as bigint); end if; if tpe in ('bigint', 'double', 'timestamp', 'timestamptz', 'inet', 'oid') then return cast(1.6 * count as bigint); end if; if tpe in ('hugeint', 'decimal', 'uuid', 'mbr') then return cast(3.2 * count as bigint); end if; return 0; end;", "user", "SQL", "Scalar function", false, false, false, "result", "bigint", 64, 0, "out", "tpe", "varchar", 1024, 0, "in", "count", "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 ] 2419 ! 2398 [ "sys", "imprintsize", "SYSTEM", "create function sys.imprintsize(i bigint, nme string) returns bigint begin if nme = 'boolean' or nme = 'tinyint' or nme = 'smallint' or nme = 'int' or nme = 'bigint' or nme = 'hugeint' or nme = 'decimal' or nme = 'date' or nme = 'timestamp' or nme = 'real' or nme = 'double' then return cast(i * 0.12 as bigint); end if ; return 0; end;", "user", "SQL", "Scalar function", false, false, false, "result", "bigint", 64, 0, "out", "i", "bigint", 64, 0, "in", "nme", "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 ] 2398
2420 [ "sys", "in", "SYSTEM", "in", "calc", "Internal C", "Scalar function", false, false, false, "res_0", "boolean", 1, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "any", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2420 2399 [ "sys", "in", "SYSTEM", "in", "calc", "Internal C", "Scalar function", false, false, false, "res_0", "boolean", 1, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "any", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2399
..................
# .s, .f, .L4, .L6, .f,
3851 [ "sys", "stopmaster", "SYSTEM", "create procedure stopmaster() external name wlc.stopmaster;", "wlc", "MAL", "Procedure", true, false, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3851 3830 [ "sys", "stopmaster", "SYSTEM", "create procedure stopmaster() external name wlc.stopmaster;", "wlc", "MAL", "Procedure", true, false, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3830
3852 [ "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", false, false, false, "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" ] 3852 ! 3831 [ "sys", "storage", "SYSTEM", "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, revsorted boolean, \"unique\" boolean, orderidx bigint) external name sql.\"storage\";", "sql", "MAL", "Function returning a table", false, false, false, "schema", "clob", 0, 0, "out", "table", "clob", 0, 0, "out", "column", "clob", 0, 0, "out", "type", "clob", 0, 0, "out", "mode", "clob", 0, 0, "out", "location", "clob", 0, 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" ] 3831
3853 [ "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, "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" ] 3853 ! 3832 [ "sys", "storage", "SYSTEM", "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, revsorted boolean, \"unique\" boolean, orderidx bigint) external name sql.\"storage\";", "sql", "MAL", "Function returning a table", false, false, false, "schema", "clob", 0, 0, "out", "table", "clob", 0, 0, "out", "column", "clob", 0, 0, "out", "type", "clob", 0, 0, "out", "mode", "clob", 0, 0, "out", "location", "clob", 0, 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" ] 3832
3854 [ "sys", "storage", "SYSTEM", "create function sys.\"storage\"(sname varchar(1024), tname 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, "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" ] 3854 ! 3833 [ "sys", "storage", "SYSTEM", "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, revsorted boolean, \"unique\" boolean, orderidx bigint) external name sql.\"storage\";", "sql", "MAL", "Function returning a table", false, false, false, "schema", "clob", 0, 0, "out", "table", "clob", 0, 0, "out", "column", "clob", 0, 0, "out", "type", "clob", 0, 0, "out", "mode", "clob", 0, 0, "out", "location", "clob", 0, 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" ] 3833
3855 [ "sys", "storage", "SYSTEM", "create function sys.\"storage\"(sname varchar(1024), tname varchar(1024), cname 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, "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" ] 3855 ! 3834 [ "sys", "storage", "SYSTEM", "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, revsorted boolean, \"unique\" boolean, orderidx bigint) external name sql.\"storage\";", "sql", "MAL", "Function returning a table", false, false, false, "schema", "clob", 0, 0, "out", "table", "clob", 0, 0, "out", "column", "clob", 0, 0, "out", "type", "clob", 0, 0, "out", "mode", "clob", 0, 0, "out", "location", "clob", 0, 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" ] 3834
[ "sys", "storagemodelinit", "SYSTEM", "create procedure sys.storagemodelinit() begin delete from sys.storagemodelinput; insert into sys.storagemodelinput select \"schema\", \"table\", \"column\", \"type\", typewidth, \"count\", case when (\"unique\" or \"type\" in ('varchar', 'char', 'clob', 'json', 'url', 'blob', 'geometry', 'geometrya')) then \"count\" else 0 end, case when \"count\" > 0 and heapsize >= 8192 and \"type\" in ('varchar', 'char', 'clob', 'json', 'url') then cast((heapsize - 8192) / \"count\" as bigint) when \"count\" > 0 and heapsize >= 32 and \"type\" in ('blob', + 3835 [ "sys", "storagemodel", "SYSTEM", "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, revsorted boolean, \"unique\" 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.revsorted, i.\"unique\", i.orderidx from sys.storagemodelinput i; end;", "user", "SQL", "Function returning a table", false, false, false, "schema", "clob", 0, 0, "out", "table", "clob", 0, 0, "out", "column", "clob", 0, 0, "out", "type", "clob", 0, 0, "out", "count", "bigint", 64, 0, "out", "columnsize", "bigint", 64, 0, "out", "heapsize", "bigint", 64, 0, "out", "hashes", "bigint", 64, 0, "out", "imprints", "bigint", 64, 0, "out", "sorted", "boolean", 1, 0, "out", "revsorted", "boolean", 1, 0, "out", "unique", "boolean", 1, 0, "out", "orderidx", "bigint", 64, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3835
3856 'geometry', 'geometrya') then cast((heapsize - 32) / \"count\" as bigint) else typewidth end, false, case sorted when true then true else false end, \"unique\", true from sys.\"storage\"; update sys.storagemodelinput set reference = true where (\"schema\", \"table\", \"column\") in (select 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 isacolumn = false where (\"schema\", \"table\", \"column\") not in (select sch.\"name\", tbl.\"name\", col.\"name\" from sys.\"schemas\" as sch, sys.\"tables\" as tbl, sys.\"columns\" as col where sch.\"id\" = tbl.\"schema_id\" and tbl.\"id\" = col.\"table_id\"); end;", "user", "SQL", "Procedure", true, false, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3856 ! 3836 [ "sys", "storagemodelinit", "SYSTEM", "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.revsorted, x.\"unique\", 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", "SQL", "Procedure", true, false, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3836
3857 [ "sys", "str_to_date", "SYSTEM", "create function str_to_date(s string, format string) returns date external name mtime.\"str_to_date\";", "mtime", "MAL", "Scalar function", false, false, false, "result", "date", 0, 0, "out", "s", "clob", 0, 0, "in", "format", "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 ] 3857 3837 [ "sys", "str_to_date", "SYSTEM", "create function str_to_date(s string, format string) returns date external name mtime.\"str_to_date\";", "mtime", "MAL", "Scalar function", false, false, false, "result", "date", 0, 0, "out", "s", "clob", 0, 0, "in", "format", "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 ] 3837
..................
#select s1.name, f1.name, s2.name, f2.na
4041 [ "sys", "st_srid", "sys", "st_transform", "FUNCTION" ] 4041 4021 [ "sys", "st_srid", "sys", "st_transform", "FUNCTION" ] 4021
+ 4022 [ "sys", "columnsize", "sys", "storagemodel", "FUNCTION" ] 4022
+ 4023 [ "sys", "hashsize", "sys", "storagemodel", "FUNCTION" ] 4023
+ 4024 [ "sys", "heapsize", "sys", "storagemodel", "FUNCTION" ] 4024
+ 4025 [ "sys", "imprintsize", "sys", "storagemodel", "FUNCTION" ] 4025
4042 #select s1.name, t.name, s2.name, f.name, dt.dependency_type_name from sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = dt.dependency_type_id, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where d.id = t.id and d.depend_id = f.id and t.schema_id = s1.id and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name; 4042 4026 #select s1.name, t.name, s2.name, f.name, dt.dependency_type_name from sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = dt.dependency_type_id, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where d.id = t.id and d.depend_id = f.id and t.schema_id = s1.id and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name; 4026
..................
#select s1.name, t.name, s2.name, f.name
4047 [ "sys", "spatial_ref_sys", "sys", "getproj4", "FUNCTION" ] 4047 4031 [ "sys", "spatial_ref_sys", "sys", "getproj4", "FUNCTION" ] 4031
4048 [ "sys", "columns", "sys", "storagemodelinit", "PROCEDURE" ] 4048 ! 4032 [ "sys", "storagemodelinput", "sys", "storagemodel", "FUNCTION" ] 4032
4049 [ "sys", "keys", "sys", "storagemodelinit", "PROCEDURE" ] 4049 4033 [ "sys", "keys", "sys", "storagemodelinit", "PROCEDURE" ] 4033
..................
#select s1.name, t.name, s2.name, f.name
4051 [ "sys", "schemas", "sys", "storagemodelinit", "PROCEDURE" ] 4051 4035 [ "sys", "schemas", "sys", "storagemodelinit", "PROCEDURE" ] 4035
4052 [ "sys", "storage", "sys", "storagemodelinit", "PROCEDURE" ] 4052 -
4053 [ "sys", "storagemodelinput", "sys", "storagemodelinit", "PROCEDURE" ] 4053 4036 [ "sys", "storagemodelinput", "sys", "storagemodelinit", "PROCEDURE" ] 4036
..................
#select s1.name, t.name, c.name, s2.name
4064 [ "sys", "spatial_ref_sys", "srtext", "sys", "getproj4", "FUNCTION" ] 4064 4047 [ "sys", "spatial_ref_sys", "srtext", "sys", "getproj4", "FUNCTION" ] 4047
+ 4048 [ "sys", "storagemodelinput", "atomwidth", "sys", "storagemodel", "FUNCTION" ] 4048
+ 4049 [ "sys", "storagemodelinput", "column", "sys", "storagemodel", "FUNCTION" ] 4049
+ 4050 [ "sys", "storagemodelinput", "count", "sys", "storagemodel", "FUNCTION" ] 4050
+ 4051 [ "sys", "storagemodelinput", "distinct", "sys", "storagemodel", "FUNCTION" ] 4051
+ 4052 [ "sys", "storagemodelinput", "orderidx", "sys", "storagemodel", "FUNCTION" ] 4052
+ 4053 [ "sys", "storagemodelinput", "reference", "sys", "storagemodel", "FUNCTION" ] 4053
+ 4054 [ "sys", "storagemodelinput", "revsorted", "sys", "storagemodel", "FUNCTION" ] 4054
+ 4055 [ "sys", "storagemodelinput", "schema", "sys", "storagemodel", "FUNCTION" ] 4055
+ 4056 [ "sys", "storagemodelinput", "sorted", "sys", "storagemodel", "FUNCTION" ] 4056
+ 4057 [ "sys", "storagemodelinput", "table", "sys", "storagemodel", "FUNCTION" ] 4057
+ 4058 [ "sys", "storagemodelinput", "type", "sys", "storagemodel", "FUNCTION" ] 4058
+ 4059 [ "sys", "storagemodelinput", "typewidth", "sys", "storagemodel", "FUNCTION" ] 4059
+ 4060 [ "sys", "storagemodelinput", "unique", "sys", "storagemodel", "FUNCTION" ] 4060
4065 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 4065 4061 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 4061
..................
#select s1.name, t.name, c.name, s2.name
4082 [ "sys", "storagemodelinput", "distinct", "sys", "storagemodelinit", "PROCEDURE" ] 4082 4078 [ "sys", "storagemodelinput", "distinct", "sys", "storagemodelinit", "PROCEDURE" ] 4078
4083 [ "sys", "storagemodelinput", "isacolumn", "sys", "storagemodelinit", "PROCEDURE" ] 4083 ! 4079 [ "sys", "storagemodelinput", "orderidx", "sys", "storagemodelinit", "PROCEDURE" ] 4079
4084 [ "sys", "storagemodelinput", "reference", "sys", "storagemodelinit", "PROCEDURE" ] 4084 4080 [ "sys", "storagemodelinput", "reference", "sys", "storagemodelinit", "PROCEDURE" ] 4080
+ 4081 [ "sys", "storagemodelinput", "revsorted", "sys", "storagemodelinit", "PROCEDURE" ] 4081
4085 [ "sys", "storagemodelinput", "schema", "sys", "storagemodelinit", "PROCEDURE" ] 4085 4082 [ "sys", "storagemodelinput", "schema", "sys", "storagemodelinit", "PROCEDURE" ] 4082
..................
#select s1.name, f1.name, s2.name, t2.na
4094 % varchar, varchar, varchar, varchar, varchar # type 4094 4091 % varchar, varchar, varchar, varchar, varchar # type 4091
4095 % 3, 11, 3, 17, 4 # length 4095 ! 4092 % 3, 8, 3, 16, 4 # length 4092
4096 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 4096 4093 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 4093
..................
#select s1.name, f1.name, s2.name, t2.na
4098 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 4098 4095 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 4095
4099 [ "sys", "columnsize", "sys", "storagemodel", "VIEW" ] 4099 -
4100 [ "sys", "hashsize", "sys", "storagemodel", "VIEW" ] 4100 -
4101 [ "sys", "heapsize", "sys", "storagemodel", "VIEW" ] 4101 -
4102 [ "sys", "imprintsize", "sys", "storagemodel", "VIEW" ] 4102 -
4103 [ "sys", "columnsize", "sys", "tablestoragemodel", "VIEW" ] 4103 -
4104 [ "sys", "hashsize", "sys", "tablestoragemodel", "VIEW" ] 4104 -
4105 [ "sys", "heapsize", "sys", "tablestoragemodel", "VIEW" ] 4105 -
4106 [ "sys", "imprintsize", "sys", "tablestoragemodel", "VIEW" ] 4106 -
4107 #select s1.name, t1.name, s2.name, t2.name, dt.dependency_type_name from sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = dt.dependency_type_id, schemas s1, _tables t1, schemas s2, _tables t2 where d.id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, t1.name; 4107 4096 #select s1.name, t1.name, s2.name, t2.name, dt.dependency_type_name from sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = dt.dependency_type_id, schemas s1, _tables t1, schemas s2, _tables t2 where d.id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, t1.name; 4096
..................
#select s1.name, t1.name, s2.name, t2.na
4110 % varchar, varchar, varchar, varchar, varchar # type 4110 4099 % varchar, varchar, varchar, varchar, varchar # type 4099
4111 % 3, 17, 3, 34, 4 # length 4111 ! 4100 % 3, 16, 3, 34, 4 # length 4100
4112 [ "sys", "dependencies", "sys", "dependencies_vw", "VIEW" ] 4112 4101 [ "sys", "dependencies", "sys", "dependencies_vw", "VIEW" ] 4101
..................
#select s1.name, t1.name, s2.name, t2.na
4207 [ "sys", "auths", "sys", "roles", "VIEW" ] 4207 4196 [ "sys", "auths", "sys", "roles", "VIEW" ] 4196
4208 [ "sys", "storage", "sys", "schemastorage", "VIEW" ] 4208 -
4209 [ "sys", "schemas", "sys", "storage", "VIEW" ] 4209 -
4210 [ "sys", "tables", "sys", "storage", "VIEW" ] 4210 -
4211 [ "sys", "storagemodelinput", "sys", "storagemodel", "VIEW" ] 4211 -
4212 [ "sys", "functions", "sys", "systemfunctions", "VIEW" ] 4212 4197 [ "sys", "functions", "sys", "systemfunctions", "VIEW" ] 4197
4213 [ "sys", "storage", "sys", "tablestorage", "VIEW" ] 4213 -
4214 [ "sys", "storagemodelinput", "sys", "tablestoragemodel", "VIEW" ] 4214 -
4215 #select s1.name, t1.name, c1.name, s2.name, t2.name, dt.dependency_type_name from sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = dt.dependency_type_id, schemas s1, _tables t1, _columns c1, schemas s2, _tables t2 where d.id = c1.id and c1.table_id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, t1.name, c1.name; 4215 4198 #select s1.name, t1.name, c1.name, s2.name, t2.name, dt.dependency_type_name from sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = dt.dependency_type_id, schemas s1, _tables t1, _columns c1, schemas s2, _tables t2 where d.id = c1.id and c1.table_id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, t1.name, c1.name; 4198
..................
#select s1.name, t1.name, c1.name, s2.na
4218 % varchar, varchar, varchar, varchar, varchar, varchar # type 4218 4201 % varchar, varchar, varchar, varchar, varchar, varchar # type 4201
4219 % 3, 17, 20, 3, 34, 4 # length 4219 ! 4202 % 3, 16, 20, 3, 34, 4 # length 4202
4220 [ "sys", "dependencies", "depend_id", "sys", "dependencies_vw", "VIEW" ] 4220 4203 [ "sys", "dependencies", "depend_id", "sys", "dependencies_vw", "VIEW" ] 4203
..................
#select s1.name, t1.name, c1.name, s2.na
4429 [ "sys", "auths", "name", "sys", "roles", "VIEW" ] 4429 4412 [ "sys", "auths", "name", "sys", "roles", "VIEW" ] 4412
4430 [ "sys", "schemas", "id", "sys", "storage", "VIEW" ] 4430 -
4431 [ "sys", "schemas", "name", "sys", "storage", "VIEW" ] 4431 -
4432 [ "sys", "storagemodelinput", "atomwidth", "sys", "storagemodel", "VIEW" ] 4432 -
4433 [ "sys", "storagemodelinput", "column", "sys", "storagemodel", "VIEW" ] 4433 -
4434 [ "sys", "storagemodelinput", "count", "sys", "storagemodel", "VIEW" ] 4434 -
4435 [ "sys", "storagemodelinput", "distinct", "sys", "storagemodel", "VIEW" ] 4435 -
4436 [ "sys", "storagemodelinput", "isacolumn", "sys", "storagemodel", "VIEW" ] 4436 -
4437 [ "sys", "storagemodelinput", "reference", "sys", "storagemodel", "VIEW" ] 4437 -
4438 [ "sys", "storagemodelinput", "schema", "sys", "storagemodel", "VIEW" ] 4438 -
4439 [ "sys", "storagemodelinput", "sorted", "sys", "storagemodel", "VIEW" ] 4439 -
4440 [ "sys", "storagemodelinput", "table", "sys", "storagemodel", "VIEW" ] 4440 -
4441 [ "sys", "storagemodelinput", "type", "sys", "storagemodel", "VIEW" ] 4441 -
4442 [ "sys", "storagemodelinput", "unique", "sys", "storagemodel", "VIEW" ] 4442 -
4443 [ "sys", "functions", "id", "sys", "systemfunctions", "VIEW" ] 4443 4413 [ "sys", "functions", "id", "sys", "systemfunctions", "VIEW" ] 4413
4444 [ "sys", "functions", "system", "sys", "systemfunctions", "VIEW" ] 4444 4414 [ "sys", "functions", "system", "sys", "systemfunctions", "VIEW" ] 4414
4445 [ "sys", "storagemodelinput", "atomwidth", "sys", "tablestoragemodel", "VIEW" ] 4445 -
4446 [ "sys", "storagemodelinput", "count", "sys", "tablestoragemodel", "VIEW" ] 4446 -
4447 [ "sys", "storagemodelinput", "distinct", "sys", "tablestoragemodel", "VIEW" ] 4447 -
4448 [ "sys", "storagemodelinput", "isacolumn", "sys", "tablestoragemodel", "VIEW" ] 4448 -
4449 [ "sys", "storagemodelinput", "reference", "sys", "tablestoragemodel", "VIEW" ] 4449 -
4450 [ "sys", "storagemodelinput", "schema", "sys", "tablestoragemodel", "VIEW" ] 4450 -
4451 [ "sys", "storagemodelinput", "sorted", "sys", "tablestoragemodel", "VIEW" ] 4451 -
4452 [ "sys", "storagemodelinput", "table", "sys", "tablestoragemodel", "VIEW" ] 4452 -
4453 [ "sys", "storagemodelinput", "type", "sys", "tablestoragemodel", "VIEW" ] 4453 -
4454 #select s1.name, t1.name, c1.name, s2.name, t2.name, k2.name, dt.dependency_type_name from sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = dt.dependency_type_id, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, keys k2 where d.id = c1.id and d.depend_id = k2.id and c1.table_id = t1.id and t1.schema_id = s1.id and k2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, k2.name, s1.name, t1.name, c1.name; 4454 4415 #select s1.name, t1.name, c1.name, s2.name, t2.name, k2.name, dt.dependency_type_name from sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = dt.dependency_type_id, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, keys k2 where d.id = c1.id and d.depend_id = k2.id and c1.table_id = t1.id and t1.schema_id = s1.id and k2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, k2.name, s1.name, t1.name, c1.name; 4415
..................
#select keyword from sys.keywords order
5341 [ "WHILE" ] 5341 5302 [ "WHILE" ] 5302
5342 [ "WINDOW" ] 5342 -
5343 [ "WITH" ] 5343 5303 [ "WITH" ] 5303