Test check.SQL.py (id 257bc073dc33) (err)
check.stable.out.FILTERED 2019-12-02 21:06:42.770935598 +0100check.test.out.FILTERED 2019-12-02 21:06:42.909933448 +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 5380 lines, 196681 words, 1291193 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5428 lines, 196575 words, 1291468 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5380 lines, 196681 words, 1291193 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5428 lines, 196575 words, 1291468 chars in lines not matching '^$|^(\| |)#` 3
4 # 5461 lines, 199120 words, 1308347 chars in all lines 4 ! 4 # 5508 lines, 199013 words, 1308651 chars in all lines 4
5 5 5 5
..................
# 10:17:18 >
197 \dSf sys."left_shift_assign" 197 196 \dSf sys."left_shift_assign" 196
198 \dSf sys."lidarattach" 198 -
199 \dSf sys."lidarexport" 199 -
200 \dSf sys."lidarload" 200 -
201 \dSf sys."like" 201 197 \dSf sys."like" 197
..................
# 10:17:18 >
245 \dSf sys."settimeout" 245 241 \dSf sys."settimeout" 241
246 \dSf sys."shpattach" 246 -
247 \dSf sys."shpload" 247 -
248 \dSf sys."shrink" 248 242 \dSf sys."shrink" 242
..................
# 10:17:18 >
582 SYSTEM FUNCTION sys.levenshtein 582 576 SYSTEM FUNCTION sys.levenshtein 576
583 SYSTEM PROCEDURE sys.lidarattach 583 -
584 SYSTEM PROCEDURE sys.lidarexport 584 -
585 SYSTEM PROCEDURE sys.lidarload 585 -
586 SYSTEM FILTER FUNCTION sys.like 586 577 SYSTEM FILTER FUNCTION sys.like 577
..................
# 10:17:18 >
696 SYSTEM PROCEDURE sys.settimeout 696 687 SYSTEM PROCEDURE sys.settimeout 687
697 SYSTEM PROCEDURE sys.shpattach 697 -
698 SYSTEM PROCEDURE sys.shpload 698 -
699 SYSTEM PROCEDURE sys.shrink 699 688 SYSTEM PROCEDURE sys.shrink 688
..................
# 10:17:18 >
949 create view sys.tracelog as select * from sys.tracelog(); 949 938 create view sys.tracelog as select * from sys.tracelog(); 938
950 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"; 950 + 939 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" ; 939
951 create view sys.var_values (var_name, value) as select 'cache' as var_name, convert(cache, varchar(10)) as value union all 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; 951 940 create view sys.var_values (var_name, value) as select 'cache' as var_name, convert(cache, varchar(10)) as value union all 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; 940
..................
# 10:17:18 >
987 create procedure sys.flush_log () external name sql."flush_log"; 987 976 create procedure sys.flush_log () external name sql."flush_log"; 976
+ 977 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 977
988 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 988 ! 978 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 978
989 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 989 ! 979 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 979
990 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 990 ! 980 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 980
991 create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; 991 ! 981 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 981
992 create function sys.generate_series(first bigint, "limit" bigint, stepsize bigint) returns table (value bigint) external name generator.series; 992 ! 982 create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series; 982
993 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; 993 ! 983 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; 983
994 create function sys.generate_series(first double, "limit" double, stepsize double) returns table (value double) external name generator.series; 994 ! 984 create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series; 984
995 create function sys.generate_series(first int, "limit" int) returns table (value int) external name generator.series; 995 ! 985 create function sys.generate_series(first int, last int) returns table (value int) external name generator.series; 985
996 create function sys.generate_series(first int, "limit" int, stepsize int) returns table (value int) external name generator.series; 996 ! 986 create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series; 986
997 create function sys.generate_series(first real, "limit" real, stepsize real) returns table (value real) external name generator.series; 997 ! 987 create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series; 987
998 create function sys.generate_series(first smallint, "limit" smallint) returns table (value smallint) external name generator.series; 998 ! 988 create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series; 988
999 create function sys.generate_series(first smallint, "limit" smallint, stepsize smallint) returns table (value smallint) external name generator.series; 999 ! 989 create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series; 989
1000 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1000 ! 990 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 990
1001 create function sys.generate_series(first tinyint, "limit" tinyint) returns table (value tinyint) external name generator.series; 1001 -
1002 create function sys.generate_series(first tinyint, "limit" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1002 ! 991 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 991
1003 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1003 992 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 992
..................
# 10:17:18 >
1034 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1034 1023 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1023
1035 create procedure lidarattach(fname string) external name lidar.attach; 1035 ! 1024 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1024
1036 create procedure lidarexport(tname string, fname string, format string) external name lidar.export; 1036 -
1037 create procedure lidarload(tname string) external name lidar.load; 1037 -
1038 create filter function "like"(val string, pat string) external name algebra."like"; 1038 1025 create filter function "like"(val string, pat string) external name algebra."like"; 1025
1039 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1039 -
1040 create procedure listdir(dirname string) external name fits.listdir; 1040 1026 create procedure listdir(dirname string) external name fits.listdir; 1026
..................
# 10:17:18 >
1077 create function sys.password_hash (username string) returns string external name sql.password; 1077 1063 create function sys.password_hash (username string) returns string external name sql.password; 1063
+ 1064 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1064
1078 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1078 1065 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1065
1079 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1079 -
1080 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1080 1066 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1066
..................
# 10:17:18 >
1122 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1122 1108 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1108
1123 create procedure shpattach(fname string) external name shp.attach; 1123 -
1124 create procedure shpload(fid integer) external name shp.import; 1124 -
1125 create procedure shpload(fid integer, filter geometry) external name shp.import; 1125 -
1126 create procedure shrink(sys string, tab string) external name sql.shrink; 1126 1109 create procedure shrink(sys string, tab string) external name sql.shrink; 1109
..................
# 10:17:18 >
1256 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1256 1239 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1239
+ 1240 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1240
1257 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1257 1241 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1241
..................
# 10:17:18 >
1266 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1266 1250 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1250
1267 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1267 -
1268 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1268 1251 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1251
..................
# .s, .t, .L15, .L16, .t,
1484 [ "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1484 1467 [ "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1467
1485 [ "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" ] 1485 ! 1468 [ "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" ] 1468
1486 [ "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1486 1469 [ "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1469
..................
#select t.name, c.name, c.type, c.type_d
2016 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2016 1999 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 1999
2017 [ "storagemodel", "orderidxsize", "bigint", 64, 0, NULL, true, 9, NULL ] 2017 ! 2000 [ "storagemodel", "orderidxsize", "bigint", 63, 0, NULL, true, 9, NULL ] 2000
2018 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2018 2001 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2001
..................
# .s, .f, .L47, .L50, .f,
2376 [ "sys", "fuse", "SYSTEM", "create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse;", "udf", "MAL", "Scalar function", false, false, false, "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 ] 2376 2359 [ "sys", "fuse", "SYSTEM", "create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse;", "udf", "MAL", "Scalar function", false, false, false, "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 ] 2359
2377 [ "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, "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 ] 2377 ! 2360 [ "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, "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 ] 2360
2378 [ "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, "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 ] 2378 ! 2361 [ "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, "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 ] 2361
2379 [ "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, "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 ] 2379 ! 2362 [ "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, "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 ] 2362
2380 [ "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, "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 ] 2380 ! 2363 [ "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, "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 ] 2363
2381 [ "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, "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 ] 2381 ! 2364 [ "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, "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 ] 2364
2382 [ "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, "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 ] 2382 ! 2365 [ "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, "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 ] 2365
2383 [ "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, "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 ] 2383 ! 2366 [ "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, "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 ] 2366
2384 [ "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, "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 ] 2384 ! 2367 [ "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, "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 ] 2367
2385 [ "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, "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 ] 2385 ! 2368 [ "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, "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 ] 2368
2386 [ "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, "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 ] 2386 ! 2369 [ "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, "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 ] 2369
2387 [ "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, "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 ] 2387 ! 2370 [ "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, "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 ] 2370
2388 [ "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, "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 ] 2388 ! 2371 [ "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, "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 ] 2371
2389 [ "sys", "geometrytype", "SYSTEM", "create function geometrytype(geom geometry) returns string external name geom.\"GeometryType1\";", "geom", "MAL", "Scalar function", false, false, false, "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 ] 2389 2372 [ "sys", "geometrytype", "SYSTEM", "create function geometrytype(geom geometry) returns string external name geom.\"GeometryType1\";", "geom", "MAL", "Scalar function", false, false, false, "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 ] 2372
..................
# .s, .f, .L47, .L50, .f,
2491 [ "sys", "levenshtein", "SYSTEM", "levenshtein", "txtsim", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "varchar", 0, 0, "in", "arg_2", "varchar", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "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 ] 2491 2474 [ "sys", "levenshtein", "SYSTEM", "levenshtein", "txtsim", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "varchar", 0, 0, "in", "arg_2", "varchar", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "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 ] 2474
2492 [ "sys", "lidarattach", "SYSTEM", "create procedure lidarattach(fname string) external name lidar.attach;", "lidar", "MAL", "Procedure", true, false, false, "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 ] 2492 -
2493 [ "sys", "lidarexport", "SYSTEM", "create procedure lidarexport(tname string, fname string, format string) external name lidar.export;", "lidar", "MAL", "Procedure", true, false, false, "tname", "clob", 0, 0, "in", "fname", "clob", 0, 0, "in", "format", "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 ] 2493 -
2494 [ "sys", "lidarload", "SYSTEM", "create procedure lidarload(tname string) external name lidar.load;", "lidar", "MAL", "Procedure", true, false, false, "tname", "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 ] 2494 -
2495 [ "sys", "like", "SYSTEM", "create filter function \"like\"(val string, pat string) external name algebra.\"like\";", "algebra", "MAL", "Filter function", false, false, false, "val", "clob", 0, 0, "in", "pat", "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 ] 2495 2475 [ "sys", "like", "SYSTEM", "create filter function \"like\"(val string, pat string) external name algebra.\"like\";", "algebra", "MAL", "Filter function", false, false, false, "val", "clob", 0, 0, "in", "pat", "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 ] 2475
..................
# .s, .f, .L47, .L50, .f,
3282 [ "sys", "settimeout", "SYSTEM", "create procedure sys.settimeout(\"query\" bigint, \"session\" bigint) external name clients.settimeout;", "clients", "MAL", "Procedure", true, false, false, "query", "bigint", 64, 0, "in", "session", "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, NULL, NULL, NULL, NULL, NULL ] 3282 3262 [ "sys", "settimeout", "SYSTEM", "create procedure sys.settimeout(\"query\" bigint, \"session\" bigint) external name clients.settimeout;", "clients", "MAL", "Procedure", true, false, false, "query", "bigint", 64, 0, "in", "session", "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, NULL, NULL, NULL, NULL, NULL ] 3262
3283 [ "sys", "shpattach", "SYSTEM", "create procedure shpattach(fname string) external name shp.attach;", "shp", "MAL", "Procedure", true, false, false, "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 ] 3283 -
3284 [ "sys", "shpload", "SYSTEM", "create procedure shpload(fid integer) external name shp.import;", "shp", "MAL", "Procedure", true, false, false, "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 ] 3284 -
3285 [ "sys", "shpload", "SYSTEM", "create procedure shpload(fid integer, filter geometry) external name shp.import;", "shp", "MAL", "Procedure", true, false, false, "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 ] 3285 -
3286 [ "sys", "shrink", "SYSTEM", "create procedure shrink(sys string, tab string) external name sql.shrink;", "sql", "MAL", "Procedure", true, false, false, "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 ] 3286 3263 [ "sys", "shrink", "SYSTEM", "create procedure shrink(sys string, tab string) external name sql.shrink;", "sql", "MAL", "Procedure", true, false, false, "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 ] 3263
..................
#select s1.name, f1.name, s2.name, f2.na
3883 % 3, 17, 3, 13, 8 # length 3883 3860 % 3, 17, 3, 13, 8 # length 3860
+ 3861 [ "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3861
3884 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3884 3862 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3862
..................
#select s1.name, t1.name, c1.name, s2.na
4168 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4168 4146 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4146
+ 4147 [ "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4147
+ 4148 [ "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4148
+ 4149 [ "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4149
+ 4150 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4150
+ 4151 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4151
4169 [ "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4169 4152 [ "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4152
..................
#select s1.name, t1.name, c1.name, s2.na
4175 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4175 4158 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4158
+ 4159 [ "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4159
4176 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4176 4160 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4160
..................
#select s1.name, t1.name, c1.name, s2.na
4183 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4183 4167 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4167
+ 4168 [ "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4168
+ 4169 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4169
+ 4170 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4170
+ 4171 [ "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4171
+ 4172 [ "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4172
+ 4173 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4173
+ 4174 [ "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4174
+ 4175 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4175
+ 4176 [ "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4176
4184 [ "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4184 4177 [ "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4177
..................
#select s1.name, t1.name, c1.name, s2.na
4196 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4196 4189 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4189
+ 4190 [ "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4190
+ 4191 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4191
+ 4192 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4192
+ 4193 [ "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4193
4197 [ "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4197 4194 [ "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4194
..................
#select s1.name, t1.name, c1.name, s2.na
4211 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4211 4208 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4208
+ 4209 [ "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4209
+ 4210 [ "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4210
+ 4211 [ "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4211
4212 [ "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4212 4212 [ "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4212
..................
#select s1.name, t1.name, c1.name, s2.na
4258 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4258 4258 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4258
+ 4259 [ "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4259
+ 4260 [ "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4260
+ 4261 [ "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4261
+ 4262 [ "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4262
4259 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4259 4263 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4263
..................
#select s1.name, t1.name, c1.name, s2.na
4279 [ "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4279 4283 [ "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4283
+ 4284 [ "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4284
+ 4285 [ "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4285
+ 4286 [ "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4286
+ 4287 [ "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4287
+ 4288 [ "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4288
+ 4289 [ "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4289
4280 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4280 4290 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4290
..................
#select s1.name, t1.name, c1.name, s2.na
4293 [ "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4293 4303 [ "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4303
+ 4304 [ "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4304
+ 4305 [ "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4305
+ 4306 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4306
+ 4307 [ "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4307
+ 4308 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4308
+ 4309 [ "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4309
4294 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4294 4310 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4310
..................
#select s1.name, t1.name, c1.name, s2.na
4311 [ "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4311 4327 [ "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4327
+ 4328 [ "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4328
+ 4329 [ "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4329
+ 4330 [ "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4330
+ 4331 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4331
+ 4332 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4332
4312 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4312 4333 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4333
..................
#select s1.name, t1.name, c1.name, s2.na
4315 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4315 4336 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4336
+ 4337 [ "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4337
4316 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4316 4338 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4338
..................
#select s1.name, t1.name, c1.name, s2.na
4333 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4333 4355 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4355
+ 4356 [ "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4356
+ 4357 [ "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4357
+ 4358 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4358
+ 4359 [ "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4359
4334 [ "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4334 4360 [ "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4360
..................
#select s1.name, t1.name, c1.name, s2.na
4387 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4387 4413 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4413
+ 4414 [ "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4414
+ 4415 [ "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4415
4388 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4388 4416 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4416
+ 4417 [ "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4417
+ 4418 [ "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4418
4389 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4389 4419 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4419
..................
#select s1.name, t1.name, c1.name, s2.na
4391 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4391 4421 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4421
+ 4422 [ "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4422
4392 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4392 4423 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4423
..................
#select s1.name, t1.name, c1.name, s2.na
4404 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4404 4435 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4435
+ 4436 [ "sys", "keys", "action", "sys", "ids", "VIEW" ] 4436
4405 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4405 4437 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4437
4406 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4406 4438 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4438
+ 4439 [ "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4439
4407 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4407 4440 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4440
+ 4441 [ "sys", "keys", "type", "sys", "ids", "VIEW" ] 4441
+ 4442 [ "sys", "objects", "id", "sys", "ids", "VIEW" ] 4442
4408 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4408 4443 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4443
..................
#select s1.name, t1.name, c1.name, s2.na
4412 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4412 4447 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4447
+ 4448 [ "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4448
4413 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4413 4449 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4449
4414 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4414 4450 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4450
+ 4451 [ "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4451
+ 4452 [ "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4452
+ 4453 [ "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4453
4415 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4415 4454 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4454
..................
#select s1.name, t1.name, c1.name, s2.na
4420 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4420 4459 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4459
+ 4460 [ "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4460
+ 4461 [ "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4461
4421 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4421 4462 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4462
+ 4463 [ "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4463
+ 4464 [ "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4464
4422 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4422 4465 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4465
..................
#select s1.name, t1.name, c1.name, s2.na
4424 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4424 4467 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4467
+ 4468 [ "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4468
4425 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4425 4469 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4469
..................
#select s1.name, t1.name, c1.name, s2.na
4428 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4428 4472 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4472
+ 4473 [ "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4473
4429 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4429 4474 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4474
4430 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4430 4475 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4475
+ 4476 [ "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4476
4431 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4431 4477 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4477
+ 4478 [ "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4478
4432 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4432 4479 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4479
..................
# .t, .g, .L3, .L4, .L5,
5151 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5151 5198 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5198
5152 [ "_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();" ] 5152 ! 5199 [ 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();" ] 5199
5153 [ "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();" ] 5153 5200 [ "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();" ] 5200