check.stable.out.FILTERED 2020-09-18 22:30:58.431392893 +0200 | check.test.out.FILTERED 2020-09-18 22:30:58.881413197 +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 | 5255 lines, 176719 words, 1199163 chars in lines not matching '^$|^(\| |)#|^=` | 2 | ! | 2 | 5315 lines, 177225 words, 1203308 chars in lines not matching '^$|^(\| |)#|^=` | 2 |
3 | = 5255 lines, 176719 words, 1199163 chars in lines not matching '^$|^(\| |)#` | 3 | ! | 3 | = 5315 lines, 177225 words, 1203308 chars in lines not matching '^$|^(\| |)#` | 3 |
4 | # 5425 lines, 180214 words, 1223376 chars in all lines | 4 | ! | 4 | # 5485 lines, 180727 words, 1227575 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 > |
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 > |
981 | create view sys.tracelog as select * from sys.tracelog(); | 981 | 977 | create view sys.tracelog as select * from sys.tracelog(); | 977 | |
982 | 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"; | 982 | + | 978 | 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" ; | 978 |
983 | 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; | 983 | 979 | 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; | 979 | |
... | ... | ... | ... | ... | ... | # 10:17:18 > |
1050 | create procedure sys.flush_log () external name sql."flush_log"; | 1050 | 1046 | create procedure sys.flush_log () external name sql."flush_log"; | 1046 | |
+ | 1047 | create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; | 1047 | |||
1051 | create function fuse(one integer, two integer) returns bigint external name udf.fuse; | 1051 | ! | 1048 | create function fuse(one smallint, two smallint) returns integer external name udf.fuse; | 1048 |
1052 | create function fuse(one smallint, two smallint) returns integer external name udf.fuse; | 1052 | ! | 1049 | create function fuse(one integer, two integer) returns bigint external name udf.fuse; | 1049 |
1053 | create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; | 1053 | ! | 1050 | create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; | 1050 |
1054 | create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; | 1054 | ! | 1051 | create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; | 1051 |
1055 | create function sys.generate_series(first bigint, "limit" bigint, stepsize bigint) returns table (value bigint) external name generator.series; | 1055 | ! | 1052 | create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series; | 1052 |
1056 | 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; | 1056 | ! | 1053 | 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; | 1053 |
1057 | create function sys.generate_series(first double, "limit" double, stepsize double) returns table (value double) external name generator.series; | 1057 | ! | 1054 | create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series; | 1054 |
1058 | create function sys.generate_series(first int, "limit" int) returns table (value int) external name generator.series; | 1058 | ! | 1055 | create function sys.generate_series(first int, last int) returns table (value int) external name generator.series; | 1055 |
1059 | create function sys.generate_series(first int, "limit" int, stepsize int) returns table (value int) external name generator.series; | 1059 | ! | 1056 | create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series; | 1056 |
1060 | create function sys.generate_series(first real, "limit" real, stepsize real) returns table (value real) external name generator.series; | 1060 | ! | 1057 | create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series; | 1057 |
1061 | create function sys.generate_series(first smallint, "limit" smallint) returns table (value smallint) external name generator.series; | 1061 | ! | 1058 | create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series; | 1058 |
1062 | create function sys.generate_series(first smallint, "limit" smallint, stepsize smallint) returns table (value smallint) external name generator.series; | 1062 | ! | 1059 | create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series; | 1059 |
1063 | create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval day) returns table (value timestamp) external name generator.series; | 1063 | 1060 | create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval day) returns table (value timestamp) external name generator.series; | 1060 | |
1064 | create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; | 1064 | ! | 1061 | create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; | 1061 |
1065 | create function sys.generate_series(first tinyint, "limit" tinyint) returns table (value tinyint) external name generator.series; | 1065 | ! | 1062 | create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; | 1062 |
1066 | create function sys.generate_series(first tinyint, "limit" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; | 1066 | - | |||
1067 | create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; | 1067 | 1063 | create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; | 1063 | |
... | ... | ... | ... | ... | ... | # 10:17:18 > |
1194 | create procedure sys.setworkerlimit("sessionid" int, "limit" int) external name clients.setworkerlimit; | 1194 | 1190 | create procedure sys.setworkerlimit("sessionid" int, "limit" int) external name clients.setworkerlimit; | 1190 | |
1195 | create procedure shpattach(fname string) external name shp.attach; | 1195 | - | |||
1196 | create procedure shpload(fid integer) external name shp.import; | 1196 | - | |||
1197 | create procedure shpload(fid integer, filter geometry) external name shp.import; | 1197 | - | |||
1198 | create procedure shrink(sys string, tab string) external name sql.shrink; | 1198 | 1191 | create procedure shrink(sys string, tab string) external name sql.shrink; | 1191 | |
... | ... | ... | ... | ... | ... | # 10:17:18 > |
1329 | create window stddev_pop(val tinyint) returns double external name "sql"."stdevp"; | 1329 | 1322 | create window stddev_pop(val tinyint) returns double external name "sql"."stdevp"; | 1322 | |
+ | 1323 | create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; | 1323 | |||
1330 | create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; | 1330 | 1324 | create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; | 1324 | |
... | ... | ... | ... | ... | ... | # 10:17:18 > |
1334 | create aggregate stddev_samp(val smallint) returns double external name "aggr"."stdev"; | 1334 | 1328 | create aggregate stddev_samp(val smallint) returns double external name "aggr"."stdev"; | 1328 | |
1335 | create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; | 1335 | - | |||
1336 | create window stddev_samp(val bigint) returns double external name "sql"."stdev"; | 1336 | 1329 | create window stddev_samp(val bigint) returns double external name "sql"."stdev"; | 1329 | |
... | ... | ... | ... | ... | ... | # %25, name, name, query, type, |
1573 | [ "sys._tables", "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] | 1573 | 1566 | [ "sys._tables", "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] | 1566 | |
1574 | [ "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" ] | 1574 | ! | 1567 | [ "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" ] | 1567 |
1575 | [ "sys._tables", "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] | 1575 | 1568 | [ "sys._tables", "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] | 1568 | |
... | ... | ... | ... | ... | ... | # %1, name, name, system, query, |
2486 | [ "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 ] | 2486 | 2479 | [ "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 ] | 2479 | |
2487 | [ "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 ] | 2487 | ! | 2480 | [ "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 ] | 2480 |
2488 | [ "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 ] | 2488 | ! | 2481 | [ "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 ] | 2481 |
2489 | [ "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 ] | 2489 | ! | 2482 | [ "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 ] | 2482 |
2490 | [ "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 ] | 2490 | ! | 2483 | [ "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 ] | 2483 |
2491 | [ "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 ] | 2491 | ! | 2484 | [ "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 ] | 2484 |
2492 | [ "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 ] | 2492 | ! | 2485 | [ "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 ] | 2485 |
2493 | [ "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 ] | 2493 | ! | 2486 | [ "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 ] | 2486 |
2494 | [ "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 ] | 2494 | ! | 2487 | [ "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 ] | 2487 |
2495 | [ "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 ] | 2495 | ! | 2488 | [ "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 ] | 2488 |
2496 | [ "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 ] | 2496 | 2489 | [ "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 ] | 2489 | |
2497 | [ "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 ] | 2497 | ! | 2490 | [ "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 ] | 2490 |
2498 | [ "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 ] | 2498 | ! | 2491 | [ "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 ] | 2491 |
2499 | [ "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 ] | 2499 | ! | 2492 | [ "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 ] | 2492 |
2500 | [ "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 ] | 2500 | 2493 | [ "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 ] | 2493 | |
... | ... | ... | ... | ... | ... | # %1, name, name, system, query, |
3037 | [ "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 ] | 3037 | 3030 | [ "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 ] | 3030 | |
3038 | [ "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 ] | 3038 | - | |||
3039 | [ "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 ] | 3039 | - | |||
3040 | [ "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 ] | 3040 | - | |||
3041 | [ "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 ] | 3041 | 3031 | [ "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 ] | 3031 | |
... | ... | ... | ... | ... | ... | # %1, name, name, name, name, |
3662 | [ "function used by function", "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] | 3662 | 3652 | [ "function used by function", "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] | 3652 | |
+ | 3653 | [ "function used by function", "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] | 3653 | |||
3663 | [ "function used by function", "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] | 3663 | 3654 | [ "function used by function", "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] | 3654 | |
... | ... | ... | ... | ... | ... | # %1, name, name, name, name, |
3960 | [ "column used by view", "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] | 3960 | 3951 | [ "column used by view", "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] | 3951 | |
+ | 3952 | [ "column used by view", "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] | 3952 | |||
+ | 3953 | [ "column used by view", "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] | 3953 | |||
+ | 3954 | [ "column used by view", "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] | 3954 | |||
+ | 3955 | [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] | 3955 | |||
+ | 3956 | [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] | 3956 | |||
3961 | [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] | 3961 | 3957 | [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] | 3957 | |
... | ... | ... | ... | ... | ... | # %1, name, name, name, name, |
3967 | [ "column used by view", "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] | 3967 | 3963 | [ "column used by view", "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] | 3963 | |
+ | 3964 | [ "column used by view", "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] | 3964 | |||
3968 | [ "column used by view", "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] | 3968 | 3965 | [ "column used by view", "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] | 3965 | |
... | ... | ... | ... | ... | ... | # %1, name, name, name, name, |
3975 | [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] | 3975 | 3972 | [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] | 3972 | |
+ | 3973 | [ "column used by view", "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] | 3973 | |||
+ | 3974 | [ "column used by view", "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] | 3974 | |||
+ | 3975 | [ "column used by view", "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] | 3975 | |||
+ | 3976 | [ "column used by view", "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] | 3976 | |||
+ | 3977 | [ "column used by view", "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] | 3977 | |||
+ | 3978 | [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] | 3978 | |||
+ | 3979 | [ "column used by view", "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] | 3979 | |||
+ | 3980 | [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] | 3980 | |||
+ | 3981 | [ "column used by view", "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] | 3981 | |||
3976 | [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] | 3976 | 3982 | [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] | 3982 | |
... | ... | ... | ... | ... | ... | # %1, name, name, name, name, |
3988 | [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] | 3988 | 3994 | [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] | 3994 | |
+ | 3995 | [ "column used by view", "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] | 3995 | |||
+ | 3996 | [ "column used by view", "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] | 3996 | |||
+ | 3997 | [ "column used by view", "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] | 3997 | |||
+ | 3998 | [ "column used by view", "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] | 3998 | |||
3989 | [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] | 3989 | 3999 | [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] | 3999 | |
... | ... | ... | ... | ... | ... | # %1, name, name, name, name, |
4003 | [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] | 4003 | 4013 | [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] | 4013 | |
+ | 4014 | [ "column used by view", "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] | 4014 | |||
+ | 4015 | [ "column used by view", "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] | 4015 | |||
+ | 4016 | [ "column used by view", "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] | 4016 | |||
4004 | [ "column used by view", "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] | 4004 | 4017 | [ "column used by view", "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] | 4017 | |
... | ... | ... | ... | ... | ... | # %1, name, name, name, name, |
4050 | [ "column used by view", "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] | 4050 | 4063 | [ "column used by view", "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] | 4063 | |
+ | 4064 | [ "column used by view", "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] | 4064 | |||
+ | 4065 | [ "column used by view", "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] | 4065 | |||
+ | 4066 | [ "column used by view", "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] | 4066 | |||
+ | 4067 | [ "column used by view", "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] | 4067 | |||
4051 | [ "column used by view", "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] | 4051 | 4068 | [ "column used by view", "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] | 4068 | |
... | ... | ... | ... | ... | ... | # %1, name, name, name, name, |
4071 | [ "column used by view", "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] | 4071 | 4088 | [ "column used by view", "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] | 4088 | |
+ | 4089 | [ "column used by view", "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] | 4089 | |||
+ | 4090 | [ "column used by view", "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] | 4090 | |||
+ | 4091 | [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] | 4091 | |||
+ | 4092 | [ "column used by view", "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] | 4092 | |||
+ | 4093 | [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] | 4093 | |||
+ | 4094 | [ "column used by view", "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] | 4094 | |||
4072 | [ "column used by view", "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] | 4072 | 4095 | [ "column used by view", "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] | 4095 | |
... | ... | ... | ... | ... | ... | # %1, name, name, name, name, |
4085 | [ "column used by view", "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] | 4085 | 4108 | [ "column used by view", "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] | 4108 | |
+ | 4109 | [ "column used by view", "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] | 4109 | |||
+ | 4110 | [ "column used by view", "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] | 4110 | |||
+ | 4111 | [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] | 4111 | |||
+ | 4112 | [ "column used by view", "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] | 4112 | |||
+ | 4113 | [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] | 4113 | |||
+ | 4114 | [ "column used by view", "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] | 4114 | |||
4086 | [ "column used by view", "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] | 4086 | 4115 | [ "column used by view", "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] | 4115 | |
... | ... | ... | ... | ... | ... | # %1, name, name, name, name, |
4103 | [ "column used by view", "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] | 4103 | 4132 | [ "column used by view", "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] | 4132 | |
+ | 4133 | [ "column used by view", "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] | 4133 | |||
+ | 4134 | [ "column used by view", "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] | 4134 | |||
+ | 4135 | [ "column used by view", "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] | 4135 | |||
+ | 4136 | [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] | 4136 | |||
+ | 4137 | [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] | 4137 | |||
4104 | [ "column used by view", "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] | 4104 | 4138 | [ "column used by view", "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] | 4138 | |
... | ... | ... | ... | ... | ... | # %1, name, name, name, name, |
4107 | [ "column used by view", "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] | 4107 | 4141 | [ "column used by view", "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] | 4141 | |
+ | 4142 | [ "column used by view", "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] | 4142 | |||
4108 | [ "column used by view", "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] | 4108 | 4143 | [ "column used by view", "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] | 4143 | |
... | ... | ... | ... | ... | ... | # %1, name, name, name, name, |
4125 | [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] | 4125 | 4160 | [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] | 4160 | |
+ | 4161 | [ "column used by view", "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] | 4161 | |||
+ | 4162 | [ "column used by view", "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] | 4162 | |||
+ | 4163 | [ "column used by view", "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] | 4163 | |||
+ | 4164 | [ "column used by view", "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] | 4164 | |||
4126 | [ "column used by view", "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] | 4126 | 4165 | [ "column used by view", "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] | 4165 | |
... | ... | ... | ... | ... | ... | # %1, name, name, name, name, |
4179 | [ "column used by view", "sys", "_columns", "name", "sys", "ids", "VIEW" ] | 4179 | 4218 | [ "column used by view", "sys", "_columns", "name", "sys", "ids", "VIEW" ] | 4218 | |
+ | 4219 | [ "column used by view", "sys", "_columns", "number", "sys", "ids", "VIEW" ] | 4219 | |||
+ | 4220 | [ "column used by view", "sys", "_columns", "storage", "sys", "ids", "VIEW" ] | 4220 | |||
4180 | [ "column used by view", "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] | 4180 | 4221 | [ "column used by view", "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] | 4221 | |
+ | 4222 | [ "column used by view", "sys", "_columns", "type", "sys", "ids", "VIEW" ] | 4222 | |||
+ | 4223 | [ "column used by view", "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] | 4223 | |||
4181 | [ "column used by view", "sys", "_tables", "id", "sys", "ids", "VIEW" ] | 4181 | 4224 | [ "column used by view", "sys", "_tables", "id", "sys", "ids", "VIEW" ] | 4224 | |
... | ... | ... | ... | ... | ... | # %1, name, name, name, name, |
4183 | [ "column used by view", "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] | 4183 | 4226 | [ "column used by view", "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] | 4226 | |
+ | 4227 | [ "column used by view", "sys", "_tables", "system", "sys", "ids", "VIEW" ] | 4227 | |||
4184 | [ "column used by view", "sys", "_tables", "type", "sys", "ids", "VIEW" ] | 4184 | 4228 | [ "column used by view", "sys", "_tables", "type", "sys", "ids", "VIEW" ] | 4228 | |
... | ... | ... | ... | ... | ... | # %1, name, name, name, name, |
4196 | [ "column used by view", "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] | 4196 | 4240 | [ "column used by view", "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] | 4240 | |
+ | 4241 | [ "column used by view", "sys", "keys", "action", "sys", "ids", "VIEW" ] | 4241 | |||
4197 | [ "column used by view", "sys", "keys", "id", "sys", "ids", "VIEW" ] | 4197 | 4242 | [ "column used by view", "sys", "keys", "id", "sys", "ids", "VIEW" ] | 4242 | |
4198 | [ "column used by view", "sys", "keys", "name", "sys", "ids", "VIEW" ] | 4198 | 4243 | [ "column used by view", "sys", "keys", "name", "sys", "ids", "VIEW" ] | 4243 | |
+ | 4244 | [ "column used by view", "sys", "keys", "rkey", "sys", "ids", "VIEW" ] | 4244 | |||
4199 | [ "column used by view", "sys", "keys", "table_id", "sys", "ids", "VIEW" ] | 4199 | 4245 | [ "column used by view", "sys", "keys", "table_id", "sys", "ids", "VIEW" ] | 4245 | |
+ | 4246 | [ "column used by view", "sys", "keys", "type", "sys", "ids", "VIEW" ] | 4246 | |||
+ | 4247 | [ "column used by view", "sys", "objects", "id", "sys", "ids", "VIEW" ] | 4247 | |||
4200 | [ "column used by view", "sys", "schemas", "id", "sys", "ids", "VIEW" ] | 4200 | 4248 | [ "column used by view", "sys", "schemas", "id", "sys", "ids", "VIEW" ] | 4248 | |
... | ... | ... | ... | ... | ... | # %1, name, name, name, name, |
4204 | [ "column used by view", "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] | 4204 | 4252 | [ "column used by view", "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] | 4252 | |
+ | 4253 | [ "column used by view", "sys", "triggers", "condition", "sys", "ids", "VIEW" ] | 4253 | |||
4205 | [ "column used by view", "sys", "triggers", "id", "sys", "ids", "VIEW" ] | 4205 | 4254 | [ "column used by view", "sys", "triggers", "id", "sys", "ids", "VIEW" ] | 4254 | |
4206 | [ "column used by view", "sys", "triggers", "name", "sys", "ids", "VIEW" ] | 4206 | 4255 | [ "column used by view", "sys", "triggers", "name", "sys", "ids", "VIEW" ] | 4255 | |
+ | 4256 | [ "column used by view", "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] | 4256 | |||
+ | 4257 | [ "column used by view", "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] | 4257 | |||
+ | 4258 | [ "column used by view", "sys", "triggers", "statement", "sys", "ids", "VIEW" ] | 4258 | |||
4207 | [ "column used by view", "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] | 4207 | 4259 | [ "column used by view", "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] | 4259 | |
... | ... | ... | ... | ... | ... | # %1, name, name, name, name, |
4212 | [ "column used by view", "tmp", "_columns", "name", "sys", "ids", "VIEW" ] | 4212 | 4264 | [ "column used by view", "tmp", "_columns", "name", "sys", "ids", "VIEW" ] | 4264 | |
+ | 4265 | [ "column used by view", "tmp", "_columns", "number", "sys", "ids", "VIEW" ] | 4265 | |||
+ | 4266 | [ "column used by view", "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] | 4266 | |||
4213 | [ "column used by view", "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] | 4213 | 4267 | [ "column used by view", "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] | 4267 | |
+ | 4268 | [ "column used by view", "tmp", "_columns", "type", "sys", "ids", "VIEW" ] | 4268 | |||
+ | 4269 | [ "column used by view", "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] | 4269 | |||
4214 | [ "column used by view", "tmp", "_tables", "id", "sys", "ids", "VIEW" ] | 4214 | 4270 | [ "column used by view", "tmp", "_tables", "id", "sys", "ids", "VIEW" ] | 4270 | |
... | ... | ... | ... | ... | ... | # %1, name, name, name, name, |
4216 | [ "column used by view", "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] | 4216 | 4272 | [ "column used by view", "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] | 4272 | |
+ | 4273 | [ "column used by view", "tmp", "_tables", "system", "sys", "ids", "VIEW" ] | 4273 | |||
4217 | [ "column used by view", "tmp", "_tables", "type", "sys", "ids", "VIEW" ] | 4217 | 4274 | [ "column used by view", "tmp", "_tables", "type", "sys", "ids", "VIEW" ] | 4274 | |
... | ... | ... | ... | ... | ... | # %1, name, name, name, name, |
4220 | [ "column used by view", "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] | 4220 | 4277 | [ "column used by view", "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] | 4277 | |
+ | 4278 | [ "column used by view", "tmp", "keys", "action", "sys", "ids", "VIEW" ] | 4278 | |||
4221 | [ "column used by view", "tmp", "keys", "id", "sys", "ids", "VIEW" ] | 4221 | 4279 | [ "column used by view", "tmp", "keys", "id", "sys", "ids", "VIEW" ] | 4279 | |
4222 | [ "column used by view", "tmp", "keys", "name", "sys", "ids", "VIEW" ] | 4222 | 4280 | [ "column used by view", "tmp", "keys", "name", "sys", "ids", "VIEW" ] | 4280 | |
+ | 4281 | [ "column used by view", "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] | 4281 | |||
4223 | [ "column used by view", "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] | 4223 | 4282 | [ "column used by view", "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] | 4282 | |
+ | 4283 | [ "column used by view", "tmp", "keys", "type", "sys", "ids", "VIEW" ] | 4283 | |||
4224 | [ "column used by view", "tmp", "triggers", "id", "sys", "ids", "VIEW" ] | 4224 | 4284 | [ "column used by view", "tmp", "triggers", "id", "sys", "ids", "VIEW" ] | 4284 | |
... | ... | ... | ... | ... | ... | # %1, name, name, time, orientat |
4944 | % 12, 7, 21, 10, 9, 6, 0, 0, 0, 110 # length | 4944 | 5004 | % 12, 7, 21, 10, 9, 6, 0, 0, 0, 110 # length | 5004 | |
4945 | [ "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();" ] | 4945 | ! | 5005 | [ "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();" ] | 5005 |
4946 | [ "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();" ] | 4946 | 5006 | [ "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();" ] | 5006 |