Test check.SQL.py (id a7c289e8f33c) (err)
check.stable.out.int128.FILTERED 2019-12-03 22:24:33.016356851 +0100check.test.out.FILTERED 2019-12-03 22:24:33.348358802 +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 5611 lines, 216381 words, 1415456 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5659 lines, 216275 words, 1415731 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5611 lines, 216381 words, 1415456 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5659 lines, 216275 words, 1415731 chars in lines not matching '^$|^(\| |)#` 3
4 # 5692 lines, 218820 words, 1432610 chars in all lines 4 ! 4 # 5739 lines, 218716 words, 1432939 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 >
988 create procedure sys.flush_log () external name sql."flush_log"; 988 977 create procedure sys.flush_log () external name sql."flush_log"; 977
+ 978 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 978
989 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 989 ! 979 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 979
990 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 990 980 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 980
991 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 991 ! 981 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 981
992 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 992 ! 982 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 982
993 create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; 993 ! 983 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 983
994 create function sys.generate_series(first bigint, "limit" bigint, stepsize bigint) returns table (value bigint) external name generator.series; 994 ! 984 create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series; 984
995 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; 995 ! 985 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; 985
996 create function sys.generate_series(first double, "limit" double, stepsize double) returns table (value double) external name generator.series; 996 ! 986 create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series; 986
997 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 997 987 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 987
998 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 998 988 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 988
999 create function sys.generate_series(first int, "limit" int) returns table (value int) external name generator.series; 999 ! 989 create function sys.generate_series(first int, last int) returns table (value int) external name generator.series; 989
1000 create function sys.generate_series(first int, "limit" int, stepsize int) returns table (value int) external name generator.series; 1000 ! 990 create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series; 990
1001 create function sys.generate_series(first real, "limit" real, stepsize real) returns table (value real) external name generator.series; 1001 ! 991 create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series; 991
1002 create function sys.generate_series(first smallint, "limit" smallint) returns table (value smallint) external name generator.series; 1002 ! 992 create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series; 992
1003 create function sys.generate_series(first smallint, "limit" smallint, stepsize smallint) returns table (value smallint) external name generator.series; 1003 ! 993 create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series; 993
1004 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1004 ! 994 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 994
1005 create function sys.generate_series(first tinyint, "limit" tinyint) returns table (value tinyint) external name generator.series; 1005 ! 995 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 995
1006 create function sys.generate_series(first tinyint, "limit" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1006 -
1007 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1007 996 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 996
..................
# 10:17:18 >
1038 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1038 1027 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1027
1039 create procedure lidarattach(fname string) external name lidar.attach; 1039 ! 1028 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1028
1040 create procedure lidarexport(tname string, fname string, format string) external name lidar.export; 1040 -
1041 create procedure lidarload(tname string) external name lidar.load; 1041 -
1042 create filter function "like"(val string, pat string) external name algebra."like"; 1042 1029 create filter function "like"(val string, pat string) external name algebra."like"; 1029
1043 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1043 -
1044 create procedure listdir(dirname string) external name fits.listdir; 1044 1030 create procedure listdir(dirname string) external name fits.listdir; 1030
..................
# 10:17:18 >
1083 create function sys.password_hash (username string) returns string external name sql.password; 1083 1069 create function sys.password_hash (username string) returns string external name sql.password; 1069
+ 1070 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1070
1084 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1084 1071 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1071
1085 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1085 -
1086 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1086 1072 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1072
..................
# 10:17:18 >
1130 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1130 1116 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1116
1131 create procedure shpattach(fname string) external name shp.attach; 1131 -
1132 create procedure shpload(fid integer) external name shp.import; 1132 -
1133 create procedure shpload(fid integer, filter geometry) external name shp.import; 1133 -
1134 create procedure shrink(sys string, tab string) external name sql.shrink; 1134 1117 create procedure shrink(sys string, tab string) external name sql.shrink; 1117
..................
# 10:17:18 >
1265 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1265 1248 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1248
+ 1249 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1249
1266 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1266 1250 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1250
..................
# 10:17:18 >
1276 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1276 1260 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1260
1277 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1277 -
1278 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1278 1261 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1261
..................
# .s, .t, .L15, .L16, .t,
1496 [ "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1496 1479 [ "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1479
1497 [ "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" ] 1497 ! 1480 [ "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" ] 1480
1498 [ "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1498 1481 [ "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1481
..................
#select t.name, c.name, c.type, c.type_d
2028 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2028 2011 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2011
2029 [ "storagemodel", "orderidxsize", "bigint", 64, 0, NULL, true, 9, NULL ] 2029 ! 2012 [ "storagemodel", "orderidxsize", "bigint", 63, 0, NULL, true, 9, NULL ] 2012
2030 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2030 2013 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2013
..................
# .s, .f, .L47, .L50, .f,
2403 [ "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 ] 2403 2386 [ "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 ] 2386
2404 [ "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 ] 2404 ! 2387 [ "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 ] 2387
2405 [ "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 ] 2405 ! 2388 [ "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 ] 2388
2406 [ "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 ] 2406 ! 2389 [ "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 ] 2389
2407 [ "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 ] 2407 ! 2390 [ "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 ] 2390
2408 [ "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, "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 ] 2408 2391 [ "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, "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 ] 2391
2409 [ "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, "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 ] 2409 2392 [ "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, "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 ] 2392
2410 [ "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 ] 2410 ! 2393 [ "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 ] 2393
2411 [ "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 ] 2411 ! 2394 [ "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 ] 2394
2412 [ "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 ] 2412 ! 2395 [ "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 ] 2395
2413 [ "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 ] 2413 ! 2396 [ "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 ] 2396
2414 [ "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 ] 2414 ! 2397 [ "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 ] 2397
2415 [ "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 ] 2415 ! 2398 [ "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 ] 2398
2416 [ "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 ] 2416 ! 2399 [ "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 ] 2399
2417 [ "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 ] 2417 ! 2400 [ "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 ] 2400
2418 [ "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 ] 2418 2401 [ "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 ] 2401
..................
# .s, .f, .L47, .L50, .f,
2526 [ "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 ] 2526 2509 [ "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 ] 2509
2527 [ "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 ] 2527 -
2528 [ "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 ] 2528 -
2529 [ "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 ] 2529 -
2530 [ "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 ] 2530 2510 [ "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 ] 2510
..................
# .s, .f, .L47, .L50, .f,
3426 [ "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 ] 3426 3406 [ "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 ] 3406
3427 [ "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 ] 3427 -
3428 [ "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 ] 3428 -
3429 [ "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 ] 3429 -
3430 [ "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 ] 3430 3407 [ "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 ] 3407
..................
#select s1.name, f1.name, s2.name, f2.na
4101 % 3, 17, 3, 13, 8 # length 4101 4078 % 3, 17, 3, 13, 8 # length 4078
+ 4079 [ "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 4079
4102 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4102 4080 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4080
..................
#select s1.name, t1.name, c1.name, s2.na
4386 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4386 4364 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4364
+ 4365 [ "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4365
+ 4366 [ "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4366
+ 4367 [ "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4367
+ 4368 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4368
+ 4369 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4369
4387 [ "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4387 4370 [ "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4370
..................
#select s1.name, t1.name, c1.name, s2.na
4393 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4393 4376 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4376
+ 4377 [ "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4377
4394 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4394 4378 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4378
..................
#select s1.name, t1.name, c1.name, s2.na
4401 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4401 4385 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4385
+ 4386 [ "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4386
+ 4387 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4387
+ 4388 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4388
+ 4389 [ "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4389
+ 4390 [ "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4390
+ 4391 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4391
+ 4392 [ "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4392
+ 4393 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4393
+ 4394 [ "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4394
4402 [ "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4402 4395 [ "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4395
..................
#select s1.name, t1.name, c1.name, s2.na
4414 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4414 4407 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4407
+ 4408 [ "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4408
+ 4409 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4409
+ 4410 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4410
+ 4411 [ "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4411
4415 [ "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4415 4412 [ "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4412
..................
#select s1.name, t1.name, c1.name, s2.na
4429 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4429 4426 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4426
+ 4427 [ "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4427
+ 4428 [ "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4428
+ 4429 [ "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4429
4430 [ "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4430 4430 [ "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4430
..................
#select s1.name, t1.name, c1.name, s2.na
4476 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4476 4476 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4476
+ 4477 [ "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4477
+ 4478 [ "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4478
+ 4479 [ "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4479
+ 4480 [ "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4480
4477 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4477 4481 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4481
..................
#select s1.name, t1.name, c1.name, s2.na
4497 [ "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4497 4501 [ "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4501
+ 4502 [ "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4502
+ 4503 [ "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4503
+ 4504 [ "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4504
+ 4505 [ "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4505
+ 4506 [ "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4506
+ 4507 [ "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4507
4498 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4498 4508 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4508
..................
#select s1.name, t1.name, c1.name, s2.na
4511 [ "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4511 4521 [ "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4521
+ 4522 [ "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4522
+ 4523 [ "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4523
+ 4524 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4524
+ 4525 [ "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4525
+ 4526 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4526
+ 4527 [ "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4527
4512 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4512 4528 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4528
..................
#select s1.name, t1.name, c1.name, s2.na
4529 [ "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4529 4545 [ "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4545
+ 4546 [ "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4546
+ 4547 [ "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4547
+ 4548 [ "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4548
+ 4549 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4549
+ 4550 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4550
4530 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4530 4551 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4551
..................
#select s1.name, t1.name, c1.name, s2.na
4533 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4533 4554 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4554
+ 4555 [ "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4555
4534 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4534 4556 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4556
..................
#select s1.name, t1.name, c1.name, s2.na
4551 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4551 4573 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4573
+ 4574 [ "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4574
+ 4575 [ "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4575
+ 4576 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4576
+ 4577 [ "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4577
4552 [ "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4552 4578 [ "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4578
..................
#select s1.name, t1.name, c1.name, s2.na
4605 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4605 4631 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4631
+ 4632 [ "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4632
+ 4633 [ "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4633
4606 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4606 4634 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4634
+ 4635 [ "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4635
+ 4636 [ "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4636
4607 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4607 4637 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4637
..................
#select s1.name, t1.name, c1.name, s2.na
4609 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4609 4639 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4639
+ 4640 [ "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4640
4610 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4610 4641 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4641
..................
#select s1.name, t1.name, c1.name, s2.na
4622 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4622 4653 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4653
+ 4654 [ "sys", "keys", "action", "sys", "ids", "VIEW" ] 4654
4623 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4623 4655 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4655
4624 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4624 4656 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4656
+ 4657 [ "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4657
4625 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4625 4658 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4658
+ 4659 [ "sys", "keys", "type", "sys", "ids", "VIEW" ] 4659
+ 4660 [ "sys", "objects", "id", "sys", "ids", "VIEW" ] 4660
4626 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4626 4661 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4661
..................
#select s1.name, t1.name, c1.name, s2.na
4630 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4630 4665 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4665
+ 4666 [ "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4666
4631 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4631 4667 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4667
4632 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4632 4668 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4668
+ 4669 [ "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4669
+ 4670 [ "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4670
+ 4671 [ "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4671
4633 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4633 4672 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4672
..................
#select s1.name, t1.name, c1.name, s2.na
4638 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4638 4677 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4677
+ 4678 [ "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4678
+ 4679 [ "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4679
4639 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4639 4680 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4680
+ 4681 [ "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4681
+ 4682 [ "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4682
4640 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4640 4683 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4683
..................
#select s1.name, t1.name, c1.name, s2.na
4642 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4642 4685 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4685
+ 4686 [ "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4686
4643 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4643 4687 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4687
..................
#select s1.name, t1.name, c1.name, s2.na
4646 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4646 4690 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4690
+ 4691 [ "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4691
4647 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4647 4692 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4692
4648 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4648 4693 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4693
+ 4694 [ "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4694
4649 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4649 4695 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4695
+ 4696 [ "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4696
4650 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4650 4697 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4697
..................
# .t, .g, .L3, .L4, .L5,
5380 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5380 5427 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5427
5381 [ "_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();" ] 5381 ! 5428 [ 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();" ] 5428
5382 [ "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();" ] 5382 5429 [ "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();" ] 5429