Test check.SQL.py (id 001aedfec00f) (err)
check.stable.out.int128.FILTERED 2018-12-06 01:27:41.204339886 +0100check.test.out.FILTERED 2018-12-06 01:27:41.305338886 +0100
1 Statistics about stdout of test 'check` in directory 'sql/test/emptydb-upgrade-chain-hge`: 1 1 Statistics about stdout of test 'check` in directory 'sql/test/emptydb-upgrade-chain-hge`: 1
2 5315 lines, 210038 words, 1369633 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5130 lines, 198782 words, 1297258 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5315 lines, 210038 words, 1369633 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5130 lines, 198782 words, 1297258 chars in lines not matching '^$|^(\| |)#` 3
4 # 5396 lines, 212477 words, 1386791 chars in all lines 4 ! 4 # 5211 lines, 201219 words, 1314473 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 >
469 SYSTEM AGGREGATE sys.avg 469 461 SYSTEM AGGREGATE sys.avg 461
470 SYSTEM FUNCTION sys.avg 470 -
471 SYSTEM FUNCTION sys.bbp 471 462 SYSTEM FUNCTION sys.bbp 462
..................
# 10:17:18 >
492 SYSTEM AGGREGATE sys.count 492 483 SYSTEM AGGREGATE sys.count 483
493 SYSTEM FUNCTION sys.count 493 -
494 SYSTEM AGGREGATE sys.count_no_nil 494 484 SYSTEM AGGREGATE sys.count_no_nil 484
495 SYSTEM PROCEDURE sys.createorderindex 495 485 SYSTEM PROCEDURE sys.createorderindex 485
496 SYSTEM FUNCTION sys.cume_dist 496 -
497 SYSTEM FUNCTION sys.curdate 497 486 SYSTEM FUNCTION sys.curdate 486
..................
# 10:17:18 >
520 SYSTEM FUNCTION sys.exp 520 509 SYSTEM FUNCTION sys.exp 509
521 SYSTEM FUNCTION sys.first_value 521 -
522 SYSTEM PROCEDURE sys.fitsattach 522 510 SYSTEM PROCEDURE sys.fitsattach 510
..................
# 10:17:18 >
564 SYSTEM FUNCTION sys.isnull 564 552 SYSTEM FUNCTION sys.isnull 552
565 SYSTEM FUNCTION sys.lag 565 -
566 SYSTEM FUNCTION sys.last_value 566 -
567 SYSTEM FUNCTION sys.lcase 567 553 SYSTEM FUNCTION sys.lcase 553
568 SYSTEM FUNCTION sys.lead 568 -
569 SYSTEM FUNCTION sys.left 569 554 SYSTEM FUNCTION sys.left 554
..................
# 10:17:18 >
573 SYSTEM FUNCTION sys.levenshtein 573 558 SYSTEM FUNCTION sys.levenshtein 558
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 559 SYSTEM FILTER FUNCTION sys.like 559
..................
# 10:17:18 >
595 SYSTEM AGGREGATE sys.max 595 577 SYSTEM AGGREGATE sys.max 577
596 SYSTEM FUNCTION sys.max 596 -
597 SYSTEM FUNCTION sys.mbr 597 578 SYSTEM FUNCTION sys.mbr 578
..................
# 10:17:18 >
613 SYSTEM AGGREGATE sys.min 613 594 SYSTEM AGGREGATE sys.min 594
614 SYSTEM FUNCTION sys.min 614 -
615 SYSTEM FUNCTION sys.minute 615 595 SYSTEM FUNCTION sys.minute 595
..................
# 10:17:18 >
633 SYSTEM FUNCTION sys.not_uniques 633 613 SYSTEM FUNCTION sys.not_uniques 613
634 SYSTEM FUNCTION sys.nth_value 634 -
635 SYSTEM FUNCTION sys.ntile 635 -
636 SYSTEM FUNCTION sys.octet_length 636 614 SYSTEM FUNCTION sys.octet_length 614
..................
# 10:17:18 >
642 SYSTEM PROCEDURE sys.pause 642 620 SYSTEM PROCEDURE sys.pause 620
643 SYSTEM FUNCTION sys.percent_rank 643 -
644 SYSTEM FUNCTION sys.pi 644 621 SYSTEM FUNCTION sys.pi 621
..................
# 10:17:18 >
646 SYSTEM AGGREGATE sys.prod 646 623 SYSTEM AGGREGATE sys.prod 623
647 SYSTEM FUNCTION sys.prod 647 -
648 SYSTEM FUNCTION sys.qgramnormalize 648 624 SYSTEM FUNCTION sys.qgramnormalize 624
..................
# 10:17:18 >
689 SYSTEM PROCEDURE sys.settimeout 689 665 SYSTEM PROCEDURE sys.settimeout 665
690 SYSTEM PROCEDURE sys.shpattach 690 -
691 SYSTEM PROCEDURE sys.shpload 691 -
692 SYSTEM PROCEDURE sys.shrink 692 666 SYSTEM PROCEDURE sys.shrink 666
..................
# 10:17:18 >
811 SYSTEM FUNCTION sys.storage 811 785 SYSTEM FUNCTION sys.storage 785
+ 786 SYSTEM FUNCTION sys.storagemodel 786
812 SYSTEM PROCEDURE sys.storagemodelinit 812 787 SYSTEM PROCEDURE sys.storagemodelinit 787
..................
# 10:17:18 >
819 SYSTEM AGGREGATE sys.sum 819 794 SYSTEM AGGREGATE sys.sum 794
820 SYSTEM FUNCTION sys.sum 820 -
821 SYSTEM PROCEDURE sys.sys_update_schemas 821 795 SYSTEM PROCEDURE sys.sys_update_schemas 795
..................
# 10:17:18 >
840 SYSTEM FUNCTION sys.weekofyear 840 814 SYSTEM FUNCTION sys.weekofyear 814
841 SYSTEM FUNCTION sys.window_bound 841 -
842 SYSTEM FUNCTION sys.xor 842 815 SYSTEM FUNCTION sys.xor 815
..................
# 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 856 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); 856
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 ! 857 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); 857
885 CREATE TABLE "sys"."table_partitions" ("id" INTEGER, "table_id" INTEGER, "column_id" INTEGER, "expression" VARCHAR(2048), "type" TINYINT); 885 858 CREATE TABLE "sys"."table_partitions" ("id" INTEGER, "table_id" INTEGER, "column_id" INTEGER, "expression" VARCHAR(2048), "type" TINYINT); 858
..................
# 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 906 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); 906
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 907 create view sys.sessions as select * from sys.sessions(); 907
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 - 908 create view sys."storage" as select * from sys."storage"(); 908
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 ! 909 create view sys.storagemodel as select * from sys.storagemodel(); 909
938 create view sys.systemfunctions as select id as function_id from sys.functions where system; 938 910 create view sys.systemfunctions as select id as function_id from sys.functions where system; 910
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 911 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"; 911
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 ! 912 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"; 912
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 913 create view sys.tracelog as select * from sys.tracelog(); 913
..................
# 10:17:18 >
953 create procedure sys.clearrejects() external name sql.copy_rejects_clear; 953 924 create procedure sys.clearrejects() external name sql.copy_rejects_clear; 924
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 ! 925 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; 925
955 create function contains(a geometry, x double, y double) returns boolean external name geom."Contains"; 955 926 create function contains(a geometry, x double, y double) returns boolean external name geom."Contains"; 926
..................
# 10:17:18 >
978 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 978 949 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 949
979 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 979 -
980 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 980 -
981 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 981 950 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 950
982 create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; 982 ! 951 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 951
983 create function sys.generate_series(first bigint, "limit" bigint, stepsize bigint) returns table (value bigint) external name generator.series; 983 ! 952 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 952
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 ! 953 create function sys.generate_series(first hugeint, last hugeint) returns table (value hugeint) external name generator.series; 953
985 create function sys.generate_series(first double, "limit" double, stepsize double) returns table (value double) external name generator.series; 985 ! 954 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 954
986 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 986 ! 955 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 955
987 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 987 ! 956 create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series; 956
988 create function sys.generate_series(first int, "limit" int) returns table (value int) external name generator.series; 988 ! 957 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; 957
989 create function sys.generate_series(first int, "limit" int, stepsize int) returns table (value int) external name generator.series; 989 ! 958 create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series; 958
990 create function sys.generate_series(first real, "limit" real, stepsize real) returns table (value real) external name generator.series; 990 ! 959 create function sys.generate_series(first hugeint, last hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 959
991 create function sys.generate_series(first smallint, "limit" smallint) returns table (value smallint) external name generator.series; 991 ! 960 create function sys.generate_series(first int, last int) returns table (value int) external name generator.series; 960
992 create function sys.generate_series(first smallint, "limit" smallint, stepsize smallint) returns table (value smallint) external name generator.series; 992 ! 961 create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series; 961
993 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 993 ! 962 create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series; 962
994 create function sys.generate_series(first tinyint, "limit" tinyint) returns table (value tinyint) external name generator.series; 994 ! 963 create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series; 963
995 create function sys.generate_series(first tinyint, "limit" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 995 ! 964 create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series; 964
+ 965 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 965
+ 966 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 966
996 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 996 967 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 967
..................
# 10:17:18 >
1015 create function has_z(info integer) returns integer external name geom."hasZ"; 1015 986 create function has_z(info integer) returns integer external name geom."hasZ"; 986
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 ! 987 create function sys.hashsize(b boolean, i bigint) returns bigint begin if b = true then return 8 * i; end if; return 0; end; 987
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 ! 988 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; 988
1018 create function "host" (p inet) returns clob external name inet."host"; 1018 989 create function "host" (p inet) returns clob external name inet."host"; 989
..................
# 10:17:18 >
1021 create filter function "ilike"(val string, pat string, esc string) external name algebra."ilike"; 1021 992 create filter function "ilike"(val string, pat string, esc string) external name algebra."ilike"; 992
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 ! 993 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; 993
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 994 create function internaltransform(geom geometry, srid_src integer, srid_dest integer, proj4_src string, proj4_dest string) returns geometry external name geom."Transform"; 994
..................
# 10:17:18 >
1027 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1027 998 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 998
1028 create procedure lidarattach(fname string) external name lidar.attach; 1028 ! 999 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 999
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 1000 create filter function "like"(val string, pat string) external name algebra."like"; 1000
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 1001 create procedure listdir(dirname string) external name fits.listdir; 1001
..................
# 10:17:18 >
1067 create function sys.password_hash (username string) returns string external name sql.password; 1067 1035 create function sys.password_hash (username string) returns string external name sql.password; 1035
+ 1036 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1036
1068 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1068 1037 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1037
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 1038 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1038
..................
# 10:17:18 >
1114 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1114 1082 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1082
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 1083 create procedure shrink(sys string, tab string) external name sql.shrink; 1083
..................
# 10:17:18 >
1247 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1247 1212 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1212
+ 1213 create aggregate stddev_samp(val hugeint) returns double external name "aggr"."stdev"; 1213
+ 1214 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1214
1248 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1248 1215 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1215
..................
# 10:17:18 >
1250 create aggregate stddev_samp(val double) returns double external name "aggr"."stdev"; 1250 1217 create aggregate stddev_samp(val double) returns double external name "aggr"."stdev"; 1217
1251 create aggregate stddev_samp(val hugeint) returns double external name "aggr"."stdev"; 1251 -
1252 create aggregate stddev_samp(val integer) returns double external name "aggr"."stdev"; 1252 1218 create aggregate stddev_samp(val integer) returns double external name "aggr"."stdev"; 1218
..................
# 10:17:18 >
1256 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1256 1222 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1222
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 1223 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1223
..................
# 10:17:18 >
1260 create procedure stopmaster() external name wlc.stopmaster; 1260 1225 create procedure stopmaster() external name wlc.stopmaster; 1225
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 ! 1226 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"; 1226
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 ! 1227 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"; 1227
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 ! 1228 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"; 1228
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 ! 1229 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"; 1229
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 + 1230 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; 1230
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 ! 1231 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; 1231
1266 create function str_to_date(s string, format string) returns date external name mtime."str_to_date"; 1266 1232 create function str_to_date(s string, format string) returns date external name mtime."str_to_date"; 1232
..................
# .s, .t, .L10, .L12, .t,
1454 [ "sys", "schemas", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1454 1420 [ "sys", "schemas", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1420
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 1421 [ "sys", "sequences", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1421
..................
# .s, .t, .L10, .L12, .t,
1459 [ "sys", "statistics", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1459 1424 [ "sys", "statistics", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1424
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 ! 1425 [ "sys", "storage", "create view sys.\"storage\" as select * from sys.\"storage\"();", "VIEW", true, "COMMIT", "WRITABLE" ] 1425
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 ! 1426 [ "sys", "storagemodel", "create view sys.storagemodel as select * from sys.storagemodel();", "VIEW", true, "COMMIT", "WRITABLE" ] 1426
1462 [ "sys", "storagemodelinput", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1462 1427 [ "sys", "storagemodelinput", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1427
..................
# .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 1431 [ "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" ] 1431
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 ! 1432 [ "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" ] 1432
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 1433 [ "sys", "tracelog", "create view sys.tracelog as select * from sys.tracelog();", "VIEW", true, "COMMIT", "WRITABLE" ] 1433
..................
#select t.name, c.name, c.type, c.type_d
1932 [ "schemas", "system", "boolean", 1, 0, NULL, true, 4, NULL ] 1932 1896 [ "schemas", "system", "boolean", 1, 0, NULL, true, 4, NULL ] 1896
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 1897 [ "sequences", "id", "int", 32, 0, NULL, true, 0, NULL ] 1897
..................
#select t.name, c.name, c.type, c.type_d
1978 [ "statistics", "revsorted", "boolean", 1, 0, NULL, true, 11, NULL ] 1978 1935 [ "statistics", "revsorted", "boolean", 1, 0, NULL, true, 11, NULL ] 1935
1979 [ "storage", "schema", "varchar", 1024, 0, NULL, true, 0, NULL ] 1979 ! 1936 [ "storage", "schema", "clob", 0, 0, NULL, true, 0, NULL ] 1936
1980 [ "storage", "table", "varchar", 1024, 0, NULL, true, 1, NULL ] 1980 ! 1937 [ "storage", "table", "clob", 0, 0, NULL, true, 1, NULL ] 1937
1981 [ "storage", "column", "varchar", 1024, 0, NULL, true, 2, NULL ] 1981 ! 1938 [ "storage", "column", "clob", 0, 0, NULL, true, 2, NULL ] 1938
1982 [ "storage", "type", "varchar", 1024, 0, NULL, true, 3, NULL ] 1982 ! 1939 [ "storage", "type", "clob", 0, 0, NULL, true, 3, NULL ] 1939
1983 [ "storage", "mode", "varchar", 15, 0, NULL, true, 4, NULL ] 1983 ! 1940 [ "storage", "mode", "clob", 0, 0, NULL, true, 4, NULL ] 1940
1984 [ "storage", "location", "varchar", 1024, 0, NULL, true, 5, NULL ] 1984 ! 1941 [ "storage", "location", "clob", 0, 0, NULL, true, 5, NULL ] 1941
1985 [ "storage", "count", "bigint", 64, 0, NULL, true, 6, NULL ] 1985 1942 [ "storage", "count", "bigint", 64, 0, NULL, true, 6, NULL ] 1942
..................
#select t.name, c.name, c.type, c.type_d
1995 [ "storage", "orderidx", "bigint", 64, 0, NULL, true, 16, NULL ] 1995 1952 [ "storage", "orderidx", "bigint", 64, 0, NULL, true, 16, NULL ] 1952
1996 [ "storagemodel", "schema", "varchar", 1024, 0, NULL, true, 0, NULL ] 1996 ! 1953 [ "storagemodel", "schema", "clob", 0, 0, NULL, true, 0, NULL ] 1953
1997 [ "storagemodel", "table", "varchar", 1024, 0, NULL, true, 1, NULL ] 1997 ! 1954 [ "storagemodel", "table", "clob", 0, 0, NULL, true, 1, NULL ] 1954
1998 [ "storagemodel", "column", "varchar", 1024, 0, NULL, true, 2, NULL ] 1998 ! 1955 [ "storagemodel", "column", "clob", 0, 0, NULL, true, 2, NULL ] 1955
1999 [ "storagemodel", "type", "varchar", 1024, 0, NULL, true, 3, NULL ] 1999 ! 1956 [ "storagemodel", "type", "clob", 0, 0, NULL, true, 3, NULL ] 1956
2000 [ "storagemodel", "count", "bigint", 64, 0, NULL, true, 4, NULL ] 2000 1957 [ "storagemodel", "count", "bigint", 64, 0, NULL, true, 4, NULL ] 1957
..................
#select t.name, c.name, c.type, c.type_d
2002 [ "storagemodel", "heapsize", "bigint", 64, 0, NULL, true, 6, NULL ] 2002 1959 [ "storagemodel", "heapsize", "bigint", 64, 0, NULL, true, 6, NULL ] 1959
2003 [ "storagemodel", "hashsize", "bigint", 64, 0, NULL, true, 7, NULL ] 2003 ! 1960 [ "storagemodel", "hashes", "bigint", 64, 0, NULL, true, 7, NULL ] 1960
2004 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2004 ! 1961 [ "storagemodel", "imprints", "bigint", 64, 0, NULL, true, 8, NULL ] 1961
2005 [ "storagemodel", "orderidxsize", "bigint", 64, 0, NULL, true, 9, NULL ] 2005 ! 1962 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 9, NULL ] 1962
2006 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2006 ! 1963 [ "storagemodel", "revsorted", "boolean", 1, 0, NULL, true, 10, NULL ] 1963
2007 [ "storagemodel", "revsorted", "boolean", 1, 0, NULL, true, 11, NULL ] 2007 ! 1964 [ "storagemodel", "unique", "boolean", 1, 0, NULL, true, 11, NULL ] 1964
2008 [ "storagemodel", "unique", "boolean", 1, 0, NULL, true, 12, NULL ] 2008 ! 1965 [ "storagemodel", "orderidx", "bigint", 64, 0, NULL, true, 12, NULL ] 1965
2009 [ "storagemodelinput", "schema", "varchar", 1024, 0, NULL, false, 0, NULL ] 2009 ! 1966 [ "storagemodelinput", "schema", "clob", 0, 0, NULL, true, 0, NULL ] 1966
2010 [ "storagemodelinput", "table", "varchar", 1024, 0, NULL, false, 1, NULL ] 2010 ! 1967 [ "storagemodelinput", "table", "clob", 0, 0, NULL, true, 1, NULL ] 1967
2011 [ "storagemodelinput", "column", "varchar", 1024, 0, NULL, false, 2, NULL ] 2011 ! 1968 [ "storagemodelinput", "column", "clob", 0, 0, NULL, true, 2, NULL ] 1968
2012 [ "storagemodelinput", "type", "varchar", 1024, 0, NULL, false, 3, NULL ] 2012 ! 1969 [ "storagemodelinput", "type", "clob", 0, 0, NULL, true, 3, NULL ] 1969
2013 [ "storagemodelinput", "typewidth", "int", 32, 0, NULL, false, 4, NULL ] 2013 ! 1970 [ "storagemodelinput", "typewidth", "int", 32, 0, NULL, true, 4, NULL ] 1970
2014 [ "storagemodelinput", "count", "bigint", 64, 0, NULL, false, 5, NULL ] 2014 ! 1971 [ "storagemodelinput", "count", "bigint", 64, 0, NULL, true, 5, NULL ] 1971
2015 [ "storagemodelinput", "distinct", "bigint", 64, 0, NULL, false, 6, NULL ] 2015 ! 1972 [ "storagemodelinput", "distinct", "bigint", 64, 0, NULL, true, 6, NULL ] 1972
2016 [ "storagemodelinput", "atomwidth", "int", 32, 0, NULL, false, 7, NULL ] 2016 ! 1973 [ "storagemodelinput", "atomwidth", "int", 32, 0, NULL, true, 7, NULL ] 1973
2017 [ "storagemodelinput", "reference", "boolean", 1, 0, NULL, false, 8, NULL ] 2017 ! 1974 [ "storagemodelinput", "reference", "boolean", 1, 0, NULL, true, 8, NULL ] 1974
2018 [ "storagemodelinput", "sorted", "boolean", 1, 0, NULL, true, 9, NULL ] 2018 1975 [ "storagemodelinput", "sorted", "boolean", 1, 0, NULL, true, 9, NULL ] 1975
..................
#select t.name, c.name, c.type, c.type_d
2020 [ "storagemodelinput", "unique", "boolean", 1, 0, NULL, true, 11, NULL ] 2020 1977 [ "storagemodelinput", "unique", "boolean", 1, 0, NULL, true, 11, NULL ] 1977
2021 [ "storagemodelinput", "orderidxsize", "bigint", 64, 0, NULL, false, 12, NULL ] 2021 ! 1978 [ "storagemodelinput", "orderidx", "bigint", 64, 0, NULL, true, 12, NULL ] 1978
2022 [ "systemfunctions", "function_id", "int", 32, 0, NULL, true, 0, NULL ] 2022 1979 [ "systemfunctions", "function_id", "int", 32, 0, NULL, true, 0, NULL ] 1979
..................
#select t.name, c.name, c.type, c.type_d
2038 [ "tables", "temporary", "smallint", 16, 0, NULL, true, 8, NULL ] 2038 1995 [ "tables", "temporary", "smallint", 16, 0, NULL, true, 8, NULL ] 1995
2039 [ "tablestorage", "schema", "varchar", 1024, 0, NULL, true, 0, NULL ] 2039 ! 1996 [ "tablestoragemodel", "schema", "clob", 0, 0, NULL, true, 0, NULL ] 1996
2040 [ "tablestorage", "table", "varchar", 1024, 0, NULL, true, 1, NULL ] 2040 ! 1997 [ "tablestoragemodel", "table", "clob", 0, 0, NULL, true, 1, NULL ] 1997
2041 [ "tablestorage", "rowcount", "bigint", 64, 0, NULL, true, 2, NULL ] 2041 ! 1998 [ "tablestoragemodel", "count", "bigint", 64, 0, NULL, true, 2, NULL ] 1998
2042 [ "tablestorage", "storages", "bigint", 64, 0, NULL, true, 3, NULL ] 2042 ! 1999 [ "tablestoragemodel", "columnsize", "bigint", 64, 0, NULL, true, 3, NULL ] 1999
2043 [ "tablestorage", "columnsize", "bigint", 64, 0, NULL, true, 4, NULL ] 2043 ! 2000 [ "tablestoragemodel", "heapsize", "bigint", 64, 0, NULL, true, 4, NULL ] 2000
2044 [ "tablestorage", "heapsize", "bigint", 64, 0, NULL, true, 5, NULL ] 2044 ! 2001 [ "tablestoragemodel", "hashes", "bigint", 64, 0, NULL, true, 5, NULL ] 2001
2045 [ "tablestorage", "hashsize", "bigint", 64, 0, NULL, true, 6, NULL ] 2045 ! 2002 [ "tablestoragemodel", "imprints", "bigint", 64, 0, NULL, true, 6, NULL ] 2002
2046 [ "tablestorage", "imprintsize", "bigint", 64, 0, NULL, true, 7, NULL ] 2046 ! 2003 [ "tablestoragemodel", "auxiliary", "hugeint", 128, 0, NULL, true, 7, NULL ] 2003
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 2004 [ "tracelog", "event", "int", 32, 0, NULL, true, 0, NULL ] 2004
..................
# .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 2079 % 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 2079
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 ! 2080 % 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, 7, 2, 1, 3, 8, 7, 2, 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 2080
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 2081 [ "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 ] 2081
..................
# .s, .f, .L4, .L6, .f,
2220 [ "sys", "avg", "SYSTEM", "avg", "aggr", "Internal C", "Aggregate function", false, false, false, "res", "double", 53, 0, "out", "arg", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2220 2166 [ "sys", "avg", "SYSTEM", "avg", "aggr", "Internal C", "Aggregate function", false, false, false, "res", "double", 53, 0, "out", "arg", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2166
2221 [ "sys", "avg", "SYSTEM", "avg", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "double", 53, 0, "out", "arg_1", "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 ] 2221 -
2222 [ "sys", "avg", "SYSTEM", "avg", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "double", 53, 0, "out", "arg_1", "decimal", 2, 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 ] 2222 -
2223 [ "sys", "avg", "SYSTEM", "avg", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "double", 53, 0, "out", "arg_1", "decimal", 4, 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 ] 2223 -
2224 [ "sys", "avg", "SYSTEM", "avg", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "double", 53, 0, "out", "arg_1", "decimal", 9, 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 ] 2224 -
2225 [ "sys", "avg", "SYSTEM", "avg", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "double", 53, 0, "out", "arg_1", "decimal", 18, 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 ] 2225 -
2226 [ "sys", "avg", "SYSTEM", "avg", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "double", 53, 0, "out", "arg_1", "decimal", 38, 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 ] 2226 -
2227 [ "sys", "avg", "SYSTEM", "avg", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "double", 53, 0, "out", "arg_1", "double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2227 -
2228 [ "sys", "avg", "SYSTEM", "avg", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "double", 53, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL ] 2228 -
2229 [ "sys", "avg", "SYSTEM", "avg", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "double", 53, 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 ] 2229 -
2230 [ "sys", "avg", "SYSTEM", "avg", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "double", 53, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2230 -
2231 [ "sys", "avg", "SYSTEM", "avg", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "double", 53, 0, "out", "arg_1", "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 ] 2231 -
2232 [ "sys", "avg", "SYSTEM", "avg", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "double", 53, 0, "out", "arg_1", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2232 -
2233 [ "sys", "bbp", "SYSTEM", "create function sys.bbp () returns table (id int, name string, ttype string, count bigint, refcnt int, lrefcnt int, location string, heat int, dirty string, status string, kind string) external name bbp.get;", "bbp", "MAL", "Function returning a table", false, false, false, "id", "int", 32, 0, "out", "name", "clob", 0, 0, "out", "ttype", "clob", 0, 0, "out", "count", "bigint", 64, 0, "out", "refcnt", "int", 32, 0, "out", "lrefcnt", "int", 32, 0, "out", "location", "clob", 0, 0, "out", "heat", "int", 32, 0, "out", "dirty", "clob", 0, 0, "out", "status", "clob", 0, 0, "out", "kind", "clob", 0, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2233 2167 [ "sys", "bbp", "SYSTEM", "create function sys.bbp () returns table (id int, name string, ttype string, count bigint, refcnt int, lrefcnt int, location string, heat int, dirty string, status string, kind string) external name bbp.get;", "bbp", "MAL", "Function returning a table", false, false, false, "id", "int", 32, 0, "out", "name", "clob", 0, 0, "out", "ttype", "clob", 0, 0, "out", "count", "bigint", 64, 0, "out", "refcnt", "int", 32, 0, "out", "lrefcnt", "int", 32, 0, "out", "location", "clob", 0, 0, "out", "heat", "int", 32, 0, "out", "dirty", "clob", 0, 0, "out", "status", "clob", 0, 0, "out", "kind", "clob", 0, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2167
..................
# .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 2232 [ "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 ] 2232
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 ! 2233 [ "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 ] 2233
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 2234 [ "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 ] 2234
..................
# .s, .f, .L4, .L6, .f,
2303 [ "sys", "contains", "SYSTEM", "create function contains(a geometry, x double, y double) returns boolean external name geom.\"Contains\";", "geom", "MAL", "Scalar function", false, false, false, "result", "boolean", 1, 0, "out", "a", "geometry", 0, 0, "in", "x", "double", 53, 0, "in", "y", "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 ] 2303 2237 [ "sys", "contains", "SYSTEM", "create function contains(a geometry, x double, y double) returns boolean external name geom.\"Contains\";", "geom", "MAL", "Scalar function", false, false, false, "result", "boolean", 1, 0, "out", "a", "geometry", 0, 0, "in", "x", "double", 53, 0, "in", "y", "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 ] 2237
2304 [ "sys", "copyfrom", "SYSTEM", "copy_from", "sql", "Internal C", "Function returning a table", false, true, false, "res_0", "table", 0, 0, "out", "arg_1", "varchar", 0, 0, "in", "arg_2", "varchar", 0, 0, "in", "arg_3", "varchar", 0, 0, "in", "arg_4", "varchar", 0, 0, "in", "arg_5", "varchar", 0, 0, "in", "arg_6", "varchar", 0, 0, "in", "arg_7", "bigint", 64, 0, "in", "arg_8", "bigint", 64, 0, "in", "arg_9", "int", 32, 0, "in", "arg_10", "int", 32, 0, "in", "arg_11", "varchar", 0, 0, "in", "arg_12", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2304 ! 2238 [ "sys", "copyfrom", "SYSTEM", "copy_from", "sql", "Internal C", "Function returning a table", false, true, false, "res_0", "table", 0, 0, "out", "arg_1", "varchar", 0, 0, "in", "arg_2", "varchar", 0, 0, "in", "arg_3", "varchar", 0, 0, "in", "arg_4", "varchar", 0, 0, "in", "arg_5", "varchar", 0, 0, "in", "arg_6", "varchar", 0, 0, "in", "arg_7", "bigint", 64, 0, "in", "arg_8", "bigint", 64, 0, "in", "arg_9", "int", 32, 0, "in", "arg_10", "int", 32, 0, "in", "arg_11", "varchar", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2238
2305 [ "sys", "copyfrom", "SYSTEM", "importTable", "sql", "Internal C", "Function returning a table", false, true, false, "res_0", "table", 0, 0, "out", "arg_1", "varchar", 0, 0, "in", "arg_2", "varchar", 0, 0, "in", "arg_3", "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 ] 2305 ! 2239 [ "sys", "copyfrom", "SYSTEM", "importTable", "sql", "Internal C", "Function returning a table", false, true, false, "res_0", "table", 0, 0, "out", "arg_1", "varchar", 0, 0, "in", "arg_2", "varchar", 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 ] 2239
2306 [ "sys", "corr", "SYSTEM", "create aggregate corr(e1 bigint, e2 bigint) returns double external name \"aggr\".\"corr\";", "aggr", "MAL", "Aggregate function", false, false, false, "result", "double", 53, 0, "out", "e1", "bigint", 64, 0, "in", "e2", "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 ] 2306 2240 [ "sys", "corr", "SYSTEM", "create aggregate corr(e1 bigint, e2 bigint) returns double external name \"aggr\".\"corr\";", "aggr", "MAL", "Aggregate function", false, false, false, "result", "double", 53, 0, "out", "e1", "bigint", 64, 0, "in", "e2", "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 ] 2240
..................
# .s, .f, .L4, .L6, .f,
2319 [ "sys", "count", "SYSTEM", "count", "aggr", "Internal C", "Aggregate function", false, false, false, "res", "bigint", 64, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2319 2253 [ "sys", "count", "SYSTEM", "count", "aggr", "Internal C", "Aggregate function", false, false, false, "res", "bigint", 64, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2253
2320 [ "sys", "count", "SYSTEM", "count", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "boolean", 1, 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 ] 2320 -
2321 [ "sys", "count_no_nil", "SYSTEM", "count_no_nil", "aggr", "Internal C", "Aggregate function", false, false, false, "res", "bigint", 64, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2321 2254 [ "sys", "count_no_nil", "SYSTEM", "count_no_nil", "aggr", "Internal C", "Aggregate function", false, false, false, "res", "bigint", 64, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2254
2322 [ "sys", "createorderindex", "SYSTEM", "create procedure sys.createorderindex(sys string, tab string, col string) external name sql.createorderindex;", "sql", "MAL", "Procedure", true, false, false, "sys", "clob", 0, 0, "in", "tab", "clob", 0, 0, "in", "col", "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 ] 2322 2255 [ "sys", "createorderindex", "SYSTEM", "create procedure sys.createorderindex(sys string, tab string, col string) external name sql.createorderindex;", "sql", "MAL", "Procedure", true, false, false, "sys", "clob", 0, 0, "in", "tab", "clob", 0, 0, "in", "col", "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 ] 2255
2323 [ "sys", "cume_dist", "SYSTEM", "cume_dist", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "double", 53, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "boolean", 1, 0, "in", "arg_3", "boolean", 1, 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 ] 2323 -
2324 [ "sys", "curdate", "SYSTEM", "current_date", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "date", 0, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2324 2256 [ "sys", "curdate", "SYSTEM", "current_date", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "date", 0, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2256
..................
# .s, .f, .L4, .L6, .f,
2361 [ "sys", "exp", "SYSTEM", "exp", "mmath", "Internal C", "Scalar function", false, false, false, "res_0", "real", 24, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2361 2293 [ "sys", "exp", "SYSTEM", "exp", "mmath", "Internal C", "Scalar function", false, false, false, "res_0", "real", 24, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2293
2362 [ "sys", "first_value", "SYSTEM", "first_value", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 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 ] 2362 -
2363 [ "sys", "fitsattach", "SYSTEM", "create procedure fitsattach(fname string) external name fits.attach;", "fits", "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 ] 2363 2294 [ "sys", "fitsattach", "SYSTEM", "create procedure fitsattach(fname string) external name fits.attach;", "fits", "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 ] 2294
..................
# .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 2302 [ "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 ] 2302
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 ! 2303 [ "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 ] 2303
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 ! 2304 [ "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 ] 2304
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 ! 2305 [ "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 ] 2305
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 ! 2306 [ "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 ] 2306
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 ! 2307 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first hugeint, last 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", "last", "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 ] 2307
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 ! 2308 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first hugeint, last 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", "last", "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 ] 2308
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 ! 2309 [ "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 ] 2309
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 ! 2310 [ "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 ] 2310
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 ! 2311 [ "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 ] 2311
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 ! 2312 [ "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 ] 2312
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 ! 2313 [ "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 ] 2313
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 ! 2314 [ "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 ] 2314
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 ! 2315 [ "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 ] 2315
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 ! 2316 [ "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 ] 2316
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 2317 [ "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 ] 2317
..................
# .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 2338 [ "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 ] 2338
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 ! 2339 [ "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 ] 2339
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 ! 2340 [ "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 ] 2340
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 2341 [ "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 ] 2341
..................
# .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 2351 [ "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 ] 2351
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 ! 2352 [ "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 ] 2352
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 2353 [ "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 ] 2353
..................
# .s, .f, .L4, .L6, .f,
2438 [ "sys", "isnull", "SYSTEM", "isnil", "calc", "Internal C", "Scalar function", false, false, false, "res_0", "boolean", 1, 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 ] 2438 2369 [ "sys", "isnull", "SYSTEM", "isnil", "calc", "Internal C", "Scalar function", false, false, false, "res_0", "boolean", 1, 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 ] 2369
2439 [ "sys", "lag", "SYSTEM", "lag", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "bigint", 64, 0, "in", "arg_3", "any", 0, 0, "in", "arg_4", "boolean", 1, 0, "in", "arg_5", "boolean", 1, 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 ] 2439 -
2440 [ "sys", "lag", "SYSTEM", "lag", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "bigint", 64, 0, "in", "arg_3", "boolean", 1, 0, "in", "arg_4", "boolean", 1, 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 ] 2440 -
2441 [ "sys", "lag", "SYSTEM", "lag", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "boolean", 1, 0, "in", "arg_3", "boolean", 1, 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 ] 2441 -
2442 [ "sys", "lag", "SYSTEM", "lag", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "hugeint", 128, 0, "in", "arg_3", "any", 0, 0, "in", "arg_4", "boolean", 1, 0, "in", "arg_5", "boolean", 1, 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 ] 2442 -
2443 [ "sys", "lag", "SYSTEM", "lag", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "hugeint", 128, 0, "in", "arg_3", "boolean", 1, 0, "in", "arg_4", "boolean", 1, 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 ] 2443 -
2444 [ "sys", "lag", "SYSTEM", "lag", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "int", 32, 0, "in", "arg_3", "any", 0, 0, "in", "arg_4", "boolean", 1, 0, "in", "arg_5", "boolean", 1, 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 ] 2444 -
2445 [ "sys", "lag", "SYSTEM", "lag", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "int", 32, 0, "in", "arg_3", "boolean", 1, 0, "in", "arg_4", "boolean", 1, 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 ] 2445 -
2446 [ "sys", "lag", "SYSTEM", "lag", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "smallint", 16, 0, "in", "arg_3", "any", 0, 0, "in", "arg_4", "boolean", 1, 0, "in", "arg_5", "boolean", 1, 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 ] 2446 -
2447 [ "sys", "lag", "SYSTEM", "lag", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "smallint", 16, 0, "in", "arg_3", "boolean", 1, 0, "in", "arg_4", "boolean", 1, 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 ] 2447 -
2448 [ "sys", "lag", "SYSTEM", "lag", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "tinyint", 8, 0, "in", "arg_3", "any", 0, 0, "in", "arg_4", "boolean", 1, 0, "in", "arg_5", "boolean", 1, 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 ] 2448 -
2449 [ "sys", "lag", "SYSTEM", "lag", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "tinyint", 8, 0, "in", "arg_3", "boolean", 1, 0, "in", "arg_4", "boolean", 1, 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 ] 2449 -
2450 [ "sys", "last_value", "SYSTEM", "last_value", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 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 ] 2450 -
2451 [ "sys", "lcase", "SYSTEM", "toLower", "str", "Internal C", "Scalar function", false, false, false, "res_0", "char", 0, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL ] 2451 2370 [ "sys", "lcase", "SYSTEM", "toLower", "str", "Internal C", "Scalar function", false, false, false, "res_0", "char", 0, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL ] 2370
..................
# .s, .f, .L4, .L6, .f,
2453 [ "sys", "lcase", "SYSTEM", "toLower", "str", "Internal C", "Scalar function", false, false, false, "res_0", "varchar", 0, 0, "out", "arg_1", "varchar", 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 2372 [ "sys", "lcase", "SYSTEM", "toLower", "str", "Internal C", "Scalar function", false, false, false, "res_0", "varchar", 0, 0, "out", "arg_1", "varchar", 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 ] 2372
2454 [ "sys", "lead", "SYSTEM", "lead", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "bigint", 64, 0, "in", "arg_3", "any", 0, 0, "in", "arg_4", "boolean", 1, 0, "in", "arg_5", "boolean", 1, 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 ] 2454 -
2455 [ "sys", "lead", "SYSTEM", "lead", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "bigint", 64, 0, "in", "arg_3", "boolean", 1, 0, "in", "arg_4", "boolean", 1, 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 ] 2455 -
2456 [ "sys", "lead", "SYSTEM", "lead", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "boolean", 1, 0, "in", "arg_3", "boolean", 1, 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 ] 2456 -
2457 [ "sys", "lead", "SYSTEM", "lead", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "hugeint", 128, 0, "in", "arg_3", "any", 0, 0, "in", "arg_4", "boolean", 1, 0, "in", "arg_5", "boolean", 1, 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 ] 2457 -
2458 [ "sys", "lead", "SYSTEM", "lead", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "hugeint", 128, 0, "in", "arg_3", "boolean", 1, 0, "in", "arg_4", "boolean", 1, 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 ] 2458 -
2459 [ "sys", "lead", "SYSTEM", "lead", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "int", 32, 0, "in", "arg_3", "any", 0, 0, "in", "arg_4", "boolean", 1, 0, "in", "arg_5", "boolean", 1, 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 ] 2459 -
2460 [ "sys", "lead", "SYSTEM", "lead", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "int", 32, 0, "in", "arg_3", "boolean", 1, 0, "in", "arg_4", "boolean", 1, 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 ] 2460 -
2461 [ "sys", "lead", "SYSTEM", "lead", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "smallint", 16, 0, "in", "arg_3", "any", 0, 0, "in", "arg_4", "boolean", 1, 0, "in", "arg_5", "boolean", 1, 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 ] 2461 -
2462 [ "sys", "lead", "SYSTEM", "lead", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "smallint", 16, 0, "in", "arg_3", "boolean", 1, 0, "in", "arg_4", "boolean", 1, 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 ] 2462 -
2463 [ "sys", "lead", "SYSTEM", "lead", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "tinyint", 8, 0, "in", "arg_3", "any", 0, 0, "in", "arg_4", "boolean", 1, 0, "in", "arg_5", "boolean", 1, 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 ] 2463 -
2464 [ "sys", "lead", "SYSTEM", "lead", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "tinyint", 8, 0, "in", "arg_3", "boolean", 1, 0, "in", "arg_4", "boolean", 1, 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 ] 2464 -
2465 [ "sys", "left", "SYSTEM", "stringleft", "str", "Internal C", "Scalar function", false, false, false, "res_0", "char", 0, 0, "out", "arg_1", "char", 0, 0, "in", "arg_2", "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 ] 2465 2373 [ "sys", "left", "SYSTEM", "stringleft", "str", "Internal C", "Scalar function", false, false, false, "res_0", "char", 0, 0, "out", "arg_1", "char", 0, 0, "in", "arg_2", "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 ] 2373
..................
# .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 2399 [ "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 ] 2399
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 2400 [ "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 ] 2400
..................
# .s, .f, .L4, .L6, .f,
2534 [ "sys", "max", "SYSTEM", "max", "aggr", "Internal C", "Aggregate function", false, false, false, "res", "any", 0, 0, "out", "arg", "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 ] 2534 2439 [ "sys", "max", "SYSTEM", "max", "aggr", "Internal C", "Aggregate function", false, false, false, "res", "any", 0, 0, "out", "arg", "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 ] 2439
2535 [ "sys", "max", "SYSTEM", "max", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 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 ] 2535 -
2536 [ "sys", "mbr", "SYSTEM", "create function mbr(geom geometry) returns mbr external name geom.\"mbr\";", "geom", "MAL", "Scalar function", false, false, false, "result", "mbr", 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 ] 2536 2440 [ "sys", "mbr", "SYSTEM", "create function mbr(geom geometry) returns mbr external name geom.\"mbr\";", "geom", "MAL", "Scalar function", false, false, false, "result", "mbr", 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 ] 2440
..................
# .s, .f, .L4, .L6, .f,
2575 [ "sys", "min", "SYSTEM", "min", "aggr", "Internal C", "Aggregate function", false, false, false, "res", "any", 0, 0, "out", "arg", "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 ] 2575 2479 [ "sys", "min", "SYSTEM", "min", "aggr", "Internal C", "Aggregate function", false, false, false, "res", "any", 0, 0, "out", "arg", "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 ] 2479
2576 [ "sys", "min", "SYSTEM", "min", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 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 ] 2576 -
2577 [ "sys", "minute", "SYSTEM", "minutes", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2577 2480 [ "sys", "minute", "SYSTEM", "minutes", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2480
..................
# .s, .f, .L4, .L6, .f,
2626 [ "sys", "not_uniques", "SYSTEM", "not_uniques", "sql", "Internal C", "Scalar function", false, false, false, "res_0", "oid", 63, 0, "out", "arg_1", "oid", 63, 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 ] 2626 2529 [ "sys", "not_uniques", "SYSTEM", "not_uniques", "sql", "Internal C", "Scalar function", false, false, false, "res_0", "oid", 63, 0, "out", "arg_1", "oid", 63, 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 ] 2529
2627 [ "sys", "nth_value", "SYSTEM", "nth_value", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "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 ] 2627 -
2628 [ "sys", "nth_value", "SYSTEM", "nth_value", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "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 ] 2628 -
2629 [ "sys", "nth_value", "SYSTEM", "nth_value", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "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 ] 2629 -
2630 [ "sys", "nth_value", "SYSTEM", "nth_value", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "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 ] 2630 -
2631 [ "sys", "nth_value", "SYSTEM", "nth_value", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "any", 0, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "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 ] 2631 -
2632 [ "sys", "ntile", "SYSTEM", "ntile", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "bigint", 64, 0, "in", "arg_3", "boolean", 1, 0, "in", "arg_4", "boolean", 1, 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 ] 2632 -
2633 [ "sys", "ntile", "SYSTEM", "ntile", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "hugeint", 128, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "hugeint", 128, 0, "in", "arg_3", "boolean", 1, 0, "in", "arg_4", "boolean", 1, 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 ] 2633 -
2634 [ "sys", "ntile", "SYSTEM", "ntile", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "int", 32, 0, "in", "arg_3", "boolean", 1, 0, "in", "arg_4", "boolean", 1, 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 ] 2634 -
2635 [ "sys", "ntile", "SYSTEM", "ntile", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "smallint", 16, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "smallint", 16, 0, "in", "arg_3", "boolean", 1, 0, "in", "arg_4", "boolean", 1, 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 ] 2635 -
2636 [ "sys", "ntile", "SYSTEM", "ntile", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "tinyint", 8, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "tinyint", 8, 0, "in", "arg_3", "boolean", 1, 0, "in", "arg_4", "boolean", 1, 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 ] 2636 -
2637 [ "sys", "octet_length", "SYSTEM", "nbytes", "str", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL ] 2637 2530 [ "sys", "octet_length", "SYSTEM", "nbytes", "str", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL ] 2530
..................
# .s, .f, .L4, .L6, .f,
2649 [ "sys", "pcre_replace", "", "create function pcre_replace(origin string, pat string, repl string, flags string) returns string external name pcre.replace;", "pcre", "MAL", "Scalar function", false, false, false, "result", "clob", 0, 0, "out", "origin", "clob", 0, 0, "in", "pat", "clob", 0, 0, "in", "repl", "clob", 0, 0, "in", "flags", "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 ] 2649 2542 [ "sys", "pcre_replace", "", "create function pcre_replace(origin string, pat string, repl string, flags string) returns string external name pcre.replace;", "pcre", "MAL", "Scalar function", false, false, false, "result", "clob", 0, 0, "out", "origin", "clob", 0, 0, "in", "pat", "clob", 0, 0, "in", "repl", "clob", 0, 0, "in", "flags", "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 ] 2542
2650 [ "sys", "percent_rank", "SYSTEM", "percent_rank", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "double", 53, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "boolean", 1, 0, "in", "arg_3", "boolean", 1, 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 ] 2650 -
2651 [ "sys", "pi", "SYSTEM", "pi", "mmath", "Internal C", "Scalar function", false, false, false, "res_0", "double", 53, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2651 2543 [ "sys", "pi", "SYSTEM", "pi", "mmath", "Internal C", "Scalar function", false, false, false, "res_0", "double", 53, 0, "out", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2543
..................
# .s, .f, .L4, .L6, .f,
2665 [ "sys", "prod", "SYSTEM", "prod", "aggr", "Internal C", "Aggregate function", false, false, false, "res", "real", 24, 0, "out", "arg", "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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2665 2557 [ "sys", "prod", "SYSTEM", "prod", "aggr", "Internal C", "Aggregate function", false, false, false, "res", "real", 24, 0, "out", "arg", "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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2557
2666 [ "sys", "prod", "SYSTEM", "prod", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "decimal", 38, 0, "out", "arg_1", "decimal", 2, 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 ] 2666 -
2667 [ "sys", "prod", "SYSTEM", "prod", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "decimal", 38, 0, "out", "arg_1", "decimal", 4, 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 ] 2667 -
2668 [ "sys", "prod", "SYSTEM", "prod", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "decimal", 38, 0, "out", "arg_1", "decimal", 9, 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 ] 2668 -
2669 [ "sys", "prod", "SYSTEM", "prod", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "decimal", 38, 0, "out", "arg_1", "decimal", 18, 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 ] 2669 -
2670 [ "sys", "prod", "SYSTEM", "prod", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "decimal", 38, 0, "out", "arg_1", "decimal", 38, 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 ] 2670 -
2671 [ "sys", "prod", "SYSTEM", "prod", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "double", 53, 0, "out", "arg_1", "double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2671 -
2672 [ "sys", "prod", "SYSTEM", "prod", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "hugeint", 128, 0, "out", "arg_1", "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 ] 2672 -
2673 [ "sys", "prod", "SYSTEM", "prod", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "hugeint", 128, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL ] 2673 -
2674 [ "sys", "prod", "SYSTEM", "prod", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "hugeint", 128, 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 ] 2674 -
2675 [ "sys", "prod", "SYSTEM", "prod", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "hugeint", 128, 0, "out", "arg_1", "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 ] 2675 -
2676 [ "sys", "prod", "SYSTEM", "prod", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "hugeint", 128, 0, "out", "arg_1", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2676 -
2677 [ "sys", "prod", "SYSTEM", "prod", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "real", 24, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2677 -
2678 [ "sys", "qgramnormalize", "SYSTEM", "qgramnormalize", "txtsim", "Internal C", "Scalar function", false, false, false, "res_0", "char", 0, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL ] 2678 2558 [ "sys", "qgramnormalize", "SYSTEM", "qgramnormalize", "txtsim", "Internal C", "Scalar function", false, false, false, "res_0", "char", 0, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL ] 2558
..................
# .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 3268 [ "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 ] 3268
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 3269 [ "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 ] 3269
..................
# .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 3730 [ "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 ] 3730
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 ! 3731 [ "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" ] 3731
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 ! 3732 [ "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" ] 3732
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 ! 3733 [ "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" ] 3733
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 ! 3734 [ "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" ] 3734
[ "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\" + 3735 [ "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 ] 3735
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 ! 3736 [ "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 ] 3736
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 3737 [ "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 ] 3737
..................
# .s, .f, .L4, .L6, .f,
3890 [ "sys", "sum", "SYSTEM", "sum", "aggr", "Internal C", "Aggregate function", false, false, false, "res", "sec_interval", 13, 0, "out", "arg", "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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3890 3768 [ "sys", "sum", "SYSTEM", "sum", "aggr", "Internal C", "Aggregate function", false, false, false, "res", "sec_interval", 13, 0, "out", "arg", "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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3768
3891 [ "sys", "sum", "SYSTEM", "sum", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "decimal", 38, 0, "out", "arg_1", "decimal", 2, 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 ] 3891 -
3892 [ "sys", "sum", "SYSTEM", "sum", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "decimal", 38, 0, "out", "arg_1", "decimal", 4, 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 ] 3892 -
3893 [ "sys", "sum", "SYSTEM", "sum", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "decimal", 38, 0, "out", "arg_1", "decimal", 9, 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 ] 3893 -
3894 [ "sys", "sum", "SYSTEM", "sum", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "decimal", 38, 0, "out", "arg_1", "decimal", 18, 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 ] 3894 -
3895 [ "sys", "sum", "SYSTEM", "sum", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "decimal", 38, 0, "out", "arg_1", "decimal", 38, 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 ] 3895 -
3896 [ "sys", "sum", "SYSTEM", "sum", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "double", 53, 0, "out", "arg_1", "double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3896 -
3897 [ "sys", "sum", "SYSTEM", "sum", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "hugeint", 128, 0, "out", "arg_1", "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 ] 3897 -
3898 [ "sys", "sum", "SYSTEM", "sum", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "hugeint", 128, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL ] 3898 -
3899 [ "sys", "sum", "SYSTEM", "sum", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "hugeint", 128, 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 ] 3899 -
3900 [ "sys", "sum", "SYSTEM", "sum", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "hugeint", 128, 0, "out", "arg_1", "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 ] 3900 -
3901 [ "sys", "sum", "SYSTEM", "sum", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "hugeint", 128, 0, "out", "arg_1", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3901 -
3902 [ "sys", "sum", "SYSTEM", "sum", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "month_interval", 32, 0, "out", "arg_1", "month_interval", 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 ] 3902 -
3903 [ "sys", "sum", "SYSTEM", "sum", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "real", 24, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3903 -
3904 [ "sys", "sum", "SYSTEM", "sum", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "sec_interval", 13, 0, "out", "arg_1", "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, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3904 -
3905 [ "sys", "sys_update_schemas", "SYSTEM", "update_schemas", "sql", "Internal C", "Procedure", false, 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 ] 3905 3769 [ "sys", "sys_update_schemas", "SYSTEM", "update_schemas", "sql", "Internal C", "Procedure", false, 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 ] 3769
..................
# .s, .f, .L4, .L6, .f,
3955 [ "sys", "weekofyear", "SYSTEM", "weekofyear", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "date", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3955 3819 [ "sys", "weekofyear", "SYSTEM", "weekofyear", "mtime", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "date", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3819
3956 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "int", 32, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "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 ] 3956 -
3957 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "int", 32, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "decimal", 2, 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 ] 3957 -
3958 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "int", 32, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "decimal", 4, 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 ] 3958 -
3959 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "int", 32, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "decimal", 9, 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 ] 3959 -
3960 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "int", 32, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "decimal", 18, 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 ] 3960 -
3961 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "int", 32, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "decimal", 38, 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 ] 3961 -
3962 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "int", 32, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "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 ] 3962 -
3963 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "int", 32, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "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 ] 3963 -
3964 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "int", 32, 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 ] 3964 -
3965 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "int", 32, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "month_interval", 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 ] 3965 -
3966 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "int", 32, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "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 ] 3966 -
3967 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "int", 32, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "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 ] 3967 -
3968 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "int", 32, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "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 ] 3968 -
3969 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "int", 32, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "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 ] 3969 -
3970 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "boolean", 1, 0, "in", "arg_2", "any", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "int", 32, 0, "in", "arg_6", "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 ] 3970 -
3971 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "boolean", 1, 0, "in", "arg_2", "any", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "int", 32, 0, "in", "arg_6", "decimal", 2, 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 ] 3971 -
3972 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "boolean", 1, 0, "in", "arg_2", "any", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "int", 32, 0, "in", "arg_6", "decimal", 4, 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 ] 3972 -
3973 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "boolean", 1, 0, "in", "arg_2", "any", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "int", 32, 0, "in", "arg_6", "decimal", 9, 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 ] 3973 -
3974 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "boolean", 1, 0, "in", "arg_2", "any", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "int", 32, 0, "in", "arg_6", "decimal", 18, 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 ] 3974 -
3975 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "boolean", 1, 0, "in", "arg_2", "any", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "int", 32, 0, "in", "arg_6", "decimal", 38, 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 ] 3975 -
3976 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "boolean", 1, 0, "in", "arg_2", "any", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "int", 32, 0, "in", "arg_6", "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 ] 3976 -
3977 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "boolean", 1, 0, "in", "arg_2", "any", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "int", 32, 0, "in", "arg_6", "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 ] 3977 -
3978 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "boolean", 1, 0, "in", "arg_2", "any", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "int", 32, 0, "in", "arg_6", "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 ] 3978 -
3979 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "boolean", 1, 0, "in", "arg_2", "any", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "int", 32, 0, "in", "arg_6", "month_interval", 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 ] 3979 -
3980 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "boolean", 1, 0, "in", "arg_2", "any", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "int", 32, 0, "in", "arg_6", "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 ] 3980 -
3981 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "boolean", 1, 0, "in", "arg_2", "any", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "int", 32, 0, "in", "arg_6", "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 ] 3981 -
3982 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "boolean", 1, 0, "in", "arg_2", "any", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "int", 32, 0, "in", "arg_6", "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 ] 3982 -
3983 [ "sys", "window_bound", "SYSTEM", "window_bound", "sql", "Internal C", "Analytic function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "boolean", 1, 0, "in", "arg_2", "any", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "int", 32, 0, "in", "arg_6", "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 ] 3983 -
3984 [ "sys", "xor", "SYSTEM", "xor", "calc", "Internal C", "Scalar function", false, false, false, "res_0", "boolean", 1, 0, "out", "arg_1", "boolean", 1, 0, "in", "arg_2", "boolean", 1, 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 ] 3984 3820 [ "sys", "xor", "SYSTEM", "xor", "calc", "Internal C", "Scalar function", false, false, false, "res_0", "boolean", 1, 0, "out", "arg_1", "boolean", 1, 0, "in", "arg_2", "boolean", 1, 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 ] 3820
..................
#select s1.name, f1.name, s2.name, f2.na
4038 % 3, 17, 3, 13, 8 # length 4038 3874 % 3, 17, 3, 13, 8 # length 3874
+ 3875 [ "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3875
4039 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4039 3876 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3876
..................
#select s1.name, f1.name, s2.name, f2.na
4043 [ "sys", "st_srid", "sys", "st_transform", "FUNCTION" ] 4043 3880 [ "sys", "st_srid", "sys", "st_transform", "FUNCTION" ] 3880
+ 3881 [ "sys", "columnsize", "sys", "storagemodel", "FUNCTION" ] 3881
+ 3882 [ "sys", "hashsize", "sys", "storagemodel", "FUNCTION" ] 3882
+ 3883 [ "sys", "heapsize", "sys", "storagemodel", "FUNCTION" ] 3883
+ 3884 [ "sys", "imprintsize", "sys", "storagemodel", "FUNCTION" ] 3884
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 3885 #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; 3885
..................
#select s1.name, t.name, s2.name, f.name
4049 [ "sys", "spatial_ref_sys", "sys", "getproj4", "FUNCTION" ] 4049 3890 [ "sys", "spatial_ref_sys", "sys", "getproj4", "FUNCTION" ] 3890
+ 3891 [ "sys", "storagemodelinput", "sys", "storagemodel", "FUNCTION" ] 3891
4050 [ "sys", "keys", "sys", "storagemodelinit", "PROCEDURE" ] 4050 3892 [ "sys", "keys", "sys", "storagemodelinit", "PROCEDURE" ] 3892
..................
#select s1.name, t.name, s2.name, f.name
4052 [ "sys", "schemas", "sys", "storagemodelinit", "PROCEDURE" ] 4052 3894 [ "sys", "schemas", "sys", "storagemodelinit", "PROCEDURE" ] 3894
4053 [ "sys", "storage", "sys", "storagemodelinit", "PROCEDURE" ] 4053 -
4054 [ "sys", "storagemodelinput", "sys", "storagemodelinit", "PROCEDURE" ] 4054 3895 [ "sys", "storagemodelinput", "sys", "storagemodelinit", "PROCEDURE" ] 3895
..................
#select s1.name, t.name, c.name, s2.name
4060 % 3, 17, 13, 3, 16, 9 # length 4060 3901 % 3, 17, 13, 3, 16, 9 # length 3901
+ 3902 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 3902
+ 3903 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 3903
4061 [ "sys", "spatial_ref_sys", "auth_name", "sys", "getproj4", "FUNCTION" ] 4061 ! 3904 [ "sys", "storagemodelinput", "atomwidth", "sys", "storagemodel", "FUNCTION" ] 3904
4062 [ "sys", "spatial_ref_sys", "auth_srid", "sys", "getproj4", "FUNCTION" ] 4062 ! 3905 [ "sys", "storagemodelinput", "column", "sys", "storagemodel", "FUNCTION" ] 3905
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 ! 3906 [ "sys", "storagemodelinput", "count", "sys", "storagemodel", "FUNCTION" ] 3906
+ 3907 [ "sys", "storagemodelinput", "distinct", "sys", "storagemodel", "FUNCTION" ] 3907
+ 3908 [ "sys", "storagemodelinput", "orderidx", "sys", "storagemodel", "FUNCTION" ] 3908
+ 3909 [ "sys", "storagemodelinput", "reference", "sys", "storagemodel", "FUNCTION" ] 3909
+ 3910 [ "sys", "storagemodelinput", "revsorted", "sys", "storagemodel", "FUNCTION" ] 3910
+ 3911 [ "sys", "storagemodelinput", "schema", "sys", "storagemodel", "FUNCTION" ] 3911
+ 3912 [ "sys", "storagemodelinput", "sorted", "sys", "storagemodel", "FUNCTION" ] 3912
+ 3913 [ "sys", "storagemodelinput", "table", "sys", "storagemodel", "FUNCTION" ] 3913
+ 3914 [ "sys", "storagemodelinput", "type", "sys", "storagemodel", "FUNCTION" ] 3914
+ 3915 [ "sys", "storagemodelinput", "typewidth", "sys", "storagemodel", "FUNCTION" ] 3915
+ 3916 [ "sys", "storagemodelinput", "unique", "sys", "storagemodel", "FUNCTION" ] 3916
4066 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 4066 3917 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 3917
..................
#select s1.name, t.name, c.name, s2.name
4083 [ "sys", "storagemodelinput", "distinct", "sys", "storagemodelinit", "PROCEDURE" ] 4083 3934 [ "sys", "storagemodelinput", "distinct", "sys", "storagemodelinit", "PROCEDURE" ] 3934
4084 [ "sys", "storagemodelinput", "orderidxsize", "sys", "storagemodelinit", "PROCEDURE" ] 4084 ! 3935 [ "sys", "storagemodelinput", "orderidx", "sys", "storagemodelinit", "PROCEDURE" ] 3935
4085 [ "sys", "storagemodelinput", "reference", "sys", "storagemodelinit", "PROCEDURE" ] 4085 3936 [ "sys", "storagemodelinput", "reference", "sys", "storagemodelinit", "PROCEDURE" ] 3936
..................
#select s1.name, f1.name, s2.name, t2.na
4096 % varchar, varchar, varchar, varchar, varchar # type 4096 3947 % varchar, varchar, varchar, varchar, varchar # type 3947
4097 % 3, 11, 3, 17, 4 # length 4097 ! 3948 % 3, 16, 3, 16, 4 # length 3948
4098 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 4098 3949 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 3949
..................
#select s1.name, f1.name, s2.name, t2.na
4100 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 4100 3951 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 3951
4101 [ "sys", "columnsize", "sys", "storagemodel", "VIEW" ] 4101 ! 3952 [ "sys", "optimizers", "sys", "optimizers", "VIEW" ] 3952
4102 [ "sys", "hashsize", "sys", "storagemodel", "VIEW" ] 4102 ! 3953 [ "sys", "querylog_catalog", "sys", "querylog_catalog", "VIEW" ] 3953
4103 [ "sys", "heapsize", "sys", "storagemodel", "VIEW" ] 4103 ! 3954 [ "sys", "queue", "sys", "queue", "VIEW" ] 3954
4104 [ "sys", "imprintsize", "sys", "storagemodel", "VIEW" ] 4104 ! 3955 [ "sys", "rejects", "sys", "rejects", "VIEW" ] 3955
4105 [ "sys", "columnsize", "sys", "tablestoragemodel", "VIEW" ] 4105 ! 3956 [ "sys", "sessions", "sys", "sessions", "VIEW" ] 3956
4106 [ "sys", "hashsize", "sys", "tablestoragemodel", "VIEW" ] 4106 ! 3957 [ "sys", "tracelog", "sys", "tracelog", "VIEW" ] 3957
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 3958 #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; 3958
..................
#select s1.name, t1.name, s2.name, t2.na
4112 % varchar, varchar, varchar, varchar, varchar # type 4112 3961 % varchar, varchar, varchar, varchar, varchar # type 3961
4113 % 3, 17, 3, 34, 4 # length 4113 ! 3962 % 3, 16, 3, 34, 4 # length 3962
4114 [ "sys", "dependencies", "sys", "dependencies_vw", "VIEW" ] 4114 3963 [ "sys", "dependencies", "sys", "dependencies_vw", "VIEW" ] 3963
..................
#select s1.name, t1.name, s2.name, t2.na
4124 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 4124 3973 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 3973
4125 [ "sys", "idxs", "sys", "dependency_columns_on_indexes", "VIEW" ] 4125 -
4126 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 4126 3974 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 3974
4127 [ "sys", "objects", "sys", "dependency_columns_on_indexes", "VIEW" ] 4127 -
4128 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 4128 3975 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 3975
4129 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 4129 3976 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 3976
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 3977 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 3977
..................
#select s1.name, t1.name, s2.name, t2.na
4138 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 4138 3983 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 3983
4139 [ "sys", "triggers", "sys", "dependency_columns_on_triggers", "VIEW" ] 4139 -
4140 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 4140 3984 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 3984
..................
#select s1.name, t1.name, s2.name, t2.na
4152 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 4152 3996 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 3996
4153 [ "sys", "triggers", "sys", "dependency_functions_on_triggers", "VIEW" ] 4153 -
4154 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 4154 3997 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 3997
..................
#select s1.name, t1.name, s2.name, t2.na
4159 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 4159 4002 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 4002
4160 [ "sys", "keys", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4160 -
4161 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 4161 4003 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 4003
..................
#select s1.name, t1.name, s2.name, t2.na
4164 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 4164 4006 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 4006
4165 [ "sys", "keys", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4165 -
4166 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4166 4007 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4007
..................
#select s1.name, t1.name, s2.name, t2.na
4169 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 4169 4010 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 4010
4170 [ "sys", "idxs", "sys", "dependency_tables_on_indexes", "VIEW" ] 4170 -
4171 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 4171 4011 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 4011
..................
#select s1.name, t1.name, s2.name, t2.na
4177 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4177 4017 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4017
4178 [ "sys", "triggers", "sys", "dependency_tables_on_triggers", "VIEW" ] 4178 -
4179 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4179 4018 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4018
..................
#select s1.name, t1.name, s2.name, t2.na
4192 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4192 4031 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4031
4193 [ "sys", "_columns", "sys", "ids", "VIEW" ] 4193 -
4194 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4194 4032 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4032
..................
#select s1.name, t1.name, s2.name, t2.na
4197 [ "sys", "functions", "sys", "ids", "VIEW" ] 4197 4035 [ "sys", "functions", "sys", "ids", "VIEW" ] 4035
4198 [ "sys", "idxs", "sys", "ids", "VIEW" ] 4198 -
4199 [ "sys", "keys", "sys", "ids", "VIEW" ] 4199 4036 [ "sys", "keys", "sys", "ids", "VIEW" ] 4036
..................
#select s1.name, t1.name, s2.name, t2.na
4201 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4201 4038 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4038
4202 [ "sys", "triggers", "sys", "ids", "VIEW" ] 4202 -
4203 [ "sys", "types", "sys", "ids", "VIEW" ] 4203 4039 [ "sys", "types", "sys", "ids", "VIEW" ] 4039
4204 [ "tmp", "_columns", "sys", "ids", "VIEW" ] 4204 -
4205 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4205 4040 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4040
4206 [ "tmp", "idxs", "sys", "ids", "VIEW" ] 4206 -
4207 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4207 4041 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4041
4208 [ "tmp", "triggers", "sys", "ids", "VIEW" ] 4208 -
4209 [ "sys", "auths", "sys", "roles", "VIEW" ] 4209 4042 [ "sys", "auths", "sys", "roles", "VIEW" ] 4042
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 4043 [ "sys", "functions", "sys", "systemfunctions", "VIEW" ] 4043
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 4044 #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; 4044
..................
#select s1.name, t1.name, c1.name, s2.na
4220 % varchar, varchar, varchar, varchar, varchar, varchar # type 4220 4047 % varchar, varchar, varchar, varchar, varchar, varchar # type 4047
4221 % 3, 17, 20, 3, 34, 4 # length 4221 ! 4048 % 3, 16, 20, 3, 34, 4 # length 4048
4222 [ "sys", "dependencies", "depend_id", "sys", "dependencies_vw", "VIEW" ] 4222 4049 [ "sys", "dependencies", "depend_id", "sys", "dependencies_vw", "VIEW" ] 4049
..................
#select s1.name, t1.name, c1.name, s2.na
4243 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4243 4070 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4070
4244 [ "sys", "idxs", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4244 ! 4071 [ "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4071
4245 [ "sys", "idxs", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4245 ! 4072 [ "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4072
4246 [ "sys", "idxs", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4246 ! 4073 [ "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4073
4247 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4247 ! 4074 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4074
4248 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4248 ! 4075 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4075
+ 4076 [ "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4076
4249 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4249 4077 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4077
4250 [ "sys", "objects", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4250 ! 4078 [ "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4078
4251 [ "sys", "objects", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4251 ! 4079 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4079
4252 [ "sys", "objects", "nr", "sys", "dependency_columns_on_indexes", "VIEW" ] 4252 ! 4080 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4080
4253 [ "sys", "keys", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4253 ! 4081 [ "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4081
4254 [ "sys", "keys", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4254 ! 4082 [ "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4082
4255 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4255 ! 4083 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4083
4256 [ "sys", "keys", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4256 ! 4084 [ "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4084
4257 [ "sys", "objects", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4257 ! 4085 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4085
4258 [ "sys", "objects", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4258 ! 4086 [ "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4086
4259 [ "sys", "objects", "nr", "sys", "dependency_columns_on_keys", "VIEW" ] 4259 ! 4087 [ "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4087
+ 4088 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4088
+ 4089 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4089
+ 4090 [ "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4090
4260 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4260 4091 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4091
..................
#select s1.name, t1.name, c1.name, s2.na
4268 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4268 4099 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4099
4269 [ "sys", "triggers", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4269 ! 4100 [ "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4100
4270 [ "sys", "triggers", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4270 ! 4101 [ "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4101
+ 4102 [ "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4102
4271 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4271 4103 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4103
..................
#select s1.name, t1.name, c1.name, s2.na
4299 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4299 4131 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4131
4300 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4300 ! 4132 [ "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4132
4301 [ "sys", "triggers", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4301 ! 4133 [ "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4133
4302 [ "sys", "triggers", "table_id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4302 ! 4134 [ "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4134
+ 4135 [ "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4135
4303 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4303 4136 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4136
..................
#select s1.name, t1.name, c1.name, s2.na
4316 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4316 4149 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4149
4317 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4317 ! 4150 [ "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4150
4318 [ "sys", "keys", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4318 ! 4151 [ "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4151
4319 [ "sys", "keys", "rkey", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4319 ! 4152 [ "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4152
4320 [ "sys", "keys", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4320 ! 4153 [ "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4153
4321 [ "sys", "keys", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4321 ! 4154 [ "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4154
+ 4155 [ "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4155
4322 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4322 4156 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4156
..................
#select s1.name, t1.name, c1.name, s2.na
4328 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4328 4162 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4162
4329 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4329 ! 4163 [ "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4163
4330 [ "sys", "keys", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4330 ! 4164 [ "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4164
4331 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4331 ! 4165 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4165
4332 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4332 ! 4166 [ "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4166
4333 [ "sys", "keys", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4333 ! 4167 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4167
+ 4168 [ "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4168
4334 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4334 4169 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4169
..................
#select s1.name, t1.name, c1.name, s2.na
4339 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4339 4174 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4174
4340 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4340 ! 4175 [ "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4175
4341 [ "sys", "idxs", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4341 ! 4176 [ "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4176
4342 [ "sys", "idxs", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4342 ! 4177 [ "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4177
4343 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4343 ! 4178 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4178
4344 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4344 ! 4179 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4179
+ 4180 [ "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4180
4345 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4345 4181 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4181
..................
#select s1.name, t1.name, c1.name, s2.na
4354 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4354 4190 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4190
4355 [ "sys", "triggers", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4355 ! 4191 [ "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4191
4356 [ "sys", "triggers", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4356 ! 4192 [ "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4192
4357 [ "sys", "triggers", "table_id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4357 ! 4193 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4193
+ 4194 [ "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4194
4358 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4358 4195 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4195
..................
#select s1.name, t1.name, c1.name, s2.na
4379 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4379 4216 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4216
+ 4217 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4217
4380 [ "sys", "_columns", "id", "sys", "ids", "VIEW" ] 4380 ! 4218 [ "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4218
4381 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4381 ! 4219 [ "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4219
4382 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4382 4220 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4220
+ 4221 [ "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4221
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 ! 4222 [ "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4222
+ 4223 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4223
+ 4224 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4224
4386 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4386 ! 4225 [ "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4225
4387 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4387 4226 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4226
..................
#select s1.name, t1.name, c1.name, s2.na
4395 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4395 4234 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4234
4396 [ "sys", "idxs", "id", "sys", "ids", "VIEW" ] 4396 ! 4235 [ "sys", "keys", "action", "sys", "ids", "VIEW" ] 4235
+ 4236 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4236
4397 [ "sys", "idxs", "name", "sys", "ids", "VIEW" ] 4397 ! 4237 [ "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4237
+ 4238 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4238
4398 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4398 ! 4239 [ "sys", "keys", "type", "sys", "ids", "VIEW" ] 4239
4399 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4399 ! 4240 [ "sys", "objects", "id", "sys", "ids", "VIEW" ] 4240
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 4241 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4241
..................
#select s1.name, t1.name, c1.name, s2.na
4406 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4406 4245 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4245
4407 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4407 ! 4246 [ "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4246
4408 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4408 ! 4247 [ "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4247
4409 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4409 ! 4248 [ "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4248
+ 4249 [ "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4249
4410 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4410 4250 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4250
..................
#select s1.name, t1.name, c1.name, s2.na
4412 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4412 4252 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4252
+ 4253 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4253
4413 [ "tmp", "_columns", "id", "sys", "ids", "VIEW" ] 4413 ! 4254 [ "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4254
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 ! 4255 [ "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4255
+ 4256 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4256
4419 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4419 ! 4257 [ "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4257
4420 [ "tmp", "idxs", "id", "sys", "ids", "VIEW" ] 4420 ! 4258 [ "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4258
+ 4259 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4259
+ 4260 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4260
4421 [ "tmp", "idxs", "name", "sys", "ids", "VIEW" ] 4421 ! 4261 [ "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4261
4422 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4422 ! 4262 [ "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4262
+ 4263 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4263
4423 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4423 ! 4264 [ "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4264
4424 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4424 -
4425 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4425 4265 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4265
4426 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4426 ! 4266 [ "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4266
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 4267 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4267
..................
#select s1.name, t1.name, c1.name, s2.na
4431 [ "sys", "auths", "name", "sys", "roles", "VIEW" ] 4431 4269 [ "sys", "auths", "name", "sys", "roles", "VIEW" ] 4269
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 4270 [ "sys", "functions", "id", "sys", "systemfunctions", "VIEW" ] 4270
4446 [ "sys", "functions", "system", "sys", "systemfunctions", "VIEW" ] 4446 4271 [ "sys", "functions", "system", "sys", "systemfunctions", "VIEW" ] 4271
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 4272 #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; 4272
..................
#select f.name, a.name, pc.privilege_cod
4791 [ "degrees", "public", "EXECUTE", "monetdb", 0 ] 4791 4608 [ "degrees", "public", "EXECUTE", "monetdb", 0 ] 4608
4792 [ "env", "public", "EXECUTE", NULL, 0 ] 4792 -
4793 [ "epoch", "public", "EXECUTE", "monetdb", 0 ] 4793 4609 [ "epoch", "public", "EXECUTE", "monetdb", 0 ] 4609
..................
# .t, .g, .L4, .L6, .L10,
5084 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5084 4900 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 4900
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 ! 4901 [ 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();" ] 4901
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 4902 [ "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();" ] 4902
..................
#select keyword from sys.keywords order
5342 [ "WHILE" ] 5342 5158 [ "WHILE" ] 5158
5343 [ "WINDOW" ] 5343 -
5344 [ "WITH" ] 5344 5159 [ "WITH" ] 5159