Test check.SQL.py (id d2a25d02ca50) (err)
check.stable.out.int128.FILTERED 2019-09-08 20:28:11.271255710 +0200check.test.out.FILTERED 2019-09-08 20:28:11.407254429 +0200
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 5368 lines, 212510 words, 1386265 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5345 lines, 211844 words, 1381879 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5368 lines, 212510 words, 1386265 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5345 lines, 211844 words, 1381879 chars in lines not matching '^$|^(\| |)#` 3
4 # 5449 lines, 214949 words, 1403419 chars in all lines 4 ! 4 # 5425 lines, 214279 words, 1399059 chars in all lines 4
5 5 5 5
..................
# 10:17:18 >
195 \dSf sys."left_shift_assign" 195 194 \dSf sys."left_shift_assign" 194
196 \dSf sys."lidarattach" 196 -
197 \dSf sys."lidarexport" 197 -
198 \dSf sys."lidarload" 198 -
199 \dSf sys."like" 199 195 \dSf sys."like" 195
..................
# 10:17:18 >
249 \dSf sys."settimeout" 249 245 \dSf sys."settimeout" 245
250 \dSf sys."shpattach" 250 -
251 \dSf sys."shpload" 251 -
252 \dSf sys."shrink" 252 246 \dSf sys."shrink" 246
..................
# 10:17:18 >
586 SYSTEM FUNCTION sys.levenshtein 586 580 SYSTEM FUNCTION sys.levenshtein 580
587 SYSTEM PROCEDURE sys.lidarattach 587 -
588 SYSTEM PROCEDURE sys.lidarexport 588 -
589 SYSTEM PROCEDURE sys.lidarload 589 -
590 SYSTEM FILTER FUNCTION sys.like 590 581 SYSTEM FILTER FUNCTION sys.like 581
..................
# 10:17:18 >
706 SYSTEM PROCEDURE sys.settimeout 706 697 SYSTEM PROCEDURE sys.settimeout 697
707 SYSTEM PROCEDURE sys.shpattach 707 -
708 SYSTEM PROCEDURE sys.shpload 708 -
709 SYSTEM PROCEDURE sys.shrink 709 698 SYSTEM PROCEDURE sys.shrink 698
..................
# 10:17:18 >
998 create procedure sys.flush_log () external name sql."flush_log"; 998 987 create procedure sys.flush_log () external name sql."flush_log"; 987
+ 988 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 988
999 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 999 ! 989 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 989
1000 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 1000 990 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 990
1001 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 1001 ! 991 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 991
1002 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 1002 ! 992 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 992
1003 create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; 1003 ! 993 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 993
1004 create function sys.generate_series(first bigint, "limit" bigint, stepsize bigint) returns table (value bigint) external name generator.series; 1004 ! 994 create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series; 994
1005 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; 1005 ! 995 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; 995
1006 create function sys.generate_series(first double, "limit" double, stepsize double) returns table (value double) external name generator.series; 1006 ! 996 create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series; 996
1007 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 1007 997 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 997
1008 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 1008 998 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 998
1009 create function sys.generate_series(first int, "limit" int) returns table (value int) external name generator.series; 1009 ! 999 create function sys.generate_series(first int, last int) returns table (value int) external name generator.series; 999
1010 create function sys.generate_series(first int, "limit" int, stepsize int) returns table (value int) external name generator.series; 1010 ! 1000 create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series; 1000
1011 create function sys.generate_series(first real, "limit" real, stepsize real) returns table (value real) external name generator.series; 1011 ! 1001 create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series; 1001
1012 create function sys.generate_series(first smallint, "limit" smallint) returns table (value smallint) external name generator.series; 1012 ! 1002 create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series; 1002
1013 create function sys.generate_series(first smallint, "limit" smallint, stepsize smallint) returns table (value smallint) external name generator.series; 1013 ! 1003 create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series; 1003
1014 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1014 ! 1004 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1004
1015 create function sys.generate_series(first tinyint, "limit" tinyint) returns table (value tinyint) external name generator.series; 1015 ! 1005 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1005
1016 create function sys.generate_series(first tinyint, "limit" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1016 -
1017 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1017 1006 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1006
..................
# 10:17:18 >
1048 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1048 1037 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1037
1049 create procedure lidarattach(fname string) external name lidar.attach; 1049 ! 1038 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1038
1050 create procedure lidarexport(tname string, fname string, format string) external name lidar.export; 1050 -
1051 create procedure lidarload(tname string) external name lidar.load; 1051 -
1052 create filter function "like"(val string, pat string) external name algebra."like"; 1052 1039 create filter function "like"(val string, pat string) external name algebra."like"; 1039
1053 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1053 -
1054 create procedure listdir(dirname string) external name fits.listdir; 1054 1040 create procedure listdir(dirname string) external name fits.listdir; 1040
..................
# 10:17:18 >
1088 create function sys.password_hash (username string) returns string external name sql.password; 1088 1074 create function sys.password_hash (username string) returns string external name sql.password; 1074
+ 1075 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1075
1089 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1089 1076 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1076
1090 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1090 -
1091 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1091 1077 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1077
..................
# 10:17:18 >
1136 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1136 1122 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1122
1137 create procedure shpattach(fname string) external name shp.attach; 1137 -
1138 create procedure shpload(fid integer) external name shp.import; 1138 -
1139 create procedure shpload(fid integer, filter geometry) external name shp.import; 1139 -
1140 create procedure shrink(sys string, tab string) external name sql.shrink; 1140 1123 create procedure shrink(sys string, tab string) external name sql.shrink; 1123
..................
# 10:17:18 >
1269 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1269 1252 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1252
+ 1253 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1253
1270 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1270 1254 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1254
..................
# 10:17:18 >
1278 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1278 1262 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1262
1279 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1279 -
1280 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1280 1263 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1263
..................
#select t.name, c.name, c.type, c.type_d
2026 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2026 2009 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2009
2027 [ "storagemodel", "orderidxsize", "bigint", 64, 0, NULL, true, 9, NULL ] 2027 ! 2010 [ "storagemodel", "orderidxsize", "bigint", 63, 0, NULL, true, 9, NULL ] 2010
2028 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2028 2011 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2011
..................
# .s, .f, .L47, .L50, .f,
2401 [ "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 ] 2401 2384 [ "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 ] 2384
2402 [ "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 ] 2402 ! 2385 [ "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 ] 2385
2403 [ "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 ] 2403 ! 2386 [ "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 ] 2386
2404 [ "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 ] 2404 ! 2387 [ "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 ] 2387
2405 [ "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 ] 2405 ! 2388 [ "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 ] 2388
2406 [ "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 ] 2406 2389 [ "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 ] 2389
2407 [ "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 ] 2407 2390 [ "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 ] 2390
2408 [ "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 ] 2408 ! 2391 [ "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 ] 2391
2409 [ "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 ] 2409 ! 2392 [ "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 ] 2392
2410 [ "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 ] 2410 ! 2393 [ "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 ] 2393
2411 [ "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 ] 2411 ! 2394 [ "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 ] 2394
2412 [ "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 ] 2412 ! 2395 [ "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 ] 2395
2413 [ "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 ] 2413 ! 2396 [ "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 ] 2396
2414 [ "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 ] 2414 ! 2397 [ "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 ] 2397
2415 [ "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 ] 2415 ! 2398 [ "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 ] 2398
2416 [ "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 ] 2416 2399 [ "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 ] 2399
..................
# .s, .f, .L47, .L50, .f,
2524 [ "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 ] 2524 2507 [ "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 ] 2507
2525 [ "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 ] 2525 -
2526 [ "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 ] 2526 -
2527 [ "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 ] 2527 -
2528 [ "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 ] 2528 2508 [ "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 ] 2508
..................
# .s, .f, .L47, .L50, .f,
3430 [ "sys", "settimeout", "SYSTEM", "create procedure sys.settimeout(\"query\" bigint, \"session\" bigint) external name clients.settimeout;", "clients", "MAL", "Procedure", true, false, false, "query", "bigint", 64, 0, "in", "session", "bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3430 3410 [ "sys", "settimeout", "SYSTEM", "create procedure sys.settimeout(\"query\" bigint, \"session\" bigint) external name clients.settimeout;", "clients", "MAL", "Procedure", true, false, false, "query", "bigint", 64, 0, "in", "session", "bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3410
3431 [ "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 ] 3431 -
3432 [ "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 ] 3432 -
3433 [ "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 ] 3433 -
3434 [ "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 ] 3434 3411 [ "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 ] 3411
..................
#select s1.name, f1.name, s2.name, f2.na
4080 % 3, 17, 3, 13, 8 # length 4080 4057 % 3, 17, 3, 13, 8 # length 4057
+ 4058 [ "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 4058
4081 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4081 4059 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4059
..................
#select s1.name, t.name, c.name, s2.name
4103 % 3, 17, 13, 3, 16, 9 # length 4103 4081 % 3, 17, 13, 3, 16, 9 # length 4081
4104 [ "sys", "spatial_ref_sys", "auth_name", "sys", "getproj4", "FUNCTION" ] 4104 -
4105 [ "sys", "spatial_ref_sys", "auth_srid", "sys", "getproj4", "FUNCTION" ] 4105 -
4106 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 4106 4082 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 4082
4107 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 4107 4083 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 4083
4108 [ "sys", "spatial_ref_sys", "srtext", "sys", "getproj4", "FUNCTION" ] 4108 -
4109 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 4109 4084 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 4084
..................
#select s1.name, f1.name, s2.name, t2.na
4138 % varchar, varchar, varchar, varchar, varchar # type 4138 4113 % varchar, varchar, varchar, varchar, varchar # type 4113
4139 % 3, 11, 3, 17, 4 # length 4139 ! 4114 % 3, 16, 3, 17, 4 # length 4114
4140 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 4140 4115 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 4115
..................
#select s1.name, f1.name, s2.name, t2.na
4142 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 4142 4117 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 4117
+ 4118 [ "sys", "optimizers", "sys", "optimizers", "VIEW" ] 4118
+ 4119 [ "sys", "querylog_catalog", "sys", "querylog_catalog", "VIEW" ] 4119
+ 4120 [ "sys", "queue", "sys", "queue", "VIEW" ] 4120
+ 4121 [ "sys", "rejects", "sys", "rejects", "VIEW" ] 4121
+ 4122 [ "sys", "sessions", "sys", "sessions", "VIEW" ] 4122
4143 [ "sys", "columnsize", "sys", "storagemodel", "VIEW" ] 4143 4123 [ "sys", "columnsize", "sys", "storagemodel", "VIEW" ] 4123
..................
#select s1.name, f1.name, s2.name, t2.na
4150 [ "sys", "imprintsize", "sys", "tablestoragemodel", "VIEW" ] 4150 4130 [ "sys", "imprintsize", "sys", "tablestoragemodel", "VIEW" ] 4130
+ 4131 [ "sys", "tracelog", "sys", "tracelog", "VIEW" ] 4131
4151 #select s1.name, t1.name, s2.name, t2.name, dt.dependency_type_name from sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = dt.dependency_type_id, schemas s1, _tables t1, schemas s2, _tables t2 where d.id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, t1.name; 4151 4132 #select s1.name, t1.name, s2.name, t2.name, dt.dependency_type_name from sys.dependencies d left outer join sys.dependency_types dt on d.depend_type = dt.dependency_type_id, schemas s1, _tables t1, schemas s2, _tables t2 where d.id = t1.id and t1.schema_id = s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name, t2.name, s1.name, t1.name; 4132
..................
#select s1.name, t1.name, s2.name, t2.na
4166 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 4166 4147 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 4147
4167 [ "sys", "idxs", "sys", "dependency_columns_on_indexes", "VIEW" ] 4167 -
4168 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 4168 4148 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 4148
4169 [ "sys", "objects", "sys", "dependency_columns_on_indexes", "VIEW" ] 4169 -
4170 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 4170 4149 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 4149
4171 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 4171 4150 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 4150
4172 [ "sys", "keys", "sys", "dependency_columns_on_keys", "VIEW" ] 4172 -
4173 [ "sys", "objects", "sys", "dependency_columns_on_keys", "VIEW" ] 4173 -
4174 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 4174 4151 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 4151
..................
#select s1.name, t1.name, s2.name, t2.na
4180 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 4180 4157 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 4157
4181 [ "sys", "triggers", "sys", "dependency_columns_on_triggers", "VIEW" ] 4181 -
4182 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 4182 4158 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 4158
..................
#select s1.name, t1.name, s2.name, t2.na
4194 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 4194 4170 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 4170
4195 [ "sys", "triggers", "sys", "dependency_functions_on_triggers", "VIEW" ] 4195 -
4196 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 4196 4171 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 4171
..................
#select s1.name, t1.name, s2.name, t2.na
4201 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 4201 4176 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 4176
4202 [ "sys", "keys", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4202 -
4203 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 4203 4177 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 4177
..................
#select s1.name, t1.name, s2.name, t2.na
4206 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 4206 4180 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 4180
4207 [ "sys", "keys", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4207 -
4208 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4208 4181 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4181
..................
#select s1.name, t1.name, s2.name, t2.na
4211 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 4211 4184 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 4184
4212 [ "sys", "idxs", "sys", "dependency_tables_on_indexes", "VIEW" ] 4212 -
4213 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 4213 4185 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 4185
..................
#select s1.name, t1.name, s2.name, t2.na
4219 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4219 4191 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4191
4220 [ "sys", "triggers", "sys", "dependency_tables_on_triggers", "VIEW" ] 4220 -
4221 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4221 4192 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4192
..................
#select s1.name, t1.name, s2.name, t2.na
4234 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4234 4205 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4205
4235 [ "sys", "_columns", "sys", "ids", "VIEW" ] 4235 -
4236 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4236 4206 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4206
..................
#select s1.name, t1.name, s2.name, t2.na
4239 [ "sys", "functions", "sys", "ids", "VIEW" ] 4239 4209 [ "sys", "functions", "sys", "ids", "VIEW" ] 4209
4240 [ "sys", "idxs", "sys", "ids", "VIEW" ] 4240 -
4241 [ "sys", "keys", "sys", "ids", "VIEW" ] 4241 4210 [ "sys", "keys", "sys", "ids", "VIEW" ] 4210
..................
#select s1.name, t1.name, s2.name, t2.na
4243 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4243 4212 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4212
4244 [ "sys", "triggers", "sys", "ids", "VIEW" ] 4244 -
4245 [ "sys", "types", "sys", "ids", "VIEW" ] 4245 4213 [ "sys", "types", "sys", "ids", "VIEW" ] 4213
4246 [ "tmp", "_columns", "sys", "ids", "VIEW" ] 4246 -
4247 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4247 4214 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4214
4248 [ "tmp", "idxs", "sys", "ids", "VIEW" ] 4248 -
4249 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4249 4215 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4215
4250 [ "tmp", "triggers", "sys", "ids", "VIEW" ] 4250 -
4251 [ "sys", "auths", "sys", "roles", "VIEW" ] 4251 4216 [ "sys", "auths", "sys", "roles", "VIEW" ] 4216
..................
#select s1.name, t1.name, c1.name, s2.na
4285 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4285 4250 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4250
4286 [ "sys", "idxs", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4286 ! 4251 [ "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4251
4287 [ "sys", "idxs", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4287 ! 4252 [ "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4252
4288 [ "sys", "idxs", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4288 ! 4253 [ "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4253
4289 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4289 ! 4254 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4254
4290 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4290 ! 4255 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4255
+ 4256 [ "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4256
4291 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4291 4257 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4257
4292 [ "sys", "objects", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4292 ! 4258 [ "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4258
4293 [ "sys", "objects", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4293 ! 4259 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4259
4294 [ "sys", "objects", "nr", "sys", "dependency_columns_on_indexes", "VIEW" ] 4294 ! 4260 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4260
4295 [ "sys", "keys", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4295 ! 4261 [ "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4261
4296 [ "sys", "keys", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4296 ! 4262 [ "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4262
4297 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4297 ! 4263 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4263
4298 [ "sys", "keys", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4298 ! 4264 [ "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4264
4299 [ "sys", "objects", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4299 ! 4265 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4265
4300 [ "sys", "objects", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4300 ! 4266 [ "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4266
4301 [ "sys", "objects", "nr", "sys", "dependency_columns_on_keys", "VIEW" ] 4301 ! 4267 [ "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4267
+ 4268 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4268
+ 4269 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4269
+ 4270 [ "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4270
4302 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4302 4271 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4271
..................
#select s1.name, t1.name, c1.name, s2.na
4310 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4310 4279 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4279
4311 [ "sys", "triggers", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4311 ! 4280 [ "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4280
4312 [ "sys", "triggers", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4312 ! 4281 [ "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4281
+ 4282 [ "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4282
4313 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4313 4283 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4283
..................
#select s1.name, t1.name, c1.name, s2.na
4341 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4341 4311 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4311
4342 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4342 ! 4312 [ "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4312
4343 [ "sys", "triggers", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4343 ! 4313 [ "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4313
4344 [ "sys", "triggers", "table_id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4344 ! 4314 [ "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4314
+ 4315 [ "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4315
4345 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4345 4316 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4316
..................
#select s1.name, t1.name, c1.name, s2.na
4358 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4358 4329 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4329
4359 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4359 ! 4330 [ "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4330
4360 [ "sys", "keys", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4360 ! 4331 [ "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4331
4361 [ "sys", "keys", "rkey", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4361 ! 4332 [ "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4332
4362 [ "sys", "keys", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4362 ! 4333 [ "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4333
4363 [ "sys", "keys", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4363 ! 4334 [ "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4334
+ 4335 [ "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4335
4364 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4364 4336 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4336
..................
#select s1.name, t1.name, c1.name, s2.na
4370 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4370 4342 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4342
4371 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4371 ! 4343 [ "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4343
4372 [ "sys", "keys", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4372 ! 4344 [ "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4344
4373 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4373 ! 4345 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4345
4374 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4374 ! 4346 [ "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4346
4375 [ "sys", "keys", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4375 ! 4347 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4347
+ 4348 [ "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4348
4376 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4376 4349 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4349
..................
#select s1.name, t1.name, c1.name, s2.na
4381 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4381 4354 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4354
4382 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4382 ! 4355 [ "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4355
4383 [ "sys", "idxs", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4383 ! 4356 [ "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4356
4384 [ "sys", "idxs", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4384 ! 4357 [ "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4357
4385 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4385 ! 4358 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4358
4386 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4386 ! 4359 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4359
+ 4360 [ "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4360
4387 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4387 4361 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4361
..................
#select s1.name, t1.name, c1.name, s2.na
4396 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4396 4370 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4370
4397 [ "sys", "triggers", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4397 ! 4371 [ "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4371
4398 [ "sys", "triggers", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4398 ! 4372 [ "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4372
4399 [ "sys", "triggers", "table_id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4399 ! 4373 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4373
+ 4374 [ "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4374
4400 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4400 4375 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4375
..................
#select s1.name, t1.name, c1.name, s2.na
4421 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4421 4396 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4396
+ 4397 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4397
4422 [ "sys", "_columns", "id", "sys", "ids", "VIEW" ] 4422 ! 4398 [ "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4398
4423 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4423 ! 4399 [ "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4399
4424 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4424 4400 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4400
+ 4401 [ "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4401
4425 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4425 -
4426 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4426 -
4427 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4427 ! 4402 [ "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4402
+ 4403 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4403
+ 4404 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4404
4428 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4428 ! 4405 [ "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4405
4429 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4429 4406 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4406
..................
#select s1.name, t1.name, c1.name, s2.na
4437 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4437 4414 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4414
4438 [ "sys", "idxs", "id", "sys", "ids", "VIEW" ] 4438 ! 4415 [ "sys", "keys", "action", "sys", "ids", "VIEW" ] 4415
+ 4416 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4416
4439 [ "sys", "idxs", "name", "sys", "ids", "VIEW" ] 4439 ! 4417 [ "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4417
+ 4418 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4418
4440 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4440 ! 4419 [ "sys", "keys", "type", "sys", "ids", "VIEW" ] 4419
4441 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4441 ! 4420 [ "sys", "objects", "id", "sys", "ids", "VIEW" ] 4420
4442 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4442 -
4443 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4443 -
4444 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4444 4421 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4421
..................
#select s1.name, t1.name, c1.name, s2.na
4448 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4448 4425 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4425
4449 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4449 ! 4426 [ "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4426
4450 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4450 ! 4427 [ "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4427
4451 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4451 ! 4428 [ "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4428
+ 4429 [ "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4429
4452 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4452 4430 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4430
..................
#select s1.name, t1.name, c1.name, s2.na
4454 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4454 4432 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4432
+ 4433 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4433
4455 [ "tmp", "_columns", "id", "sys", "ids", "VIEW" ] 4455 ! 4434 [ "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4434
4456 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4456 -
4457 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4457 -
4458 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4458 -
4459 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4459 -
4460 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4460 ! 4435 [ "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4435
+ 4436 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4436
4461 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4461 ! 4437 [ "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4437
4462 [ "tmp", "idxs", "id", "sys", "ids", "VIEW" ] 4462 ! 4438 [ "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4438
+ 4439 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4439
+ 4440 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4440
4463 [ "tmp", "idxs", "name", "sys", "ids", "VIEW" ] 4463 ! 4441 [ "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4441
4464 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4464 ! 4442 [ "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4442
+ 4443 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4443
4465 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4465 ! 4444 [ "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4444
4466 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4466 -
4467 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4467 4445 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4445
4468 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4468 ! 4446 [ "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4446
4469 [ "tmp", "triggers", "name", "sys", "ids", "VIEW" ] 4469 -
4470 [ "tmp", "triggers", "table_id", "sys", "ids", "VIEW" ] 4470 -
4471 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4471 4447 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4447
..................
# .t, .g, .L3, .L4, .L5,
5137 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5137 5113 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5113
5138 [ "_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();" ] 5138 ! 5114 [ 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();" ] 5114
5139 [ "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();" ] 5139 5115 [ "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();" ] 5115