Test check.SQL.py (id fe24a3b420fb) (err)
check.stable.out.int128.FILTERED 2018-12-08 20:07:37.459656373 +0100check.test.out.FILTERED 2018-12-08 20:07:37.700658365 +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 5314 lines, 210131 words, 1370203 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5130 lines, 198782 words, 1297258 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5314 lines, 210131 words, 1370203 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5130 lines, 198782 words, 1297258 chars in lines not matching '^$|^(\| |)#` 3
4 # 5395 lines, 212570 words, 1387361 chars in all lines 4 ! 4 # 5211 lines, 201220 words, 1314610 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 DEFAULT false, "sorted" BOOLEAN, "unique" BOOLEAN, "isacolumn" BOOLEAN NOT NULL DEFAULT true); 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, case when isacolumn then imprintsize("type", "count") else 0 end as imprintsize, case when (isacolumn and not sorted) then cast(8 * "count" as bigint) else 0 end as orderidxsize, sorted, "unique", isacolumn from sys.storagemodelinput order by "schema", "table", "column"; 937 ! 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(case when isacolumn then imprintsize("type", "count") else 0 end) as imprintsize, sum(case when (isacolumn and not sorted) then cast(8 * "count" as bigint) else 0 end) as orderidxsize from sys.storagemodelinput group by "schema", "table" order by "schema", "table"; 941 -
942 create view sys.tracelog as select * from sys.tracelog(); 942 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 32 + (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", case when ("unique" or "type" in ('varchar', 'char', 'clob', 'json', 'url', 'blob', 'geometry', 'geometrya')) then "count" else 0 end, case when "count" > 0 and heapsize >= 8192 and "type" in ('varchar', 'char', 'clob', 'json', 'url') then cast((heapsize - 8192) / "count" as bigint) when "count" > 0 and heapsize >= 32 and "type" + 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 in ('blob', 'geometry', 'geometrya') then cast((heapsize - 32) / "count" as bigint) else typewidth end, false, case sorted when true then true else false end, "unique", true from sys."storage"; update sys.storagemodelinput set reference = true where ("schema", "table", "column") in (select fkschema."name", fktable."name", fkkeycol."name" from sys."keys" as fkkey, sys."objects" as fkkeycol, sys."tables" as fktable, sys."schemas" as fkschema where fktable."id" = fkkey."table_id" and fkkey."id" = fkkeycol."id" and fkschema."id" = fktable."schema_id" and fkkey."rkey" > -1); update sys.storagemodelinput set isacolumn = false where ("schema", "table", "column") not in (select sch."name", tbl."name", col."name" from sys."schemas" as sch, sys."tables" as tbl, sys."columns" as col where sch."id" = tbl."schema_id" and tbl."id" = col."table_id"); end; 1265 ! 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, case when isacolumn then imprintsize(\"type\", \"count\") else 0 end as imprintsize, case when (isacolumn and not sorted) then cast(8 * \"count\" as bigint) else 0 end as orderidxsize, sorted, \"unique\", isacolumn from sys.storagemodelinput order by \"schema\", \"table\", \"column\";", "VIEW", true, "COMMIT", "WRITABLE" ] 1461 ! 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(case when isacolumn then imprintsize(\"type\", \"count\") else 0 end) as imprintsize, sum(case when (isacolumn and not sorted) then cast(8 * \"count\" as bigint) else 0 end) as orderidxsize from sys.storagemodelinput group by \"schema\", \"table\" order by \"schema\", \"table\";", "VIEW", true, "COMMIT", "WRITABLE" ] 1468 -
1469 [ "sys", "tracelog", "create view sys.tracelog as select * from sys.tracelog();", "VIEW", true, "COMMIT", "WRITABLE" ] 1469 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
1485 % varchar, varchar, varchar, int, int, varchar, boolean, int, varchar # type 1485 1449 % varchar, varchar, varchar, int, int, varchar, boolean, int, varchar # type 1449
1486 % 34, 26, 9, 5, 1, 5, 5, 2, 0 # length 1486 ! 1450 % 34, 26, 9, 5, 1, 0, 5, 2, 0 # length 1450
1487 [ "_columns", "id", "int", 32, 0, NULL, true, 0, NULL ] 1487 1451 [ "_columns", "id", "int", 32, 0, NULL, true, 0, NULL ] 1451
..................
#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", "unique", "boolean", 1, 0, NULL, true, 11, NULL ] 2007 1964 [ "storagemodel", "unique", "boolean", 1, 0, NULL, true, 11, NULL ] 1964
2008 [ "storagemodel", "isacolumn", "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, "false", 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
2019 [ "storagemodelinput", "unique", "boolean", 1, 0, NULL, true, 10, NULL ] 2019 ! 1976 [ "storagemodelinput", "revsorted", "boolean", 1, 0, NULL, true, 10, NULL ] 1976
2020 [ "storagemodelinput", "isacolumn", "boolean", 1, 0, "true", false, 11, NULL ] 2020 ! 1977 [ "storagemodelinput", "unique", "boolean", 1, 0, NULL, true, 11, NULL ] 1977
+ 1978 [ "storagemodelinput", "orderidx", "bigint", 64, 0, NULL, true, 12, NULL ] 1978
2021 [ "systemfunctions", "function_id", "int", 32, 0, NULL, true, 0, NULL ] 2021 1979 [ "systemfunctions", "function_id", "int", 32, 0, NULL, true, 0, NULL ] 1979
..................
#select t.name, c.name, c.type, c.type_d
2037 [ "tables", "temporary", "smallint", 16, 0, NULL, true, 8, NULL ] 2037 1995 [ "tables", "temporary", "smallint", 16, 0, NULL, true, 8, NULL ] 1995
2038 [ "tablestorage", "schema", "varchar", 1024, 0, NULL, true, 0, NULL ] 2038 ! 1996 [ "tablestoragemodel", "schema", "clob", 0, 0, NULL, true, 0, NULL ] 1996
2039 [ "tablestorage", "table", "varchar", 1024, 0, NULL, true, 1, NULL ] 2039 ! 1997 [ "tablestoragemodel", "table", "clob", 0, 0, NULL, true, 1, NULL ] 1997
2040 [ "tablestorage", "rowcount", "bigint", 64, 0, NULL, true, 2, NULL ] 2040 ! 1998 [ "tablestoragemodel", "count", "bigint", 64, 0, NULL, true, 2, NULL ] 1998
2041 [ "tablestorage", "storages", "bigint", 64, 0, NULL, true, 3, NULL ] 2041 ! 1999 [ "tablestoragemodel", "columnsize", "bigint", 64, 0, NULL, true, 3, NULL ] 1999
2042 [ "tablestorage", "columnsize", "bigint", 64, 0, NULL, true, 4, NULL ] 2042 ! 2000 [ "tablestoragemodel", "heapsize", "bigint", 64, 0, NULL, true, 4, NULL ] 2000
2043 [ "tablestorage", "heapsize", "bigint", 64, 0, NULL, true, 5, NULL ] 2043 ! 2001 [ "tablestoragemodel", "hashes", "bigint", 64, 0, NULL, true, 5, NULL ] 2001
2044 [ "tablestorage", "hashsize", "bigint", 64, 0, NULL, true, 6, NULL ] 2044 ! 2002 [ "tablestoragemodel", "imprints", "bigint", 64, 0, NULL, true, 6, NULL ] 2002
2045 [ "tablestorage", "imprintsize", "bigint", 64, 0, NULL, true, 7, NULL ] 2045 ! 2003 [ "tablestoragemodel", "auxiliary", "hugeint", 128, 0, NULL, true, 7, NULL ] 2003
2046 [ "tablestorage", "orderidxsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2046 -
2047 [ "tablestoragemodel", "schema", "varchar", 1024, 0, NULL, true, 0, NULL ] 2047 -
2048 [ "tablestoragemodel", "table", "varchar", 1024, 0, NULL, true, 1, NULL ] 2048 -
2049 [ "tablestoragemodel", "rowcount", "bigint", 64, 0, NULL, true, 2, NULL ] 2049 -
2050 [ "tablestoragemodel", "storages", "bigint", 64, 0, NULL, true, 3, NULL ] 2050 -
2051 [ "tablestoragemodel", "columnsize", "bigint", 64, 0, NULL, true, 4, NULL ] 2051 -
2052 [ "tablestoragemodel", "heapsize", "bigint", 64, 0, NULL, true, 5, NULL ] 2052 -
2053 [ "tablestoragemodel", "hashsize", "bigint", 64, 0, NULL, true, 6, NULL ] 2053 -
2054 [ "tablestoragemodel", "imprintsize", "bigint", 64, 0, NULL, true, 7, NULL ] 2054 -
2055 [ "tablestoragemodel", "orderidxsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2055 -
2056 [ "tracelog", "event", "int", 32, 0, NULL, true, 0, NULL ] 2056 2004 [ "tracelog", "event", "int", 32, 0, NULL, true, 0, NULL ] 2004
..................
# .s, .f, .L4, .L6, .f,
2131 % varchar, varchar, char, varchar, varchar, varchar, varchar, boolean, boolean, boolean, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char, varchar, varchar, int, int, char # type 2131 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
2132 % 8, 24, 6, 1362, 9, 10, 26, 5, 5, 5, 11, 14, 4, 1, 3, 16, 14, 4, 1, 3, 16, 14, 4, 1, 3, 27, 12, 4, 1, 3, 12, 7, 2, 1, 3, 10, 14, 4, 1, 3, 8, 14, 3, 1, 3, 9, 6, 2, 1, 3, 10, 6, 2, 1, 3, 8, 6, 2, 1, 3, 6, 6, 2, 1, 3, 6, 7, 2, 1, 3, 8, 6, 2, 1, 3, 6, 7, 1, 1, 3, 9, 7, 1, 1, 3, 6, 7, 1, 1, 3 # length 2132 ! 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
2133 [ "bam", "bam_drop_file", "SYSTEM", "create procedure bam.bam_drop_file(file_id bigint, dbschema smallint) external name bam.bam_drop_file;", "bam", "MAL", "Procedure", true, false, false, "file_id", "bigint", 64, 0, "in", "dbschema", "smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2133 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,
2218 [ "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 ] 2218 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
2219 [ "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 ] 2219 -
2220 [ "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 ] 2220 -
2221 [ "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 ] 2221 -
2222 [ "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 ] 2222 -
2223 [ "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 ] 2223 -
2224 [ "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 ] 2224 -
2225 [ "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 ] 2225 -
2226 [ "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 ] 2226 -
2227 [ "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 ] 2227 -
2228 [ "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 ] 2228 -
2229 [ "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 ] 2229 -
2230 [ "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 ] 2230 -
2231 [ "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 ] 2231 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,
2296 [ "sys", "code", "SYSTEM", "unicode", "str", "Internal C", "Scalar function", false, false, false, "res_0", "varchar", 0, 0, "out", "arg_1", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2296 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
2297 [ "sys", "columnsize", "SYSTEM", "create function sys.columnsize(tpe varchar(1024), count bigint) returns bigint begin if tpe in ('tinyint', 'boolean') then return count; end if; if tpe = 'smallint' then return 2 * count; end if; if tpe in ('int', 'real', 'date', 'time', 'timetz', 'sec_interval', 'month_interval') then return 4 * count; end if; if tpe in ('bigint', 'double', 'timestamp', 'timestamptz', 'inet', 'oid') then return 8 * count; end if; if tpe in ('hugeint', 'decimal', 'uuid', 'mbr') then return 16 * count; end if; if tpe in ('varchar', 'char', 'clob', 'json', 'url') then return 4 * count; end if; if tpe in ('blob', 'geometry', 'geometrya') then return 8 * count; end if; return 8 * count; end;", "user", "SQL", "Scalar function", false, false, false, "result", "bigint", 64, 0, "out", "tpe", "varchar", 1024, 0, "in", "count", "bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2297 ! 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
2298 [ "sys", "concat", "SYSTEM", "+", "calc", "Internal C", "Scalar function", false, false, false, "res_0", "char", 0, 0, "out", "arg_1", "char", 0, 0, "in", "arg_2", "char", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2298 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,
2301 [ "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 ] 2301 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
2302 [ "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 ] 2302 ! 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
2303 [ "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 ] 2303 ! 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
2304 [ "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 ] 2304 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,
2317 [ "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 ] 2317 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
2318 [ "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 ] 2318 -
2319 [ "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 ] 2319 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
2320 [ "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 ] 2320 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
2321 [ "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 ] 2321 -
2322 [ "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 ] 2322 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,
2359 [ "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 ] 2359 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
2360 [ "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 ] 2360 -
2361 [ "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 ] 2361 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,
2369 [ "sys", "fuse", "SYSTEM", "create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse;", "udf", "MAL", "Scalar function", false, false, false, "result", "smallint", 16, 0, "out", "one", "tinyint", 8, 0, "in", "two", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2369 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
2370 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first bigint, \"limit\" bigint) returns table (value bigint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "bigint", 64, 0, "out", "first", "bigint", 64, 0, "in", "limit", "bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2370 ! 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
2371 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first bigint, \"limit\" bigint, stepsize bigint) returns table (value bigint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "bigint", 64, 0, "out", "first", "bigint", 64, 0, "in", "limit", "bigint", 64, 0, "in", "stepsize", "bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2371 ! 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
2372 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first decimal(10,2), \"limit\" decimal(10,2), stepsize decimal(10,2)) returns table (value decimal(10,2)) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "decimal", 10, 2, "out", "first", "decimal", 10, 2, "in", "limit", "decimal", 10, 2, "in", "stepsize", "decimal", 10, 2, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2372 ! 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
2373 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first double, \"limit\" double, stepsize double) returns table (value double) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "double", 53, 0, "out", "first", "double", 53, 0, "in", "limit", "double", 53, 0, "in", "stepsize", "double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2373 ! 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
2374 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first hugeint, \"limit\" hugeint) returns table (value hugeint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "hugeint", 128, 0, "out", "first", "hugeint", 128, 0, "in", "limit", "hugeint", 128, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2374 ! 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
2375 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first hugeint, \"limit\" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "hugeint", 128, 0, "out", "first", "hugeint", 128, 0, "in", "limit", "hugeint", 128, 0, "in", "stepsize", "hugeint", 128, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2375 ! 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
2376 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first int, \"limit\" int) returns table (value int) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "int", 32, 0, "out", "first", "int", 32, 0, "in", "limit", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2376 ! 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
2377 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first int, \"limit\" int, stepsize int) returns table (value int) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "int", 32, 0, "out", "first", "int", 32, 0, "in", "limit", "int", 32, 0, "in", "stepsize", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2377 ! 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
2378 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first real, \"limit\" real, stepsize real) returns table (value real) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "real", 24, 0, "out", "first", "real", 24, 0, "in", "limit", "real", 24, 0, "in", "stepsize", "real", 24, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2378 ! 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
2379 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first smallint, \"limit\" smallint) returns table (value smallint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "smallint", 16, 0, "out", "first", "smallint", 16, 0, "in", "limit", "smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2379 ! 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
2380 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first smallint, \"limit\" smallint, stepsize smallint) returns table (value smallint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "smallint", 16, 0, "out", "first", "smallint", 16, 0, "in", "limit", "smallint", 16, 0, "in", "stepsize", "smallint", 16, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2380 ! 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
2381 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first timestamp, \"limit\" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "timestamp", 7, 0, "out", "first", "timestamp", 7, 0, "in", "limit", "timestamp", 7, 0, "in", "stepsize", "sec_interval", 13, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2381 ! 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
2382 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first tinyint, \"limit\" tinyint) returns table (value tinyint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "tinyint", 8, 0, "out", "first", "tinyint", 8, 0, "in", "limit", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2382 ! 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
2383 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first tinyint, \"limit\" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "tinyint", 8, 0, "out", "first", "tinyint", 8, 0, "in", "limit", "tinyint", 8, 0, "in", "stepsize", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2383 ! 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
2384 [ "sys", "geometrytype", "SYSTEM", "create function geometrytype(geom geometry) returns string external name geom.\"GeometryType1\";", "geom", "MAL", "Scalar function", false, false, false, "result", "clob", 0, 0, "out", "geom", "geometry", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2384 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,
2405 [ "sys", "hash", "SYSTEM", "hash", "mkey", "Internal C", "Scalar function", false, false, false, "res_0", "bigint", 64, 0, "out", "arg_1", "any", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2405 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
2406 [ "sys", "hashsize", "SYSTEM", "create function sys.hashsize(b boolean, count bigint) returns bigint begin if b = true then return 8 * count; end if; return 0; end;", "user", "SQL", "Scalar function", false, false, false, "result", "bigint", 64, 0, "out", "b", "boolean", 1, 0, "in", "count", "bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2406 ! 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
2407 [ "sys", "heapsize", "SYSTEM", "create function sys.heapsize(tpe varchar(1024), count bigint, distincts bigint, avgwidth int) returns bigint begin if tpe in ('varchar', 'char', 'clob', 'json', 'url') then return 8192 + ((avgwidth + 8) * distincts); end if; if tpe in ('blob', 'geometry', 'geometrya') then return 32 + (avgwidth * count); end if; return 0; end;", "user", "SQL", "Scalar function", false, false, false, "result", "bigint", 64, 0, "out", "tpe", "varchar", 1024, 0, "in", "count", "bigint", 64, 0, "in", "distincts", "bigint", 64, 0, "in", "avgwidth", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2407 ! 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
2408 [ "sys", "host", "SYSTEM", "create function \"host\" (p inet) returns clob external name inet.\"host\";", "inet", "MAL", "Scalar function", false, false, false, "result", "clob", 0, 0, "out", "p", "inet", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2408 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,
2418 [ "sys", "ilike", "SYSTEM", "create filter function \"ilike\"(val string, pat string, esc string) external name algebra.\"ilike\";", "algebra", "MAL", "Filter function", false, false, false, "val", "clob", 0, 0, "in", "pat", "clob", 0, 0, "in", "esc", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2418 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
2419 [ "sys", "imprintsize", "SYSTEM", "create function sys.imprintsize(tpe varchar(1024), count bigint) returns bigint begin if tpe in ('tinyint', 'boolean') then return cast(0.2 * count as bigint); end if; if tpe = 'smallint' then return cast(0.4 * count as bigint); end if; if tpe in ('int', 'real', 'date', 'time', 'timetz', 'sec_interval', 'month_interval') then return cast(0.8 * count as bigint); end if; if tpe in ('bigint', 'double', 'timestamp', 'timestamptz', 'inet', 'oid') then return cast(1.6 * count as bigint); end if; if tpe in ('hugeint', 'decimal', 'uuid', 'mbr') then return cast(3.2 * count as bigint); end if; return 0; end;", "user", "SQL", "Scalar function", false, false, false, "result", "bigint", 64, 0, "out", "tpe", "varchar", 1024, 0, "in", "count", "bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2419 ! 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
2420 [ "sys", "in", "SYSTEM", "in", "calc", "Internal C", "Scalar function", false, false, false, "res_0", "boolean", 1, 0, "out", "arg_1", "any", 0, 0, "in", "arg_2", "any", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2420 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,
2436 [ "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 ] 2436 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
2437 [ "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 ] 2437 -
2438 [ "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 ] 2438 -
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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 2447 -
2448 [ "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 ] 2448 -
2449 [ "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 ] 2449 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,
2451 [ "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 ] 2451 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
2452 [ "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 ] 2452 -
2453 [ "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 ] 2453 -
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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 2462 -
2463 [ "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 ] 2463 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,
2489 [ "sys", "levenshtein", "SYSTEM", "levenshtein", "txtsim", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "varchar", 0, 0, "in", "arg_2", "varchar", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2489 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
2490 [ "sys", "lidarattach", "SYSTEM", "create procedure lidarattach(fname string) external name lidar.attach;", "lidar", "MAL", "Procedure", true, false, false, "fname", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2490 -
2491 [ "sys", "lidarexport", "SYSTEM", "create procedure lidarexport(tname string, fname string, format string) external name lidar.export;", "lidar", "MAL", "Procedure", true, false, false, "tname", "clob", 0, 0, "in", "fname", "clob", 0, 0, "in", "format", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2491 -
2492 [ "sys", "lidarload", "SYSTEM", "create procedure lidarload(tname string) external name lidar.load;", "lidar", "MAL", "Procedure", true, false, false, "tname", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2492 -
2493 [ "sys", "like", "SYSTEM", "create filter function \"like\"(val string, pat string) external name algebra.\"like\";", "algebra", "MAL", "Filter function", false, false, false, "val", "clob", 0, 0, "in", "pat", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2493 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,
2532 [ "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 ] 2532 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
2533 [ "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 ] 2533 -
2534 [ "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 ] 2534 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,
2573 [ "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 ] 2573 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
2574 [ "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 ] 2574 -
2575 [ "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 ] 2575 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,
2624 [ "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 ] 2624 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
2625 [ "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 ] 2625 -
2626 [ "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 ] 2626 -
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", "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 ] 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", "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 ] 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", "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 ] 2629 -
2630 [ "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 ] 2630 -
2631 [ "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 ] 2631 -
2632 [ "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 ] 2632 -
2633 [ "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 ] 2633 -
2634 [ "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 ] 2634 -
2635 [ "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 ] 2635 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,
2647 [ "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 ] 2647 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
2648 [ "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 ] 2648 -
2649 [ "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 ] 2649 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,
2663 [ "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 ] 2663 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
2664 [ "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 ] 2664 -
2665 [ "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 ] 2665 -
2666 [ "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 ] 2666 -
2667 [ "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 ] 2667 -
2668 [ "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 ] 2668 -
2669 [ "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 ] 2669 -
2670 [ "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 ] 2670 -
2671 [ "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 ] 2671 -
2672 [ "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 ] 2672 -
2673 [ "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 ] 2673 -
2674 [ "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 ] 2674 -
2675 [ "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 ] 2675 -
2676 [ "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 ] 2676 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,
3386 [ "sys", "settimeout", "SYSTEM", "create procedure sys.settimeout(\"query\" bigint, \"session\" bigint) external name clients.settimeout;", "clients", "MAL", "Procedure", true, false, false, "query", "bigint", 64, 0, "in", "session", "bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3386 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
3387 [ "sys", "shpattach", "SYSTEM", "create procedure shpattach(fname string) external name shp.attach;", "shp", "MAL", "Procedure", true, false, false, "fname", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3387 -
3388 [ "sys", "shpload", "SYSTEM", "create procedure shpload(fid integer) external name shp.import;", "shp", "MAL", "Procedure", true, false, false, "fid", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3388 -
3389 [ "sys", "shpload", "SYSTEM", "create procedure shpload(fid integer, filter geometry) external name shp.import;", "shp", "MAL", "Procedure", true, false, false, "fid", "int", 32, 0, "in", "filter", "geometry", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3389 -
3390 [ "sys", "shrink", "SYSTEM", "create procedure shrink(sys string, tab string) external name sql.shrink;", "sql", "MAL", "Procedure", true, false, false, "sys", "clob", 0, 0, "in", "tab", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3390 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,
3851 [ "sys", "stopmaster", "SYSTEM", "create procedure stopmaster() external name wlc.stopmaster;", "wlc", "MAL", "Procedure", true, false, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3851 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
3852 [ "sys", "storage", "SYSTEM", "create function sys.\"storage\"() returns table (\"schema\" varchar(1024), \"table\" varchar(1024), \"column\" varchar(1024), \"type\" varchar(1024), \"mode\" varchar(15), location varchar(1024), \"count\" bigint, typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash boolean, \"imprints\" bigint, sorted boolean, revsorted boolean, \"unique\" boolean, orderidx bigint) external name sql.\"storage\";", "sql", "MAL", "Function returning a table", false, false, false, "schema", "varchar", 1024, 0, "out", "table", "varchar", 1024, 0, "out", "column", "varchar", 1024, 0, "out", "type", "varchar", 1024, 0, "out", "mode", "varchar", 15, 0, "out", "location", "varchar", 1024, 0, "out", "count", "bigint", 64, 0, "out", "typewidth", "int", 32, 0, "out", "columnsize", "bigint", 64, 0, "out", "heapsize", "bigint", 64, 0, "out", "hashes", "bigint", 64, 0, "out", "phash", "boolean", 1, 0, "out", "imprints", "bigint", 64, 0, "out", "sorted", "boolean", 1, 0, "out", "revsorted", "boolean", 1, 0, "out", "unique", "boolean", 1, 0, "out" ] 3852 ! 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
3853 [ "sys", "storage", "SYSTEM", "create function sys.\"storage\"(sname varchar(1024)) returns table (\"schema\" varchar(1024), \"table\" varchar(1024), \"column\" varchar(1024), \"type\" varchar(1024), \"mode\" varchar(15), location varchar(1024), \"count\" bigint, typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash boolean, \"imprints\" bigint, sorted boolean, revsorted boolean, \"unique\" boolean, orderidx bigint) external name sql.\"storage\";", "sql", "MAL", "Function returning a table", false, false, false, "schema", "varchar", 1024, 0, "out", "table", "varchar", 1024, 0, "out", "column", "varchar", 1024, 0, "out", "type", "varchar", 1024, 0, "out", "mode", "varchar", 15, 0, "out", "location", "varchar", 1024, 0, "out", "count", "bigint", 64, 0, "out", "typewidth", "int", 32, 0, "out", "columnsize", "bigint", 64, 0, "out", "heapsize", "bigint", 64, 0, "out", "hashes", "bigint", 64, 0, "out", "phash", "boolean", 1, 0, "out", "imprints", "bigint", 64, 0, "out", "sorted", "boolean", 1, 0, "out", "revsorted", "boolean", 1, 0, "out", "unique", "boolean", 1, 0, "out" ] 3853 ! 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
3854 [ "sys", "storage", "SYSTEM", "create function sys.\"storage\"(sname varchar(1024), tname varchar(1024)) returns table (\"schema\" varchar(1024), \"table\" varchar(1024), \"column\" varchar(1024), \"type\" varchar(1024), \"mode\" varchar(15), location varchar(1024), \"count\" bigint, typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash boolean, \"imprints\" bigint, sorted boolean, revsorted boolean, \"unique\" boolean, orderidx bigint) external name sql.\"storage\";", "sql", "MAL", "Function returning a table", false, false, false, "schema", "varchar", 1024, 0, "out", "table", "varchar", 1024, 0, "out", "column", "varchar", 1024, 0, "out", "type", "varchar", 1024, 0, "out", "mode", "varchar", 15, 0, "out", "location", "varchar", 1024, 0, "out", "count", "bigint", 64, 0, "out", "typewidth", "int", 32, 0, "out", "columnsize", "bigint", 64, 0, "out", "heapsize", "bigint", 64, 0, "out", "hashes", "bigint", 64, 0, "out", "phash", "boolean", 1, 0, "out", "imprints", "bigint", 64, 0, "out", "sorted", "boolean", 1, 0, "out", "revsorted", "boolean", 1, 0, "out", "unique", "boolean", 1, 0, "out" ] 3854 ! 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
3855 [ "sys", "storage", "SYSTEM", "create function sys.\"storage\"(sname varchar(1024), tname varchar(1024), cname varchar(1024)) returns table (\"schema\" varchar(1024), \"table\" varchar(1024), \"column\" varchar(1024), \"type\" varchar(1024), \"mode\" varchar(15), location varchar(1024), \"count\" bigint, typewidth int, columnsize bigint, heapsize bigint, hashes bigint, phash boolean, \"imprints\" bigint, sorted boolean, revsorted boolean, \"unique\" boolean, orderidx bigint) external name sql.\"storage\";", "sql", "MAL", "Function returning a table", false, false, false, "schema", "varchar", 1024, 0, "out", "table", "varchar", 1024, 0, "out", "column", "varchar", 1024, 0, "out", "type", "varchar", 1024, 0, "out", "mode", "varchar", 15, 0, "out", "location", "varchar", 1024, 0, "out", "count", "bigint", 64, 0, "out", "typewidth", "int", 32, 0, "out", "columnsize", "bigint", 64, 0, "out", "heapsize", "bigint", 64, 0, "out", "hashes", "bigint", 64, 0, "out", "phash", "boolean", 1, 0, "out", "imprints", "bigint", 64, 0, "out", "sorted", "boolean", 1, 0, "out", "revsorted", "boolean", 1, 0, "out", "unique", "boolean", 1, 0, "out" ] 3855 ! 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\", case when (\"unique\" or \"type\" in ('varchar', 'char', 'clob', 'json', 'url', 'blob', 'geometry', 'geometrya')) then \"count\" else 0 end, case when \"count\" > 0 and heapsize >= 8192 and \"type\" in ('varchar', 'char', 'clob', 'json', 'url') then cast((heapsize - 8192) / \"count\" as bigint) when \"count\" > 0 and heapsize >= 32 and \"type\" in ('blob', + 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
3856 'geometry', 'geometrya') then cast((heapsize - 32) / \"count\" as bigint) else typewidth end, false, case sorted when true then true else false end, \"unique\", true from sys.\"storage\"; update sys.storagemodelinput set reference = true where (\"schema\", \"table\", \"column\") in (select fkschema.\"name\", fktable.\"name\", fkkeycol.\"name\" from sys.\"keys\" as fkkey, sys.\"objects\" as fkkeycol, sys.\"tables\" as fktable, sys.\"schemas\" as fkschema where fktable.\"id\" = fkkey.\"table_id\" and fkkey.\"id\" = fkkeycol.\"id\" and fkschema.\"id\" = fktable.\"schema_id\" and fkkey.\"rkey\" > -1); update sys.storagemodelinput set isacolumn = false where (\"schema\", \"table\", \"column\") not in (select sch.\"name\", tbl.\"name\", col.\"name\" from sys.\"schemas\" as sch, sys.\"tables\" as tbl, sys.\"columns\" as col where sch.\"id\" = tbl.\"schema_id\" and tbl.\"id\" = col.\"table_id\"); end;", "user", "SQL", "Procedure", true, false, false, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3856 ! 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
3857 [ "sys", "str_to_date", "SYSTEM", "create function str_to_date(s string, format string) returns date external name mtime.\"str_to_date\";", "mtime", "MAL", "Scalar function", false, false, false, "result", "date", 0, 0, "out", "s", "clob", 0, 0, "in", "format", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3857 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,
3888 [ "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 ] 3888 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
3889 [ "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 ] 3889 -
3890 [ "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 ] 3890 -
3891 [ "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 ] 3891 -
3892 [ "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 ] 3892 -
3893 [ "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 ] 3893 -
3894 [ "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 ] 3894 -
3895 [ "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 ] 3895 -
3896 [ "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 ] 3896 -
3897 [ "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 ] 3897 -
3898 [ "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 ] 3898 -
3899 [ "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 ] 3899 -
3900 [ "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 ] 3900 -
3901 [ "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 ] 3901 -
3902 [ "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 ] 3902 -
3903 [ "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 ] 3903 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,
3953 [ "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 ] 3953 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
3954 [ "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 ] 3954 -
3955 [ "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 ] 3955 -
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", "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 ] 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", 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 ] 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", 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 ] 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", 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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 3967 -
3968 [ "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 ] 3968 -
3969 [ "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 ] 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", "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 ] 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", 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 ] 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", 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 ] 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", 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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 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", "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 ] 3981 -
3982 [ "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 ] 3982 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
4036 % 3, 17, 3, 13, 8 # length 4036 3874 % 3, 17, 3, 13, 8 # length 3874
+ 3875 [ "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3875
4037 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4037 3876 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3876
..................
#select s1.name, f1.name, s2.name, f2.na
4041 [ "sys", "st_srid", "sys", "st_transform", "FUNCTION" ] 4041 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
4042 #select s1.name, t.name, s2.name, f.name, dt.dependency_type_name from sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = dt.dependency_type_id, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2 where d.id = t.id and d.depend_id = f.id and t.schema_id = s1.id and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name; 4042 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
4047 [ "sys", "spatial_ref_sys", "sys", "getproj4", "FUNCTION" ] 4047 3890 [ "sys", "spatial_ref_sys", "sys", "getproj4", "FUNCTION" ] 3890
4048 [ "sys", "columns", "sys", "storagemodelinit", "PROCEDURE" ] 4048 ! 3891 [ "sys", "storagemodelinput", "sys", "storagemodel", "FUNCTION" ] 3891
4049 [ "sys", "keys", "sys", "storagemodelinit", "PROCEDURE" ] 4049 3892 [ "sys", "keys", "sys", "storagemodelinit", "PROCEDURE" ] 3892
..................
#select s1.name, t.name, s2.name, f.name
4051 [ "sys", "schemas", "sys", "storagemodelinit", "PROCEDURE" ] 4051 3894 [ "sys", "schemas", "sys", "storagemodelinit", "PROCEDURE" ] 3894
4052 [ "sys", "storage", "sys", "storagemodelinit", "PROCEDURE" ] 4052 -
4053 [ "sys", "storagemodelinput", "sys", "storagemodelinit", "PROCEDURE" ] 4053 3895 [ "sys", "storagemodelinput", "sys", "storagemodelinit", "PROCEDURE" ] 3895
..................
#select s1.name, t.name, c.name, s2.name
4059 % 3, 17, 13, 3, 16, 9 # length 4059 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
4060 [ "sys", "spatial_ref_sys", "auth_name", "sys", "getproj4", "FUNCTION" ] 4060 ! 3904 [ "sys", "storagemodelinput", "atomwidth", "sys", "storagemodel", "FUNCTION" ] 3904
4061 [ "sys", "spatial_ref_sys", "auth_srid", "sys", "getproj4", "FUNCTION" ] 4061 ! 3905 [ "sys", "storagemodelinput", "column", "sys", "storagemodel", "FUNCTION" ] 3905
4062 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 4062 -
4063 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 4063 -
4064 [ "sys", "spatial_ref_sys", "srtext", "sys", "getproj4", "FUNCTION" ] 4064 ! 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
4065 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 4065 3917 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 3917
..................
#select s1.name, t.name, c.name, s2.name
4082 [ "sys", "storagemodelinput", "distinct", "sys", "storagemodelinit", "PROCEDURE" ] 4082 3934 [ "sys", "storagemodelinput", "distinct", "sys", "storagemodelinit", "PROCEDURE" ] 3934
4083 [ "sys", "storagemodelinput", "isacolumn", "sys", "storagemodelinit", "PROCEDURE" ] 4083 ! 3935 [ "sys", "storagemodelinput", "orderidx", "sys", "storagemodelinit", "PROCEDURE" ] 3935
4084 [ "sys", "storagemodelinput", "reference", "sys", "storagemodelinit", "PROCEDURE" ] 4084 3936 [ "sys", "storagemodelinput", "reference", "sys", "storagemodelinit", "PROCEDURE" ] 3936
+ 3937 [ "sys", "storagemodelinput", "revsorted", "sys", "storagemodelinit", "PROCEDURE" ] 3937
4085 [ "sys", "storagemodelinput", "schema", "sys", "storagemodelinit", "PROCEDURE" ] 4085 3938 [ "sys", "storagemodelinput", "schema", "sys", "storagemodelinit", "PROCEDURE" ] 3938
..................
#select s1.name, f1.name, s2.name, t2.na
4094 % varchar, varchar, varchar, varchar, varchar # type 4094 3947 % varchar, varchar, varchar, varchar, varchar # type 3947
4095 % 3, 11, 3, 17, 4 # length 4095 ! 3948 % 3, 16, 3, 16, 4 # length 3948
4096 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 4096 3949 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 3949
..................
#select s1.name, f1.name, s2.name, t2.na
4098 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 4098 3951 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 3951
4099 [ "sys", "columnsize", "sys", "storagemodel", "VIEW" ] 4099 ! 3952 [ "sys", "optimizers", "sys", "optimizers", "VIEW" ] 3952
4100 [ "sys", "hashsize", "sys", "storagemodel", "VIEW" ] 4100 ! 3953 [ "sys", "querylog_catalog", "sys", "querylog_catalog", "VIEW" ] 3953
4101 [ "sys", "heapsize", "sys", "storagemodel", "VIEW" ] 4101 ! 3954 [ "sys", "queue", "sys", "queue", "VIEW" ] 3954
4102 [ "sys", "imprintsize", "sys", "storagemodel", "VIEW" ] 4102 ! 3955 [ "sys", "rejects", "sys", "rejects", "VIEW" ] 3955
4103 [ "sys", "columnsize", "sys", "tablestoragemodel", "VIEW" ] 4103 ! 3956 [ "sys", "sessions", "sys", "sessions", "VIEW" ] 3956
4104 [ "sys", "hashsize", "sys", "tablestoragemodel", "VIEW" ] 4104 ! 3957 [ "sys", "tracelog", "sys", "tracelog", "VIEW" ] 3957
4105 [ "sys", "heapsize", "sys", "tablestoragemodel", "VIEW" ] 4105 -
4106 [ "sys", "imprintsize", "sys", "tablestoragemodel", "VIEW" ] 4106 -
4107 #select s1.name, t1.name, s2.name, t2.name, dt.dependency_type_name from sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = dt.dependency_type_id, schemas s1, _tables t1, schemas s2, _tables t2 where d.id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, t1.name; 4107 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
4110 % varchar, varchar, varchar, varchar, varchar # type 4110 3961 % varchar, varchar, varchar, varchar, varchar # type 3961
4111 % 3, 17, 3, 34, 4 # length 4111 ! 3962 % 3, 16, 3, 34, 4 # length 3962
4112 [ "sys", "dependencies", "sys", "dependencies_vw", "VIEW" ] 4112 3963 [ "sys", "dependencies", "sys", "dependencies_vw", "VIEW" ] 3963
..................
#select s1.name, t1.name, s2.name, t2.na
4122 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 4122 3973 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 3973
4123 [ "sys", "idxs", "sys", "dependency_columns_on_indexes", "VIEW" ] 4123 -
4124 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 4124 3974 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 3974
4125 [ "sys", "objects", "sys", "dependency_columns_on_indexes", "VIEW" ] 4125 -
4126 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 4126 3975 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 3975
4127 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 4127 3976 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 3976
4128 [ "sys", "keys", "sys", "dependency_columns_on_keys", "VIEW" ] 4128 -
4129 [ "sys", "objects", "sys", "dependency_columns_on_keys", "VIEW" ] 4129 -
4130 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 4130 3977 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 3977
..................
#select s1.name, t1.name, s2.name, t2.na
4136 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 4136 3983 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 3983
4137 [ "sys", "triggers", "sys", "dependency_columns_on_triggers", "VIEW" ] 4137 -
4138 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 4138 3984 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 3984
..................
#select s1.name, t1.name, s2.name, t2.na
4150 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 4150 3996 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 3996
4151 [ "sys", "triggers", "sys", "dependency_functions_on_triggers", "VIEW" ] 4151 -
4152 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 4152 3997 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 3997
..................
#select s1.name, t1.name, s2.name, t2.na
4157 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 4157 4002 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 4002
4158 [ "sys", "keys", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4158 -
4159 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 4159 4003 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 4003
..................
#select s1.name, t1.name, s2.name, t2.na
4162 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 4162 4006 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 4006
4163 [ "sys", "keys", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4163 -
4164 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4164 4007 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4007
..................
#select s1.name, t1.name, s2.name, t2.na
4167 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 4167 4010 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 4010
4168 [ "sys", "idxs", "sys", "dependency_tables_on_indexes", "VIEW" ] 4168 -
4169 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 4169 4011 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 4011
..................
#select s1.name, t1.name, s2.name, t2.na
4175 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4175 4017 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4017
4176 [ "sys", "triggers", "sys", "dependency_tables_on_triggers", "VIEW" ] 4176 -
4177 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4177 4018 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4018
..................
#select s1.name, t1.name, s2.name, t2.na
4190 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4190 4031 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4031
4191 [ "sys", "_columns", "sys", "ids", "VIEW" ] 4191 -
4192 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4192 4032 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4032
..................
#select s1.name, t1.name, s2.name, t2.na
4195 [ "sys", "functions", "sys", "ids", "VIEW" ] 4195 4035 [ "sys", "functions", "sys", "ids", "VIEW" ] 4035
4196 [ "sys", "idxs", "sys", "ids", "VIEW" ] 4196 -
4197 [ "sys", "keys", "sys", "ids", "VIEW" ] 4197 4036 [ "sys", "keys", "sys", "ids", "VIEW" ] 4036
..................
#select s1.name, t1.name, s2.name, t2.na
4199 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4199 4038 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4038
4200 [ "sys", "triggers", "sys", "ids", "VIEW" ] 4200 -
4201 [ "sys", "types", "sys", "ids", "VIEW" ] 4201 4039 [ "sys", "types", "sys", "ids", "VIEW" ] 4039
4202 [ "tmp", "_columns", "sys", "ids", "VIEW" ] 4202 -
4203 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4203 4040 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4040
4204 [ "tmp", "idxs", "sys", "ids", "VIEW" ] 4204 -
4205 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4205 4041 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4041
4206 [ "tmp", "triggers", "sys", "ids", "VIEW" ] 4206 -
4207 [ "sys", "auths", "sys", "roles", "VIEW" ] 4207 4042 [ "sys", "auths", "sys", "roles", "VIEW" ] 4042
4208 [ "sys", "storage", "sys", "schemastorage", "VIEW" ] 4208 -
4209 [ "sys", "schemas", "sys", "storage", "VIEW" ] 4209 -
4210 [ "sys", "tables", "sys", "storage", "VIEW" ] 4210 -
4211 [ "sys", "storagemodelinput", "sys", "storagemodel", "VIEW" ] 4211 -
4212 [ "sys", "functions", "sys", "systemfunctions", "VIEW" ] 4212 4043 [ "sys", "functions", "sys", "systemfunctions", "VIEW" ] 4043
4213 [ "sys", "storage", "sys", "tablestorage", "VIEW" ] 4213 -
4214 [ "sys", "storagemodelinput", "sys", "tablestoragemodel", "VIEW" ] 4214 -
4215 #select s1.name, t1.name, c1.name, s2.name, t2.name, dt.dependency_type_name from sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = dt.dependency_type_id, schemas s1, _tables t1, _columns c1, schemas s2, _tables t2 where d.id = c1.id and c1.table_id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, t1.name, c1.name; 4215 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
4218 % varchar, varchar, varchar, varchar, varchar, varchar # type 4218 4047 % varchar, varchar, varchar, varchar, varchar, varchar # type 4047
4219 % 3, 17, 20, 3, 34, 4 # length 4219 ! 4048 % 3, 16, 20, 3, 34, 4 # length 4048
4220 [ "sys", "dependencies", "depend_id", "sys", "dependencies_vw", "VIEW" ] 4220 4049 [ "sys", "dependencies", "depend_id", "sys", "dependencies_vw", "VIEW" ] 4049
..................
#select s1.name, t1.name, c1.name, s2.na
4241 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4241 4070 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4070
4242 [ "sys", "idxs", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4242 ! 4071 [ "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4071
4243 [ "sys", "idxs", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4243 ! 4072 [ "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4072
4244 [ "sys", "idxs", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4244 ! 4073 [ "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4073
4245 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4245 ! 4074 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4074
4246 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4246 ! 4075 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4075
+ 4076 [ "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4076
4247 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4247 4077 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4077
4248 [ "sys", "objects", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4248 ! 4078 [ "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4078
4249 [ "sys", "objects", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4249 ! 4079 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4079
4250 [ "sys", "objects", "nr", "sys", "dependency_columns_on_indexes", "VIEW" ] 4250 ! 4080 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4080
4251 [ "sys", "keys", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4251 ! 4081 [ "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4081
4252 [ "sys", "keys", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4252 ! 4082 [ "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4082
4253 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4253 ! 4083 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4083
4254 [ "sys", "keys", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4254 ! 4084 [ "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4084
4255 [ "sys", "objects", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4255 ! 4085 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4085
4256 [ "sys", "objects", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4256 ! 4086 [ "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4086
4257 [ "sys", "objects", "nr", "sys", "dependency_columns_on_keys", "VIEW" ] 4257 ! 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
4258 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4258 4091 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4091
..................
#select s1.name, t1.name, c1.name, s2.na
4266 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4266 4099 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4099
4267 [ "sys", "triggers", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4267 ! 4100 [ "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4100
4268 [ "sys", "triggers", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4268 ! 4101 [ "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4101
+ 4102 [ "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4102
4269 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4269 4103 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4103
..................
#select s1.name, t1.name, c1.name, s2.na
4297 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4297 4131 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4131
4298 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4298 ! 4132 [ "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4132
4299 [ "sys", "triggers", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4299 ! 4133 [ "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4133
4300 [ "sys", "triggers", "table_id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4300 ! 4134 [ "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4134
+ 4135 [ "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4135
4301 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4301 4136 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4136
..................
#select s1.name, t1.name, c1.name, s2.na
4314 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4314 4149 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4149
4315 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4315 ! 4150 [ "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4150
4316 [ "sys", "keys", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4316 ! 4151 [ "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4151
4317 [ "sys", "keys", "rkey", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4317 ! 4152 [ "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4152
4318 [ "sys", "keys", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4318 ! 4153 [ "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4153
4319 [ "sys", "keys", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4319 ! 4154 [ "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4154
+ 4155 [ "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4155
4320 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4320 4156 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4156
..................
#select s1.name, t1.name, c1.name, s2.na
4326 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4326 4162 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4162
4327 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4327 ! 4163 [ "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4163
4328 [ "sys", "keys", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4328 ! 4164 [ "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4164
4329 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4329 ! 4165 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4165
4330 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4330 ! 4166 [ "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4166
4331 [ "sys", "keys", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4331 ! 4167 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4167
+ 4168 [ "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4168
4332 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4332 4169 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4169
..................
#select s1.name, t1.name, c1.name, s2.na
4337 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4337 4174 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4174
4338 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4338 ! 4175 [ "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4175
4339 [ "sys", "idxs", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4339 ! 4176 [ "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4176
4340 [ "sys", "idxs", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4340 ! 4177 [ "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4177
4341 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4341 ! 4178 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4178
4342 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4342 ! 4179 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4179
+ 4180 [ "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4180
4343 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4343 4181 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4181
..................
#select s1.name, t1.name, c1.name, s2.na
4352 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4352 4190 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4190
4353 [ "sys", "triggers", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4353 ! 4191 [ "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4191
4354 [ "sys", "triggers", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4354 ! 4192 [ "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4192
4355 [ "sys", "triggers", "table_id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4355 ! 4193 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4193
+ 4194 [ "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4194
4356 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4356 4195 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4195
..................
#select s1.name, t1.name, c1.name, s2.na
4377 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4377 4216 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4216
+ 4217 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4217
4378 [ "sys", "_columns", "id", "sys", "ids", "VIEW" ] 4378 ! 4218 [ "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4218
4379 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4379 ! 4219 [ "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4219
4380 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4380 4220 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4220
+ 4221 [ "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4221
4381 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4381 -
4382 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4382 -
4383 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4383 ! 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
4384 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4384 ! 4225 [ "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4225
4385 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4385 4226 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4226
..................
#select s1.name, t1.name, c1.name, s2.na
4393 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4393 4234 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4234
4394 [ "sys", "idxs", "id", "sys", "ids", "VIEW" ] 4394 ! 4235 [ "sys", "keys", "action", "sys", "ids", "VIEW" ] 4235
+ 4236 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4236
4395 [ "sys", "idxs", "name", "sys", "ids", "VIEW" ] 4395 ! 4237 [ "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4237
+ 4238 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4238
4396 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4396 ! 4239 [ "sys", "keys", "type", "sys", "ids", "VIEW" ] 4239
4397 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4397 ! 4240 [ "sys", "objects", "id", "sys", "ids", "VIEW" ] 4240
4398 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4398 -
4399 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4399 -
4400 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4400 4241 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4241
..................
#select s1.name, t1.name, c1.name, s2.na
4404 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4404 4245 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4245
4405 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4405 ! 4246 [ "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4246
4406 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4406 ! 4247 [ "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4247
4407 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4407 ! 4248 [ "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4248
+ 4249 [ "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4249
4408 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4408 4250 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4250
..................
#select s1.name, t1.name, c1.name, s2.na
4410 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4410 4252 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4252
+ 4253 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4253
4411 [ "tmp", "_columns", "id", "sys", "ids", "VIEW" ] 4411 ! 4254 [ "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4254
4412 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4412 -
4413 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4413 -
4414 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4414 -
4415 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4415 -
4416 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4416 ! 4255 [ "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4255
+ 4256 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4256
4417 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4417 ! 4257 [ "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4257
4418 [ "tmp", "idxs", "id", "sys", "ids", "VIEW" ] 4418 ! 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
4419 [ "tmp", "idxs", "name", "sys", "ids", "VIEW" ] 4419 ! 4261 [ "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4261
4420 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4420 ! 4262 [ "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4262
+ 4263 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4263
4421 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4421 ! 4264 [ "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4264
4422 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4422 -
4423 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4423 4265 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4265
4424 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4424 ! 4266 [ "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4266
4425 [ "tmp", "triggers", "name", "sys", "ids", "VIEW" ] 4425 -
4426 [ "tmp", "triggers", "table_id", "sys", "ids", "VIEW" ] 4426 -
4427 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4427 4267 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4267
..................
#select s1.name, t1.name, c1.name, s2.na
4429 [ "sys", "auths", "name", "sys", "roles", "VIEW" ] 4429 4269 [ "sys", "auths", "name", "sys", "roles", "VIEW" ] 4269
4430 [ "sys", "schemas", "id", "sys", "storage", "VIEW" ] 4430 -
4431 [ "sys", "schemas", "name", "sys", "storage", "VIEW" ] 4431 -
4432 [ "sys", "storagemodelinput", "atomwidth", "sys", "storagemodel", "VIEW" ] 4432 -
4433 [ "sys", "storagemodelinput", "column", "sys", "storagemodel", "VIEW" ] 4433 -
4434 [ "sys", "storagemodelinput", "count", "sys", "storagemodel", "VIEW" ] 4434 -
4435 [ "sys", "storagemodelinput", "distinct", "sys", "storagemodel", "VIEW" ] 4435 -
4436 [ "sys", "storagemodelinput", "isacolumn", "sys", "storagemodel", "VIEW" ] 4436 -
4437 [ "sys", "storagemodelinput", "reference", "sys", "storagemodel", "VIEW" ] 4437 -
4438 [ "sys", "storagemodelinput", "schema", "sys", "storagemodel", "VIEW" ] 4438 -
4439 [ "sys", "storagemodelinput", "sorted", "sys", "storagemodel", "VIEW" ] 4439 -
4440 [ "sys", "storagemodelinput", "table", "sys", "storagemodel", "VIEW" ] 4440 -
4441 [ "sys", "storagemodelinput", "type", "sys", "storagemodel", "VIEW" ] 4441 -
4442 [ "sys", "storagemodelinput", "unique", "sys", "storagemodel", "VIEW" ] 4442 -
4443 [ "sys", "functions", "id", "sys", "systemfunctions", "VIEW" ] 4443 4270 [ "sys", "functions", "id", "sys", "systemfunctions", "VIEW" ] 4270
4444 [ "sys", "functions", "system", "sys", "systemfunctions", "VIEW" ] 4444 4271 [ "sys", "functions", "system", "sys", "systemfunctions", "VIEW" ] 4271
4445 [ "sys", "storagemodelinput", "atomwidth", "sys", "tablestoragemodel", "VIEW" ] 4445 -
4446 [ "sys", "storagemodelinput", "count", "sys", "tablestoragemodel", "VIEW" ] 4446 -
4447 [ "sys", "storagemodelinput", "distinct", "sys", "tablestoragemodel", "VIEW" ] 4447 -
4448 [ "sys", "storagemodelinput", "isacolumn", "sys", "tablestoragemodel", "VIEW" ] 4448 -
4449 [ "sys", "storagemodelinput", "reference", "sys", "tablestoragemodel", "VIEW" ] 4449 -
4450 [ "sys", "storagemodelinput", "schema", "sys", "tablestoragemodel", "VIEW" ] 4450 -
4451 [ "sys", "storagemodelinput", "sorted", "sys", "tablestoragemodel", "VIEW" ] 4451 -
4452 [ "sys", "storagemodelinput", "table", "sys", "tablestoragemodel", "VIEW" ] 4452 -
4453 [ "sys", "storagemodelinput", "type", "sys", "tablestoragemodel", "VIEW" ] 4453 -
4454 #select s1.name, t1.name, c1.name, s2.name, t2.name, k2.name, dt.dependency_type_name from sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = dt.dependency_type_id, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, keys k2 where d.id = c1.id and d.depend_id = k2.id and c1.table_id = t1.id and t1.schema_id = s1.id and k2.table_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, k2.name, s1.name, t1.name, c1.name; 4454 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
4790 [ "degrees", "public", "EXECUTE", "monetdb", 0 ] 4790 4608 [ "degrees", "public", "EXECUTE", "monetdb", 0 ] 4608
4791 [ "env", "public", "EXECUTE", NULL, 0 ] 4791 -
4792 [ "epoch", "public", "EXECUTE", "monetdb", 0 ] 4792 4609 [ "epoch", "public", "EXECUTE", "monetdb", 0 ] 4609
..................
# .t, .g, .L4, .L6, .L10,
5083 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5083 4900 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 4900
5084 [ "_tables", "system_update_tables", "AFTER", "STATEMENT", "UPDATE", NULL, NULL, NULL, "create trigger system_update_tables after update on sys._tables for each statement call sys_update_tables();" ] 5084 ! 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
5085 [ "schemas", "system_update_schemas", "AFTER", "STATEMENT", "UPDATE", NULL, NULL, NULL, "create trigger system_update_schemas after update on sys.schemas for each statement call sys_update_schemas();" ] 5085 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
5341 [ "WHILE" ] 5341 5158 [ "WHILE" ] 5158
5342 [ "WINDOW" ] 5342 -
5343 [ "WITH" ] 5343 5159 [ "WITH" ] 5159