Test check.SQL.py (id 5d46ef638df2) (err)
check.stable.out.int128.FILTERED 2020-10-17 01:03:58.742101201 +0200check.test.out.FILTERED 2020-10-17 01:03:59.083104373 +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 5481 lines, 194728 words, 1315500 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5541 lines, 195234 words, 1319645 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5481 lines, 194728 words, 1315500 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5541 lines, 195234 words, 1319645 chars in lines not matching '^$|^(\| |)#` 3
4 # 5651 lines, 198223 words, 1339715 chars in all lines 4 ! 4 # 5711 lines, 198739 words, 1343958 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 >
1057 create procedure sys.flush_log () external name sql."flush_log"; 1057 1053 create procedure sys.flush_log () external name sql."flush_log"; 1053
+ 1054 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 1054
1058 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 1058 ! 1055 create function fuse(one smallint, two smallint) returns integer 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 integer, two integer) returns bigint 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 bigint, two bigint) returns hugeint external name udf.fuse; 1057
1061 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 1061 ! 1058 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 1058
1062 create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; 1062 ! 1059 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 1059
1063 create function sys.generate_series(first bigint, "limit" bigint, stepsize bigint) returns table (value bigint) external name generator.series; 1063 ! 1060 create function sys.generate_series(first bigint, last bigint, stepsize 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 decimal(10,2), last decimal(10,2), stepsize decimal(10,2)) returns table (value decimal(10,2)) 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 double, last double, stepsize double) returns table (value double) 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 hugeint, "limit" hugeint) returns table (value hugeint) 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, "limit" 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 tinyint) returns double external name "aggr"."stdev"; 1339
1346 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1346 1340 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1340
..................
# 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,
1595 [ "sys._tables", "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1595 1588 [ "sys._tables", "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1588
1596 [ "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" ] 1596 ! 1589 [ "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" ] 1589
1597 [ "sys._tables", "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1597 1590 [ "sys._tables", "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1590
..................
# %1, name, name, system, query,
2538 [ "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 ] 2538 2531 [ "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 ] 2531
2539 [ "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 ] 2539 ! 2532 [ "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 ] 2532
2540 [ "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 ] 2540 ! 2533 [ "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 ] 2533
2541 [ "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 ] 2541 ! 2534 [ "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 ] 2534
2542 [ "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 ] 2542 ! 2535 [ "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 ] 2535
2543 [ "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 ] 2543 2536 [ "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 ] 2536
2544 [ "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 ] 2544 2537 [ "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 ] 2537
2545 [ "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 ] 2545 ! 2538 [ "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 ] 2538
2546 [ "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 ] 2546 ! 2539 [ "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 ] 2539
2547 [ "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 ] 2547 ! 2540 [ "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 ] 2540
2548 [ "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 ] 2548 ! 2541 [ "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 ] 2541
2549 [ "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 ] 2549 ! 2542 [ "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 ] 2542
2550 [ "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 ] 2550 2543 [ "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 ] 2543
2551 [ "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 ] 2551 ! 2544 [ "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 ] 2544
2552 [ "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 ] 2552 ! 2545 [ "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 ] 2545
2553 [ "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 ] 2553 ! 2546 [ "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 ] 2546
2554 [ "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 ] 2554 2547 [ "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 ] 2547
..................
# %1, name, name, system, query,
3162 [ "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 ] 3162 3155 [ "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 ] 3155
3163 [ "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 ] 3163 -
3164 [ "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 ] 3164 -
3165 [ "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 ] 3165 -
3166 [ "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 ] 3166 3156 [ "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 ] 3156
..................
# %1, name, name, name, name,
3865 [ "function used by function", "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3865 3855 [ "function used by function", "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3855
+ 3856 [ "function used by function", "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3856
3866 [ "function used by function", "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3866 3857 [ "function used by function", "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3857
..................
# %1, name, name, name, name,
4163 [ "column used by view", "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4163 4154 [ "column used by view", "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4154
+ 4155 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4155
+ 4156 [ "column used by view", "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4156
+ 4157 [ "column used by view", "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4157
+ 4158 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4158
+ 4159 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4159
4164 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4164 4160 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4160
..................
# %1, name, name, name, name,
4170 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4170 4166 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4166
+ 4167 [ "column used by view", "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4167
4171 [ "column used by view", "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4171 4168 [ "column used by view", "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4168
..................
# %1, name, name, name, name,
4178 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4178 4175 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4175
+ 4176 [ "column used by view", "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4176
+ 4177 [ "column used by view", "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4177
+ 4178 [ "column used by view", "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4178
+ 4179 [ "column used by view", "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4179
+ 4180 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4180
+ 4181 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4181
+ 4182 [ "column used by view", "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4182
+ 4183 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4183
+ 4184 [ "column used by view", "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4184
4179 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4179 4185 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4185
..................
# %1, name, name, name, name,
4191 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4191 4197 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4197
+ 4198 [ "column used by view", "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4198
+ 4199 [ "column used by view", "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4199
+ 4200 [ "column used by view", "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4200
+ 4201 [ "column used by view", "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4201
4192 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4192 4202 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4202
..................
# %1, name, name, name, name,
4206 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4206 4216 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4216
+ 4217 [ "column used by view", "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4217
+ 4218 [ "column used by view", "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4218
+ 4219 [ "column used by view", "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4219
4207 [ "column used by view", "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4207 4220 [ "column used by view", "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4220
..................
# %1, name, name, name, name,
4253 [ "column used by view", "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4253 4266 [ "column used by view", "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4266
+ 4267 [ "column used by view", "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4267
+ 4268 [ "column used by view", "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4268
+ 4269 [ "column used by view", "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4269
+ 4270 [ "column used by view", "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4270
4254 [ "column used by view", "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4254 4271 [ "column used by view", "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4271
..................
# %1, name, name, name, name,
4274 [ "column used by view", "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4274 4291 [ "column used by view", "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4291
+ 4292 [ "column used by view", "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4292
+ 4293 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4293
+ 4294 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4294
+ 4295 [ "column used by view", "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4295
+ 4296 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4296
+ 4297 [ "column used by view", "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4297
4275 [ "column used by view", "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4275 4298 [ "column used by view", "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4298
..................
# %1, name, name, name, name,
4288 [ "column used by view", "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4288 4311 [ "column used by view", "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4311
+ 4312 [ "column used by view", "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4312
+ 4313 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4313
+ 4314 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4314
+ 4315 [ "column used by view", "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4315
+ 4316 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4316
+ 4317 [ "column used by view", "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4317
4289 [ "column used by view", "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4289 4318 [ "column used by view", "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4318
..................
# %1, name, name, name, name,
4306 [ "column used by view", "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4306 4335 [ "column used by view", "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4335
+ 4336 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4336
+ 4337 [ "column used by view", "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4337
+ 4338 [ "column used by view", "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4338
+ 4339 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4339
+ 4340 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4340
4307 [ "column used by view", "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4307 4341 [ "column used by view", "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4341
..................
# %1, name, name, name, name,
4310 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4310 4344 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4344
+ 4345 [ "column used by view", "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4345
4311 [ "column used by view", "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4311 4346 [ "column used by view", "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4346
..................
# %1, name, name, name, name,
4328 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4328 4363 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4363
+ 4364 [ "column used by view", "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4364
+ 4365 [ "column used by view", "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4365
+ 4366 [ "column used by view", "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4366
+ 4367 [ "column used by view", "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4367
4329 [ "column used by view", "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4329 4368 [ "column used by view", "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4368
..................
# %1, name, name, name, name,
4382 [ "column used by view", "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4382 4421 [ "column used by view", "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4421
+ 4422 [ "column used by view", "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4422
+ 4423 [ "column used by view", "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4423
4383 [ "column used by view", "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4383 4424 [ "column used by view", "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4424
+ 4425 [ "column used by view", "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4425
+ 4426 [ "column used by view", "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4426
4384 [ "column used by view", "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4384 4427 [ "column used by view", "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4427
..................
# %1, name, name, name, name,
4386 [ "column used by view", "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4386 4429 [ "column used by view", "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4429
+ 4430 [ "column used by view", "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4430
4387 [ "column used by view", "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4387 4431 [ "column used by view", "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4431
..................
# %1, name, name, name, name,
4399 [ "column used by view", "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4399 4443 [ "column used by view", "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4443
+ 4444 [ "column used by view", "sys", "keys", "action", "sys", "ids", "VIEW" ] 4444
4400 [ "column used by view", "sys", "keys", "id", "sys", "ids", "VIEW" ] 4400 4445 [ "column used by view", "sys", "keys", "id", "sys", "ids", "VIEW" ] 4445
4401 [ "column used by view", "sys", "keys", "name", "sys", "ids", "VIEW" ] 4401 4446 [ "column used by view", "sys", "keys", "name", "sys", "ids", "VIEW" ] 4446
+ 4447 [ "column used by view", "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4447
4402 [ "column used by view", "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4402 4448 [ "column used by view", "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4448
+ 4449 [ "column used by view", "sys", "keys", "type", "sys", "ids", "VIEW" ] 4449
+ 4450 [ "column used by view", "sys", "objects", "id", "sys", "ids", "VIEW" ] 4450
4403 [ "column used by view", "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4403 4451 [ "column used by view", "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4451
..................
# %1, name, name, name, name,
4407 [ "column used by view", "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4407 4455 [ "column used by view", "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4455
+ 4456 [ "column used by view", "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4456
4408 [ "column used by view", "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4408 4457 [ "column used by view", "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4457
4409 [ "column used by view", "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4409 4458 [ "column used by view", "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4458
+ 4459 [ "column used by view", "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4459
+ 4460 [ "column used by view", "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4460
+ 4461 [ "column used by view", "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4461
4410 [ "column used by view", "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4410 4462 [ "column used by view", "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4462
..................
# %1, name, name, name, name,
4415 [ "column used by view", "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4415 4467 [ "column used by view", "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4467
+ 4468 [ "column used by view", "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4468
+ 4469 [ "column used by view", "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4469
4416 [ "column used by view", "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4416 4470 [ "column used by view", "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4470
+ 4471 [ "column used by view", "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4471
+ 4472 [ "column used by view", "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4472
4417 [ "column used by view", "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4417 4473 [ "column used by view", "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4473
..................
# %1, name, name, name, name,
4419 [ "column used by view", "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4419 4475 [ "column used by view", "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4475
+ 4476 [ "column used by view", "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4476
4420 [ "column used by view", "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4420 4477 [ "column used by view", "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4477
..................
# %1, name, name, name, name,
4423 [ "column used by view", "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4423 4480 [ "column used by view", "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4480
+ 4481 [ "column used by view", "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4481
4424 [ "column used by view", "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4424 4482 [ "column used by view", "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4482
4425 [ "column used by view", "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4425 4483 [ "column used by view", "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4483
+ 4484 [ "column used by view", "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4484
4426 [ "column used by view", "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4426 4485 [ "column used by view", "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4485
+ 4486 [ "column used by view", "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4486
4427 [ "column used by view", "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4427 4487 [ "column used by view", "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4487
..................
# %1, name, name, time, orientat
5167 % 12, 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5167 5227 % 12, 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5227
5168 [ "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();" ] 5168 ! 5228 [ "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();" ] 5228
5169 [ "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();" ] 5169 5229 [ "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();" ] 5229