Test check.SQL.py (id 9fb2b731c9eb) (err)
check.stable.out.int128.FILTERED 2020-07-31 23:56:16.345021044 +0200check.test.out.FILTERED 2020-07-31 23:56:16.905046813 +0200
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 5925 lines, 233092 words, 1560014 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5985 lines, 233598 words, 1564159 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5925 lines, 233092 words, 1560014 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5985 lines, 233598 words, 1564159 chars in lines not matching '^$|^(\| |)#` 3
4 # 6095 lines, 236587 words, 1584121 chars in all lines 4 ! 4 # 6155 lines, 237103 words, 1588448 chars in all lines 4
5 5 5 5
..................
# 10:17:18 >
249 \dSf sys."setworkerlimit" 249 249 \dSf sys."setworkerlimit" 249
250 \dSf sys."shpattach" 250 -
251 \dSf sys."shpload" 251 -
252 \dSf sys."shrink" 252 250 \dSf sys."shrink" 250
..................
# 10:17:18 >
720 SYSTEM PROCEDURE sys.setworkerlimit 720 718 SYSTEM PROCEDURE sys.setworkerlimit 718
721 SYSTEM PROCEDURE sys.shpattach 721 -
722 SYSTEM PROCEDURE sys.shpload 722 -
723 SYSTEM PROCEDURE sys.shrink 723 719 SYSTEM PROCEDURE sys.shrink 719
..................
# 10:17:18 >
979 create view sys.tracelog as select * from sys.tracelog(); 979 975 create view sys.tracelog as select * from sys.tracelog(); 975
980 SELECT u."name" AS "name", ui."fullname", ui."default_schema" FROM db_users() AS u LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name"; 980 + 976 SELECT u."name" AS "name", ui."fullname", ui."default_schema" FROM db_users() AS u LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name" ; 976
981 create view sys.var_values (var_name, value) as select 'cache' as var_name, convert(cache, varchar(10)) as value union all select 'current_role', current_role union all select 'current_schema', current_schema union all select 'current_timezone', current_timezone union all select 'current_user', current_user union all select 'debug', debug union all select 'last_id', last_id union all select 'optimizer', optimizer union all select 'pi', pi() union all select 'rowcnt', rowcnt; 981 977 create view sys.var_values (var_name, value) as select 'cache' as var_name, convert(cache, varchar(10)) as value union all select 'current_role', current_role union all select 'current_schema', current_schema union all select 'current_timezone', current_timezone union all select 'current_user', current_user union all select 'debug', debug union all select 'last_id', last_id union all select 'optimizer', optimizer union all select 'pi', pi() union all select 'rowcnt', rowcnt; 977
..................
# 10:17:18 >
1066 create procedure sys.flush_log () external name sql."flush_log"; 1066 1062 create procedure sys.flush_log () external name sql."flush_log"; 1062
+ 1063 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 1063
1067 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 1067 ! 1064 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 1064
1068 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 1068 1065 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 1065
1069 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 1069 ! 1066 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 1066
1070 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 1070 ! 1067 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 1067
1071 create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; 1071 ! 1068 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 1068
1072 create function sys.generate_series(first bigint, "limit" bigint, stepsize bigint) returns table (value bigint) external name generator.series; 1072 ! 1069 create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series; 1069
1073 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; 1073 ! 1070 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; 1070
1074 create function sys.generate_series(first double, "limit" double, stepsize double) returns table (value double) external name generator.series; 1074 ! 1071 create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series; 1071
1075 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 1075 1072 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 1072
1076 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 1076 1073 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 1073
1077 create function sys.generate_series(first int, "limit" int) returns table (value int) external name generator.series; 1077 ! 1074 create function sys.generate_series(first int, last int) returns table (value int) external name generator.series; 1074
1078 create function sys.generate_series(first int, "limit" int, stepsize int) returns table (value int) external name generator.series; 1078 ! 1075 create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series; 1075
1079 create function sys.generate_series(first real, "limit" real, stepsize real) returns table (value real) external name generator.series; 1079 ! 1076 create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series; 1076
1080 create function sys.generate_series(first smallint, "limit" smallint) returns table (value smallint) external name generator.series; 1080 ! 1077 create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series; 1077
1081 create function sys.generate_series(first smallint, "limit" smallint, stepsize smallint) returns table (value smallint) external name generator.series; 1081 ! 1078 create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series; 1078
1082 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1082 ! 1079 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1079
1083 create function sys.generate_series(first tinyint, "limit" tinyint) returns table (value tinyint) external name generator.series; 1083 ! 1080 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1080
1084 create function sys.generate_series(first tinyint, "limit" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1084 -
1085 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1085 1081 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1081
..................
# 10:17:18 >
1119 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1119 1115 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1115
+ 1116 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1116
1120 create filter function "like"(val string, pat string) external name algebra."like"; 1120 1117 create filter function "like"(val string, pat string) external name algebra."like"; 1117
1121 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1121 -
1122 create procedure listdir(dirname string) external name fits.listdir; 1122 1118 create procedure listdir(dirname string) external name fits.listdir; 1118
..................
# 10:17:18 >
1218 create procedure sys.setworkerlimit("sessionid" int, "limit" int) external name clients.setworkerlimit; 1218 1214 create procedure sys.setworkerlimit("sessionid" int, "limit" int) external name clients.setworkerlimit; 1214
1219 create procedure shpattach(fname string) external name shp.attach; 1219 -
1220 create procedure shpload(fid integer) external name shp.import; 1220 -
1221 create procedure shpload(fid integer, filter geometry) external name shp.import; 1221 -
1222 create procedure shrink(sys string, tab string) external name sql.shrink; 1222 1215 create procedure shrink(sys string, tab string) external name sql.shrink; 1215
..................
# 10:17:18 >
1359 create window stddev_pop(val tinyint) returns double external name "sql"."stdevp"; 1359 1352 create window stddev_pop(val tinyint) returns double external name "sql"."stdevp"; 1352
+ 1353 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1353
1360 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1360 1354 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1354
..................
# 10:17:18 >
1367 create aggregate stddev_samp(val smallint) returns double external name "aggr"."stdev"; 1367 1361 create aggregate stddev_samp(val smallint) returns double external name "aggr"."stdev"; 1361
1368 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1368 -
1369 create window stddev_samp(val bigint) returns double external name "sql"."stdev"; 1369 1362 create window stddev_samp(val bigint) returns double external name "sql"."stdev"; 1362
..................
# %36, name, name, query, type,
1620 [ "sys._tables", "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1620 1613 [ "sys._tables", "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1613
1621 [ "sys._tables", "sys", "users", "SELECT u.\"name\" AS \"name\", ui.\"fullname\", ui.\"default_schema\" FROM db_users() AS u LEFT JOIN \"sys\".\"db_user_info\" AS ui ON u.\"name\" = ui.\"name\";", "VIEW", true, "COMMIT", "WRITABLE" ] 1621 ! 1614 [ "sys._tables", "sys", "users", "SELECT u.\"name\" AS \"name\", ui.\"fullname\", ui.\"default_schema\" FROM db_users() AS u LEFT JOIN \"sys\".\"db_user_info\" AS ui ON u.\"name\" = ui.\"name\" ;", "VIEW", true, "COMMIT", "WRITABLE" ] 1614
1622 [ "sys._tables", "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1622 1615 [ "sys._tables", "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1615
..................
# %2, name, name, type, type_dig
2133 [ "sys._columns", "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2133 2126 [ "sys._columns", "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2126
2134 [ "sys._columns", "storagemodel", "orderidxsize", "bigint", 64, 0, NULL, true, 9, NULL ] 2134 ! 2127 [ "sys._columns", "storagemodel", "orderidxsize", "bigint", 63, 0, NULL, true, 9, NULL ] 2127
2135 [ "sys._columns", "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2135 2128 [ "sys._columns", "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2128
..................
# %50, name, name, system, query,
2567 [ "sys.functions", "sys", "fuse", "SYSTEM", "create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse;", "udf", "MAL", "Scalar function", false, false, false, true, "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 ] 2567 2560 [ "sys.functions", "sys", "fuse", "SYSTEM", "create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse;", "udf", "MAL", "Scalar function", false, false, false, true, "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 ] 2560
2568 [ "sys.functions", "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, true, "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 ] 2568 ! 2561 [ "sys.functions", "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, true, "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 ] 2561
2569 [ "sys.functions", "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, true, "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 ] 2569 ! 2562 [ "sys.functions", "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, true, "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 ] 2562
2570 [ "sys.functions", "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, true, "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 ] 2570 ! 2563 [ "sys.functions", "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, true, "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 ] 2563
2571 [ "sys.functions", "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, true, "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 ] 2571 ! 2564 [ "sys.functions", "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, true, "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 ] 2564
2572 [ "sys.functions", "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, true, "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 ] 2572 2565 [ "sys.functions", "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, true, "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 ] 2565
2573 [ "sys.functions", "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, true, "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 ] 2573 2566 [ "sys.functions", "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, true, "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 ] 2566
2574 [ "sys.functions", "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, true, "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 ] 2574 ! 2567 [ "sys.functions", "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, true, "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 ] 2567
2575 [ "sys.functions", "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, true, "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 ] 2575 ! 2568 [ "sys.functions", "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, true, "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 ] 2568
2576 [ "sys.functions", "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, true, "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 ] 2576 ! 2569 [ "sys.functions", "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, true, "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 ] 2569
2577 [ "sys.functions", "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, true, "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 ] 2577 ! 2570 [ "sys.functions", "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, true, "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 ] 2570
2578 [ "sys.functions", "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, true, "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 ] 2578 ! 2571 [ "sys.functions", "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, true, "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 ] 2571
2579 [ "sys.functions", "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, true, "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 ] 2579 ! 2572 [ "sys.functions", "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, true, "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 ] 2572
2580 [ "sys.functions", "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, true, "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 ] 2580 ! 2573 [ "sys.functions", "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, true, "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 ] 2573
2581 [ "sys.functions", "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, true, "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 ] 2581 ! 2574 [ "sys.functions", "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, true, "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 ] 2574
2582 [ "sys.functions", "sys", "geometrytype", "SYSTEM", "create function geometrytype(geom geometry) returns string external name geom.\"GeometryType1\";", "geom", "MAL", "Scalar function", false, false, false, true, "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 ] 2582 2575 [ "sys.functions", "sys", "geometrytype", "SYSTEM", "create function geometrytype(geom geometry) returns string external name geom.\"GeometryType1\";", "geom", "MAL", "Scalar function", false, false, false, true, "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 ] 2575
..................
# %50, name, name, system, query,
3610 [ "sys.functions", "sys", "setworkerlimit", "SYSTEM", "create procedure sys.setworkerlimit(\"sessionid\" int, \"limit\" int) external name clients.setworkerlimit;", "clients", "MAL", "Procedure", true, false, false, true, "sessionid", "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, NULL, NULL, NULL, NULL, NULL ] 3610 3603 [ "sys.functions", "sys", "setworkerlimit", "SYSTEM", "create procedure sys.setworkerlimit(\"sessionid\" int, \"limit\" int) external name clients.setworkerlimit;", "clients", "MAL", "Procedure", true, false, false, true, "sessionid", "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, NULL, NULL, NULL, NULL, NULL ] 3603
3611 [ "sys.functions", "sys", "shpattach", "SYSTEM", "create procedure shpattach(fname string) external name shp.attach;", "shp", "MAL", "Procedure", true, false, false, true, "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 ] 3611 -
3612 [ "sys.functions", "sys", "shpload", "SYSTEM", "create procedure shpload(fid integer) external name shp.import;", "shp", "MAL", "Procedure", true, false, false, true, "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 ] 3612 -
3613 [ "sys.functions", "sys", "shpload", "SYSTEM", "create procedure shpload(fid integer, filter geometry) external name shp.import;", "shp", "MAL", "Procedure", true, false, false, true, "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 ] 3613 -
3614 [ "sys.functions", "sys", "shrink", "SYSTEM", "create procedure shrink(sys string, tab string) external name sql.shrink;", "sql", "MAL", "Procedure", true, false, false, true, "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 ] 3614 3604 [ "sys.functions", "sys", "shrink", "SYSTEM", "create procedure shrink(sys string, tab string) external name sql.shrink;", "sql", "MAL", "Procedure", true, false, false, true, "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 ] 3604
..................
# %4, name, name, name, name,
4281 [ "function used by function", "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 4281 4271 [ "function used by function", "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 4271
+ 4272 [ "function used by function", "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 4272
4282 [ "function used by function", "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4282 4273 [ "function used by function", "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4273
..................
# %4, name, name, name, name,
4579 [ "column used by view", "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4579 4570 [ "column used by view", "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4570
+ 4571 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4571
+ 4572 [ "column used by view", "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4572
+ 4573 [ "column used by view", "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4573
+ 4574 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4574
+ 4575 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4575
4580 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4580 4576 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4576
..................
# %4, name, name, name, name,
4586 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4586 4582 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4582
+ 4583 [ "column used by view", "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4583
4587 [ "column used by view", "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4587 4584 [ "column used by view", "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4584
..................
# %4, name, name, name, name,
4594 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4594 4591 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4591
+ 4592 [ "column used by view", "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4592
+ 4593 [ "column used by view", "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4593
+ 4594 [ "column used by view", "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4594
+ 4595 [ "column used by view", "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4595
+ 4596 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4596
+ 4597 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4597
+ 4598 [ "column used by view", "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4598
+ 4599 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4599
+ 4600 [ "column used by view", "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4600
4595 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4595 4601 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4601
..................
# %4, name, name, name, name,
4607 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4607 4613 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4613
+ 4614 [ "column used by view", "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4614
+ 4615 [ "column used by view", "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4615
+ 4616 [ "column used by view", "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4616
+ 4617 [ "column used by view", "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4617
4608 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4608 4618 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4618
..................
# %4, name, name, name, name,
4622 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4622 4632 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4632
+ 4633 [ "column used by view", "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4633
+ 4634 [ "column used by view", "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4634
+ 4635 [ "column used by view", "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4635
4623 [ "column used by view", "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4623 4636 [ "column used by view", "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4636
..................
# %4, name, name, name, name,
4669 [ "column used by view", "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4669 4682 [ "column used by view", "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4682
+ 4683 [ "column used by view", "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4683
+ 4684 [ "column used by view", "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4684
+ 4685 [ "column used by view", "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4685
+ 4686 [ "column used by view", "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4686
4670 [ "column used by view", "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4670 4687 [ "column used by view", "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4687
..................
# %4, name, name, name, name,
4690 [ "column used by view", "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4690 4707 [ "column used by view", "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4707
+ 4708 [ "column used by view", "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4708
+ 4709 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4709
+ 4710 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4710
+ 4711 [ "column used by view", "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4711
+ 4712 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4712
+ 4713 [ "column used by view", "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4713
4691 [ "column used by view", "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4691 4714 [ "column used by view", "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4714
..................
# %4, name, name, name, name,
4704 [ "column used by view", "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4704 4727 [ "column used by view", "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4727
+ 4728 [ "column used by view", "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4728
+ 4729 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4729
+ 4730 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4730
+ 4731 [ "column used by view", "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4731
+ 4732 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4732
+ 4733 [ "column used by view", "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4733
4705 [ "column used by view", "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4705 4734 [ "column used by view", "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4734
..................
# %4, name, name, name, name,
4722 [ "column used by view", "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4722 4751 [ "column used by view", "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4751
+ 4752 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4752
+ 4753 [ "column used by view", "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4753
+ 4754 [ "column used by view", "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4754
+ 4755 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4755
+ 4756 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4756
4723 [ "column used by view", "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4723 4757 [ "column used by view", "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4757
..................
# %4, name, name, name, name,
4726 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4726 4760 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4760
+ 4761 [ "column used by view", "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4761
4727 [ "column used by view", "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4727 4762 [ "column used by view", "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4762
..................
# %4, name, name, name, name,
4744 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4744 4779 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4779
+ 4780 [ "column used by view", "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4780
+ 4781 [ "column used by view", "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4781
+ 4782 [ "column used by view", "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4782
+ 4783 [ "column used by view", "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4783
4745 [ "column used by view", "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4745 4784 [ "column used by view", "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4784
..................
# %4, name, name, name, name,
4798 [ "column used by view", "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4798 4837 [ "column used by view", "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4837
+ 4838 [ "column used by view", "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4838
+ 4839 [ "column used by view", "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4839
4799 [ "column used by view", "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4799 4840 [ "column used by view", "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4840
+ 4841 [ "column used by view", "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4841
+ 4842 [ "column used by view", "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4842
4800 [ "column used by view", "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4800 4843 [ "column used by view", "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4843
..................
# %4, name, name, name, name,
4802 [ "column used by view", "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4802 4845 [ "column used by view", "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4845
+ 4846 [ "column used by view", "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4846
4803 [ "column used by view", "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4803 4847 [ "column used by view", "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4847
..................
# %4, name, name, name, name,
4815 [ "column used by view", "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4815 4859 [ "column used by view", "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4859
+ 4860 [ "column used by view", "sys", "keys", "action", "sys", "ids", "VIEW" ] 4860
4816 [ "column used by view", "sys", "keys", "id", "sys", "ids", "VIEW" ] 4816 4861 [ "column used by view", "sys", "keys", "id", "sys", "ids", "VIEW" ] 4861
4817 [ "column used by view", "sys", "keys", "name", "sys", "ids", "VIEW" ] 4817 4862 [ "column used by view", "sys", "keys", "name", "sys", "ids", "VIEW" ] 4862
+ 4863 [ "column used by view", "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4863
4818 [ "column used by view", "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4818 4864 [ "column used by view", "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4864
+ 4865 [ "column used by view", "sys", "keys", "type", "sys", "ids", "VIEW" ] 4865
+ 4866 [ "column used by view", "sys", "objects", "id", "sys", "ids", "VIEW" ] 4866
4819 [ "column used by view", "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4819 4867 [ "column used by view", "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4867
..................
# %4, name, name, name, name,
4823 [ "column used by view", "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4823 4871 [ "column used by view", "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4871
+ 4872 [ "column used by view", "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4872
4824 [ "column used by view", "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4824 4873 [ "column used by view", "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4873
4825 [ "column used by view", "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4825 4874 [ "column used by view", "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4874
+ 4875 [ "column used by view", "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4875
+ 4876 [ "column used by view", "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4876
+ 4877 [ "column used by view", "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4877
4826 [ "column used by view", "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4826 4878 [ "column used by view", "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4878
..................
# %4, name, name, name, name,
4831 [ "column used by view", "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4831 4883 [ "column used by view", "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4883
+ 4884 [ "column used by view", "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4884
+ 4885 [ "column used by view", "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4885
4832 [ "column used by view", "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4832 4886 [ "column used by view", "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4886
+ 4887 [ "column used by view", "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4887
+ 4888 [ "column used by view", "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4888
4833 [ "column used by view", "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4833 4889 [ "column used by view", "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4889
..................
# %4, name, name, name, name,
4835 [ "column used by view", "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4835 4891 [ "column used by view", "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4891
+ 4892 [ "column used by view", "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4892
4836 [ "column used by view", "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4836 4893 [ "column used by view", "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4893
..................
# %4, name, name, name, name,
4839 [ "column used by view", "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4839 4896 [ "column used by view", "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4896
+ 4897 [ "column used by view", "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4897
4840 [ "column used by view", "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4840 4898 [ "column used by view", "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4898
4841 [ "column used by view", "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4841 4899 [ "column used by view", "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4899
+ 4900 [ "column used by view", "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4900
4842 [ "column used by view", "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4842 4901 [ "column used by view", "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4901
+ 4902 [ "column used by view", "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4902
4843 [ "column used by view", "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4843 4903 [ "column used by view", "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4903
..................
# %4, name, name, time, orientat
5613 % 12, 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5613 5673 % 12, 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5673
5614 [ "sys.triggers", "_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();" ] 5614 ! 5674 [ "sys.triggers", 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();" ] 5674
5615 [ "sys.triggers", "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();" ] 5615 5675 [ "sys.triggers", "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();" ] 5675