Test check.SQL.py (id 7a4f3daf6d73) (err)
check.stable.out.int128.FILTERED 2020-03-26 22:03:40.375449866 +0100check.test.out.FILTERED 2020-03-26 22:03:40.530447604 +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, 1415461 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5659 lines, 216275 words, 1415736 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5611 lines, 216381 words, 1415461 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5659 lines, 216275 words, 1415736 chars in lines not matching '^$|^(\| |)#` 3
4 # 5692 lines, 218820 words, 1432615 chars in all lines 4 ! 4 # 5740 lines, 218724 words, 1432991 chars in all lines 4
5 5 5 5
..................
# 10:17:18 >
197 \dSf sys."left_shift_assign" 197 197 \dSf sys."left_shift_assign" 197
198 \dSf sys."lidarattach" 198 -
199 \dSf sys."lidarexport" 199 -
200 \dSf sys."lidarload" 200 -
201 \dSf sys."like" 201 198 \dSf sys."like" 198
..................
# 10:17:18 >
245 \dSf sys."settimeout" 245 242 \dSf sys."settimeout" 242
246 \dSf sys."shpattach" 246 -
247 \dSf sys."shpload" 247 -
248 \dSf sys."shrink" 248 243 \dSf sys."shrink" 243
..................
# 10:17:18 >
582 SYSTEM FUNCTION sys.levenshtein 582 577 SYSTEM FUNCTION sys.levenshtein 577
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 578 SYSTEM FILTER FUNCTION sys.like 578
..................
# 10:17:18 >
696 SYSTEM PROCEDURE sys.settimeout 696 688 SYSTEM PROCEDURE sys.settimeout 688
697 SYSTEM PROCEDURE sys.shpattach 697 -
698 SYSTEM PROCEDURE sys.shpload 698 -
699 SYSTEM PROCEDURE sys.shrink 699 689 SYSTEM PROCEDURE sys.shrink 689
..................
# 10:17:18 >
949 create view sys.tracelog as select * from sys.tracelog(); 949 939 create view sys.tracelog as select * from sys.tracelog(); 939
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 + 940 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" ; 940
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 941 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; 941
..................
# 10:17:18 >
988 create procedure sys.flush_log () external name sql."flush_log"; 988 978 create procedure sys.flush_log () external name sql."flush_log"; 978
+ 979 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 979
989 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 989 ! 980 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 980
990 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 990 981 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 981
991 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 991 ! 982 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 982
992 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 992 ! 983 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 983
993 create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; 993 ! 984 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 984
994 create function sys.generate_series(first bigint, "limit" bigint, stepsize bigint) returns table (value bigint) external name generator.series; 994 ! 985 create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series; 985
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 ! 986 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; 986
996 create function sys.generate_series(first double, "limit" double, stepsize double) returns table (value double) external name generator.series; 996 ! 987 create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series; 987
997 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 997 988 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 988
998 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 998 989 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 989
999 create function sys.generate_series(first int, "limit" int) returns table (value int) external name generator.series; 999 ! 990 create function sys.generate_series(first int, last int) returns table (value int) external name generator.series; 990
1000 create function sys.generate_series(first int, "limit" int, stepsize int) returns table (value int) external name generator.series; 1000 ! 991 create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series; 991
1001 create function sys.generate_series(first real, "limit" real, stepsize real) returns table (value real) external name generator.series; 1001 ! 992 create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series; 992
1002 create function sys.generate_series(first smallint, "limit" smallint) returns table (value smallint) external name generator.series; 1002 ! 993 create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series; 993
1003 create function sys.generate_series(first smallint, "limit" smallint, stepsize smallint) returns table (value smallint) external name generator.series; 1003 ! 994 create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series; 994
1004 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1004 ! 995 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 995
1005 create function sys.generate_series(first tinyint, "limit" tinyint) returns table (value tinyint) external name generator.series; 1005 ! 996 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 996
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 997 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 997
..................
# 10:17:18 >
1038 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1038 1028 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1028
1039 create procedure lidarattach(fname string) external name lidar.attach; 1039 ! 1029 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1029
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 1030 create filter function "like"(val string, pat string) external name algebra."like"; 1030
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 1031 create procedure listdir(dirname string) external name fits.listdir; 1031
..................
# 10:17:18 >
1083 create function sys.password_hash (username string) returns string external name sql.password; 1083 1070 create function sys.password_hash (username string) returns string external name sql.password; 1070
+ 1071 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1071
1084 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1084 1072 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1072
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 1073 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1073
..................
# 10:17:18 >
1130 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1130 1117 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1117
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 1118 create procedure shrink(sys string, tab string) external name sql.shrink; 1118
..................
# 10:17:18 >
1265 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1265 1249 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1249
+ 1250 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1250
1266 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1266 1251 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1251
..................
# 10:17:18 >
1276 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1276 1261 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1261
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 1262 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1262
..................
# .s, .t, .L15, .L16, .t,
1496 [ "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1496 1480 [ "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1480
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 ! 1481 [ "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" ] 1481
1498 [ "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1498 1482 [ "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1482
..................
#select t.name, c.name, c.type, c.type_d
2028 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2028 2012 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2012
2029 [ "storagemodel", "orderidxsize", "bigint", 64, 0, NULL, true, 9, NULL ] 2029 ! 2013 [ "storagemodel", "orderidxsize", "bigint", 63, 0, NULL, true, 9, NULL ] 2013
2030 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2030 2014 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2014
..................
# .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 2387 [ "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 ] 2387
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 ! 2388 [ "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 ] 2388
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 ! 2389 [ "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 ] 2389
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 ! 2390 [ "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 ] 2390
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 ! 2391 [ "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 ] 2391
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 2392 [ "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 ] 2392
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 2393 [ "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 ] 2393
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 ! 2394 [ "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 ] 2394
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 ! 2395 [ "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 ] 2395
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 ! 2396 [ "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 ] 2396
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 ! 2397 [ "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 ] 2397
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 ! 2398 [ "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 ] 2398
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 ! 2399 [ "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 ] 2399
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 ! 2400 [ "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 ] 2400
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 ! 2401 [ "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 ] 2401
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 2402 [ "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 ] 2402
..................
# .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 2510 [ "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 ] 2510
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 2511 [ "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 ] 2511
..................
# .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 3407 [ "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 ] 3407
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 3408 [ "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 ] 3408
..................
#select s1.name, f1.name, s2.name, f2.na
4101 % 3, 17, 3, 13, 8 # length 4101 4079 % 3, 17, 3, 13, 8 # length 4079
+ 4080 [ "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 4080
4102 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4102 4081 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4081
..................
#select s1.name, t1.name, c1.name, s2.na
4386 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4386 4365 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4365
+ 4366 [ "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4366
+ 4367 [ "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4367
+ 4368 [ "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4368
+ 4369 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4369
+ 4370 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4370
4387 [ "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4387 4371 [ "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4371
..................
#select s1.name, t1.name, c1.name, s2.na
4393 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4393 4377 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4377
+ 4378 [ "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4378
4394 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4394 4379 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4379
..................
#select s1.name, t1.name, c1.name, s2.na
4401 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4401 4386 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4386
+ 4387 [ "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4387
+ 4388 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4388
+ 4389 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4389
+ 4390 [ "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4390
+ 4391 [ "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4391
+ 4392 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4392
+ 4393 [ "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4393
+ 4394 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4394
+ 4395 [ "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4395
4402 [ "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4402 4396 [ "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4396
..................
#select s1.name, t1.name, c1.name, s2.na
4414 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4414 4408 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4408
+ 4409 [ "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4409
+ 4410 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4410
+ 4411 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4411
+ 4412 [ "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4412
4415 [ "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4415 4413 [ "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4413
..................
#select s1.name, t1.name, c1.name, s2.na
4429 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4429 4427 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4427
+ 4428 [ "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4428
+ 4429 [ "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4429
+ 4430 [ "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4430
4430 [ "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4430 4431 [ "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4431
..................
#select s1.name, t1.name, c1.name, s2.na
4476 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4476 4477 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4477
+ 4478 [ "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4478
+ 4479 [ "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4479
+ 4480 [ "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4480
+ 4481 [ "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4481
4477 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4477 4482 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4482
..................
#select s1.name, t1.name, c1.name, s2.na
4497 [ "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4497 4502 [ "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4502
+ 4503 [ "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4503
+ 4504 [ "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4504
+ 4505 [ "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4505
+ 4506 [ "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4506
+ 4507 [ "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4507
+ 4508 [ "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4508
4498 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4498 4509 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4509
..................
#select s1.name, t1.name, c1.name, s2.na
4511 [ "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4511 4522 [ "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4522
+ 4523 [ "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4523
+ 4524 [ "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4524
+ 4525 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4525
+ 4526 [ "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4526
+ 4527 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4527
+ 4528 [ "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4528
4512 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4512 4529 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4529
..................
#select s1.name, t1.name, c1.name, s2.na
4529 [ "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4529 4546 [ "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4546
+ 4547 [ "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4547
+ 4548 [ "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4548
+ 4549 [ "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4549
+ 4550 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4550
+ 4551 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4551
4530 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4530 4552 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4552
..................
#select s1.name, t1.name, c1.name, s2.na
4533 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4533 4555 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4555
+ 4556 [ "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4556
4534 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4534 4557 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4557
..................
#select s1.name, t1.name, c1.name, s2.na
4551 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4551 4574 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4574
+ 4575 [ "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4575
+ 4576 [ "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4576
+ 4577 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4577
+ 4578 [ "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4578
4552 [ "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4552 4579 [ "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4579
..................
#select s1.name, t1.name, c1.name, s2.na
4605 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4605 4632 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4632
+ 4633 [ "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4633
+ 4634 [ "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4634
4606 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4606 4635 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4635
+ 4636 [ "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4636
+ 4637 [ "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4637
4607 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4607 4638 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4638
..................
#select s1.name, t1.name, c1.name, s2.na
4609 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4609 4640 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4640
+ 4641 [ "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4641
4610 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4610 4642 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4642
..................
#select s1.name, t1.name, c1.name, s2.na
4622 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4622 4654 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4654
+ 4655 [ "sys", "keys", "action", "sys", "ids", "VIEW" ] 4655
4623 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4623 4656 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4656
4624 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4624 4657 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4657
+ 4658 [ "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4658
4625 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4625 4659 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4659
+ 4660 [ "sys", "keys", "type", "sys", "ids", "VIEW" ] 4660
+ 4661 [ "sys", "objects", "id", "sys", "ids", "VIEW" ] 4661
4626 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4626 4662 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4662
..................
#select s1.name, t1.name, c1.name, s2.na
4630 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4630 4666 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4666
+ 4667 [ "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4667
4631 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4631 4668 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4668
4632 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4632 4669 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4669
+ 4670 [ "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4670
+ 4671 [ "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4671
+ 4672 [ "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4672
4633 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4633 4673 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4673
..................
#select s1.name, t1.name, c1.name, s2.na
4638 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4638 4678 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4678
+ 4679 [ "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4679
+ 4680 [ "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4680
4639 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4639 4681 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4681
+ 4682 [ "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4682
+ 4683 [ "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4683
4640 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4640 4684 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4684
..................
#select s1.name, t1.name, c1.name, s2.na
4642 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4642 4686 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4686
+ 4687 [ "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4687
4643 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4643 4688 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4688
..................
#select s1.name, t1.name, c1.name, s2.na
4646 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4646 4691 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4691
+ 4692 [ "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4692
4647 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4647 4693 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4693
4648 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4648 4694 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4694
+ 4695 [ "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4695
4649 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4649 4696 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4696
+ 4697 [ "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4697
4650 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4650 4698 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4698
..................
# .t, .g, .L3, .L4, .L5,
5380 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5380 5428 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5428
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 ! 5429 [ 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();" ] 5429
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 5430 [ "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();" ] 5430