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