Test check.SQL.py (id 001aedfec00f) (err)
check.stable.out.int128.FILTERED 2018-12-06 01:27:34.347407803 +0100check.test.out.FILTERED 2018-12-06 01:27:34.451406773 +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 5315 lines, 210038 words, 1369629 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5250 lines, 208697 words, 1359228 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5315 lines, 210038 words, 1369629 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5250 lines, 208697 words, 1359228 chars in lines not matching '^$|^(\| |)#` 3
4 # 5396 lines, 212477 words, 1386787 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, "sorted" BOOLEAN, "revsorted" BOOLEAN, "unique" BOOLEAN, "orderidxsize" BIGINT NOT NULL); 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, imprintsize("type", "count") as imprintsize, cast(8 * "count" as bigint) as orderidxsize, sorted, revsorted, "unique" 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(imprintsize("type", "count")) as imprintsize, sum(cast(8 * "count" as bigint)) as orderidxsize, sum(cast(case when sorted = false then 8 * "count" else 0 end as bigint)) as auxiliary 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 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", 0, 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', 'geometry', 'geometrya') then cast((heapsize - 32) / "count" as bigint) else typewidth end, false, sorted, revsorted, "unique", orderidx from sys."storage" order by + 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 "schema", "table", "column"; update sys.storagemodelinput set "distinct" = "count" where "unique" = true or "type" in ('varchar', 'char', 'clob', 'json', 'url', 'blob', 'geometry', 'geometrya'); 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); 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, imprintsize(\"type\", \"count\") as imprintsize, cast(8 * \"count\" as bigint) as orderidxsize, sorted, revsorted, \"unique\" 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(imprintsize(\"type\", \"count\")) as imprintsize, sum(cast(8 * \"count\" as bigint)) as orderidxsize, sum(cast(case when sorted = false then 8 * \"count\" else 0 end as bigint)) as auxiliary 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
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", "revsorted", "boolean", 1, 0, NULL, true, 11, NULL ] 2007 ! 1979 [ "storagemodel", "unique", "boolean", 1, 0, NULL, true, 11, NULL ] 1979
2008 [ "storagemodel", "unique", "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, NULL, 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
..................
#select t.name, c.name, c.type, c.type_d
2020 [ "storagemodelinput", "unique", "boolean", 1, 0, NULL, true, 11, NULL ] 2020 1992 [ "storagemodelinput", "unique", "boolean", 1, 0, NULL, true, 11, NULL ] 1992
2021 [ "storagemodelinput", "orderidxsize", "bigint", 64, 0, NULL, false, 12, NULL ] 2021 ! 1993 [ "storagemodelinput", "orderidx", "bigint", 64, 0, NULL, true, 12, NULL ] 1993
2022 [ "systemfunctions", "function_id", "int", 32, 0, NULL, true, 0, NULL ] 2022 1994 [ "systemfunctions", "function_id", "int", 32, 0, NULL, true, 0, NULL ] 1994
..................
#select t.name, c.name, c.type, c.type_d
2038 [ "tables", "temporary", "smallint", 16, 0, NULL, true, 8, NULL ] 2038 2010 [ "tables", "temporary", "smallint", 16, 0, NULL, true, 8, NULL ] 2010
2039 [ "tablestorage", "schema", "varchar", 1024, 0, NULL, true, 0, NULL ] 2039 ! 2011 [ "tablestoragemodel", "schema", "clob", 0, 0, NULL, true, 0, NULL ] 2011
2040 [ "tablestorage", "table", "varchar", 1024, 0, NULL, true, 1, NULL ] 2040 ! 2012 [ "tablestoragemodel", "table", "clob", 0, 0, NULL, true, 1, NULL ] 2012
2041 [ "tablestorage", "rowcount", "bigint", 64, 0, NULL, true, 2, NULL ] 2041 ! 2013 [ "tablestoragemodel", "count", "bigint", 64, 0, NULL, true, 2, NULL ] 2013
2042 [ "tablestorage", "storages", "bigint", 64, 0, NULL, true, 3, NULL ] 2042 ! 2014 [ "tablestoragemodel", "columnsize", "bigint", 64, 0, NULL, true, 3, NULL ] 2014
2043 [ "tablestorage", "columnsize", "bigint", 64, 0, NULL, true, 4, NULL ] 2043 ! 2015 [ "tablestoragemodel", "heapsize", "bigint", 64, 0, NULL, true, 4, NULL ] 2015
2044 [ "tablestorage", "heapsize", "bigint", 64, 0, NULL, true, 5, NULL ] 2044 ! 2016 [ "tablestoragemodel", "hashes", "bigint", 64, 0, NULL, true, 5, NULL ] 2016
2045 [ "tablestorage", "hashsize", "bigint", 64, 0, NULL, true, 6, NULL ] 2045 ! 2017 [ "tablestoragemodel", "imprints", "bigint", 64, 0, NULL, true, 6, NULL ] 2017
2046 [ "tablestorage", "imprintsize", "bigint", 64, 0, NULL, true, 7, NULL ] 2046 ! 2018 [ "tablestoragemodel", "auxiliary", "hugeint", 128, 0, NULL, true, 7, NULL ] 2018
2047 [ "tablestorage", "orderidxsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2047 -
2048 [ "tablestoragemodel", "schema", "varchar", 1024, 0, NULL, true, 0, NULL ] 2048 -
2049 [ "tablestoragemodel", "table", "varchar", 1024, 0, NULL, true, 1, NULL ] 2049 -
2050 [ "tablestoragemodel", "rowcount", "bigint", 64, 0, NULL, true, 2, NULL ] 2050 -
2051 [ "tablestoragemodel", "storages", "bigint", 64, 0, NULL, true, 3, NULL ] 2051 -
2052 [ "tablestoragemodel", "columnsize", "bigint", 64, 0, NULL, true, 4, NULL ] 2052 -
2053 [ "tablestoragemodel", "heapsize", "bigint", 64, 0, NULL, true, 5, NULL ] 2053 -
2054 [ "tablestoragemodel", "hashsize", "bigint", 64, 0, NULL, true, 6, NULL ] 2054 -
2055 [ "tablestoragemodel", "imprintsize", "bigint", 64, 0, NULL, true, 7, NULL ] 2055 -
2056 [ "tablestoragemodel", "orderidxsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2056 -
2057 [ "tablestoragemodel", "auxiliary", "bigint", 64, 0, NULL, true, 9, NULL ] 2057 -
2058 [ "tracelog", "event", "int", 32, 0, NULL, true, 0, NULL ] 2058 2019 [ "tracelog", "event", "int", 32, 0, NULL, true, 0, NULL ] 2019
..................
# .s, .f, .L4, .L6, .f,
2133 % 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 2133 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
2134 % 8, 24, 6, 1137, 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 2134 ! 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
2135 [ "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 ] 2135 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,
2298 [ "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 ] 2298 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
2299 [ "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 ] 2299 ! 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
2300 [ "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 ] 2300 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,
2371 [ "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 ] 2371 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
2372 [ "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 ] 2372 ! 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
2373 [ "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 ] 2373 ! 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
2374 [ "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 ] 2374 ! 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
2375 [ "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 ] 2375 ! 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
2376 [ "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 ] 2376 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
2377 [ "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 ] 2377 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
2378 [ "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 ] 2378 ! 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
2379 [ "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 ] 2379 ! 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
2380 [ "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 ] 2380 ! 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
2381 [ "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 ] 2381 ! 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
2382 [ "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 ] 2382 ! 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
2383 [ "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 ] 2383 ! 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
2384 [ "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 ] 2384 ! 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
2385 [ "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 ] 2385 ! 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
2386 [ "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 ] 2386 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,
2407 [ "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 ] 2407 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
2408 [ "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 ] 2408 ! 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
2409 [ "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 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 ] 2409 ! 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
2410 [ "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 ] 2410 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,
2420 [ "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 ] 2420 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
2421 [ "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 ] 2421 ! 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
2422 [ "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 ] 2422 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,
2491 [ "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 ] 2491 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
2492 [ "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 ] 2492 -
2493 [ "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 ] 2493 -
2494 [ "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 ] 2494 -
2495 [ "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 ] 2495 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,
3388 [ "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 ] 3388 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
3389 [ "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 ] 3389 -
3390 [ "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 ] 3390 -
3391 [ "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 ] 3391 -
3392 [ "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 ] 3392 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,
3853 [ "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 ] 3853 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
3854 [ "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" ] 3854 ! 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
3855 [ "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" ] 3855 ! 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
3856 [ "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" ] 3856 ! 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
3857 [ "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" ] 3857 ! 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\", 0, 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', 'geometry', 'geometrya') then cast((heapsize - 32) / \"count\" as bigint) else typewidth end, false, sorted, revsorted, \"unique\", orderidx from sys.\"storage\" order by \"schema\", \"table\", \"column\" + 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
3858 ; update sys.storagemodelinput set \"distinct\" = \"count\" where \"unique\" = true or \"type\" in ('varchar', 'char', 'clob', 'json', 'url', 'blob', 'geometry', 'geometrya'); 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); 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 ] 3858 ! 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
3859 [ "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 ] 3859 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
4038 % 3, 17, 3, 13, 8 # length 4038 3994 % 3, 17, 3, 13, 8 # length 3994
+ 3995 [ "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3995
4039 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4039 3996 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3996
..................
#select s1.name, f1.name, s2.name, f2.na
4043 [ "sys", "st_srid", "sys", "st_transform", "FUNCTION" ] 4043 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
4044 #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; 4044 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
4049 [ "sys", "spatial_ref_sys", "sys", "getproj4", "FUNCTION" ] 4049 4010 [ "sys", "spatial_ref_sys", "sys", "getproj4", "FUNCTION" ] 4010
+ 4011 [ "sys", "storagemodelinput", "sys", "storagemodel", "FUNCTION" ] 4011
4050 [ "sys", "keys", "sys", "storagemodelinit", "PROCEDURE" ] 4050 4012 [ "sys", "keys", "sys", "storagemodelinit", "PROCEDURE" ] 4012
..................
#select s1.name, t.name, s2.name, f.name
4052 [ "sys", "schemas", "sys", "storagemodelinit", "PROCEDURE" ] 4052 4014 [ "sys", "schemas", "sys", "storagemodelinit", "PROCEDURE" ] 4014
4053 [ "sys", "storage", "sys", "storagemodelinit", "PROCEDURE" ] 4053 -
4054 [ "sys", "storagemodelinput", "sys", "storagemodelinit", "PROCEDURE" ] 4054 4015 [ "sys", "storagemodelinput", "sys", "storagemodelinit", "PROCEDURE" ] 4015
..................
#select s1.name, t.name, c.name, s2.name
4060 % 3, 17, 13, 3, 16, 9 # length 4060 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
4061 [ "sys", "spatial_ref_sys", "auth_name", "sys", "getproj4", "FUNCTION" ] 4061 ! 4024 [ "sys", "storagemodelinput", "atomwidth", "sys", "storagemodel", "FUNCTION" ] 4024
4062 [ "sys", "spatial_ref_sys", "auth_srid", "sys", "getproj4", "FUNCTION" ] 4062 ! 4025 [ "sys", "storagemodelinput", "column", "sys", "storagemodel", "FUNCTION" ] 4025
4063 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 4063 -
4064 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 4064 -
4065 [ "sys", "spatial_ref_sys", "srtext", "sys", "getproj4", "FUNCTION" ] 4065 ! 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
4066 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 4066 4037 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 4037
..................
#select s1.name, t.name, c.name, s2.name
4083 [ "sys", "storagemodelinput", "distinct", "sys", "storagemodelinit", "PROCEDURE" ] 4083 4054 [ "sys", "storagemodelinput", "distinct", "sys", "storagemodelinit", "PROCEDURE" ] 4054
4084 [ "sys", "storagemodelinput", "orderidxsize", "sys", "storagemodelinit", "PROCEDURE" ] 4084 ! 4055 [ "sys", "storagemodelinput", "orderidx", "sys", "storagemodelinit", "PROCEDURE" ] 4055
4085 [ "sys", "storagemodelinput", "reference", "sys", "storagemodelinit", "PROCEDURE" ] 4085 4056 [ "sys", "storagemodelinput", "reference", "sys", "storagemodelinit", "PROCEDURE" ] 4056
..................
#select s1.name, f1.name, s2.name, t2.na
4096 % varchar, varchar, varchar, varchar, varchar # type 4096 4067 % varchar, varchar, varchar, varchar, varchar # type 4067
4097 % 3, 11, 3, 17, 4 # length 4097 ! 4068 % 3, 16, 3, 16, 4 # length 4068
4098 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 4098 4069 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 4069
..................
#select s1.name, f1.name, s2.name, t2.na
4100 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 4100 4071 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 4071
4101 [ "sys", "columnsize", "sys", "storagemodel", "VIEW" ] 4101 ! 4072 [ "sys", "optimizers", "sys", "optimizers", "VIEW" ] 4072
4102 [ "sys", "hashsize", "sys", "storagemodel", "VIEW" ] 4102 ! 4073 [ "sys", "querylog_catalog", "sys", "querylog_catalog", "VIEW" ] 4073
4103 [ "sys", "heapsize", "sys", "storagemodel", "VIEW" ] 4103 ! 4074 [ "sys", "queue", "sys", "queue", "VIEW" ] 4074
4104 [ "sys", "imprintsize", "sys", "storagemodel", "VIEW" ] 4104 ! 4075 [ "sys", "rejects", "sys", "rejects", "VIEW" ] 4075
4105 [ "sys", "columnsize", "sys", "tablestoragemodel", "VIEW" ] 4105 ! 4076 [ "sys", "sessions", "sys", "sessions", "VIEW" ] 4076
4106 [ "sys", "hashsize", "sys", "tablestoragemodel", "VIEW" ] 4106 ! 4077 [ "sys", "tracelog", "sys", "tracelog", "VIEW" ] 4077
4107 [ "sys", "heapsize", "sys", "tablestoragemodel", "VIEW" ] 4107 -
4108 [ "sys", "imprintsize", "sys", "tablestoragemodel", "VIEW" ] 4108 -
4109 #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; 4109 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
4112 % varchar, varchar, varchar, varchar, varchar # type 4112 4081 % varchar, varchar, varchar, varchar, varchar # type 4081
4113 % 3, 17, 3, 34, 4 # length 4113 ! 4082 % 3, 16, 3, 34, 4 # length 4082
4114 [ "sys", "dependencies", "sys", "dependencies_vw", "VIEW" ] 4114 4083 [ "sys", "dependencies", "sys", "dependencies_vw", "VIEW" ] 4083
..................
#select s1.name, t1.name, s2.name, t2.na
4124 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 4124 4093 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 4093
4125 [ "sys", "idxs", "sys", "dependency_columns_on_indexes", "VIEW" ] 4125 -
4126 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 4126 4094 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 4094
4127 [ "sys", "objects", "sys", "dependency_columns_on_indexes", "VIEW" ] 4127 -
4128 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 4128 4095 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 4095
4129 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 4129 4096 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 4096
4130 [ "sys", "keys", "sys", "dependency_columns_on_keys", "VIEW" ] 4130 -
4131 [ "sys", "objects", "sys", "dependency_columns_on_keys", "VIEW" ] 4131 -
4132 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 4132 4097 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 4097
..................
#select s1.name, t1.name, s2.name, t2.na
4138 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 4138 4103 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 4103
4139 [ "sys", "triggers", "sys", "dependency_columns_on_triggers", "VIEW" ] 4139 -
4140 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 4140 4104 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 4104
..................
#select s1.name, t1.name, s2.name, t2.na
4152 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 4152 4116 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 4116
4153 [ "sys", "triggers", "sys", "dependency_functions_on_triggers", "VIEW" ] 4153 -
4154 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 4154 4117 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 4117
..................
#select s1.name, t1.name, s2.name, t2.na
4159 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 4159 4122 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 4122
4160 [ "sys", "keys", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4160 -
4161 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 4161 4123 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 4123
..................
#select s1.name, t1.name, s2.name, t2.na
4164 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 4164 4126 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 4126
4165 [ "sys", "keys", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4165 -
4166 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4166 4127 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4127
..................
#select s1.name, t1.name, s2.name, t2.na
4169 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 4169 4130 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 4130
4170 [ "sys", "idxs", "sys", "dependency_tables_on_indexes", "VIEW" ] 4170 -
4171 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 4171 4131 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 4131
..................
#select s1.name, t1.name, s2.name, t2.na
4177 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4177 4137 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4137
4178 [ "sys", "triggers", "sys", "dependency_tables_on_triggers", "VIEW" ] 4178 -
4179 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4179 4138 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4138
..................
#select s1.name, t1.name, s2.name, t2.na
4192 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4192 4151 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4151
4193 [ "sys", "_columns", "sys", "ids", "VIEW" ] 4193 -
4194 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4194 4152 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4152
..................
#select s1.name, t1.name, s2.name, t2.na
4197 [ "sys", "functions", "sys", "ids", "VIEW" ] 4197 4155 [ "sys", "functions", "sys", "ids", "VIEW" ] 4155
4198 [ "sys", "idxs", "sys", "ids", "VIEW" ] 4198 -
4199 [ "sys", "keys", "sys", "ids", "VIEW" ] 4199 4156 [ "sys", "keys", "sys", "ids", "VIEW" ] 4156
..................
#select s1.name, t1.name, s2.name, t2.na
4201 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4201 4158 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4158
4202 [ "sys", "triggers", "sys", "ids", "VIEW" ] 4202 -
4203 [ "sys", "types", "sys", "ids", "VIEW" ] 4203 4159 [ "sys", "types", "sys", "ids", "VIEW" ] 4159
4204 [ "tmp", "_columns", "sys", "ids", "VIEW" ] 4204 -
4205 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4205 4160 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4160
4206 [ "tmp", "idxs", "sys", "ids", "VIEW" ] 4206 -
4207 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4207 4161 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4161
4208 [ "tmp", "triggers", "sys", "ids", "VIEW" ] 4208 -
4209 [ "sys", "auths", "sys", "roles", "VIEW" ] 4209 4162 [ "sys", "auths", "sys", "roles", "VIEW" ] 4162
4210 [ "sys", "storage", "sys", "schemastorage", "VIEW" ] 4210 -
4211 [ "sys", "schemas", "sys", "storage", "VIEW" ] 4211 -
4212 [ "sys", "tables", "sys", "storage", "VIEW" ] 4212 -
4213 [ "sys", "storagemodelinput", "sys", "storagemodel", "VIEW" ] 4213 -
4214 [ "sys", "functions", "sys", "systemfunctions", "VIEW" ] 4214 4163 [ "sys", "functions", "sys", "systemfunctions", "VIEW" ] 4163
4215 [ "sys", "storage", "sys", "tablestorage", "VIEW" ] 4215 -
4216 [ "sys", "storagemodelinput", "sys", "tablestoragemodel", "VIEW" ] 4216 -
4217 #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; 4217 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
4220 % varchar, varchar, varchar, varchar, varchar, varchar # type 4220 4167 % varchar, varchar, varchar, varchar, varchar, varchar # type 4167
4221 % 3, 17, 20, 3, 34, 4 # length 4221 ! 4168 % 3, 16, 20, 3, 34, 4 # length 4168
4222 [ "sys", "dependencies", "depend_id", "sys", "dependencies_vw", "VIEW" ] 4222 4169 [ "sys", "dependencies", "depend_id", "sys", "dependencies_vw", "VIEW" ] 4169
..................
#select s1.name, t1.name, c1.name, s2.na
4243 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4243 4190 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4190
4244 [ "sys", "idxs", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4244 ! 4191 [ "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4191
4245 [ "sys", "idxs", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4245 ! 4192 [ "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4192
4246 [ "sys", "idxs", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4246 ! 4193 [ "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4193
4247 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4247 ! 4194 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4194
4248 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4248 ! 4195 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4195
+ 4196 [ "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4196
4249 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4249 4197 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4197
4250 [ "sys", "objects", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4250 ! 4198 [ "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4198
4251 [ "sys", "objects", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4251 ! 4199 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4199
4252 [ "sys", "objects", "nr", "sys", "dependency_columns_on_indexes", "VIEW" ] 4252 ! 4200 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4200
4253 [ "sys", "keys", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4253 ! 4201 [ "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4201
4254 [ "sys", "keys", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4254 ! 4202 [ "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4202
4255 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4255 ! 4203 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4203
4256 [ "sys", "keys", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4256 ! 4204 [ "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4204
4257 [ "sys", "objects", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4257 ! 4205 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4205
4258 [ "sys", "objects", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4258 ! 4206 [ "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4206
4259 [ "sys", "objects", "nr", "sys", "dependency_columns_on_keys", "VIEW" ] 4259 ! 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
4260 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4260 4211 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4211
..................
#select s1.name, t1.name, c1.name, s2.na
4268 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4268 4219 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4219
4269 [ "sys", "triggers", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4269 ! 4220 [ "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4220
4270 [ "sys", "triggers", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4270 ! 4221 [ "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4221
+ 4222 [ "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4222
4271 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4271 4223 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4223
..................
#select s1.name, t1.name, c1.name, s2.na
4299 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4299 4251 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4251
4300 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4300 ! 4252 [ "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4252
4301 [ "sys", "triggers", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4301 ! 4253 [ "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4253
4302 [ "sys", "triggers", "table_id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4302 ! 4254 [ "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4254
+ 4255 [ "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4255
4303 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4303 4256 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4256
..................
#select s1.name, t1.name, c1.name, s2.na
4316 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4316 4269 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4269
4317 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4317 ! 4270 [ "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4270
4318 [ "sys", "keys", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4318 ! 4271 [ "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4271
4319 [ "sys", "keys", "rkey", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4319 ! 4272 [ "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4272
4320 [ "sys", "keys", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4320 ! 4273 [ "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4273
4321 [ "sys", "keys", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4321 ! 4274 [ "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4274
+ 4275 [ "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4275
4322 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4322 4276 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4276
..................
#select s1.name, t1.name, c1.name, s2.na
4328 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4328 4282 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4282
4329 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4329 ! 4283 [ "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4283
4330 [ "sys", "keys", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4330 ! 4284 [ "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4284
4331 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4331 ! 4285 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4285
4332 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4332 ! 4286 [ "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4286
4333 [ "sys", "keys", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4333 ! 4287 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4287
+ 4288 [ "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4288
4334 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4334 4289 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4289
..................
#select s1.name, t1.name, c1.name, s2.na
4339 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4339 4294 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4294
4340 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4340 ! 4295 [ "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4295
4341 [ "sys", "idxs", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4341 ! 4296 [ "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4296
4342 [ "sys", "idxs", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4342 ! 4297 [ "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4297
4343 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4343 ! 4298 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4298
4344 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4344 ! 4299 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4299
+ 4300 [ "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4300
4345 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4345 4301 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4301
..................
#select s1.name, t1.name, c1.name, s2.na
4354 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4354 4310 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4310
4355 [ "sys", "triggers", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4355 ! 4311 [ "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4311
4356 [ "sys", "triggers", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4356 ! 4312 [ "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4312
4357 [ "sys", "triggers", "table_id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4357 ! 4313 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4313
+ 4314 [ "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4314
4358 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4358 4315 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4315
..................
#select s1.name, t1.name, c1.name, s2.na
4379 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4379 4336 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4336
+ 4337 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4337
4380 [ "sys", "_columns", "id", "sys", "ids", "VIEW" ] 4380 ! 4338 [ "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4338
4381 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4381 ! 4339 [ "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4339
4382 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4382 4340 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4340
+ 4341 [ "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4341
4383 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4383 -
4384 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4384 -
4385 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4385 ! 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
4386 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4386 ! 4345 [ "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4345
4387 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4387 4346 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4346
..................
#select s1.name, t1.name, c1.name, s2.na
4395 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4395 4354 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4354
4396 [ "sys", "idxs", "id", "sys", "ids", "VIEW" ] 4396 ! 4355 [ "sys", "keys", "action", "sys", "ids", "VIEW" ] 4355
+ 4356 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4356
4397 [ "sys", "idxs", "name", "sys", "ids", "VIEW" ] 4397 ! 4357 [ "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4357
+ 4358 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4358
4398 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4398 ! 4359 [ "sys", "keys", "type", "sys", "ids", "VIEW" ] 4359
4399 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4399 ! 4360 [ "sys", "objects", "id", "sys", "ids", "VIEW" ] 4360
4400 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4400 -
4401 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4401 -
4402 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4402 4361 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4361
..................
#select s1.name, t1.name, c1.name, s2.na
4406 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4406 4365 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4365
4407 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4407 ! 4366 [ "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4366
4408 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4408 ! 4367 [ "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4367
4409 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4409 ! 4368 [ "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4368
+ 4369 [ "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4369
4410 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4410 4370 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4370
..................
#select s1.name, t1.name, c1.name, s2.na
4412 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4412 4372 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4372
+ 4373 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4373
4413 [ "tmp", "_columns", "id", "sys", "ids", "VIEW" ] 4413 ! 4374 [ "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4374
4414 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4414 -
4415 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4415 -
4416 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4416 -
4417 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4417 -
4418 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4418 ! 4375 [ "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4375
+ 4376 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4376
4419 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4419 ! 4377 [ "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4377
4420 [ "tmp", "idxs", "id", "sys", "ids", "VIEW" ] 4420 ! 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
4421 [ "tmp", "idxs", "name", "sys", "ids", "VIEW" ] 4421 ! 4381 [ "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4381
4422 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4422 ! 4382 [ "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4382
+ 4383 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4383
4423 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4423 ! 4384 [ "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4384
4424 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4424 -
4425 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4425 4385 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4385
4426 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4426 ! 4386 [ "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4386
4427 [ "tmp", "triggers", "name", "sys", "ids", "VIEW" ] 4427 -
4428 [ "tmp", "triggers", "table_id", "sys", "ids", "VIEW" ] 4428 -
4429 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4429 4387 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4387
..................
#select s1.name, t1.name, c1.name, s2.na
4431 [ "sys", "auths", "name", "sys", "roles", "VIEW" ] 4431 4389 [ "sys", "auths", "name", "sys", "roles", "VIEW" ] 4389
4432 [ "sys", "schemas", "id", "sys", "storage", "VIEW" ] 4432 -
4433 [ "sys", "schemas", "name", "sys", "storage", "VIEW" ] 4433 -
4434 [ "sys", "storagemodelinput", "atomwidth", "sys", "storagemodel", "VIEW" ] 4434 -
4435 [ "sys", "storagemodelinput", "column", "sys", "storagemodel", "VIEW" ] 4435 -
4436 [ "sys", "storagemodelinput", "count", "sys", "storagemodel", "VIEW" ] 4436 -
4437 [ "sys", "storagemodelinput", "distinct", "sys", "storagemodel", "VIEW" ] 4437 -
4438 [ "sys", "storagemodelinput", "reference", "sys", "storagemodel", "VIEW" ] 4438 -
4439 [ "sys", "storagemodelinput", "revsorted", "sys", "storagemodel", "VIEW" ] 4439 -
4440 [ "sys", "storagemodelinput", "schema", "sys", "storagemodel", "VIEW" ] 4440 -
4441 [ "sys", "storagemodelinput", "sorted", "sys", "storagemodel", "VIEW" ] 4441 -
4442 [ "sys", "storagemodelinput", "table", "sys", "storagemodel", "VIEW" ] 4442 -
4443 [ "sys", "storagemodelinput", "type", "sys", "storagemodel", "VIEW" ] 4443 -
4444 [ "sys", "storagemodelinput", "unique", "sys", "storagemodel", "VIEW" ] 4444 -
4445 [ "sys", "functions", "id", "sys", "systemfunctions", "VIEW" ] 4445 4390 [ "sys", "functions", "id", "sys", "systemfunctions", "VIEW" ] 4390
4446 [ "sys", "functions", "system", "sys", "systemfunctions", "VIEW" ] 4446 4391 [ "sys", "functions", "system", "sys", "systemfunctions", "VIEW" ] 4391
4447 [ "sys", "storagemodelinput", "atomwidth", "sys", "tablestoragemodel", "VIEW" ] 4447 -
4448 [ "sys", "storagemodelinput", "count", "sys", "tablestoragemodel", "VIEW" ] 4448 -
4449 [ "sys", "storagemodelinput", "distinct", "sys", "tablestoragemodel", "VIEW" ] 4449 -
4450 [ "sys", "storagemodelinput", "reference", "sys", "tablestoragemodel", "VIEW" ] 4450 -
4451 [ "sys", "storagemodelinput", "schema", "sys", "tablestoragemodel", "VIEW" ] 4451 -
4452 [ "sys", "storagemodelinput", "sorted", "sys", "tablestoragemodel", "VIEW" ] 4452 -
4453 [ "sys", "storagemodelinput", "table", "sys", "tablestoragemodel", "VIEW" ] 4453 -
4454 [ "sys", "storagemodelinput", "type", "sys", "tablestoragemodel", "VIEW" ] 4454 -
4455 #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; 4455 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
4791 [ "degrees", "public", "EXECUTE", "monetdb", 0 ] 4791 4728 [ "degrees", "public", "EXECUTE", "monetdb", 0 ] 4728
4792 [ "env", "public", "EXECUTE", NULL, 0 ] 4792 -
4793 [ "epoch", "public", "EXECUTE", "monetdb", 0 ] 4793 4729 [ "epoch", "public", "EXECUTE", "monetdb", 0 ] 4729
..................
# .t, .g, .L4, .L6, .L10,
5084 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5084 5020 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5020
5085 [ "_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();" ] 5085 ! 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
5086 [ "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();" ] 5086 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
5342 [ "WHILE" ] 5342 5278 [ "WHILE" ] 5278
5343 [ "WINDOW" ] 5343 -
5344 [ "WITH" ] 5344 5279 [ "WITH" ] 5279