Test check.SQL.py (id 666b3fcab133) (err)
check.stable.out.int128.FILTERED 2020-11-20 23:07:27.206307638 +0100check.test.out.FILTERED 2020-11-20 23:07:27.541309448 +0100
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 5479 lines, 194467 words, 1313681 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5539 lines, 194973 words, 1317826 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5479 lines, 194467 words, 1313681 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5539 lines, 194973 words, 1317826 chars in lines not matching '^$|^(\| |)#` 3
4 # 5649 lines, 197962 words, 1337896 chars in all lines 4 ! 4 # 5709 lines, 198478 words, 1342141 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,
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, \"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 ] 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, \"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 ] 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,
3159 [ "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 ] 3159 3152 [ "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 ] 3152
3160 [ "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 ] 3160 -
3161 [ "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 ] 3161 -
3162 [ "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 ] 3162 -
3163 [ "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 ] 3163 3153 [ "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 ] 3153
..................
# %1, name, name, name, name,
3863 [ "function used by function", "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3863 3853 [ "function used by function", "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3853
+ 3854 [ "function used by function", "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3854
3864 [ "function used by function", "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3864 3855 [ "function used by function", "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3855
..................
# %1, name, name, name, name,
4161 [ "column used by view", "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4161 4152 [ "column used by view", "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4152
+ 4153 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4153
+ 4154 [ "column used by view", "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4154
+ 4155 [ "column used by view", "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4155
+ 4156 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4156
+ 4157 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4157
4162 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4162 4158 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4158
..................
# %1, name, name, name, name,
4168 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4168 4164 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4164
+ 4165 [ "column used by view", "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4165
4169 [ "column used by view", "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4169 4166 [ "column used by view", "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4166
..................
# %1, name, name, name, name,
4176 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4176 4173 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4173
+ 4174 [ "column used by view", "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4174
+ 4175 [ "column used by view", "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4175
+ 4176 [ "column used by view", "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4176
+ 4177 [ "column used by view", "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4177
+ 4178 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4178
+ 4179 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4179
+ 4180 [ "column used by view", "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4180
+ 4181 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4181
+ 4182 [ "column used by view", "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4182
4177 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4177 4183 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4183
..................
# %1, name, name, name, name,
4189 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4189 4195 [ "column used by view", "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4195
+ 4196 [ "column used by view", "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4196
+ 4197 [ "column used by view", "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4197
+ 4198 [ "column used by view", "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4198
+ 4199 [ "column used by view", "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4199
4190 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4190 4200 [ "column used by view", "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4200
..................
# %1, name, name, name, name,
4204 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4204 4214 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4214
+ 4215 [ "column used by view", "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4215
+ 4216 [ "column used by view", "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4216
+ 4217 [ "column used by view", "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4217
4205 [ "column used by view", "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4205 4218 [ "column used by view", "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4218
..................
# %1, name, name, name, name,
4251 [ "column used by view", "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4251 4264 [ "column used by view", "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4264
+ 4265 [ "column used by view", "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4265
+ 4266 [ "column used by view", "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4266
+ 4267 [ "column used by view", "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4267
+ 4268 [ "column used by view", "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4268
4252 [ "column used by view", "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4252 4269 [ "column used by view", "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4269
..................
# %1, name, name, name, name,
4272 [ "column used by view", "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4272 4289 [ "column used by view", "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4289
+ 4290 [ "column used by view", "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4290
+ 4291 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4291
+ 4292 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4292
+ 4293 [ "column used by view", "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4293
+ 4294 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4294
+ 4295 [ "column used by view", "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4295
4273 [ "column used by view", "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4273 4296 [ "column used by view", "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4296
..................
# %1, name, name, name, name,
4286 [ "column used by view", "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4286 4309 [ "column used by view", "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4309
+ 4310 [ "column used by view", "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4310
+ 4311 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4311
+ 4312 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4312
+ 4313 [ "column used by view", "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4313
+ 4314 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4314
+ 4315 [ "column used by view", "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4315
4287 [ "column used by view", "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4287 4316 [ "column used by view", "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4316
..................
# %1, name, name, name, name,
4304 [ "column used by view", "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4304 4333 [ "column used by view", "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4333
+ 4334 [ "column used by view", "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4334
+ 4335 [ "column used by view", "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4335
+ 4336 [ "column used by view", "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4336
+ 4337 [ "column used by view", "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4337
+ 4338 [ "column used by view", "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4338
4305 [ "column used by view", "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4305 4339 [ "column used by view", "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4339
..................
# %1, name, name, name, name,
4308 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4308 4342 [ "column used by view", "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4342
+ 4343 [ "column used by view", "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4343
4309 [ "column used by view", "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4309 4344 [ "column used by view", "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4344
..................
# %1, name, name, name, name,
4326 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4326 4361 [ "column used by view", "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4361
+ 4362 [ "column used by view", "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4362
+ 4363 [ "column used by view", "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4363
+ 4364 [ "column used by view", "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4364
+ 4365 [ "column used by view", "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4365
4327 [ "column used by view", "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4327 4366 [ "column used by view", "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4366
..................
# %1, name, name, name, name,
4380 [ "column used by view", "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4380 4419 [ "column used by view", "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4419
+ 4420 [ "column used by view", "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4420
+ 4421 [ "column used by view", "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4421
4381 [ "column used by view", "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4381 4422 [ "column used by view", "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4422
+ 4423 [ "column used by view", "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4423
+ 4424 [ "column used by view", "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4424
4382 [ "column used by view", "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4382 4425 [ "column used by view", "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4425
..................
# %1, name, name, name, name,
4384 [ "column used by view", "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4384 4427 [ "column used by view", "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4427
+ 4428 [ "column used by view", "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4428
4385 [ "column used by view", "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4385 4429 [ "column used by view", "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4429
..................
# %1, name, name, name, name,
4397 [ "column used by view", "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4397 4441 [ "column used by view", "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4441
+ 4442 [ "column used by view", "sys", "keys", "action", "sys", "ids", "VIEW" ] 4442
4398 [ "column used by view", "sys", "keys", "id", "sys", "ids", "VIEW" ] 4398 4443 [ "column used by view", "sys", "keys", "id", "sys", "ids", "VIEW" ] 4443
4399 [ "column used by view", "sys", "keys", "name", "sys", "ids", "VIEW" ] 4399 4444 [ "column used by view", "sys", "keys", "name", "sys", "ids", "VIEW" ] 4444
+ 4445 [ "column used by view", "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4445
4400 [ "column used by view", "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4400 4446 [ "column used by view", "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4446
+ 4447 [ "column used by view", "sys", "keys", "type", "sys", "ids", "VIEW" ] 4447
+ 4448 [ "column used by view", "sys", "objects", "id", "sys", "ids", "VIEW" ] 4448
4401 [ "column used by view", "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4401 4449 [ "column used by view", "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4449
..................
# %1, name, name, name, name,
4405 [ "column used by view", "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4405 4453 [ "column used by view", "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4453
+ 4454 [ "column used by view", "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4454
4406 [ "column used by view", "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4406 4455 [ "column used by view", "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4455
4407 [ "column used by view", "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4407 4456 [ "column used by view", "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4456
+ 4457 [ "column used by view", "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4457
+ 4458 [ "column used by view", "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4458
+ 4459 [ "column used by view", "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4459
4408 [ "column used by view", "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4408 4460 [ "column used by view", "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4460
..................
# %1, name, name, name, name,
4413 [ "column used by view", "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4413 4465 [ "column used by view", "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4465
+ 4466 [ "column used by view", "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4466
+ 4467 [ "column used by view", "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4467
4414 [ "column used by view", "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4414 4468 [ "column used by view", "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4468
+ 4469 [ "column used by view", "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4469
+ 4470 [ "column used by view", "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4470
4415 [ "column used by view", "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4415 4471 [ "column used by view", "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4471
..................
# %1, name, name, name, name,
4417 [ "column used by view", "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4417 4473 [ "column used by view", "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4473
+ 4474 [ "column used by view", "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4474
4418 [ "column used by view", "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4418 4475 [ "column used by view", "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4475
..................
# %1, name, name, name, name,
4421 [ "column used by view", "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4421 4478 [ "column used by view", "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4478
+ 4479 [ "column used by view", "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4479
4422 [ "column used by view", "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4422 4480 [ "column used by view", "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4480
4423 [ "column used by view", "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4423 4481 [ "column used by view", "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4481
+ 4482 [ "column used by view", "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4482
4424 [ "column used by view", "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4424 4483 [ "column used by view", "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4483
+ 4484 [ "column used by view", "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4484
4425 [ "column used by view", "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4425 4485 [ "column used by view", "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4485
..................
# %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