Test check.SQL.py (id 0b8bcdf65189) (err)
check.stable.out.int128.FILTERED 2020-02-14 23:53:45.471020383 +0100check.test.out.FILTERED 2020-02-14 23:53:45.632017852 +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 5900 lines, 227944 words, 1495437 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5948 lines, 227838 words, 1495712 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5900 lines, 227944 words, 1495437 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5948 lines, 227838 words, 1495712 chars in lines not matching '^$|^(\| |)#` 3
4 # 5977 lines, 230258 words, 1511854 chars in all lines 4 ! 4 # 6025 lines, 230162 words, 1512221 chars in all lines 4
5 5 5 5
..................
# 10:17:18 >
199 \dSf sys."left_shift_assign" 199 199 \dSf sys."left_shift_assign" 199
200 \dSf sys."lidarattach" 200 -
201 \dSf sys."lidarexport" 201 -
202 \dSf sys."lidarload" 202 -
203 \dSf sys."like" 203 200 \dSf sys."like" 200
..................
# 10:17:18 >
255 \dSf sys."setworkerlimit" 255 252 \dSf sys."setworkerlimit" 252
256 \dSf sys."shpattach" 256 -
257 \dSf sys."shpload" 257 -
258 \dSf sys."shrink" 258 253 \dSf sys."shrink" 253
..................
# 10:17:18 >
605 SYSTEM FUNCTION sys.levenshtein 605 600 SYSTEM FUNCTION sys.levenshtein 600
606 SYSTEM PROCEDURE sys.lidarattach 606 -
607 SYSTEM PROCEDURE sys.lidarexport 607 -
608 SYSTEM PROCEDURE sys.lidarload 608 -
609 SYSTEM FILTER FUNCTION sys.like 609 601 SYSTEM FILTER FUNCTION sys.like 601
..................
# 10:17:18 >
728 SYSTEM PROCEDURE sys.setworkerlimit 728 720 SYSTEM PROCEDURE sys.setworkerlimit 720
729 SYSTEM PROCEDURE sys.shpattach 729 -
730 SYSTEM PROCEDURE sys.shpload 730 -
731 SYSTEM PROCEDURE sys.shrink 731 721 SYSTEM PROCEDURE sys.shrink 721
..................
# 10:17:18 >
989 create view sys.tracelog as select * from sys.tracelog(); 989 979 create view sys.tracelog as select * from sys.tracelog(); 979
990 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"; 990 + 980 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" ; 980
991 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; 991 981 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; 981
..................
# 10:17:18 >
1077 create procedure sys.flush_log () external name sql."flush_log"; 1077 1067 create procedure sys.flush_log () external name sql."flush_log"; 1067
+ 1068 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 1068
1078 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 1078 ! 1069 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 1069
1079 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 1079 1070 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 1070
1080 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 1080 ! 1071 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 1071
1081 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 1081 ! 1072 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 1072
1082 create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; 1082 ! 1073 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 1073
1083 create function sys.generate_series(first bigint, "limit" bigint, stepsize bigint) returns table (value bigint) external name generator.series; 1083 ! 1074 create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series; 1074
1084 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; 1084 ! 1075 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; 1075
1085 create function sys.generate_series(first double, "limit" double, stepsize double) returns table (value double) external name generator.series; 1085 ! 1076 create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series; 1076
1086 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 1086 1077 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 1077
1087 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 1087 1078 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 1078
1088 create function sys.generate_series(first int, "limit" int) returns table (value int) external name generator.series; 1088 ! 1079 create function sys.generate_series(first int, last int) returns table (value int) external name generator.series; 1079
1089 create function sys.generate_series(first int, "limit" int, stepsize int) returns table (value int) external name generator.series; 1089 ! 1080 create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series; 1080
1090 create function sys.generate_series(first real, "limit" real, stepsize real) returns table (value real) external name generator.series; 1090 ! 1081 create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series; 1081
1091 create function sys.generate_series(first smallint, "limit" smallint) returns table (value smallint) external name generator.series; 1091 ! 1082 create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series; 1082
1092 create function sys.generate_series(first smallint, "limit" smallint, stepsize smallint) returns table (value smallint) external name generator.series; 1092 ! 1083 create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series; 1083
1093 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1093 ! 1084 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1084
1094 create function sys.generate_series(first tinyint, "limit" tinyint) returns table (value tinyint) external name generator.series; 1094 ! 1085 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1085
1095 create function sys.generate_series(first tinyint, "limit" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1095 -
1096 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1096 1086 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1086
..................
# 10:17:18 >
1130 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1130 1120 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1120
1131 create procedure lidarattach(fname string) external name lidar.attach; 1131 ! 1121 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1121
1132 create procedure lidarexport(tname string, fname string, format string) external name lidar.export; 1132 -
1133 create procedure lidarload(tname string) external name lidar.load; 1133 -
1134 create filter function "like"(val string, pat string) external name algebra."like"; 1134 1122 create filter function "like"(val string, pat string) external name algebra."like"; 1122
1135 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1135 -
1136 create procedure listdir(dirname string) external name fits.listdir; 1136 1123 create procedure listdir(dirname string) external name fits.listdir; 1123
..................
# 10:17:18 >
1175 create function sys.password_hash (username string) returns string external name sql.password; 1175 1162 create function sys.password_hash (username string) returns string external name sql.password; 1162
+ 1163 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1163
1176 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1176 1164 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1164
1177 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1177 -
1178 create procedure sys.pause(tag smallint) external name sql.sysmon_pause; 1178 1165 create procedure sys.pause(tag smallint) external name sql.sysmon_pause; 1165
..................
# 10:17:18 >
1239 create procedure sys.setworkerlimit("sessionid" int, "limit" int) external name clients.setworkerlimit; 1239 1226 create procedure sys.setworkerlimit("sessionid" int, "limit" int) external name clients.setworkerlimit; 1226
1240 create procedure shpattach(fname string) external name shp.attach; 1240 -
1241 create procedure shpload(fid integer) external name shp.import; 1241 -
1242 create procedure shpload(fid integer, filter geometry) external name shp.import; 1242 -
1243 create procedure shrink(sys string, tab string) external name sql.shrink; 1243 1227 create procedure shrink(sys string, tab string) external name sql.shrink; 1227
..................
# 10:17:18 >
1382 create window stddev_pop(val tinyint) returns double external name "sql"."stdevp"; 1382 1366 create window stddev_pop(val tinyint) returns double external name "sql"."stdevp"; 1366
+ 1367 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1367
1383 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1383 1368 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1368
..................
# 10:17:18 >
1390 create aggregate stddev_samp(val smallint) returns double external name "aggr"."stdev"; 1390 1375 create aggregate stddev_samp(val smallint) returns double external name "aggr"."stdev"; 1375
1391 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1391 -
1392 create window stddev_samp(val bigint) returns double external name "sql"."stdev"; 1392 1376 create window stddev_samp(val bigint) returns double external name "sql"."stdev"; 1376
..................
#select s.name, t.name, replace(replace(
1632 [ "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1632 1616 [ "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1616
1633 [ "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" ] 1633 ! 1617 [ "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" ] 1617
1634 [ "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1634 1618 [ "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1618
..................
#select t.name, c.name, c.type, c.type_d
2142 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2142 2126 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2126
2143 [ "storagemodel", "orderidxsize", "bigint", 64, 0, NULL, true, 9, NULL ] 2143 ! 2127 [ "storagemodel", "orderidxsize", "bigint", 63, 0, NULL, true, 9, NULL ] 2127
2144 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2144 2128 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2128
..................
#select s.name, f.name, case f.system wh
2553 [ "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 ] 2553 2537 [ "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 ] 2537
2554 [ "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 ] 2554 ! 2538 [ "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 ] 2538
2555 [ "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 ] 2555 ! 2539 [ "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 ] 2539
2556 [ "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 ] 2556 ! 2540 [ "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 ] 2540
2557 [ "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 ] 2557 ! 2541 [ "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 ] 2541
2558 [ "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 ] 2558 2542 [ "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 ] 2542
2559 [ "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 ] 2559 2543 [ "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 ] 2543
2560 [ "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 ] 2560 ! 2544 [ "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 ] 2544
2561 [ "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 ] 2561 ! 2545 [ "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 ] 2545
2562 [ "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 ] 2562 ! 2546 [ "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 ] 2546
2563 [ "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 ] 2563 ! 2547 [ "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 ] 2547
2564 [ "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 ] 2564 ! 2548 [ "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 ] 2548
2565 [ "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 ] 2565 ! 2549 [ "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 ] 2549
2566 [ "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 ] 2566 ! 2550 [ "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 ] 2550
2567 [ "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 ] 2567 ! 2551 [ "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 ] 2551
2568 [ "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 ] 2568 2552 [ "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 ] 2552
..................
#select s.name, f.name, case f.system wh
2683 [ "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 ] 2683 2667 [ "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 ] 2667
2684 [ "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 ] 2684 -
2685 [ "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 ] 2685 -
2686 [ "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 ] 2686 -
2687 [ "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 ] 2687 2668 [ "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 ] 2668
..................
#select s.name, f.name, case f.system wh
3602 [ "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 ] 3602 3583 [ "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 ] 3583
3603 [ "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 ] 3603 -
3604 [ "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 ] 3604 -
3605 [ "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 ] 3605 -
3606 [ "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 ] 3606 3584 [ "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 ] 3584
..................
#select s1.name, f1.name, s2.name, f2.na
4309 % 3, 17, 3, 13, 8 # length 4309 4287 % 3, 17, 3, 13, 8 # length 4287
+ 4288 [ "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 4288
4310 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4310 4289 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4289
..................
#select s1.name, t1.name, c1.name, s2.na
4597 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4597 4576 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4576
+ 4577 [ "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4577
+ 4578 [ "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4578
+ 4579 [ "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4579
+ 4580 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4580
+ 4581 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4581
4598 [ "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4598 4582 [ "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4582
..................
#select s1.name, t1.name, c1.name, s2.na
4604 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4604 4588 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4588
+ 4589 [ "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4589
4605 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4605 4590 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4590
..................
#select s1.name, t1.name, c1.name, s2.na
4612 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4612 4597 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4597
+ 4598 [ "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4598
+ 4599 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4599
+ 4600 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4600
+ 4601 [ "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4601
+ 4602 [ "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4602
+ 4603 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4603
+ 4604 [ "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4604
+ 4605 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4605
+ 4606 [ "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4606
4613 [ "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4613 4607 [ "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4607
..................
#select s1.name, t1.name, c1.name, s2.na
4625 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4625 4619 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4619
+ 4620 [ "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4620
+ 4621 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4621
+ 4622 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4622
+ 4623 [ "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4623
4626 [ "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4626 4624 [ "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4624
..................
#select s1.name, t1.name, c1.name, s2.na
4640 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4640 4638 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4638
+ 4639 [ "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4639
+ 4640 [ "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4640
+ 4641 [ "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4641
4641 [ "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4641 4642 [ "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4642
..................
#select s1.name, t1.name, c1.name, s2.na
4687 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4687 4688 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4688
+ 4689 [ "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4689
+ 4690 [ "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4690
+ 4691 [ "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4691
+ 4692 [ "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4692
4688 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4688 4693 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4693
..................
#select s1.name, t1.name, c1.name, s2.na
4708 [ "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4708 4713 [ "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4713
+ 4714 [ "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4714
+ 4715 [ "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4715
+ 4716 [ "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4716
+ 4717 [ "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4717
+ 4718 [ "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4718
+ 4719 [ "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4719
4709 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4709 4720 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4720
..................
#select s1.name, t1.name, c1.name, s2.na
4722 [ "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4722 4733 [ "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4733
+ 4734 [ "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4734
+ 4735 [ "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4735
+ 4736 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4736
+ 4737 [ "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4737
+ 4738 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4738
+ 4739 [ "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4739
4723 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4723 4740 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4740
..................
#select s1.name, t1.name, c1.name, s2.na
4740 [ "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4740 4757 [ "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4757
+ 4758 [ "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4758
+ 4759 [ "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4759
+ 4760 [ "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4760
+ 4761 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4761
+ 4762 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4762
4741 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4741 4763 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4763
..................
#select s1.name, t1.name, c1.name, s2.na
4744 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4744 4766 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4766
+ 4767 [ "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4767
4745 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4745 4768 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4768
..................
#select s1.name, t1.name, c1.name, s2.na
4762 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4762 4785 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4785
+ 4786 [ "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4786
+ 4787 [ "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4787
+ 4788 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4788
+ 4789 [ "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4789
4763 [ "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4763 4790 [ "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4790
..................
#select s1.name, t1.name, c1.name, s2.na
4816 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4816 4843 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4843
+ 4844 [ "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4844
+ 4845 [ "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4845
4817 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4817 4846 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4846
+ 4847 [ "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4847
+ 4848 [ "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4848
4818 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4818 4849 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4849
..................
#select s1.name, t1.name, c1.name, s2.na
4820 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4820 4851 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4851
+ 4852 [ "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4852
4821 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4821 4853 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4853
..................
#select s1.name, t1.name, c1.name, s2.na
4833 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4833 4865 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4865
+ 4866 [ "sys", "keys", "action", "sys", "ids", "VIEW" ] 4866
4834 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4834 4867 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4867
4835 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4835 4868 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4868
+ 4869 [ "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4869
4836 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4836 4870 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4870
+ 4871 [ "sys", "keys", "type", "sys", "ids", "VIEW" ] 4871
+ 4872 [ "sys", "objects", "id", "sys", "ids", "VIEW" ] 4872
4837 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4837 4873 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4873
..................
#select s1.name, t1.name, c1.name, s2.na
4841 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4841 4877 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4877
+ 4878 [ "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4878
4842 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4842 4879 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4879
4843 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4843 4880 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4880
+ 4881 [ "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4881
+ 4882 [ "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4882
+ 4883 [ "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4883
4844 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4844 4884 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4884
..................
#select s1.name, t1.name, c1.name, s2.na
4849 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4849 4889 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4889
+ 4890 [ "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4890
+ 4891 [ "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4891
4850 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4850 4892 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4892
+ 4893 [ "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4893
+ 4894 [ "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4894
4851 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4851 4895 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4895
..................
#select s1.name, t1.name, c1.name, s2.na
4853 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4853 4897 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4897
+ 4898 [ "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4898
4854 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4854 4899 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4899
..................
#select s1.name, t1.name, c1.name, s2.na
4857 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4857 4902 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4902
+ 4903 [ "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4903
4858 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4858 4904 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4904
4859 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4859 4905 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4905
+ 4906 [ "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4906
4860 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4860 4907 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4907
+ 4908 [ "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4908
4861 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4861 4909 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4909
..................
#select t.name, g.name, case g.time when
5598 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5598 5646 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5646
5599 [ "_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();" ] 5599 ! 5647 [ 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();" ] 5647
5600 [ "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();" ] 5600 5648 [ "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();" ] 5648