Test check.SQL.py (id 5d46ef638df2) (err)
check.stable.out.FILTERED 2020-10-17 00:23:47.386906298 +0200check.test.out.FILTERED 2020-10-17 00:23:47.846927424 +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 5266 lines, 177590 words, 1204724 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5326 lines, 178096 words, 1208869 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5266 lines, 177590 words, 1204724 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5326 lines, 178096 words, 1208869 chars in lines not matching '^$|^(\| |)#` 3
4 # 5436 lines, 181085 words, 1228939 chars in all lines 4 ! 4 # 5496 lines, 181598 words, 1233138 chars in all lines 4
5 5 5 5
..................
# 10:17:18 >
247 \dSf sys."setworkerlimit" 247 247 \dSf sys."setworkerlimit" 247
248 \dSf sys."shpattach" 248 -
249 \dSf sys."shpload" 249 -
250 \dSf sys."shrink" 250 248 \dSf sys."shrink" 248
..................
# 10:17:18 >
721 SYSTEM PROCEDURE sys.setworkerlimit 721 719 SYSTEM PROCEDURE sys.setworkerlimit 719
722 SYSTEM PROCEDURE sys.shpattach 722 -
723 SYSTEM PROCEDURE sys.shpload 723 -
724 SYSTEM PROCEDURE sys.shrink 724 720 SYSTEM PROCEDURE sys.shrink 720
..................
# 10:17:18 >
982 create view sys.tracelog as select * from sys.tracelog(); 982 978 create view sys.tracelog as select * from sys.tracelog(); 978
983 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"; 983 + 979 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" ; 979
984 create view sys.var_values (var_name, value) as 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; 984 980 create view sys.var_values (var_name, value) as 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; 980
..................
# 10:17:18 >
1051 create procedure sys.flush_log () external name sql."flush_log"; 1051 1047 create procedure sys.flush_log () external name sql."flush_log"; 1047
+ 1048 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 1048
1052 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 1052 ! 1049 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 1049
1053 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 1053 ! 1050 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 1050
1054 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 1054 ! 1051 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 1051
1055 create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; 1055 ! 1052 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 1052
1056 create function sys.generate_series(first bigint, "limit" bigint, stepsize bigint) returns table (value bigint) external name generator.series; 1056 ! 1053 create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series; 1053
1057 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; 1057 ! 1054 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; 1054
1058 create function sys.generate_series(first double, "limit" double, stepsize double) returns table (value double) external name generator.series; 1058 ! 1055 create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series; 1055
1059 create function sys.generate_series(first int, "limit" int) returns table (value int) external name generator.series; 1059 ! 1056 create function sys.generate_series(first int, last int) returns table (value int) external name generator.series; 1056
1060 create function sys.generate_series(first int, "limit" int, stepsize int) returns table (value int) external name generator.series; 1060 ! 1057 create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series; 1057
1061 create function sys.generate_series(first real, "limit" real, stepsize real) returns table (value real) external name generator.series; 1061 ! 1058 create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series; 1058
1062 create function sys.generate_series(first smallint, "limit" smallint) returns table (value smallint) external name generator.series; 1062 ! 1059 create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series; 1059
1063 create function sys.generate_series(first smallint, "limit" smallint, stepsize smallint) returns table (value smallint) external name generator.series; 1063 ! 1060 create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series; 1060
1064 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval day) returns table (value timestamp) external name generator.series; 1064 1061 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval day) returns table (value timestamp) external name generator.series; 1061
1065 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1065 ! 1062 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1062
1066 create function sys.generate_series(first tinyint, "limit" tinyint) returns table (value tinyint) external name generator.series; 1066 ! 1063 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1063
1067 create function sys.generate_series(first tinyint, "limit" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1067 -
1068 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1068 1064 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1064
..................
# 10:17:18 >
1195 create procedure sys.setworkerlimit("sessionid" int, "limit" int) external name clients.setworkerlimit; 1195 1191 create procedure sys.setworkerlimit("sessionid" int, "limit" int) external name clients.setworkerlimit; 1191
1196 create procedure shpattach(fname string) external name shp.attach; 1196 -
1197 create procedure shpload(fid integer) external name shp.import; 1197 -
1198 create procedure shpload(fid integer, filter geometry) external name shp.import; 1198 -
1199 create procedure shrink(sys string, tab string) external name sql.shrink; 1199 1192 create procedure shrink(sys string, tab string) external name sql.shrink; 1192
..................
# 10:17:18 >
1330 create window stddev_pop(val tinyint) returns double external name "sql"."stdevp"; 1330 1323 create window stddev_pop(val tinyint) returns double external name "sql"."stdevp"; 1323
+ 1324 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1324
1331 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1331 1325 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1325
..................
# 10:17:18 >
1335 create aggregate stddev_samp(val smallint) returns double external name "aggr"."stdev"; 1335 1329 create aggregate stddev_samp(val smallint) returns double external name "aggr"."stdev"; 1329
1336 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1336 -
1337 create window stddev_samp(val bigint) returns double external name "sql"."stdev"; 1337 1330 create window stddev_samp(val bigint) returns double external name "sql"."stdev"; 1330
..................
# %25, name, name, query, type,
1574 [ "sys._tables", "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1574 1567 [ "sys._tables", "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1567
1575 [ "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" ] 1575 ! 1568 [ "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" ] 1568
1576 [ "sys._tables", "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1576 1569 [ "sys._tables", "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1569
..................
# %1, name, name, system, query,
2495 [ "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 ] 2495 2488 [ "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 ] 2488
2496 [ "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 ] 2496 ! 2489 [ "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 ] 2489
2497 [ "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 ] 2497 ! 2490 [ "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 ] 2490
2498 [ "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 ] 2498 ! 2491 [ "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 ] 2491
2499 [ "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 ] 2499 ! 2492 [ "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 ] 2492
2500 [ "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 ] 2500 ! 2493 [ "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 ] 2493
2501 [ "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 ] 2501 ! 2494 [ "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 ] 2494
2502 [ "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 ] 2502 ! 2495 [ "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 ] 2495
2503 [ "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 ] 2503 ! 2496 [ "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 ] 2496
2504 [ "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 ] 2504 ! 2497 [ "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 ] 2497
2505 [ "sys.functions", "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first timestamp, \"limit\" timestamp, stepsize interval day) 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", "day_interval", 4, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2505 2498 [ "sys.functions", "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first timestamp, \"limit\" timestamp, stepsize interval day) 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", "day_interval", 4, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2498
2506 [ "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 ] 2506 ! 2499 [ "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 ] 2499
2507 [ "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 ] 2507 ! 2500 [ "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 ] 2500
2508 [ "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 ] 2508 ! 2501 [ "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 ] 2501
2509 [ "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 ] 2509 2502 [ "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 ] 2502
..................
# %1, name, name, system, query,
3049 [ "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 ] 3049 3042 [ "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 ] 3042
3050 [ "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 ] 3050 -
3051 [ "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 ] 3051 -
3052 [ "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 ] 3052 -
3053 [ "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 ] 3053 3043 [ "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 ] 3043
..................
# %1, name, name, name, name,
3672 [ "function used by function", "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3672 3662 [ "function used by function", "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3662
+ 3663 [ "function used by function", "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3663
3673 [ "function used by function", "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3673 3664 [ "function used by function", "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3664
..................
# %1, name, name, name, name,
3970 [ "column used by view", "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 3970 3961 [ "column used by view", "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 3961
+ 3962 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 3962
+ 3963 [ "column used by view", "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 3963
+ 3964 [ "column used by view", "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 3964
+ 3965 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 3965
+ 3966 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 3966
3971 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 3971 3967 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 3967
..................
# %1, name, name, name, name,
3977 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 3977 3973 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 3973
+ 3974 [ "column used by view", "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 3974
3978 [ "column used by view", "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 3978 3975 [ "column used by view", "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 3975
..................
# %1, name, name, name, name,
3985 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 3985 3982 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 3982
+ 3983 [ "column used by view", "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 3983
+ 3984 [ "column used by view", "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 3984
+ 3985 [ "column used by view", "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 3985
+ 3986 [ "column used by view", "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 3986
+ 3987 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 3987
+ 3988 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 3988
+ 3989 [ "column used by view", "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 3989
+ 3990 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 3990
+ 3991 [ "column used by view", "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 3991
3986 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 3986 3992 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 3992
..................
# %1, name, name, name, name,
3998 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 3998 4004 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4004
+ 4005 [ "column used by view", "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4005
+ 4006 [ "column used by view", "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4006
+ 4007 [ "column used by view", "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4007
+ 4008 [ "column used by view", "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4008
3999 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 3999 4009 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4009
..................
# %1, name, name, name, name,
4013 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4013 4023 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4023
+ 4024 [ "column used by view", "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4024
+ 4025 [ "column used by view", "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4025
+ 4026 [ "column used by view", "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4026
4014 [ "column used by view", "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4014 4027 [ "column used by view", "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4027
..................
# %1, name, name, name, name,
4060 [ "column used by view", "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4060 4073 [ "column used by view", "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4073
+ 4074 [ "column used by view", "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4074
+ 4075 [ "column used by view", "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4075
+ 4076 [ "column used by view", "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4076
+ 4077 [ "column used by view", "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4077
4061 [ "column used by view", "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4061 4078 [ "column used by view", "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4078
..................
# %1, name, name, name, name,
4081 [ "column used by view", "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4081 4098 [ "column used by view", "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4098
+ 4099 [ "column used by view", "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4099
+ 4100 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4100
+ 4101 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4101
+ 4102 [ "column used by view", "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4102
+ 4103 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4103
+ 4104 [ "column used by view", "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4104
4082 [ "column used by view", "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4082 4105 [ "column used by view", "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4105
..................
# %1, name, name, name, name,
4095 [ "column used by view", "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4095 4118 [ "column used by view", "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4118
+ 4119 [ "column used by view", "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4119
+ 4120 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4120
+ 4121 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4121
+ 4122 [ "column used by view", "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4122
+ 4123 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4123
+ 4124 [ "column used by view", "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4124
4096 [ "column used by view", "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4096 4125 [ "column used by view", "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4125
..................
# %1, name, name, name, name,
4113 [ "column used by view", "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4113 4142 [ "column used by view", "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4142
+ 4143 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4143
+ 4144 [ "column used by view", "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4144
+ 4145 [ "column used by view", "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4145
+ 4146 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4146
+ 4147 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4147
4114 [ "column used by view", "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4114 4148 [ "column used by view", "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4148
..................
# %1, name, name, name, name,
4117 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4117 4151 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4151
+ 4152 [ "column used by view", "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4152
4118 [ "column used by view", "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4118 4153 [ "column used by view", "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4153
..................
# %1, name, name, name, name,
4135 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4135 4170 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4170
+ 4171 [ "column used by view", "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4171
+ 4172 [ "column used by view", "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4172
+ 4173 [ "column used by view", "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4173
+ 4174 [ "column used by view", "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4174
4136 [ "column used by view", "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4136 4175 [ "column used by view", "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4175
..................
# %1, name, name, name, name,
4189 [ "column used by view", "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4189 4228 [ "column used by view", "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4228
+ 4229 [ "column used by view", "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4229
+ 4230 [ "column used by view", "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4230
4190 [ "column used by view", "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4190 4231 [ "column used by view", "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4231
+ 4232 [ "column used by view", "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4232
+ 4233 [ "column used by view", "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4233
4191 [ "column used by view", "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4191 4234 [ "column used by view", "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4234
..................
# %1, name, name, name, name,
4193 [ "column used by view", "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4193 4236 [ "column used by view", "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4236
+ 4237 [ "column used by view", "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4237
4194 [ "column used by view", "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4194 4238 [ "column used by view", "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4238
..................
# %1, name, name, name, name,
4206 [ "column used by view", "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4206 4250 [ "column used by view", "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4250
+ 4251 [ "column used by view", "sys", "keys", "action", "sys", "ids", "VIEW" ] 4251
4207 [ "column used by view", "sys", "keys", "id", "sys", "ids", "VIEW" ] 4207 4252 [ "column used by view", "sys", "keys", "id", "sys", "ids", "VIEW" ] 4252
4208 [ "column used by view", "sys", "keys", "name", "sys", "ids", "VIEW" ] 4208 4253 [ "column used by view", "sys", "keys", "name", "sys", "ids", "VIEW" ] 4253
+ 4254 [ "column used by view", "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4254
4209 [ "column used by view", "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4209 4255 [ "column used by view", "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4255
+ 4256 [ "column used by view", "sys", "keys", "type", "sys", "ids", "VIEW" ] 4256
+ 4257 [ "column used by view", "sys", "objects", "id", "sys", "ids", "VIEW" ] 4257
4210 [ "column used by view", "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4210 4258 [ "column used by view", "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4258
..................
# %1, name, name, name, name,
4214 [ "column used by view", "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4214 4262 [ "column used by view", "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4262
+ 4263 [ "column used by view", "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4263
4215 [ "column used by view", "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4215 4264 [ "column used by view", "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4264
4216 [ "column used by view", "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4216 4265 [ "column used by view", "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4265
+ 4266 [ "column used by view", "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4266
+ 4267 [ "column used by view", "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4267
+ 4268 [ "column used by view", "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4268
4217 [ "column used by view", "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4217 4269 [ "column used by view", "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4269
..................
# %1, name, name, name, name,
4222 [ "column used by view", "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4222 4274 [ "column used by view", "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4274
+ 4275 [ "column used by view", "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4275
+ 4276 [ "column used by view", "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4276
4223 [ "column used by view", "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4223 4277 [ "column used by view", "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4277
+ 4278 [ "column used by view", "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4278
+ 4279 [ "column used by view", "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4279
4224 [ "column used by view", "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4224 4280 [ "column used by view", "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4280
..................
# %1, name, name, name, name,
4226 [ "column used by view", "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4226 4282 [ "column used by view", "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4282
+ 4283 [ "column used by view", "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4283
4227 [ "column used by view", "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4227 4284 [ "column used by view", "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4284
..................
# %1, name, name, name, name,
4230 [ "column used by view", "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4230 4287 [ "column used by view", "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4287
+ 4288 [ "column used by view", "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4288
4231 [ "column used by view", "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4231 4289 [ "column used by view", "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4289
4232 [ "column used by view", "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4232 4290 [ "column used by view", "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4290
+ 4291 [ "column used by view", "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4291
4233 [ "column used by view", "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4233 4292 [ "column used by view", "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4292
+ 4293 [ "column used by view", "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4293
4234 [ "column used by view", "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4234 4294 [ "column used by view", "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4294
..................
# %1, name, name, time, orientat
4954 % 12, 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 4954 5014 % 12, 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5014
4955 [ "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();" ] 4955 ! 5015 [ "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();" ] 5015
4956 [ "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();" ] 4956 5016 [ "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();" ] 5016