Test check.SQL.py (id 340fc40864f2) (err)
check.stable.out.int128.FILTERED 2020-01-15 01:46:19.644920340 +0100check.test.out.FILTERED 2020-01-15 01:46:19.800917881 +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 5781 lines, 220068 words, 1441204 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5829 lines, 219962 words, 1441479 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5781 lines, 220068 words, 1441204 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5829 lines, 219962 words, 1441479 chars in lines not matching '^$|^(\| |)#` 3
4 # 5858 lines, 222382 words, 1457621 chars in all lines 4 ! 4 # 5905 lines, 222278 words, 1457949 chars in all lines 4
5 5 5 5
..................
# 10:17:18 >
201 \dSf sys."left_shift_assign" 201 200 \dSf sys."left_shift_assign" 200
202 \dSf sys."lidarattach" 202 -
203 \dSf sys."lidarexport" 203 -
204 \dSf sys."lidarload" 204 -
205 \dSf sys."like" 205 201 \dSf sys."like" 201
..................
# 10:17:18 >
257 \dSf sys."setworkerlimit" 257 253 \dSf sys."setworkerlimit" 253
258 \dSf sys."shpattach" 258 -
259 \dSf sys."shpload" 259 -
260 \dSf sys."shrink" 260 254 \dSf sys."shrink" 254
..................
# 10:17:18 >
601 SYSTEM FUNCTION sys.levenshtein 601 595 SYSTEM FUNCTION sys.levenshtein 595
602 SYSTEM PROCEDURE sys.lidarattach 602 -
603 SYSTEM PROCEDURE sys.lidarexport 603 -
604 SYSTEM PROCEDURE sys.lidarload 604 -
605 SYSTEM FILTER FUNCTION sys.like 605 596 SYSTEM FILTER FUNCTION sys.like 596
..................
# 10:17:18 >
723 SYSTEM PROCEDURE sys.setworkerlimit 723 714 SYSTEM PROCEDURE sys.setworkerlimit 714
724 SYSTEM PROCEDURE sys.shpattach 724 -
725 SYSTEM PROCEDURE sys.shpload 725 -
726 SYSTEM PROCEDURE sys.shrink 726 715 SYSTEM PROCEDURE sys.shrink 715
..................
# 10:17:18 >
982 create view sys.tracelog as select * from sys.tracelog(); 982 971 create view sys.tracelog as select * from sys.tracelog(); 971
983 SELECT u."name" AS "name", ui."fullname", ui."default_schema" FROM db_users() AS u LEFT JOIN "sys"."db_user_info" AS ui ON u."name" = ui."name"; 983 + 972 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" ; 972
984 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; 984 973 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; 973
..................
# 10:17:18 >
1023 create procedure sys.flush_log () external name sql."flush_log"; 1023 1012 create procedure sys.flush_log () external name sql."flush_log"; 1012
+ 1013 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 1013
1024 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 1024 ! 1014 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 1014
1025 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 1025 1015 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 1015
1026 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 1026 ! 1016 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 1016
1027 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 1027 ! 1017 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 1017
1028 create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; 1028 ! 1018 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 1018
1029 create function sys.generate_series(first bigint, "limit" bigint, stepsize bigint) returns table (value bigint) external name generator.series; 1029 ! 1019 create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series; 1019
1030 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; 1030 ! 1020 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; 1020
1031 create function sys.generate_series(first double, "limit" double, stepsize double) returns table (value double) external name generator.series; 1031 ! 1021 create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series; 1021
1032 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 1032 1022 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 1022
1033 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 1033 1023 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 1023
1034 create function sys.generate_series(first int, "limit" int) returns table (value int) external name generator.series; 1034 ! 1024 create function sys.generate_series(first int, last int) returns table (value int) external name generator.series; 1024
1035 create function sys.generate_series(first int, "limit" int, stepsize int) returns table (value int) external name generator.series; 1035 ! 1025 create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series; 1025
1036 create function sys.generate_series(first real, "limit" real, stepsize real) returns table (value real) external name generator.series; 1036 ! 1026 create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series; 1026
1037 create function sys.generate_series(first smallint, "limit" smallint) returns table (value smallint) external name generator.series; 1037 ! 1027 create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series; 1027
1038 create function sys.generate_series(first smallint, "limit" smallint, stepsize smallint) returns table (value smallint) external name generator.series; 1038 ! 1028 create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series; 1028
1039 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1039 ! 1029 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1029
1040 create function sys.generate_series(first tinyint, "limit" tinyint) returns table (value tinyint) external name generator.series; 1040 ! 1030 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1030
1041 create function sys.generate_series(first tinyint, "limit" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1041 -
1042 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1042 1031 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1031
..................
# 10:17:18 >
1074 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1074 1063 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1063
1075 create procedure lidarattach(fname string) external name lidar.attach; 1075 ! 1064 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1064
1076 create procedure lidarexport(tname string, fname string, format string) external name lidar.export; 1076 -
1077 create procedure lidarload(tname string) external name lidar.load; 1077 -
1078 create filter function "like"(val string, pat string) external name algebra."like"; 1078 1065 create filter function "like"(val string, pat string) external name algebra."like"; 1065
1079 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1079 -
1080 create procedure listdir(dirname string) external name fits.listdir; 1080 1066 create procedure listdir(dirname string) external name fits.listdir; 1066
..................
# 10:17:18 >
1119 create function sys.password_hash (username string) returns string external name sql.password; 1119 1105 create function sys.password_hash (username string) returns string external name sql.password; 1105
+ 1106 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1106
1120 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1120 1107 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1107
1121 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1121 -
1122 create procedure sys.pause(tag smallint) external name sql.sysmon_pause; 1122 1108 create procedure sys.pause(tag smallint) external name sql.sysmon_pause; 1108
..................
# 10:17:18 >
1183 create procedure sys.setworkerlimit("sessionid" int, "limit" int) external name clients.setworkerlimit; 1183 1169 create procedure sys.setworkerlimit("sessionid" int, "limit" int) external name clients.setworkerlimit; 1169
1184 create procedure shpattach(fname string) external name shp.attach; 1184 -
1185 create procedure shpload(fid integer) external name shp.import; 1185 -
1186 create procedure shpload(fid integer, filter geometry) external name shp.import; 1186 -
1187 create procedure shrink(sys string, tab string) external name sql.shrink; 1187 1170 create procedure shrink(sys string, tab string) external name sql.shrink; 1170
..................
# 10:17:18 >
1318 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1318 1301 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1301
+ 1302 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1302
1319 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1319 1303 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1303
..................
# 10:17:18 >
1329 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1329 1313 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1313
1330 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1330 -
1331 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1331 1314 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1314
..................
#select s.name, t.name, replace(replace(
1554 [ "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1554 1537 [ "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1537
1555 [ "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" ] 1555 ! 1538 [ "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" ] 1538
1556 [ "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1556 1539 [ "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1539
..................
#select t.name, c.name, c.type, c.type_d
2104 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2104 2087 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2087
2105 [ "storagemodel", "orderidxsize", "bigint", 64, 0, NULL, true, 9, NULL ] 2105 ! 2088 [ "storagemodel", "orderidxsize", "bigint", 63, 0, NULL, true, 9, NULL ] 2088
2106 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2106 2089 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2089
..................
#select s.name, f.name, case f.system wh
2469 [ "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 ] 2469 2452 [ "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 ] 2452
2470 [ "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 ] 2470 ! 2453 [ "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 ] 2453
2471 [ "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 ] 2471 ! 2454 [ "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 ] 2454
2472 [ "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 ] 2472 ! 2455 [ "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 ] 2455
2473 [ "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 ] 2473 ! 2456 [ "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 ] 2456
2474 [ "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 ] 2474 2457 [ "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 ] 2457
2475 [ "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 ] 2475 2458 [ "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 ] 2458
2476 [ "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 ] 2476 ! 2459 [ "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 ] 2459
2477 [ "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 ] 2477 ! 2460 [ "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 ] 2460
2478 [ "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 ] 2478 ! 2461 [ "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 ] 2461
2479 [ "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 ] 2479 ! 2462 [ "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 ] 2462
2480 [ "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 ] 2480 ! 2463 [ "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 ] 2463
2481 [ "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 ] 2481 ! 2464 [ "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 ] 2464
2482 [ "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 ] 2482 ! 2465 [ "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 ] 2465
2483 [ "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 ] 2483 ! 2466 [ "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 ] 2466
2484 [ "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 ] 2484 2467 [ "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 ] 2467
..................
#select s.name, f.name, case f.system wh
2598 [ "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 ] 2598 2581 [ "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 ] 2581
2599 [ "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 ] 2599 -
2600 [ "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 ] 2600 -
2601 [ "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 ] 2601 -
2602 [ "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 ] 2602 2582 [ "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 ] 2582
..................
#select s.name, f.name, case f.system wh
3515 [ "sys", "setworkerlimit", "SYSTEM", "create procedure sys.setworkerlimit(\"sessionid\" int, \"limit\" int) external name clients.setworkerlimit;", "clients", "MAL", "Procedure", true, false, false, "sessionid", "int", 32, 0, "in", "limit", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3515 3495 [ "sys", "setworkerlimit", "SYSTEM", "create procedure sys.setworkerlimit(\"sessionid\" int, \"limit\" int) external name clients.setworkerlimit;", "clients", "MAL", "Procedure", true, false, false, "sessionid", "int", 32, 0, "in", "limit", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3495
3516 [ "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 ] 3516 -
3517 [ "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 ] 3517 -
3518 [ "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 ] 3518 -
3519 [ "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 ] 3519 3496 [ "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 ] 3496
..................
#select s1.name, f1.name, s2.name, f2.na
4196 % 3, 17, 3, 13, 8 # length 4196 4173 % 3, 17, 3, 13, 8 # length 4173
+ 4174 [ "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 4174
4197 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4197 4175 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4175
..................
#select s1.name, t1.name, c1.name, s2.na
4483 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4483 4461 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4461
+ 4462 [ "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4462
+ 4463 [ "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4463
+ 4464 [ "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4464
+ 4465 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4465
+ 4466 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4466
4484 [ "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4484 4467 [ "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4467
..................
#select s1.name, t1.name, c1.name, s2.na
4490 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4490 4473 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4473
+ 4474 [ "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4474
4491 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4491 4475 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4475
..................
#select s1.name, t1.name, c1.name, s2.na
4498 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4498 4482 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4482
+ 4483 [ "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4483
+ 4484 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4484
+ 4485 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4485
+ 4486 [ "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4486
+ 4487 [ "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4487
+ 4488 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4488
+ 4489 [ "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4489
+ 4490 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4490
+ 4491 [ "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4491
4499 [ "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4499 4492 [ "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4492
..................
#select s1.name, t1.name, c1.name, s2.na
4511 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4511 4504 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4504
+ 4505 [ "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4505
+ 4506 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4506
+ 4507 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4507
+ 4508 [ "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4508
4512 [ "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4512 4509 [ "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4509
..................
#select s1.name, t1.name, c1.name, s2.na
4526 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4526 4523 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4523
+ 4524 [ "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4524
+ 4525 [ "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4525
+ 4526 [ "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4526
4527 [ "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4527 4527 [ "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4527
..................
#select s1.name, t1.name, c1.name, s2.na
4573 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4573 4573 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4573
+ 4574 [ "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4574
+ 4575 [ "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4575
+ 4576 [ "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4576
+ 4577 [ "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4577
4574 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4574 4578 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4578
..................
#select s1.name, t1.name, c1.name, s2.na
4594 [ "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4594 4598 [ "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4598
+ 4599 [ "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4599
+ 4600 [ "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4600
+ 4601 [ "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4601
+ 4602 [ "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4602
+ 4603 [ "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4603
+ 4604 [ "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4604
4595 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4595 4605 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4605
..................
#select s1.name, t1.name, c1.name, s2.na
4608 [ "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4608 4618 [ "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4618
+ 4619 [ "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4619
+ 4620 [ "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4620
+ 4621 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4621
+ 4622 [ "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4622
+ 4623 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4623
+ 4624 [ "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4624
4609 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4609 4625 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4625
..................
#select s1.name, t1.name, c1.name, s2.na
4626 [ "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4626 4642 [ "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4642
+ 4643 [ "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4643
+ 4644 [ "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4644
+ 4645 [ "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4645
+ 4646 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4646
+ 4647 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4647
4627 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4627 4648 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4648
..................
#select s1.name, t1.name, c1.name, s2.na
4630 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4630 4651 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4651
+ 4652 [ "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4652
4631 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4631 4653 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4653
..................
#select s1.name, t1.name, c1.name, s2.na
4648 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4648 4670 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4670
+ 4671 [ "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4671
+ 4672 [ "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4672
+ 4673 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4673
+ 4674 [ "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4674
4649 [ "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4649 4675 [ "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4675
..................
#select s1.name, t1.name, c1.name, s2.na
4702 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4702 4728 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4728
+ 4729 [ "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4729
+ 4730 [ "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4730
4703 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4703 4731 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4731
+ 4732 [ "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4732
+ 4733 [ "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4733
4704 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4704 4734 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4734
..................
#select s1.name, t1.name, c1.name, s2.na
4706 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4706 4736 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4736
+ 4737 [ "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4737
4707 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4707 4738 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4738
..................
#select s1.name, t1.name, c1.name, s2.na
4719 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4719 4750 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4750
+ 4751 [ "sys", "keys", "action", "sys", "ids", "VIEW" ] 4751
4720 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4720 4752 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4752
4721 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4721 4753 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4753
+ 4754 [ "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4754
4722 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4722 4755 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4755
+ 4756 [ "sys", "keys", "type", "sys", "ids", "VIEW" ] 4756
+ 4757 [ "sys", "objects", "id", "sys", "ids", "VIEW" ] 4757
4723 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4723 4758 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4758
..................
#select s1.name, t1.name, c1.name, s2.na
4727 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4727 4762 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4762
+ 4763 [ "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4763
4728 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4728 4764 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4764
4729 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4729 4765 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4765
+ 4766 [ "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4766
+ 4767 [ "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4767
+ 4768 [ "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4768
4730 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4730 4769 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4769
..................
#select s1.name, t1.name, c1.name, s2.na
4735 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4735 4774 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4774
+ 4775 [ "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4775
+ 4776 [ "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4776
4736 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4736 4777 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4777
+ 4778 [ "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4778
+ 4779 [ "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4779
4737 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4737 4780 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4780
..................
#select s1.name, t1.name, c1.name, s2.na
4739 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4739 4782 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4782
+ 4783 [ "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4783
4740 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4740 4784 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4784
..................
#select s1.name, t1.name, c1.name, s2.na
4743 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4743 4787 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4787
+ 4788 [ "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4788
4744 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4744 4789 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4789
4745 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4745 4790 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4790
+ 4791 [ "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4791
4746 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4746 4792 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4792
+ 4793 [ "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4793
4747 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4747 4794 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4794
..................
#select t.name, g.name, case g.time when
5479 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5479 5526 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5526
5480 [ "_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();" ] 5480 ! 5527 [ 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();" ] 5527
5481 [ "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();" ] 5481 5528 [ "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();" ] 5528