Test check.SQL.py (id dc1281226f15) (err)
check.stable.out.int128.FILTERED 2019-12-03 04:11:47.618611351 +0100check.test.out.FILTERED 2019-12-03 04:11:47.965613225 +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 5682 lines, 219347 words, 1436183 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5730 lines, 219241 words, 1436458 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5682 lines, 219347 words, 1436183 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5730 lines, 219241 words, 1436458 chars in lines not matching '^$|^(\| |)#` 3
4 # 5759 lines, 221661 words, 1452596 chars in all lines 4 ! 4 # 5806 lines, 221557 words, 1452922 chars in all lines 4
5 5 5 5
..................
# 10:17:18 >
199 \dSf sys."left_shift_assign" 199 198 \dSf sys."left_shift_assign" 198
200 \dSf sys."lidarattach" 200 -
201 \dSf sys."lidarexport" 201 -
202 \dSf sys."lidarload" 202 -
203 \dSf sys."like" 203 199 \dSf sys."like" 199
..................
# 10:17:18 >
253 \dSf sys."setworkerlimit" 253 249 \dSf sys."setworkerlimit" 249
254 \dSf sys."shpattach" 254 -
255 \dSf sys."shpload" 255 -
256 \dSf sys."shrink" 256 250 \dSf sys."shrink" 250
..................
# 10:17:18 >
595 SYSTEM FUNCTION sys.levenshtein 595 589 SYSTEM FUNCTION sys.levenshtein 589
596 SYSTEM PROCEDURE sys.lidarattach 596 -
597 SYSTEM PROCEDURE sys.lidarexport 597 -
598 SYSTEM PROCEDURE sys.lidarload 598 -
599 SYSTEM FILTER FUNCTION sys.like 599 590 SYSTEM FILTER FUNCTION sys.like 590
..................
# 10:17:18 >
715 SYSTEM PROCEDURE sys.setworkerlimit 715 706 SYSTEM PROCEDURE sys.setworkerlimit 706
716 SYSTEM PROCEDURE sys.shpattach 716 -
717 SYSTEM PROCEDURE sys.shpload 717 -
718 SYSTEM PROCEDURE sys.shrink 718 707 SYSTEM PROCEDURE sys.shrink 707
..................
# 10:17:18 >
972 create view sys.tracelog as select * from sys.tracelog(); 972 961 create view sys.tracelog as select * from sys.tracelog(); 961
973 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"; 973 + 962 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" ; 962
974 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; 974 963 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; 963
..................
# 10:17:18 >
1013 create procedure sys.flush_log () external name sql."flush_log"; 1013 1002 create procedure sys.flush_log () external name sql."flush_log"; 1002
+ 1003 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 1003
1014 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 1014 ! 1004 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 1004
1015 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 1015 1005 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 1005
1016 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 1016 ! 1006 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 1006
1017 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 1017 ! 1007 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 1007
1018 create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; 1018 ! 1008 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 1008
1019 create function sys.generate_series(first bigint, "limit" bigint, stepsize bigint) returns table (value bigint) external name generator.series; 1019 ! 1009 create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series; 1009
1020 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; 1020 ! 1010 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; 1010
1021 create function sys.generate_series(first double, "limit" double, stepsize double) returns table (value double) external name generator.series; 1021 ! 1011 create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series; 1011
1022 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 1022 1012 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 1012
1023 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 1023 1013 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 1013
1024 create function sys.generate_series(first int, "limit" int) returns table (value int) external name generator.series; 1024 ! 1014 create function sys.generate_series(first int, last int) returns table (value int) external name generator.series; 1014
1025 create function sys.generate_series(first int, "limit" int, stepsize int) returns table (value int) external name generator.series; 1025 ! 1015 create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series; 1015
1026 create function sys.generate_series(first real, "limit" real, stepsize real) returns table (value real) external name generator.series; 1026 ! 1016 create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series; 1016
1027 create function sys.generate_series(first smallint, "limit" smallint) returns table (value smallint) external name generator.series; 1027 ! 1017 create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series; 1017
1028 create function sys.generate_series(first smallint, "limit" smallint, stepsize smallint) returns table (value smallint) external name generator.series; 1028 ! 1018 create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series; 1018
1029 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1029 ! 1019 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1019
1030 create function sys.generate_series(first tinyint, "limit" tinyint) returns table (value tinyint) external name generator.series; 1030 ! 1020 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1020
1031 create function sys.generate_series(first tinyint, "limit" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1031 -
1032 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1032 1021 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1021
..................
# 10:17:18 >
1064 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1064 1053 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1053
1065 create procedure lidarattach(fname string) external name lidar.attach; 1065 ! 1054 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1054
1066 create procedure lidarexport(tname string, fname string, format string) external name lidar.export; 1066 -
1067 create procedure lidarload(tname string) external name lidar.load; 1067 -
1068 create filter function "like"(val string, pat string) external name algebra."like"; 1068 1055 create filter function "like"(val string, pat string) external name algebra."like"; 1055
1069 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1069 -
1070 create procedure listdir(dirname string) external name fits.listdir; 1070 1056 create procedure listdir(dirname string) external name fits.listdir; 1056
..................
# 10:17:18 >
1109 create function sys.password_hash (username string) returns string external name sql.password; 1109 1095 create function sys.password_hash (username string) returns string external name sql.password; 1095
+ 1096 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1096
1110 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1110 1097 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1097
1111 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1111 -
1112 create procedure sys.pause(tag smallint) external name sql.sysmon_pause; 1112 1098 create procedure sys.pause(tag smallint) external name sql.sysmon_pause; 1098
..................
# 10:17:18 >
1171 create procedure sys.setworkerlimit("sessionid" int, "limit" int) external name clients.setworkerlimit; 1171 1157 create procedure sys.setworkerlimit("sessionid" int, "limit" int) external name clients.setworkerlimit; 1157
1172 create procedure shpattach(fname string) external name shp.attach; 1172 -
1173 create procedure shpload(fid integer) external name shp.import; 1173 -
1174 create procedure shpload(fid integer, filter geometry) external name shp.import; 1174 -
1175 create procedure shrink(sys string, tab string) external name sql.shrink; 1175 1158 create procedure shrink(sys string, tab string) external name sql.shrink; 1158
..................
# 10:17:18 >
1306 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1306 1289 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1289
+ 1290 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1290
1307 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1307 1291 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1291
..................
# 10:17:18 >
1317 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1317 1301 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1301
1318 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1318 -
1319 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1319 1302 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1302
..................
#select s.name, t.name, replace(replace(
1540 [ "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1540 1523 [ "sys", "user_role", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1523
1541 [ "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" ] 1541 ! 1524 [ "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" ] 1524
1542 [ "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1542 1525 [ "sys", "value_partitions", NULL, "TABLE", true, "COMMIT", "WRITABLE" ] 1525
..................
#select t.name, c.name, c.type, c.type_d
2076 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2076 2059 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2059
2077 [ "storagemodel", "orderidxsize", "bigint", 64, 0, NULL, true, 9, NULL ] 2077 ! 2060 [ "storagemodel", "orderidxsize", "bigint", 63, 0, NULL, true, 9, NULL ] 2060
2078 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2078 2061 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2061
..................
#select s.name, f.name, case f.system wh
2441 [ "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 ] 2441 2424 [ "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 ] 2424
2442 [ "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 ] 2442 ! 2425 [ "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 ] 2425
2443 [ "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 ] 2443 ! 2426 [ "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 ] 2426
2444 [ "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 ] 2444 ! 2427 [ "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 ] 2427
2445 [ "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 ] 2445 ! 2428 [ "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 ] 2428
2446 [ "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 ] 2446 2429 [ "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 ] 2429
2447 [ "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 ] 2447 2430 [ "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 ] 2430
2448 [ "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 ] 2448 ! 2431 [ "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 ] 2431
2449 [ "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 ] 2449 ! 2432 [ "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 ] 2432
2450 [ "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 ] 2450 ! 2433 [ "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 ] 2433
2451 [ "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 ] 2451 ! 2434 [ "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 ] 2434
2452 [ "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 ] 2452 ! 2435 [ "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 ] 2435
2453 [ "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 ] 2453 ! 2436 [ "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 ] 2436
2454 [ "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 ] 2454 ! 2437 [ "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 ] 2437
2455 [ "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 ] 2455 ! 2438 [ "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 ] 2438
2456 [ "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 ] 2456 2439 [ "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 ] 2439
..................
#select s.name, f.name, case f.system wh
2570 [ "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 ] 2570 2553 [ "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 ] 2553
2571 [ "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 ] 2571 -
2572 [ "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 ] 2572 -
2573 [ "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 ] 2573 -
2574 [ "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 ] 2574 2554 [ "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 ] 2554
..................
#select s.name, f.name, case f.system wh
3485 [ "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 ] 3485 3465 [ "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 ] 3465
3486 [ "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 ] 3486 -
3487 [ "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 ] 3487 -
3488 [ "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 ] 3488 -
3489 [ "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 ] 3489 3466 [ "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 ] 3466
..................
#select s1.name, f1.name, s2.name, f2.na
4166 % 3, 17, 3, 13, 8 # length 4166 4143 % 3, 17, 3, 13, 8 # length 4143
+ 4144 [ "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 4144
4167 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4167 4145 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4145
..................
#select s1.name, t1.name, c1.name, s2.na
4451 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4451 4429 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4429
+ 4430 [ "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4430
+ 4431 [ "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4431
+ 4432 [ "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4432
+ 4433 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4433
+ 4434 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4434
4452 [ "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4452 4435 [ "sys", "columns", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4435
..................
#select s1.name, t1.name, c1.name, s2.na
4458 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4458 4441 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4441
+ 4442 [ "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4442
4459 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4459 4443 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4443
..................
#select s1.name, t1.name, c1.name, s2.na
4466 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4466 4450 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4450
+ 4451 [ "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4451
+ 4452 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4452
+ 4453 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4453
+ 4454 [ "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4454
+ 4455 [ "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4455
+ 4456 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4456
+ 4457 [ "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4457
+ 4458 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4458
+ 4459 [ "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4459
4467 [ "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4467 4460 [ "sys", "columns", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4460
..................
#select s1.name, t1.name, c1.name, s2.na
4479 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4479 4472 [ "sys", "tables", "schema_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4472
+ 4473 [ "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4473
+ 4474 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4474
+ 4475 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4475
+ 4476 [ "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4476
4480 [ "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4480 4477 [ "sys", "columns", "id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4477
..................
#select s1.name, t1.name, c1.name, s2.na
4494 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4494 4491 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4491
+ 4492 [ "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4492
+ 4493 [ "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4493
+ 4494 [ "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4494
4495 [ "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4495 4495 [ "sys", "tables", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4495
..................
#select s1.name, t1.name, c1.name, s2.na
4541 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4541 4541 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4541
+ 4542 [ "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4542
+ 4543 [ "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4543
+ 4544 [ "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4544
+ 4545 [ "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4545
4542 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4542 4546 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4546
..................
#select s1.name, t1.name, c1.name, s2.na
4562 [ "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4562 4566 [ "sys", "tables", "type", "sys", "dependency_functions_on_views", "VIEW" ] 4566
+ 4567 [ "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4567
+ 4568 [ "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4568
+ 4569 [ "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4569
+ 4570 [ "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4570
+ 4571 [ "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4571
+ 4572 [ "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4572
4563 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4563 4573 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4573
..................
#select s1.name, t1.name, c1.name, s2.na
4576 [ "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4576 4586 [ "sys", "users", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4586
+ 4587 [ "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4587
+ 4588 [ "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4588
+ 4589 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4589
+ 4590 [ "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4590
+ 4591 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4591
+ 4592 [ "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4592
4577 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4577 4593 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4593
..................
#select s1.name, t1.name, c1.name, s2.na
4594 [ "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4594 4610 [ "sys", "tables", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4610
+ 4611 [ "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4611
+ 4612 [ "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4612
+ 4613 [ "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4613
+ 4614 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4614
+ 4615 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4615
4595 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4595 4616 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4616
..................
#select s1.name, t1.name, c1.name, s2.na
4598 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4598 4619 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4619
+ 4620 [ "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4620
4599 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4599 4621 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4621
..................
#select s1.name, t1.name, c1.name, s2.na
4616 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4616 4638 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4638
+ 4639 [ "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4639
+ 4640 [ "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4640
+ 4641 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4641
+ 4642 [ "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4642
4617 [ "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4617 4643 [ "sys", "tables", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4643
..................
#select s1.name, t1.name, c1.name, s2.na
4670 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4670 4696 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4696
+ 4697 [ "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4697
+ 4698 [ "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4698
4671 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4671 4699 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4699
+ 4700 [ "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4700
+ 4701 [ "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4701
4672 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4672 4702 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4702
..................
#select s1.name, t1.name, c1.name, s2.na
4674 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4674 4704 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4704
+ 4705 [ "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4705
4675 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4675 4706 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4706
..................
#select s1.name, t1.name, c1.name, s2.na
4687 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4687 4718 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4718
+ 4719 [ "sys", "keys", "action", "sys", "ids", "VIEW" ] 4719
4688 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4688 4720 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4720
4689 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4689 4721 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4721
+ 4722 [ "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4722
4690 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4690 4723 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4723
+ 4724 [ "sys", "keys", "type", "sys", "ids", "VIEW" ] 4724
+ 4725 [ "sys", "objects", "id", "sys", "ids", "VIEW" ] 4725
4691 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4691 4726 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4726
..................
#select s1.name, t1.name, c1.name, s2.na
4695 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4695 4730 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4730
+ 4731 [ "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4731
4696 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4696 4732 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4732
4697 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4697 4733 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4733
+ 4734 [ "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4734
+ 4735 [ "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4735
+ 4736 [ "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4736
4698 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4698 4737 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4737
..................
#select s1.name, t1.name, c1.name, s2.na
4703 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4703 4742 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4742
+ 4743 [ "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4743
+ 4744 [ "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4744
4704 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4704 4745 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4745
+ 4746 [ "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4746
+ 4747 [ "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4747
4705 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4705 4748 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4748
..................
#select s1.name, t1.name, c1.name, s2.na
4707 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4707 4750 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4750
+ 4751 [ "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4751
4708 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4708 4752 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4752
..................
#select s1.name, t1.name, c1.name, s2.na
4711 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4711 4755 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4755
+ 4756 [ "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4756
4712 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4712 4757 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4757
4713 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4713 4758 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4758
+ 4759 [ "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4759
4714 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4714 4760 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4760
+ 4761 [ "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4761
4715 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4715 4762 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4762
..................
#select t.name, g.name, case g.time when
5444 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5444 5491 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5491
5445 [ "_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();" ] 5445 ! 5492 [ 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();" ] 5492
5446 [ "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();" ] 5446 5493 [ "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();" ] 5493