Test check.SQL.py (id 350cc55cd57a) (err)
check.stable.out.int128.FILTERED 2018-12-07 01:52:55.499241333 +0100check.test.out.FILTERED 2018-12-07 01:52:55.743247565 +0100
1 Statistics about stdout of test 'check` in directory 'sql/test/emptydb-upgrade-chain`: 1 1 Statistics about stdout of test 'check` in directory 'sql/test/emptydb-upgrade-chain`: 1
2 5314 lines, 210131 words, 1370199 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5250 lines, 208697 words, 1359228 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5314 lines, 210131 words, 1370199 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5250 lines, 208697 words, 1359228 chars in lines not matching '^$|^(\| |)#` 3
4 # 5395 lines, 212570 words, 1387357 chars in all lines 4 ! 4 # 5331 lines, 211134 words, 1376435 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 >
194 \dSf sys."left_shift_assign" 194 192 \dSf sys."left_shift_assign" 192
195 \dSf sys."lidarattach" 195 -
196 \dSf sys."lidarexport" 196 -
197 \dSf sys."lidarload" 197 -
198 \dSf sys."like" 198 193 \dSf sys."like" 193
..................
# 10:17:18 >
247 \dSf sys."settimeout" 247 242 \dSf sys."settimeout" 242
248 \dSf sys."shpattach" 248 -
249 \dSf sys."shpload" 249 -
250 \dSf sys."shrink" 250 243 \dSf sys."shrink" 243
..................
# 10:17:18 >
349 \dSf sys."storage" 349 342 \dSf sys."storage" 342
+ 343 \dSf sys."storagemodel" 343
350 \dSf sys."storagemodelinit" 350 344 \dSf sys."storagemodelinit" 344
..................
# 10:17:18 >
441 SYSTEM VIEW sys.roles 441 435 SYSTEM VIEW sys.roles 435
442 SYSTEM VIEW sys.schemastorage 442 -
443 SYSTEM VIEW sys.sessions 443 436 SYSTEM VIEW sys.sessions 436
..................
# 10:17:18 >
447 SYSTEM VIEW sys.tables 447 440 SYSTEM VIEW sys.tables 440
448 SYSTEM VIEW sys.tablestorage 448 -
449 SYSTEM VIEW sys.tablestoragemodel 449 441 SYSTEM VIEW sys.tablestoragemodel 441
..................
# 10:17:18 >
573 SYSTEM FUNCTION sys.levenshtein 573 565 SYSTEM FUNCTION sys.levenshtein 565
574 SYSTEM PROCEDURE sys.lidarattach 574 -
575 SYSTEM PROCEDURE sys.lidarexport 575 -
576 SYSTEM PROCEDURE sys.lidarload 576 -
577 SYSTEM FILTER FUNCTION sys.like 577 566 SYSTEM FILTER FUNCTION sys.like 566
..................
# 10:17:18 >
689 SYSTEM PROCEDURE sys.settimeout 689 678 SYSTEM PROCEDURE sys.settimeout 678
690 SYSTEM PROCEDURE sys.shpattach 690 -
691 SYSTEM PROCEDURE sys.shpload 691 -
692 SYSTEM PROCEDURE sys.shrink 692 679 SYSTEM PROCEDURE sys.shrink 679
..................
# 10:17:18 >
811 SYSTEM FUNCTION sys.storage 811 798 SYSTEM FUNCTION sys.storage 798
+ 799 SYSTEM FUNCTION sys.storagemodel 799
812 SYSTEM PROCEDURE sys.storagemodelinit 812 800 SYSTEM PROCEDURE sys.storagemodelinit 800
..................
# 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 871 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); 871
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 ! 872 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); 872
885 CREATE TABLE "sys"."table_partitions" ("id" INTEGER, "table_id" INTEGER, "column_id" INTEGER, "expression" VARCHAR(2048), "type" TINYINT); 885 873 CREATE TABLE "sys"."table_partitions" ("id" INTEGER, "table_id" INTEGER, "column_id" INTEGER, "expression" VARCHAR(2048), "type" TINYINT); 873
..................
# 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 921 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); 921
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 922 create view sys.sessions as select * from sys.sessions(); 922
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 - 923 create view sys."storage" as select * from sys."storage"(); 923
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 ! 924 create view sys.storagemodel as select * from sys.storagemodel(); 924
938 create view sys.systemfunctions as select id as function_id from sys.functions where system; 938 925 create view sys.systemfunctions as select id as function_id from sys.functions where system; 925
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 926 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"; 926
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 ! 927 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"; 927
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 928 create view sys.tracelog as select * from sys.tracelog(); 928
..................
# 10:17:18 >
953 create procedure sys.clearrejects() external name sql.copy_rejects_clear; 953 939 create procedure sys.clearrejects() external name sql.copy_rejects_clear; 939
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 ! 940 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; 940
955 create function contains(a geometry, x double, y double) returns boolean external name geom."Contains"; 955 941 create function contains(a geometry, x double, y double) returns boolean external name geom."Contains"; 941
..................
# 10:17:18 >
977 create procedure sys.flush_log () external name sql."flush_log"; 977 963 create procedure sys.flush_log () external name sql."flush_log"; 963
+ 964 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 964
978 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 978 ! 965 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 965
979 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 979 966 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 966
980 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 980 ! 967 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 967
981 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 981 ! 968 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 968
982 create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; 982 ! 969 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 969
983 create function sys.generate_series(first bigint, "limit" bigint, stepsize bigint) returns table (value bigint) external name generator.series; 983 ! 970 create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series; 970
984 create function sys.generate_series(first decimal(10,2), "limit" decimal(10,2), stepsize decimal(10,2)) returns table (value decimal(10,2)) external name generator.series; 984 ! 971 create function sys.generate_series(first decimal(10,2), last decimal(10,2), stepsize decimal(10,2)) returns table (value decimal(10,2)) external name generator.series; 971
985 create function sys.generate_series(first double, "limit" double, stepsize double) returns table (value double) external name generator.series; 985 ! 972 create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series; 972
986 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 986 973 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 973
987 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 987 974 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 974
988 create function sys.generate_series(first int, "limit" int) returns table (value int) external name generator.series; 988 ! 975 create function sys.generate_series(first int, last int) returns table (value int) external name generator.series; 975
989 create function sys.generate_series(first int, "limit" int, stepsize int) returns table (value int) external name generator.series; 989 ! 976 create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series; 976
990 create function sys.generate_series(first real, "limit" real, stepsize real) returns table (value real) external name generator.series; 990 ! 977 create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series; 977
991 create function sys.generate_series(first smallint, "limit" smallint) returns table (value smallint) external name generator.series; 991 ! 978 create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series; 978
992 create function sys.generate_series(first smallint, "limit" smallint, stepsize smallint) returns table (value smallint) external name generator.series; 992 ! 979 create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series; 979
993 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 993 ! 980 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 980
994 create function sys.generate_series(first tinyint, "limit" tinyint) returns table (value tinyint) external name generator.series; 994 ! 981 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 981
995 create function sys.generate_series(first tinyint, "limit" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 995 -
996 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 996 982 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 982
..................
# 10:17:18 >
1015 create function has_z(info integer) returns integer external name geom."hasZ"; 1015 1001 create function has_z(info integer) returns integer external name geom."hasZ"; 1001
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 ! 1002 create function sys.hashsize(b boolean, i bigint) returns bigint begin if b = true then return 8 * i; end if; return 0; end; 1002
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 ! 1003 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; 1003
1018 create function "host" (p inet) returns clob external name inet."host"; 1018 1004 create function "host" (p inet) returns clob external name inet."host"; 1004
..................
# 10:17:18 >
1021 create filter function "ilike"(val string, pat string, esc string) external name algebra."ilike"; 1021 1007 create filter function "ilike"(val string, pat string, esc string) external name algebra."ilike"; 1007
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 ! 1008 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; 1008
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 1009 create function internaltransform(geom geometry, srid_src integer, srid_dest integer, proj4_src string, proj4_dest string) returns geometry external name geom."Transform"; 1009
..................
# 10:17:18 >
1027 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1027 1013 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1013
1028 create procedure lidarattach(fname string) external name lidar.attach; 1028 ! 1014 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1014
1029 create procedure lidarexport(tname string, fname string, format string) external name lidar.export; 1029 -
1030 create procedure lidarload(tname string) external name lidar.load; 1030 -
1031 create filter function "like"(val string, pat string) external name algebra."like"; 1031 1015 create filter function "like"(val string, pat string) external name algebra."like"; 1015
1032 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1032 -
1033 create procedure listdir(dirname string) external name fits.listdir; 1033 1016 create procedure listdir(dirname string) external name fits.listdir; 1016
..................
# 10:17:18 >
1067 create function sys.password_hash (username string) returns string external name sql.password; 1067 1050 create function sys.password_hash (username string) returns string external name sql.password; 1050
+ 1051 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1051
1068 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1068 1052 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1052
1069 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1069 -
1070 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1070 1053 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1053
..................
# 10:17:18 >
1114 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1114 1097 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1097
1115 create procedure shpattach(fname string) external name shp.attach; 1115 -
1116 create procedure shpload(fid integer) external name shp.import; 1116 -
1117 create procedure shpload(fid integer, filter geometry) external name shp.import; 1117 -
1118 create procedure shrink(sys string, tab string) external name sql.shrink; 1118 1098 create procedure shrink(sys string, tab string) external name sql.shrink; 1098
..................
# 10:17:18 >
1247 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1247 1227 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1227
+ 1228 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1228
1248 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1248 1229 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1229
..................
# 10:17:18 >
1256 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1256 1237 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1237
1257 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1257 -
1258 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1258 1238 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1238
..................
# 10:17:18 >
1260 create procedure stopmaster() external name wlc.stopmaster; 1260 1240 create procedure stopmaster() external name wlc.stopmaster; 1240
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 ! 1241 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"; 1241
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 ! 1242 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"; 1242
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 ! 1243 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"; 1243
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 ! 1244 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"; 1244
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" + 1245 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; 1245
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 ! 1246 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; 1246
1266 create function str_to_date(s string, format string) returns date external name mtime."str_to_date"; 1266 1247 create function str_to_date(s string, format string) returns date external name mtime."str_to_date"; 1247
..................
# .s, .t, .L10, .L12, .t,
1454 [ "sys", "schemas", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1454 1435 [ "sys", "schemas", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1435
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 1436 [ "sys", "sequences", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1436
..................
# .s, .t, .L10, .L12, .t,
1459 [ "sys", "statistics", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1459 1439 [ "sys", "statistics", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1439
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 ! 1440 [ "sys", "storage", "create view sys.\"storage\" as select * from sys.\"storage\"();", "VIEW", true, "COMMIT", "WRITABLE" ] 1440
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 ! 1441 [ "sys", "storagemodel", "create view sys.storagemodel as select * from sys.storagemodel();", "VIEW", true, "COMMIT", "WRITABLE" ] 1441
1462 [ "sys", "storagemodelinput", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1462 1442 [ "sys", "storagemodelinput", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1442
..................
# .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 1446 [ "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" ] 1446
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 ! 1447 [ "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" ] 1447
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 1448 [ "sys", "tracelog", "create view sys.tracelog as select * from sys.tracelog();", "VIEW", true, "COMMIT", "WRITABLE" ] 1448
..................
#select t.name, c.name, c.type, c.type_d
1485 % varchar, varchar, varchar, int, int, varchar, boolean, int, varchar # type 1485 1464 % varchar, varchar, varchar, int, int, varchar, boolean, int, varchar # type 1464
1486 % 34, 26, 9, 5, 1, 5, 5, 2, 0 # length 1486 ! 1465 % 34, 26, 9, 5, 1, 0, 5, 2, 0 # length 1465
1487 [ "_columns", "id", "int", 32, 0, NULL, true, 0, NULL ] 1487 1466 [ "_columns", "id", "int", 32, 0, NULL, true, 0, NULL ] 1466
..................
#select t.name, c.name, c.type, c.type_d
1932 [ "schemas", "system", "boolean", 1, 0, NULL, true, 4, NULL ] 1932 1911 [ "schemas", "system", "boolean", 1, 0, NULL, true, 4, NULL ] 1911
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 1912 [ "sequences", "id", "int", 32, 0, NULL, true, 0, NULL ] 1912
..................
#select t.name, c.name, c.type, c.type_d
1978 [ "statistics", "revsorted", "boolean", 1, 0, NULL, true, 11, NULL ] 1978 1950 [ "statistics", "revsorted", "boolean", 1, 0, NULL, true, 11, NULL ] 1950
1979 [ "storage", "schema", "varchar", 1024, 0, NULL, true, 0, NULL ] 1979 ! 1951 [ "storage", "schema", "clob", 0, 0, NULL, true, 0, NULL ] 1951
1980 [ "storage", "table", "varchar", 1024, 0, NULL, true, 1, NULL ] 1980 ! 1952 [ "storage", "table", "clob", 0, 0, NULL, true, 1, NULL ] 1952
1981 [ "storage", "column", "varchar", 1024, 0, NULL, true, 2, NULL ] 1981 ! 1953 [ "storage", "column", "clob", 0, 0, NULL, true, 2, NULL ] 1953
1982 [ "storage", "type", "varchar", 1024, 0, NULL, true, 3, NULL ] 1982 ! 1954 [ "storage", "type", "clob", 0, 0, NULL, true, 3, NULL ] 1954
1983 [ "storage", "mode", "varchar", 15, 0, NULL, true, 4, NULL ] 1983 ! 1955 [ "storage", "mode", "clob", 0, 0, NULL, true, 4, NULL ] 1955
1984 [ "storage", "location", "varchar", 1024, 0, NULL, true, 5, NULL ] 1984 ! 1956 [ "storage", "location", "clob", 0, 0, NULL, true, 5, NULL ] 1956
1985 [ "storage", "count", "bigint", 64, 0, NULL, true, 6, NULL ] 1985 1957 [ "storage", "count", "bigint", 64, 0, NULL, true, 6, NULL ] 1957
..................
#select t.name, c.name, c.type, c.type_d
1995 [ "storage", "orderidx", "bigint", 64, 0, NULL, true, 16, NULL ] 1995 1967 [ "storage", "orderidx", "bigint", 64, 0, NULL, true, 16, NULL ] 1967
1996 [ "storagemodel", "schema", "varchar", 1024, 0, NULL, true, 0, NULL ] 1996 ! 1968 [ "storagemodel", "schema", "clob", 0, 0, NULL, true, 0, NULL ] 1968
1997 [ "storagemodel", "table", "varchar", 1024, 0, NULL, true, 1, NULL ] 1997 ! 1969 [ "storagemodel", "table", "clob", 0, 0, NULL, true, 1, NULL ] 1969
1998 [ "storagemodel", "column", "varchar", 1024, 0, NULL, true, 2, NULL ] 1998 ! 1970 [ "storagemodel", "column", "clob", 0, 0, NULL, true, 2, NULL ] 1970
1999 [ "storagemodel", "type", "varchar", 1024, 0, NULL, true, 3, NULL ] 1999 ! 1971 [ "storagemodel", "type", "clob", 0, 0, NULL, true, 3, NULL ] 1971
2000 [ "storagemodel", "count", "bigint", 64, 0, NULL, true, 4, NULL ] 2000 1972 [ "storagemodel", "count", "bigint", 64, 0, NULL, true, 4, NULL ] 1972
..................
#select t.name, c.name, c.type, c.type_d
2002 [ "storagemodel", "heapsize", "bigint", 64, 0, NULL, true, 6, NULL ] 2002 1974 [ "storagemodel", "heapsize", "bigint", 64, 0, NULL, true, 6, NULL ] 1974
2003 [ "storagemodel", "hashsize", "bigint", 64, 0, NULL, true, 7, NULL ] 2003 ! 1975 [ "storagemodel", "hashes", "bigint", 64, 0, NULL, true, 7, NULL ] 1975
2004 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2004 ! 1976 [ "storagemodel", "imprints", "bigint", 64, 0, NULL, true, 8, NULL ] 1976
2005 [ "storagemodel", "orderidxsize", "bigint", 64, 0, NULL, true, 9, NULL ] 2005 ! 1977 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 9, NULL ] 1977
2006 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2006 ! 1978 [ "storagemodel", "revsorted", "boolean", 1, 0, NULL, true, 10, NULL ] 1978
2007 [ "storagemodel", "unique", "boolean", 1, 0, NULL, true, 11, NULL ] 2007 1979 [ "storagemodel", "unique", "boolean", 1, 0, NULL, true, 11, NULL ] 1979
2008 [ "storagemodel", "isacolumn", "boolean", 1, 0, NULL, true, 12, NULL ] 2008 ! 1980 [ "storagemodel", "orderidx", "bigint", 64, 0, NULL, true, 12, NULL ] 1980
2009 [ "storagemodelinput", "schema", "varchar", 1024, 0, NULL, false, 0, NULL ] 2009 ! 1981 [ "storagemodelinput", "schema", "clob", 0, 0, NULL, true, 0, NULL ] 1981
2010 [ "storagemodelinput", "table", "varchar", 1024, 0, NULL, false, 1, NULL ] 2010 ! 1982 [ "storagemodelinput", "table", "clob", 0, 0, NULL, true, 1, NULL ] 1982
2011 [ "storagemodelinput", "column", "varchar", 1024, 0, NULL, false, 2, NULL ] 2011 ! 1983 [ "storagemodelinput", "column", "clob", 0, 0, NULL, true, 2, NULL ] 1983
2012 [ "storagemodelinput", "type", "varchar", 1024, 0, NULL, false, 3, NULL ] 2012 ! 1984 [ "storagemodelinput", "type", "clob", 0, 0, NULL, true, 3, NULL ] 1984
2013 [ "storagemodelinput", "typewidth", "int", 32, 0, NULL, false, 4, NULL ] 2013 ! 1985 [ "storagemodelinput", "typewidth", "int", 32, 0, NULL, true, 4, NULL ] 1985
2014 [ "storagemodelinput", "count", "bigint", 64, 0, NULL, false, 5, NULL ] 2014 ! 1986 [ "storagemodelinput", "count", "bigint", 64, 0, NULL, true, 5, NULL ] 1986
2015 [ "storagemodelinput", "distinct", "bigint", 64, 0, NULL, false, 6, NULL ] 2015 ! 1987 [ "storagemodelinput", "distinct", "bigint", 64, 0, NULL, true, 6, NULL ] 1987
2016 [ "storagemodelinput", "atomwidth", "int", 32, 0, NULL, false, 7, NULL ] 2016 ! 1988 [ "storagemodelinput", "atomwidth", "int", 32, 0, NULL, true, 7, NULL ] 1988
2017 [ "storagemodelinput", "reference", "boolean", 1, 0, "false", false, 8, NULL ] 2017 ! 1989 [ "storagemodelinput", "reference", "boolean", 1, 0, NULL, true, 8, NULL ] 1989
2018 [ "storagemodelinput", "sorted", "boolean", 1, 0, NULL, true, 9, NULL ] 2018 1990 [ "storagemodelinput", "sorted", "boolean", 1, 0, NULL, true, 9, NULL ] 1990
2019 [ "storagemodelinput", "unique", "boolean", 1, 0, NULL, true, 10, NULL ] 2019 ! 1991 [ "storagemodelinput", "revsorted", "boolean", 1, 0, NULL, true, 10, NULL ] 1991
2020 [ "storagemodelinput", "isacolumn", "boolean", 1, 0, "true", false, 11, NULL ] 2020 ! 1992 [ "storagemodelinput", "unique", "boolean", 1, 0, NULL, true, 11, NULL ] 1992
+ 1993 [ "storagemodelinput", "orderidx", "bigint", 64, 0, NULL, true, 12, NULL ] 1993
2021 [ "systemfunctions", "function_id", "int", 32, 0, NULL, true, 0, NULL ] 2021 1994 [ "systemfunctions", "function_id", "int", 32, 0, NULL, true, 0, NULL ] 1994
..................
#select t.name, c.name, c.type, c.type_d
2037 [ "tables", "temporary", "smallint", 16, 0, NULL, true, 8, NULL ] 2037 2010 [ "tables", "temporary", "smallint", 16, 0, NULL, true, 8, NULL ] 2010
2038 [ "tablestorage", "schema", "varchar", 1024, 0, NULL, true, 0, NULL ] 2038 ! 2011 [ "tablestoragemodel", "schema", "clob", 0, 0, NULL, true, 0, NULL ] 2011
2039 [ "tablestorage", "table", "varchar", 1024, 0, NULL, true, 1, NULL ] 2039 ! 2012 [ "tablestoragemodel", "table", "clob", 0, 0, NULL, true, 1, NULL ] 2012
2040 [ "tablestorage", "rowcount", "bigint", 64, 0, NULL, true, 2, NULL ] 2040 ! 2013 [ "tablestoragemodel", "count", "bigint", 64, 0, NULL, true, 2, NULL ] 2013
2041 [ "tablestorage", "storages", "bigint", 64, 0, NULL, true, 3, NULL ] 2041 ! 2014 [ "tablestoragemodel", "columnsize", "bigint", 64, 0, NULL, true, 3, NULL ] 2014
2042 [ "tablestorage", "columnsize", "bigint", 64, 0, NULL, true, 4, NULL ] 2042 ! 2015 [ "tablestoragemodel", "heapsize", "bigint", 64, 0, NULL, true, 4, NULL ] 2015
2043 [ "tablestorage", "heapsize", "bigint", 64, 0, NULL, true, 5, NULL ] 2043 ! 2016 [ "tablestoragemodel", "hashes", "bigint", 64, 0, NULL, true, 5, NULL ] 2016
2044 [ "tablestorage", "hashsize", "bigint", 64, 0, NULL, true, 6, NULL ] 2044 ! 2017 [ "tablestoragemodel", "imprints", "bigint", 64, 0, NULL, true, 6, NULL ] 2017
2045 [ "tablestorage", "imprintsize", "bigint", 64, 0, NULL, true, 7, NULL ] 2045 ! 2018 [ "tablestoragemodel", "auxiliary", "hugeint", 128, 0, NULL, true, 7, NULL ] 2018
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 2019 [ "tracelog", "event", "int", 32, 0, NULL, true, 0, NULL ] 2019
..................
# .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 2094 % 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 2094
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 ! 2095 % 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 2095
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 2096 [ "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 ] 2096
..................
# .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 2259 [ "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 ] 2259
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 ! 2260 [ "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 ] 2260
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 2261 [ "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 ] 2261
..................
# .s, .f, .L4, .L6, .f,
2369 [ "sys", "fuse", "SYSTEM", "create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse;", "udf", "MAL", "Scalar function", false, false, false, "result", "smallint", 16, 0, "out", "one", "tinyint", 8, 0, "in", "two", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2369 2332 [ "sys", "fuse", "SYSTEM", "create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse;", "udf", "MAL", "Scalar function", false, false, false, "result", "smallint", 16, 0, "out", "one", "tinyint", 8, 0, "in", "two", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2332
2370 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first bigint, \"limit\" bigint) returns table (value bigint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "bigint", 64, 0, "out", "first", "bigint", 64, 0, "in", "limit", "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 ] 2370 ! 2333 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "bigint", 64, 0, "out", "first", "bigint", 64, 0, "in", "last", "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 ] 2333
2371 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first bigint, \"limit\" bigint, stepsize bigint) returns table (value bigint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "bigint", 64, 0, "out", "first", "bigint", 64, 0, "in", "limit", "bigint", 64, 0, "in", "stepsize", "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 ] 2371 ! 2334 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "bigint", 64, 0, "out", "first", "bigint", 64, 0, "in", "last", "bigint", 64, 0, "in", "stepsize", "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 ] 2334
2372 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first decimal(10,2), \"limit\" decimal(10,2), stepsize decimal(10,2)) returns table (value decimal(10,2)) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "decimal", 10, 2, "out", "first", "decimal", 10, 2, "in", "limit", "decimal", 10, 2, "in", "stepsize", "decimal", 10, 2, "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 ] 2372 ! 2335 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first decimal(10,2), last decimal(10,2), stepsize decimal(10,2)) returns table (value decimal(10,2)) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "decimal", 10, 2, "out", "first", "decimal", 10, 2, "in", "last", "decimal", 10, 2, "in", "stepsize", "decimal", 10, 2, "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 ] 2335
2373 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first double, \"limit\" double, stepsize double) returns table (value double) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "double", 53, 0, "out", "first", "double", 53, 0, "in", "limit", "double", 53, 0, "in", "stepsize", "double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2373 ! 2336 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "double", 53, 0, "out", "first", "double", 53, 0, "in", "last", "double", 53, 0, "in", "stepsize", "double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2336
2374 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first hugeint, \"limit\" hugeint) returns table (value hugeint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "hugeint", 128, 0, "out", "first", "hugeint", 128, 0, "in", "limit", "hugeint", 128, 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 ] 2374 2337 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first hugeint, \"limit\" hugeint) returns table (value hugeint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "hugeint", 128, 0, "out", "first", "hugeint", 128, 0, "in", "limit", "hugeint", 128, 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 ] 2337
2375 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first hugeint, \"limit\" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "hugeint", 128, 0, "out", "first", "hugeint", 128, 0, "in", "limit", "hugeint", 128, 0, "in", "stepsize", "hugeint", 128, 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 ] 2375 2338 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first hugeint, \"limit\" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "hugeint", 128, 0, "out", "first", "hugeint", 128, 0, "in", "limit", "hugeint", 128, 0, "in", "stepsize", "hugeint", 128, 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 ] 2338
2376 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first int, \"limit\" int) returns table (value int) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "int", 32, 0, "out", "first", "int", 32, 0, "in", "limit", "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 ] 2376 ! 2339 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first int, last int) returns table (value int) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "int", 32, 0, "out", "first", "int", 32, 0, "in", "last", "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 ] 2339
2377 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first int, \"limit\" int, stepsize int) returns table (value int) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "int", 32, 0, "out", "first", "int", 32, 0, "in", "limit", "int", 32, 0, "in", "stepsize", "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 ] 2377 ! 2340 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "int", 32, 0, "out", "first", "int", 32, 0, "in", "last", "int", 32, 0, "in", "stepsize", "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 ] 2340
2378 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first real, \"limit\" real, stepsize real) returns table (value real) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "real", 24, 0, "out", "first", "real", 24, 0, "in", "limit", "real", 24, 0, "in", "stepsize", "real", 24, 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 ] 2378 ! 2341 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "real", 24, 0, "out", "first", "real", 24, 0, "in", "last", "real", 24, 0, "in", "stepsize", "real", 24, 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 ] 2341
2379 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first smallint, \"limit\" smallint) returns table (value smallint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "smallint", 16, 0, "out", "first", "smallint", 16, 0, "in", "limit", "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 ] 2379 ! 2342 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "smallint", 16, 0, "out", "first", "smallint", 16, 0, "in", "last", "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 ] 2342
2380 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first smallint, \"limit\" smallint, stepsize smallint) returns table (value smallint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "smallint", 16, 0, "out", "first", "smallint", 16, 0, "in", "limit", "smallint", 16, 0, "in", "stepsize", "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 ] 2380 ! 2343 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "smallint", 16, 0, "out", "first", "smallint", 16, 0, "in", "last", "smallint", 16, 0, "in", "stepsize", "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 ] 2343
2381 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first timestamp, \"limit\" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "timestamp", 7, 0, "out", "first", "timestamp", 7, 0, "in", "limit", "timestamp", 7, 0, "in", "stepsize", "sec_interval", 13, 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 ] 2381 ! 2344 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "timestamp", 7, 0, "out", "first", "timestamp", 7, 0, "in", "last", "timestamp", 7, 0, "in", "stepsize", "sec_interval", 13, 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 ] 2344
2382 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first tinyint, \"limit\" tinyint) returns table (value tinyint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "tinyint", 8, 0, "out", "first", "tinyint", 8, 0, "in", "limit", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2382 ! 2345 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "tinyint", 8, 0, "out", "first", "tinyint", 8, 0, "in", "last", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2345
2383 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first tinyint, \"limit\" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "tinyint", 8, 0, "out", "first", "tinyint", 8, 0, "in", "limit", "tinyint", 8, 0, "in", "stepsize", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2383 ! 2346 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "tinyint", 8, 0, "out", "first", "tinyint", 8, 0, "in", "last", "tinyint", 8, 0, "in", "stepsize", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2346
2384 [ "sys", "geometrytype", "SYSTEM", "create function geometrytype(geom geometry) returns string external name geom.\"GeometryType1\";", "geom", "MAL", "Scalar function", false, false, false, "result", "clob", 0, 0, "out", "geom", "geometry", 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 2347 [ "sys", "geometrytype", "SYSTEM", "create function geometrytype(geom geometry) returns string external name geom.\"GeometryType1\";", "geom", "MAL", "Scalar function", false, false, false, "result", "clob", 0, 0, "out", "geom", "geometry", 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 ] 2347
..................
# .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 2368 [ "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 ] 2368
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 ! 2369 [ "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 ] 2369
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 ! 2370 [ "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 ] 2370
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 2371 [ "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 ] 2371
..................
# .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 2381 [ "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 ] 2381
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 ! 2382 [ "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 ] 2382
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 2383 [ "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 ] 2383
..................
# .s, .f, .L4, .L6, .f,
2489 [ "sys", "levenshtein", "SYSTEM", "levenshtein", "txtsim", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "varchar", 0, 0, "in", "arg_2", "varchar", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "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 ] 2489 2452 [ "sys", "levenshtein", "SYSTEM", "levenshtein", "txtsim", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "varchar", 0, 0, "in", "arg_2", "varchar", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "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 ] 2452
2490 [ "sys", "lidarattach", "SYSTEM", "create procedure lidarattach(fname string) external name lidar.attach;", "lidar", "MAL", "Procedure", true, false, false, "fname", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2490 -
2491 [ "sys", "lidarexport", "SYSTEM", "create procedure lidarexport(tname string, fname string, format string) external name lidar.export;", "lidar", "MAL", "Procedure", true, false, false, "tname", "clob", 0, 0, "in", "fname", "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 ] 2491 -
2492 [ "sys", "lidarload", "SYSTEM", "create procedure lidarload(tname string) external name lidar.load;", "lidar", "MAL", "Procedure", true, false, false, "tname", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2492 -
2493 [ "sys", "like", "SYSTEM", "create filter function \"like\"(val string, pat string) external name algebra.\"like\";", "algebra", "MAL", "Filter function", false, false, false, "val", "clob", 0, 0, "in", "pat", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2493 2453 [ "sys", "like", "SYSTEM", "create filter function \"like\"(val string, pat string) external name algebra.\"like\";", "algebra", "MAL", "Filter function", false, false, false, "val", "clob", 0, 0, "in", "pat", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2453
..................
# .s, .f, .L4, .L6, .f,
3386 [ "sys", "settimeout", "SYSTEM", "create procedure sys.settimeout(\"query\" bigint, \"session\" bigint) external name clients.settimeout;", "clients", "MAL", "Procedure", true, false, false, "query", "bigint", 64, 0, "in", "session", "bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3386 3346 [ "sys", "settimeout", "SYSTEM", "create procedure sys.settimeout(\"query\" bigint, \"session\" bigint) external name clients.settimeout;", "clients", "MAL", "Procedure", true, false, false, "query", "bigint", 64, 0, "in", "session", "bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3346
3387 [ "sys", "shpattach", "SYSTEM", "create procedure shpattach(fname string) external name shp.attach;", "shp", "MAL", "Procedure", true, false, false, "fname", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3387 -
3388 [ "sys", "shpload", "SYSTEM", "create procedure shpload(fid integer) external name shp.import;", "shp", "MAL", "Procedure", true, false, false, "fid", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3388 -
3389 [ "sys", "shpload", "SYSTEM", "create procedure shpload(fid integer, filter geometry) external name shp.import;", "shp", "MAL", "Procedure", true, false, false, "fid", "int", 32, 0, "in", "filter", "geometry", 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 ] 3389 -
3390 [ "sys", "shrink", "SYSTEM", "create procedure shrink(sys string, tab string) external name sql.shrink;", "sql", "MAL", "Procedure", true, false, false, "sys", "clob", 0, 0, "in", "tab", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3390 3347 [ "sys", "shrink", "SYSTEM", "create procedure shrink(sys string, tab string) external name sql.shrink;", "sql", "MAL", "Procedure", true, false, false, "sys", "clob", 0, 0, "in", "tab", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3347
..................
# .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 3808 [ "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 ] 3808
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 ! 3809 [ "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" ] 3809
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 ! 3810 [ "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" ] 3810
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 ! 3811 [ "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" ] 3811
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 ! 3812 [ "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" ] 3812
[ "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', + 3813 [ "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 ] 3813
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 ! 3814 [ "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 ] 3814
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 3815 [ "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 ] 3815
..................
#select s1.name, f1.name, s2.name, f2.na
4036 % 3, 17, 3, 13, 8 # length 4036 3994 % 3, 17, 3, 13, 8 # length 3994
+ 3995 [ "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3995
4037 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4037 3996 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3996
..................
#select s1.name, f1.name, s2.name, f2.na
4041 [ "sys", "st_srid", "sys", "st_transform", "FUNCTION" ] 4041 4000 [ "sys", "st_srid", "sys", "st_transform", "FUNCTION" ] 4000
+ 4001 [ "sys", "columnsize", "sys", "storagemodel", "FUNCTION" ] 4001
+ 4002 [ "sys", "hashsize", "sys", "storagemodel", "FUNCTION" ] 4002
+ 4003 [ "sys", "heapsize", "sys", "storagemodel", "FUNCTION" ] 4003
+ 4004 [ "sys", "imprintsize", "sys", "storagemodel", "FUNCTION" ] 4004
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 4005 #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; 4005
..................
#select s1.name, t.name, s2.name, f.name
4047 [ "sys", "spatial_ref_sys", "sys", "getproj4", "FUNCTION" ] 4047 4010 [ "sys", "spatial_ref_sys", "sys", "getproj4", "FUNCTION" ] 4010
4048 [ "sys", "columns", "sys", "storagemodelinit", "PROCEDURE" ] 4048 ! 4011 [ "sys", "storagemodelinput", "sys", "storagemodel", "FUNCTION" ] 4011
4049 [ "sys", "keys", "sys", "storagemodelinit", "PROCEDURE" ] 4049 4012 [ "sys", "keys", "sys", "storagemodelinit", "PROCEDURE" ] 4012
..................
#select s1.name, t.name, s2.name, f.name
4051 [ "sys", "schemas", "sys", "storagemodelinit", "PROCEDURE" ] 4051 4014 [ "sys", "schemas", "sys", "storagemodelinit", "PROCEDURE" ] 4014
4052 [ "sys", "storage", "sys", "storagemodelinit", "PROCEDURE" ] 4052 -
4053 [ "sys", "storagemodelinput", "sys", "storagemodelinit", "PROCEDURE" ] 4053 4015 [ "sys", "storagemodelinput", "sys", "storagemodelinit", "PROCEDURE" ] 4015
..................
#select s1.name, t.name, c.name, s2.name
4059 % 3, 17, 13, 3, 16, 9 # length 4059 4021 % 3, 17, 13, 3, 16, 9 # length 4021
+ 4022 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 4022
+ 4023 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 4023
4060 [ "sys", "spatial_ref_sys", "auth_name", "sys", "getproj4", "FUNCTION" ] 4060 ! 4024 [ "sys", "storagemodelinput", "atomwidth", "sys", "storagemodel", "FUNCTION" ] 4024
4061 [ "sys", "spatial_ref_sys", "auth_srid", "sys", "getproj4", "FUNCTION" ] 4061 ! 4025 [ "sys", "storagemodelinput", "column", "sys", "storagemodel", "FUNCTION" ] 4025
4062 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 4062 -
4063 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 4063 -
4064 [ "sys", "spatial_ref_sys", "srtext", "sys", "getproj4", "FUNCTION" ] 4064 ! 4026 [ "sys", "storagemodelinput", "count", "sys", "storagemodel", "FUNCTION" ] 4026
+ 4027 [ "sys", "storagemodelinput", "distinct", "sys", "storagemodel", "FUNCTION" ] 4027
+ 4028 [ "sys", "storagemodelinput", "orderidx", "sys", "storagemodel", "FUNCTION" ] 4028
+ 4029 [ "sys", "storagemodelinput", "reference", "sys", "storagemodel", "FUNCTION" ] 4029
+ 4030 [ "sys", "storagemodelinput", "revsorted", "sys", "storagemodel", "FUNCTION" ] 4030
+ 4031 [ "sys", "storagemodelinput", "schema", "sys", "storagemodel", "FUNCTION" ] 4031
+ 4032 [ "sys", "storagemodelinput", "sorted", "sys", "storagemodel", "FUNCTION" ] 4032
+ 4033 [ "sys", "storagemodelinput", "table", "sys", "storagemodel", "FUNCTION" ] 4033
+ 4034 [ "sys", "storagemodelinput", "type", "sys", "storagemodel", "FUNCTION" ] 4034
+ 4035 [ "sys", "storagemodelinput", "typewidth", "sys", "storagemodel", "FUNCTION" ] 4035
+ 4036 [ "sys", "storagemodelinput", "unique", "sys", "storagemodel", "FUNCTION" ] 4036
4065 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 4065 4037 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 4037
..................
#select s1.name, t.name, c.name, s2.name
4082 [ "sys", "storagemodelinput", "distinct", "sys", "storagemodelinit", "PROCEDURE" ] 4082 4054 [ "sys", "storagemodelinput", "distinct", "sys", "storagemodelinit", "PROCEDURE" ] 4054
4083 [ "sys", "storagemodelinput", "isacolumn", "sys", "storagemodelinit", "PROCEDURE" ] 4083 ! 4055 [ "sys", "storagemodelinput", "orderidx", "sys", "storagemodelinit", "PROCEDURE" ] 4055
4084 [ "sys", "storagemodelinput", "reference", "sys", "storagemodelinit", "PROCEDURE" ] 4084 4056 [ "sys", "storagemodelinput", "reference", "sys", "storagemodelinit", "PROCEDURE" ] 4056
+ 4057 [ "sys", "storagemodelinput", "revsorted", "sys", "storagemodelinit", "PROCEDURE" ] 4057
4085 [ "sys", "storagemodelinput", "schema", "sys", "storagemodelinit", "PROCEDURE" ] 4085 4058 [ "sys", "storagemodelinput", "schema", "sys", "storagemodelinit", "PROCEDURE" ] 4058
..................
#select s1.name, f1.name, s2.name, t2.na
4094 % varchar, varchar, varchar, varchar, varchar # type 4094 4067 % varchar, varchar, varchar, varchar, varchar # type 4067
4095 % 3, 11, 3, 17, 4 # length 4095 ! 4068 % 3, 16, 3, 16, 4 # length 4068
4096 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 4096 4069 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 4069
..................
#select s1.name, f1.name, s2.name, t2.na
4098 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 4098 4071 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 4071
4099 [ "sys", "columnsize", "sys", "storagemodel", "VIEW" ] 4099 ! 4072 [ "sys", "optimizers", "sys", "optimizers", "VIEW" ] 4072
4100 [ "sys", "hashsize", "sys", "storagemodel", "VIEW" ] 4100 ! 4073 [ "sys", "querylog_catalog", "sys", "querylog_catalog", "VIEW" ] 4073
4101 [ "sys", "heapsize", "sys", "storagemodel", "VIEW" ] 4101 ! 4074 [ "sys", "queue", "sys", "queue", "VIEW" ] 4074
4102 [ "sys", "imprintsize", "sys", "storagemodel", "VIEW" ] 4102 ! 4075 [ "sys", "rejects", "sys", "rejects", "VIEW" ] 4075
4103 [ "sys", "columnsize", "sys", "tablestoragemodel", "VIEW" ] 4103 ! 4076 [ "sys", "sessions", "sys", "sessions", "VIEW" ] 4076
4104 [ "sys", "hashsize", "sys", "tablestoragemodel", "VIEW" ] 4104 ! 4077 [ "sys", "tracelog", "sys", "tracelog", "VIEW" ] 4077
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 4078 #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; 4078
..................
#select s1.name, t1.name, s2.name, t2.na
4110 % varchar, varchar, varchar, varchar, varchar # type 4110 4081 % varchar, varchar, varchar, varchar, varchar # type 4081
4111 % 3, 17, 3, 34, 4 # length 4111 ! 4082 % 3, 16, 3, 34, 4 # length 4082
4112 [ "sys", "dependencies", "sys", "dependencies_vw", "VIEW" ] 4112 4083 [ "sys", "dependencies", "sys", "dependencies_vw", "VIEW" ] 4083
..................
#select s1.name, t1.name, s2.name, t2.na
4122 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 4122 4093 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 4093
4123 [ "sys", "idxs", "sys", "dependency_columns_on_indexes", "VIEW" ] 4123 -
4124 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 4124 4094 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 4094
4125 [ "sys", "objects", "sys", "dependency_columns_on_indexes", "VIEW" ] 4125 -
4126 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 4126 4095 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 4095
4127 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 4127 4096 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 4096
4128 [ "sys", "keys", "sys", "dependency_columns_on_keys", "VIEW" ] 4128 -
4129 [ "sys", "objects", "sys", "dependency_columns_on_keys", "VIEW" ] 4129 -
4130 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 4130 4097 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 4097
..................
#select s1.name, t1.name, s2.name, t2.na
4136 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 4136 4103 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 4103
4137 [ "sys", "triggers", "sys", "dependency_columns_on_triggers", "VIEW" ] 4137 -
4138 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 4138 4104 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 4104
..................
#select s1.name, t1.name, s2.name, t2.na
4150 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 4150 4116 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 4116
4151 [ "sys", "triggers", "sys", "dependency_functions_on_triggers", "VIEW" ] 4151 -
4152 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 4152 4117 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 4117
..................
#select s1.name, t1.name, s2.name, t2.na
4157 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 4157 4122 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 4122
4158 [ "sys", "keys", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4158 -
4159 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 4159 4123 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 4123
..................
#select s1.name, t1.name, s2.name, t2.na
4162 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 4162 4126 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 4126
4163 [ "sys", "keys", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4163 -
4164 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4164 4127 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4127
..................
#select s1.name, t1.name, s2.name, t2.na
4167 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 4167 4130 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 4130
4168 [ "sys", "idxs", "sys", "dependency_tables_on_indexes", "VIEW" ] 4168 -
4169 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 4169 4131 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 4131
..................
#select s1.name, t1.name, s2.name, t2.na
4175 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4175 4137 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4137
4176 [ "sys", "triggers", "sys", "dependency_tables_on_triggers", "VIEW" ] 4176 -
4177 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4177 4138 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4138
..................
#select s1.name, t1.name, s2.name, t2.na
4190 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4190 4151 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4151
4191 [ "sys", "_columns", "sys", "ids", "VIEW" ] 4191 -
4192 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4192 4152 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4152
..................
#select s1.name, t1.name, s2.name, t2.na
4195 [ "sys", "functions", "sys", "ids", "VIEW" ] 4195 4155 [ "sys", "functions", "sys", "ids", "VIEW" ] 4155
4196 [ "sys", "idxs", "sys", "ids", "VIEW" ] 4196 -
4197 [ "sys", "keys", "sys", "ids", "VIEW" ] 4197 4156 [ "sys", "keys", "sys", "ids", "VIEW" ] 4156
..................
#select s1.name, t1.name, s2.name, t2.na
4199 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4199 4158 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4158
4200 [ "sys", "triggers", "sys", "ids", "VIEW" ] 4200 -
4201 [ "sys", "types", "sys", "ids", "VIEW" ] 4201 4159 [ "sys", "types", "sys", "ids", "VIEW" ] 4159
4202 [ "tmp", "_columns", "sys", "ids", "VIEW" ] 4202 -
4203 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4203 4160 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4160
4204 [ "tmp", "idxs", "sys", "ids", "VIEW" ] 4204 -
4205 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4205 4161 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4161
4206 [ "tmp", "triggers", "sys", "ids", "VIEW" ] 4206 -
4207 [ "sys", "auths", "sys", "roles", "VIEW" ] 4207 4162 [ "sys", "auths", "sys", "roles", "VIEW" ] 4162
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 4163 [ "sys", "functions", "sys", "systemfunctions", "VIEW" ] 4163
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 4164 #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; 4164
..................
#select s1.name, t1.name, c1.name, s2.na
4218 % varchar, varchar, varchar, varchar, varchar, varchar # type 4218 4167 % varchar, varchar, varchar, varchar, varchar, varchar # type 4167
4219 % 3, 17, 20, 3, 34, 4 # length 4219 ! 4168 % 3, 16, 20, 3, 34, 4 # length 4168
4220 [ "sys", "dependencies", "depend_id", "sys", "dependencies_vw", "VIEW" ] 4220 4169 [ "sys", "dependencies", "depend_id", "sys", "dependencies_vw", "VIEW" ] 4169
..................
#select s1.name, t1.name, c1.name, s2.na
4241 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4241 4190 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4190
4242 [ "sys", "idxs", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4242 ! 4191 [ "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4191
4243 [ "sys", "idxs", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4243 ! 4192 [ "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4192
4244 [ "sys", "idxs", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4244 ! 4193 [ "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4193
4245 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4245 ! 4194 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4194
4246 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4246 ! 4195 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4195
+ 4196 [ "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4196
4247 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4247 4197 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4197
4248 [ "sys", "objects", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4248 ! 4198 [ "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4198
4249 [ "sys", "objects", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4249 ! 4199 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4199
4250 [ "sys", "objects", "nr", "sys", "dependency_columns_on_indexes", "VIEW" ] 4250 ! 4200 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4200
4251 [ "sys", "keys", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4251 ! 4201 [ "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4201
4252 [ "sys", "keys", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4252 ! 4202 [ "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4202
4253 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4253 ! 4203 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4203
4254 [ "sys", "keys", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4254 ! 4204 [ "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4204
4255 [ "sys", "objects", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4255 ! 4205 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4205
4256 [ "sys", "objects", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4256 ! 4206 [ "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4206
4257 [ "sys", "objects", "nr", "sys", "dependency_columns_on_keys", "VIEW" ] 4257 ! 4207 [ "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4207
+ 4208 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4208
+ 4209 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4209
+ 4210 [ "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4210
4258 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4258 4211 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4211
..................
#select s1.name, t1.name, c1.name, s2.na
4266 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4266 4219 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4219
4267 [ "sys", "triggers", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4267 ! 4220 [ "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4220
4268 [ "sys", "triggers", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4268 ! 4221 [ "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4221
+ 4222 [ "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4222
4269 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4269 4223 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4223
..................
#select s1.name, t1.name, c1.name, s2.na
4297 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4297 4251 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4251
4298 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4298 ! 4252 [ "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4252
4299 [ "sys", "triggers", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4299 ! 4253 [ "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4253
4300 [ "sys", "triggers", "table_id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4300 ! 4254 [ "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4254
+ 4255 [ "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4255
4301 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4301 4256 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4256
..................
#select s1.name, t1.name, c1.name, s2.na
4314 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4314 4269 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4269
4315 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4315 ! 4270 [ "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4270
4316 [ "sys", "keys", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4316 ! 4271 [ "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4271
4317 [ "sys", "keys", "rkey", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4317 ! 4272 [ "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4272
4318 [ "sys", "keys", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4318 ! 4273 [ "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4273
4319 [ "sys", "keys", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4319 ! 4274 [ "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4274
+ 4275 [ "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4275
4320 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4320 4276 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4276
..................
#select s1.name, t1.name, c1.name, s2.na
4326 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4326 4282 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4282
4327 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4327 ! 4283 [ "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4283
4328 [ "sys", "keys", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4328 ! 4284 [ "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4284
4329 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4329 ! 4285 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4285
4330 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4330 ! 4286 [ "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4286
4331 [ "sys", "keys", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4331 ! 4287 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4287
+ 4288 [ "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4288
4332 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4332 4289 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4289
..................
#select s1.name, t1.name, c1.name, s2.na
4337 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4337 4294 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4294
4338 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4338 ! 4295 [ "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4295
4339 [ "sys", "idxs", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4339 ! 4296 [ "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4296
4340 [ "sys", "idxs", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4340 ! 4297 [ "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4297
4341 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4341 ! 4298 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4298
4342 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4342 ! 4299 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4299
+ 4300 [ "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4300
4343 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4343 4301 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4301
..................
#select s1.name, t1.name, c1.name, s2.na
4352 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4352 4310 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4310
4353 [ "sys", "triggers", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4353 ! 4311 [ "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4311
4354 [ "sys", "triggers", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4354 ! 4312 [ "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4312
4355 [ "sys", "triggers", "table_id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4355 ! 4313 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4313
+ 4314 [ "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4314
4356 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4356 4315 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4315
..................
#select s1.name, t1.name, c1.name, s2.na
4377 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4377 4336 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4336
+ 4337 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4337
4378 [ "sys", "_columns", "id", "sys", "ids", "VIEW" ] 4378 ! 4338 [ "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4338
4379 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4379 ! 4339 [ "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4339
4380 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4380 4340 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4340
+ 4341 [ "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4341
4381 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4381 -
4382 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4382 -
4383 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4383 ! 4342 [ "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4342
+ 4343 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4343
+ 4344 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4344
4384 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4384 ! 4345 [ "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4345
4385 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4385 4346 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4346
..................
#select s1.name, t1.name, c1.name, s2.na
4393 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4393 4354 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4354
4394 [ "sys", "idxs", "id", "sys", "ids", "VIEW" ] 4394 ! 4355 [ "sys", "keys", "action", "sys", "ids", "VIEW" ] 4355
+ 4356 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4356
4395 [ "sys", "idxs", "name", "sys", "ids", "VIEW" ] 4395 ! 4357 [ "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4357
+ 4358 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4358
4396 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4396 ! 4359 [ "sys", "keys", "type", "sys", "ids", "VIEW" ] 4359
4397 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4397 ! 4360 [ "sys", "objects", "id", "sys", "ids", "VIEW" ] 4360
4398 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4398 -
4399 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4399 -
4400 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4400 4361 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4361
..................
#select s1.name, t1.name, c1.name, s2.na
4404 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4404 4365 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4365
4405 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4405 ! 4366 [ "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4366
4406 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4406 ! 4367 [ "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4367
4407 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4407 ! 4368 [ "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4368
+ 4369 [ "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4369
4408 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4408 4370 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4370
..................
#select s1.name, t1.name, c1.name, s2.na
4410 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4410 4372 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4372
+ 4373 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4373
4411 [ "tmp", "_columns", "id", "sys", "ids", "VIEW" ] 4411 ! 4374 [ "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4374
4412 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4412 -
4413 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4413 -
4414 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4414 -
4415 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4415 -
4416 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4416 ! 4375 [ "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4375
+ 4376 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4376
4417 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4417 ! 4377 [ "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4377
4418 [ "tmp", "idxs", "id", "sys", "ids", "VIEW" ] 4418 ! 4378 [ "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4378
+ 4379 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4379
+ 4380 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4380
4419 [ "tmp", "idxs", "name", "sys", "ids", "VIEW" ] 4419 ! 4381 [ "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4381
4420 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4420 ! 4382 [ "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4382
+ 4383 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4383
4421 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4421 ! 4384 [ "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4384
4422 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4422 -
4423 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4423 4385 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4385
4424 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4424 ! 4386 [ "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4386
4425 [ "tmp", "triggers", "name", "sys", "ids", "VIEW" ] 4425 -
4426 [ "tmp", "triggers", "table_id", "sys", "ids", "VIEW" ] 4426 -
4427 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4427 4387 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4387
..................
#select s1.name, t1.name, c1.name, s2.na
4429 [ "sys", "auths", "name", "sys", "roles", "VIEW" ] 4429 4389 [ "sys", "auths", "name", "sys", "roles", "VIEW" ] 4389
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 4390 [ "sys", "functions", "id", "sys", "systemfunctions", "VIEW" ] 4390
4444 [ "sys", "functions", "system", "sys", "systemfunctions", "VIEW" ] 4444 4391 [ "sys", "functions", "system", "sys", "systemfunctions", "VIEW" ] 4391
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 4392 #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; 4392
..................
#select f.name, a.name, pc.privilege_cod
4790 [ "degrees", "public", "EXECUTE", "monetdb", 0 ] 4790 4728 [ "degrees", "public", "EXECUTE", "monetdb", 0 ] 4728
4791 [ "env", "public", "EXECUTE", NULL, 0 ] 4791 -
4792 [ "epoch", "public", "EXECUTE", "monetdb", 0 ] 4792 4729 [ "epoch", "public", "EXECUTE", "monetdb", 0 ] 4729
..................
# .t, .g, .L4, .L6, .L10,
5083 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5083 5020 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5020
5084 [ "_tables", "system_update_tables", "AFTER", "STATEMENT", "UPDATE", NULL, NULL, NULL, "create trigger system_update_tables after update on sys._tables for each statement call sys_update_tables();" ] 5084 ! 5021 [ NULL, "system_update_tables", "AFTER", "STATEMENT", "UPDATE", NULL, NULL, NULL, "create trigger system_update_tables after update on sys._tables for each statement call sys_update_tables();" ] 5021
5085 [ "schemas", "system_update_schemas", "AFTER", "STATEMENT", "UPDATE", NULL, NULL, NULL, "create trigger system_update_schemas after update on sys.schemas for each statement call sys_update_schemas();" ] 5085 5022 [ "schemas", "system_update_schemas", "AFTER", "STATEMENT", "UPDATE", NULL, NULL, NULL, "create trigger system_update_schemas after update on sys.schemas for each statement call sys_update_schemas();" ] 5022
..................
#select keyword from sys.keywords order
5341 [ "WHILE" ] 5341 5278 [ "WHILE" ] 5278
5342 [ "WINDOW" ] 5342 -
5343 [ "WITH" ] 5343 5279 [ "WITH" ] 5279