Test check.SQL.py (id baf04b4f27a7) (err)
check.stable.out.int128.FILTERED 2020-11-22 19:23:19.673649672 +0100check.test.out.FILTERED 2020-11-22 19:23:19.821647421 +0100
1 Statistics about stdout of test 'check` in directory 'sql/test/emptydb-upgrade-chain-hge`: 1 1 Statistics about stdout of test 'check` in directory 'sql/test/emptydb-upgrade-chain-hge`: 1
2 5485 lines, 194861 words, 1316363 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5545 lines, 195367 words, 1320490 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5485 lines, 194861 words, 1316363 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5545 lines, 195367 words, 1320490 chars in lines not matching '^$|^(\| |)#` 3
4 # 5655 lines, 198356 words, 1340578 chars in all lines 4 ! 4 # 5715 lines, 198872 words, 1344809 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 >
1058 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 1058 1054 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 1054
+ 1055 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 1055
1059 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 1059 ! 1056 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 1056
1060 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 1060 ! 1057 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 1057
1061 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 1061 -
1062 create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; 1062 ! 1058 create function sys.generate_series(first hugeint, last hugeint) returns table (value hugeint) external name generator.series; 1058
create function sys.generate_series(first bigint, "limit" + 1059 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 1059
1063 bigint, stepsize bigint) returns table (value bigint) external name generator.series; 1063 ! 1060 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 1060
1064 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; 1064 ! 1061 create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series; 1061
1065 create function sys.generate_series(first double, "limit" double, stepsize double) returns table (value double) external name generator.series; 1065 ! 1062 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; 1062
1066 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 1066 ! 1063 create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series; 1063
1067 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 1067 ! 1064 create function sys.generate_series(first hugeint, last hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 1064
1068 create function sys.generate_series(first int, "limit" int) returns table (value int) external name generator.series; 1068 ! 1065 create function sys.generate_series(first int, last int) returns table (value int) external name generator.series; 1065
1069 create function sys.generate_series(first int, "limit" int, stepsize int) returns table (value int) external name generator.series; 1069 ! 1066 create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series; 1066
1070 create function sys.generate_series(first real, "limit" real, stepsize real) returns table (value real) external name generator.series; 1070 ! 1067 create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series; 1067
1071 create function sys.generate_series(first smallint, "limit" smallint) returns table (value smallint) external name generator.series; 1071 ! 1068 create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series; 1068
1072 create function sys.generate_series(first smallint, "limit" smallint, stepsize smallint) returns table (value smallint) external name generator.series; 1072 ! 1069 create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series; 1069
1073 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval day) returns table (value timestamp) external name generator.series; 1073 1070 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval day) returns table (value timestamp) external name generator.series; 1070
1074 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1074 ! 1071 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1071
1075 create function sys.generate_series(first tinyint, "limit" tinyint) returns table (value tinyint) external name generator.series; 1075 ! 1072 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1072
1076 create function sys.generate_series(first tinyint, "limit" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1076 -
1077 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1077 1073 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1073
..................
# 10:17:18 >
1208 create procedure sys.setworkerlimit("sessionid" int, "limit" int) external name clients.setworkerlimit; 1208 1204 create procedure sys.setworkerlimit("sessionid" int, "limit" int) external name clients.setworkerlimit; 1204
1209 create procedure shpattach(fname string) external name shp.attach; 1209 -
1210 create procedure shpload(fid integer) external name shp.import; 1210 -
1211 create procedure shpload(fid integer, filter geometry) external name shp.import; 1211 -
1212 create procedure shrink(sys string, tab string) external name sql.shrink; 1212 1205 create procedure shrink(sys string, tab string) external name sql.shrink; 1205
..................
# 10:17:18 >
1345 create window stddev_pop(val tinyint) returns double external name "sql"."stdevp"; 1345 1338 create window stddev_pop(val tinyint) returns double external name "sql"."stdevp"; 1338
+ 1339 create aggregate stddev_samp(val hugeint) returns double external name "aggr"."stdev"; 1339
1346 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1346 -
1347 create aggregate stddev_samp(val double) returns double external name "aggr"."stdev"; 1347 -
1348 create aggregate stddev_samp(val hugeint) returns double external name "aggr"."stdev"; 1348 ! 1340 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1340
+ 1341 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1341
+ 1342 create aggregate stddev_samp(val double) returns double external name "aggr"."stdev"; 1342
1349 create aggregate stddev_samp(val integer) returns double external name "aggr"."stdev"; 1349 1343 create aggregate stddev_samp(val integer) returns double external name "aggr"."stdev"; 1343
..................
# 10:17:18 >
1351 create aggregate stddev_samp(val smallint) returns double external name "aggr"."stdev"; 1351 1345 create aggregate stddev_samp(val smallint) returns double external name "aggr"."stdev"; 1345
1352 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1352 -
1353 create window stddev_samp(val bigint) returns double external name "sql"."stdev"; 1353 1346 create window stddev_samp(val bigint) returns double external name "sql"."stdev"; 1346
..................
# %25, name, name, query, type,
1596 [ "sys._tables", "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1596 1589 [ "sys._tables", "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1589
1597 [ "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" ] 1597 ! 1590 [ "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" ] 1590
1598 [ "sys._tables", "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1598 1591 [ "sys._tables", "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1591
..................
# %1, name, name, system, query,
2539 [ "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 ] 2539 2532 [ "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 ] 2532
2540 [ "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 ] 2540 ! 2533 [ "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 ] 2533
2541 [ "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 ] 2541 ! 2534 [ "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 ] 2534
2542 [ "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 ] 2542 ! 2535 [ "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 ] 2535
2543 [ "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 ] 2543 ! 2536 [ "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 ] 2536
2544 [ "sys.functions", "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first hugeint, \"limit\" hugeint) returns table (value hugeint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, true, "value", "hugeint", 128, 0, "out", "first", "hugeint", 128, 0, "in", "limit", "hugeint", 128, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2544 ! 2537 [ "sys.functions", "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first hugeint, last hugeint) returns table (value hugeint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, true, "value", "hugeint", 128, 0, "out", "first", "hugeint", 128, 0, "in", "last", "hugeint", 128, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2537
2545 [ "sys.functions", "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first hugeint, \"limit\" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, true, "value", "hugeint", 128, 0, "out", "first", "hugeint", 128, 0, "in", "limit", "hugeint", 128, 0, "in", "stepsize", "hugeint", 128, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2545 ! 2538 [ "sys.functions", "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first hugeint, last hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, true, "value", "hugeint", 128, 0, "out", "first", "hugeint", 128, 0, "in", "last", "hugeint", 128, 0, "in", "stepsize", "hugeint", 128, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2538
2546 [ "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 ] 2546 ! 2539 [ "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 ] 2539
2547 [ "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 ] 2547 ! 2540 [ "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 ] 2540
2548 [ "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 ] 2548 ! 2541 [ "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 ] 2541
2549 [ "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 ] 2549 ! 2542 [ "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 ] 2542
2550 [ "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 ] 2550 ! 2543 [ "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 ] 2543
2551 [ "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 ] 2551 2544 [ "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 ] 2544
2552 [ "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 ] 2552 ! 2545 [ "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 ] 2545
2553 [ "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 ] 2553 ! 2546 [ "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 ] 2546
2554 [ "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 ] 2554 ! 2547 [ "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 ] 2547
2555 [ "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 ] 2555 2548 [ "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 ] 2548
..................
# %1, name, name, system, query,
3163 [ "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 ] 3163 3156 [ "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 ] 3156
3164 [ "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 ] 3164 -
3165 [ "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 ] 3165 -
3166 [ "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 ] 3166 -
3167 [ "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 ] 3167 3157 [ "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 ] 3157
..................
# %1, name, name, name, name,
3867 [ "function used by function", "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3867 3857 [ "function used by function", "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3857
+ 3858 [ "function used by function", "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3858
3868 [ "function used by function", "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3868 3859 [ "function used by function", "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3859
..................
# %1, name, name, name, name,
4165 [ "column used by view", "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4165 4156 [ "column used by view", "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4156
+ 4157 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4157
+ 4158 [ "column used by view", "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4158
+ 4159 [ "column used by view", "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4159
+ 4160 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4160
+ 4161 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4161
4166 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4166 4162 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4162
..................
# %1, name, name, name, name,
4172 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4172 4168 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4168
+ 4169 [ "column used by view", "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4169
4173 [ "column used by view", "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4173 4170 [ "column used by view", "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4170
..................
# %1, name, name, name, name,
4180 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4180 4177 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4177
+ 4178 [ "column used by view", "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4178
+ 4179 [ "column used by view", "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4179
+ 4180 [ "column used by view", "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4180
+ 4181 [ "column used by view", "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4181
+ 4182 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4182
+ 4183 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4183
+ 4184 [ "column used by view", "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4184
+ 4185 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4185
+ 4186 [ "column used by view", "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4186
4181 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4181 4187 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4187
..................
# %1, name, name, name, name,
4193 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4193 4199 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4199
+ 4200 [ "column used by view", "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4200
+ 4201 [ "column used by view", "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4201
+ 4202 [ "column used by view", "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4202
+ 4203 [ "column used by view", "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4203
4194 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4194 4204 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4204
..................
# %1, name, name, name, name,
4208 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4208 4218 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4218
+ 4219 [ "column used by view", "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4219
+ 4220 [ "column used by view", "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4220
+ 4221 [ "column used by view", "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4221
4209 [ "column used by view", "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4209 4222 [ "column used by view", "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4222
..................
# %1, name, name, name, name,
4255 [ "column used by view", "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4255 4268 [ "column used by view", "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4268
+ 4269 [ "column used by view", "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4269
+ 4270 [ "column used by view", "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4270
+ 4271 [ "column used by view", "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4271
+ 4272 [ "column used by view", "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4272
4256 [ "column used by view", "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4256 4273 [ "column used by view", "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4273
..................
# %1, name, name, name, name,
4276 [ "column used by view", "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4276 4293 [ "column used by view", "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4293
+ 4294 [ "column used by view", "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4294
+ 4295 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4295
+ 4296 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4296
+ 4297 [ "column used by view", "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4297
+ 4298 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4298
+ 4299 [ "column used by view", "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4299
4277 [ "column used by view", "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4277 4300 [ "column used by view", "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4300
..................
# %1, name, name, name, name,
4290 [ "column used by view", "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4290 4313 [ "column used by view", "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4313
+ 4314 [ "column used by view", "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4314
+ 4315 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4315
+ 4316 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4316
+ 4317 [ "column used by view", "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4317
+ 4318 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4318
+ 4319 [ "column used by view", "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4319
4291 [ "column used by view", "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4291 4320 [ "column used by view", "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4320
..................
# %1, name, name, name, name,
4308 [ "column used by view", "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4308 4337 [ "column used by view", "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4337
+ 4338 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4338
+ 4339 [ "column used by view", "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4339
+ 4340 [ "column used by view", "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4340
+ 4341 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4341
+ 4342 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4342
4309 [ "column used by view", "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4309 4343 [ "column used by view", "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4343
..................
# %1, name, name, name, name,
4312 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4312 4346 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4346
+ 4347 [ "column used by view", "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4347
4313 [ "column used by view", "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4313 4348 [ "column used by view", "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4348
..................
# %1, name, name, name, name,
4330 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4330 4365 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4365
+ 4366 [ "column used by view", "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4366
+ 4367 [ "column used by view", "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4367
+ 4368 [ "column used by view", "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4368
+ 4369 [ "column used by view", "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4369
4331 [ "column used by view", "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4331 4370 [ "column used by view", "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4370
..................
# %1, name, name, name, name,
4384 [ "column used by view", "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4384 4423 [ "column used by view", "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4423
+ 4424 [ "column used by view", "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4424
+ 4425 [ "column used by view", "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4425
4385 [ "column used by view", "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4385 4426 [ "column used by view", "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4426
+ 4427 [ "column used by view", "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4427
+ 4428 [ "column used by view", "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4428
4386 [ "column used by view", "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4386 4429 [ "column used by view", "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4429
..................
# %1, name, name, name, name,
4388 [ "column used by view", "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4388 4431 [ "column used by view", "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4431
+ 4432 [ "column used by view", "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4432
4389 [ "column used by view", "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4389 4433 [ "column used by view", "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4433
..................
# %1, name, name, name, name,
4401 [ "column used by view", "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4401 4445 [ "column used by view", "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4445
+ 4446 [ "column used by view", "sys", "keys", "action", "sys", "ids", "VIEW" ] 4446
4402 [ "column used by view", "sys", "keys", "id", "sys", "ids", "VIEW" ] 4402 4447 [ "column used by view", "sys", "keys", "id", "sys", "ids", "VIEW" ] 4447
4403 [ "column used by view", "sys", "keys", "name", "sys", "ids", "VIEW" ] 4403 4448 [ "column used by view", "sys", "keys", "name", "sys", "ids", "VIEW" ] 4448
+ 4449 [ "column used by view", "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4449
4404 [ "column used by view", "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4404 4450 [ "column used by view", "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4450
+ 4451 [ "column used by view", "sys", "keys", "type", "sys", "ids", "VIEW" ] 4451
+ 4452 [ "column used by view", "sys", "objects", "id", "sys", "ids", "VIEW" ] 4452
4405 [ "column used by view", "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4405 4453 [ "column used by view", "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4453
..................
# %1, name, name, name, name,
4409 [ "column used by view", "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4409 4457 [ "column used by view", "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4457
+ 4458 [ "column used by view", "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4458
4410 [ "column used by view", "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4410 4459 [ "column used by view", "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4459
4411 [ "column used by view", "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4411 4460 [ "column used by view", "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4460
+ 4461 [ "column used by view", "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4461
+ 4462 [ "column used by view", "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4462
+ 4463 [ "column used by view", "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4463
4412 [ "column used by view", "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4412 4464 [ "column used by view", "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4464
..................
# %1, name, name, name, name,
4417 [ "column used by view", "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4417 4469 [ "column used by view", "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4469
+ 4470 [ "column used by view", "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4470
+ 4471 [ "column used by view", "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4471
4418 [ "column used by view", "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4418 4472 [ "column used by view", "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4472
+ 4473 [ "column used by view", "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4473
+ 4474 [ "column used by view", "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4474
4419 [ "column used by view", "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4419 4475 [ "column used by view", "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4475
..................
# %1, name, name, name, name,
4421 [ "column used by view", "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4421 4477 [ "column used by view", "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4477
+ 4478 [ "column used by view", "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4478
4422 [ "column used by view", "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4422 4479 [ "column used by view", "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4479
..................
# %1, name, name, name, name,
4425 [ "column used by view", "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4425 4482 [ "column used by view", "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4482
+ 4483 [ "column used by view", "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4483
4426 [ "column used by view", "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4426 4484 [ "column used by view", "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4484
4427 [ "column used by view", "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4427 4485 [ "column used by view", "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4485
+ 4486 [ "column used by view", "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4486
4428 [ "column used by view", "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4428 4487 [ "column used by view", "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4487
+ 4488 [ "column used by view", "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4488
4429 [ "column used by view", "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4429 4489 [ "column used by view", "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4489
..................
# %1, name, name, time, orientat
5171 % 12, 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5171 5231 % 12, 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5231
5172 [ "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();" ] 5172 ! 5232 [ "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();" ] 5232
5173 [ "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();" ] 5173 5233 [ "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();" ] 5233