Test check.SQL.py (id d2a25d02ca50) (err)
check.stable.out.FILTERED 2019-09-08 21:11:06.614291189 +0200check.test.out.FILTERED 2019-09-08 21:11:06.904292829 +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 5141 lines, 192860 words, 1262496 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5118 lines, 192194 words, 1258110 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5141 lines, 192860 words, 1262496 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5118 lines, 192194 words, 1258110 chars in lines not matching '^$|^(\| |)#` 3
4 # 5222 lines, 195299 words, 1279650 chars in all lines 4 ! 4 # 5198 lines, 194626 words, 1275269 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 >
997 create procedure sys.flush_log () external name sql."flush_log"; 997 986 create procedure sys.flush_log () external name sql."flush_log"; 986
+ 987 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 987
998 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 998 ! 988 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 988
999 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 999 ! 989 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 989
1000 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 1000 ! 990 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 990
1001 create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; 1001 ! 991 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 991
1002 create function sys.generate_series(first bigint, "limit" bigint, stepsize bigint) returns table (value bigint) external name generator.series; 1002 ! 992 create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series; 992
1003 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; 1003 ! 993 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; 993
1004 create function sys.generate_series(first double, "limit" double, stepsize double) returns table (value double) external name generator.series; 1004 ! 994 create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series; 994
1005 create function sys.generate_series(first int, "limit" int) returns table (value int) external name generator.series; 1005 ! 995 create function sys.generate_series(first int, last int) returns table (value int) external name generator.series; 995
1006 create function sys.generate_series(first int, "limit" int, stepsize int) returns table (value int) external name generator.series; 1006 ! 996 create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series; 996
1007 create function sys.generate_series(first real, "limit" real, stepsize real) returns table (value real) external name generator.series; 1007 ! 997 create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series; 997
1008 create function sys.generate_series(first smallint, "limit" smallint) returns table (value smallint) external name generator.series; 1008 ! 998 create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series; 998
1009 create function sys.generate_series(first smallint, "limit" smallint, stepsize smallint) returns table (value smallint) external name generator.series; 1009 ! 999 create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series; 999
1010 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1010 ! 1000 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1000
1011 create function sys.generate_series(first tinyint, "limit" tinyint) returns table (value tinyint) external name generator.series; 1011 -
1012 create function sys.generate_series(first tinyint, "limit" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1012 ! 1001 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1001
1013 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1013 1002 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1002
..................
# 10:17:18 >
1044 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1044 1033 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1033
1045 create procedure lidarattach(fname string) external name lidar.attach; 1045 ! 1034 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1034
1046 create procedure lidarexport(tname string, fname string, format string) external name lidar.export; 1046 -
1047 create procedure lidarload(tname string) external name lidar.load; 1047 -
1048 create filter function "like"(val string, pat string) external name algebra."like"; 1048 1035 create filter function "like"(val string, pat string) external name algebra."like"; 1035
1049 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1049 -
1050 create procedure listdir(dirname string) external name fits.listdir; 1050 1036 create procedure listdir(dirname string) external name fits.listdir; 1036
..................
# 10:17:18 >
1083 create function sys.password_hash (username string) returns string external name sql.password; 1083 1069 create function sys.password_hash (username string) returns string external name sql.password; 1069
+ 1070 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1070
1084 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1084 1071 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1071
1085 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1085 -
1086 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1086 1072 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1072
..................
# 10:17:18 >
1130 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1130 1116 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1116
1131 create procedure shpattach(fname string) external name shp.attach; 1131 -
1132 create procedure shpload(fid integer) external name shp.import; 1132 -
1133 create procedure shpload(fid integer, filter geometry) external name shp.import; 1133 -
1134 create procedure shrink(sys string, tab string) external name sql.shrink; 1134 1117 create procedure shrink(sys string, tab string) external name sql.shrink; 1117
..................
# 10:17:18 >
1262 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1262 1245 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1245
+ 1246 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1246
1263 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1263 1247 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1247
..................
# 10:17:18 >
1270 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1270 1254 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1254
1271 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1271 -
1272 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1272 1255 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1255
..................
#select t.name, c.name, c.type, c.type_d
2016 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2016 1999 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 1999
2017 [ "storagemodel", "orderidxsize", "bigint", 64, 0, NULL, true, 9, NULL ] 2017 ! 2000 [ "storagemodel", "orderidxsize", "bigint", 63, 0, NULL, true, 9, NULL ] 2000
2018 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2018 2001 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2001
..................
# .s, .f, .L47, .L50, .f,
2376 [ "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 ] 2376 2359 [ "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 ] 2359
2377 [ "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 ] 2377 ! 2360 [ "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 ] 2360
2378 [ "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 ] 2378 ! 2361 [ "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 ] 2361
2379 [ "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 ] 2379 ! 2362 [ "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 ] 2362
2380 [ "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 ] 2380 ! 2363 [ "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 ] 2363
2381 [ "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 ] 2381 ! 2364 [ "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 ] 2364
2382 [ "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 ] 2382 ! 2365 [ "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 ] 2365
2383 [ "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 ] 2383 ! 2366 [ "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 ] 2366
2384 [ "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 ] 2384 ! 2367 [ "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 ] 2367
2385 [ "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 ] 2385 ! 2368 [ "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 ] 2368
2386 [ "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 ] 2386 ! 2369 [ "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 ] 2369
2387 [ "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 ] 2387 ! 2370 [ "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 ] 2370
2388 [ "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 ] 2388 ! 2371 [ "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 ] 2371
2389 [ "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 ] 2389 2372 [ "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 ] 2372
..................
# .s, .f, .L47, .L50, .f,
2491 [ "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 ] 2491 2474 [ "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 ] 2474
2492 [ "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 ] 2492 -
2493 [ "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 ] 2493 -
2494 [ "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 ] 2494 -
2495 [ "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 ] 2495 2475 [ "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 ] 2475
..................
# .s, .f, .L47, .L50, .f,
3288 [ "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 ] 3288 3268 [ "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 ] 3268
3289 [ "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 ] 3289 -
3290 [ "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 ] 3290 -
3291 [ "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 ] 3291 -
3292 [ "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 ] 3292 3269 [ "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 ] 3269
..................
#select s1.name, f1.name, s2.name, f2.na
3864 % 3, 17, 3, 13, 8 # length 3864 3841 % 3, 17, 3, 13, 8 # length 3841
+ 3842 [ "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3842
3865 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3865 3843 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3843
..................
#select s1.name, t.name, c.name, s2.name
3887 % 3, 17, 13, 3, 16, 9 # length 3887 3865 % 3, 17, 13, 3, 16, 9 # length 3865
3888 [ "sys", "spatial_ref_sys", "auth_name", "sys", "getproj4", "FUNCTION" ] 3888 -
3889 [ "sys", "spatial_ref_sys", "auth_srid", "sys", "getproj4", "FUNCTION" ] 3889 -
3890 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 3890 3866 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 3866
3891 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 3891 3867 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 3867
3892 [ "sys", "spatial_ref_sys", "srtext", "sys", "getproj4", "FUNCTION" ] 3892 -
3893 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 3893 3868 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 3868
..................
#select s1.name, f1.name, s2.name, t2.na
3922 % varchar, varchar, varchar, varchar, varchar # type 3922 3897 % varchar, varchar, varchar, varchar, varchar # type 3897
3923 % 3, 11, 3, 17, 4 # length 3923 ! 3898 % 3, 16, 3, 17, 4 # length 3898
3924 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 3924 3899 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 3899
..................
#select s1.name, f1.name, s2.name, t2.na
3926 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 3926 3901 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 3901
+ 3902 [ "sys", "optimizers", "sys", "optimizers", "VIEW" ] 3902
+ 3903 [ "sys", "querylog_catalog", "sys", "querylog_catalog", "VIEW" ] 3903
+ 3904 [ "sys", "queue", "sys", "queue", "VIEW" ] 3904
+ 3905 [ "sys", "rejects", "sys", "rejects", "VIEW" ] 3905
+ 3906 [ "sys", "sessions", "sys", "sessions", "VIEW" ] 3906
3927 [ "sys", "columnsize", "sys", "storagemodel", "VIEW" ] 3927 3907 [ "sys", "columnsize", "sys", "storagemodel", "VIEW" ] 3907
..................
#select s1.name, f1.name, s2.name, t2.na
3934 [ "sys", "imprintsize", "sys", "tablestoragemodel", "VIEW" ] 3934 3914 [ "sys", "imprintsize", "sys", "tablestoragemodel", "VIEW" ] 3914
+ 3915 [ "sys", "tracelog", "sys", "tracelog", "VIEW" ] 3915
3935 #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; 3935 3916 #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; 3916
..................
#select s1.name, t1.name, s2.name, t2.na
3950 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 3950 3931 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 3931
3951 [ "sys", "idxs", "sys", "dependency_columns_on_indexes", "VIEW" ] 3951 -
3952 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 3952 3932 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 3932
3953 [ "sys", "objects", "sys", "dependency_columns_on_indexes", "VIEW" ] 3953 -
3954 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 3954 3933 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 3933
3955 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 3955 3934 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 3934
3956 [ "sys", "keys", "sys", "dependency_columns_on_keys", "VIEW" ] 3956 -
3957 [ "sys", "objects", "sys", "dependency_columns_on_keys", "VIEW" ] 3957 -
3958 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 3958 3935 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 3935
..................
#select s1.name, t1.name, s2.name, t2.na
3964 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 3964 3941 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 3941
3965 [ "sys", "triggers", "sys", "dependency_columns_on_triggers", "VIEW" ] 3965 -
3966 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 3966 3942 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 3942
..................
#select s1.name, t1.name, s2.name, t2.na
3978 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 3978 3954 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 3954
3979 [ "sys", "triggers", "sys", "dependency_functions_on_triggers", "VIEW" ] 3979 -
3980 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 3980 3955 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 3955
..................
#select s1.name, t1.name, s2.name, t2.na
3985 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 3985 3960 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 3960
3986 [ "sys", "keys", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 3986 -
3987 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 3987 3961 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 3961
..................
#select s1.name, t1.name, s2.name, t2.na
3990 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 3990 3964 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 3964
3991 [ "sys", "keys", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 3991 -
3992 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 3992 3965 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 3965
..................
#select s1.name, t1.name, s2.name, t2.na
3995 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 3995 3968 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 3968
3996 [ "sys", "idxs", "sys", "dependency_tables_on_indexes", "VIEW" ] 3996 -
3997 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 3997 3969 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 3969
..................
#select s1.name, t1.name, s2.name, t2.na
4003 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4003 3975 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 3975
4004 [ "sys", "triggers", "sys", "dependency_tables_on_triggers", "VIEW" ] 4004 -
4005 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4005 3976 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 3976
..................
#select s1.name, t1.name, s2.name, t2.na
4018 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4018 3989 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 3989
4019 [ "sys", "_columns", "sys", "ids", "VIEW" ] 4019 -
4020 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4020 3990 [ "sys", "_tables", "sys", "ids", "VIEW" ] 3990
..................
#select s1.name, t1.name, s2.name, t2.na
4023 [ "sys", "functions", "sys", "ids", "VIEW" ] 4023 3993 [ "sys", "functions", "sys", "ids", "VIEW" ] 3993
4024 [ "sys", "idxs", "sys", "ids", "VIEW" ] 4024 -
4025 [ "sys", "keys", "sys", "ids", "VIEW" ] 4025 3994 [ "sys", "keys", "sys", "ids", "VIEW" ] 3994
..................
#select s1.name, t1.name, s2.name, t2.na
4027 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4027 3996 [ "sys", "sequences", "sys", "ids", "VIEW" ] 3996
4028 [ "sys", "triggers", "sys", "ids", "VIEW" ] 4028 -
4029 [ "sys", "types", "sys", "ids", "VIEW" ] 4029 3997 [ "sys", "types", "sys", "ids", "VIEW" ] 3997
4030 [ "tmp", "_columns", "sys", "ids", "VIEW" ] 4030 -
4031 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4031 3998 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 3998
4032 [ "tmp", "idxs", "sys", "ids", "VIEW" ] 4032 -
4033 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4033 3999 [ "tmp", "keys", "sys", "ids", "VIEW" ] 3999
4034 [ "tmp", "triggers", "sys", "ids", "VIEW" ] 4034 -
4035 [ "sys", "auths", "sys", "roles", "VIEW" ] 4035 4000 [ "sys", "auths", "sys", "roles", "VIEW" ] 4000
..................
#select s1.name, t1.name, c1.name, s2.na
4069 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4069 4034 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4034
4070 [ "sys", "idxs", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4070 ! 4035 [ "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4035
4071 [ "sys", "idxs", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4071 ! 4036 [ "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4036
4072 [ "sys", "idxs", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4072 ! 4037 [ "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4037
4073 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4073 ! 4038 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4038
4074 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4074 ! 4039 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4039
+ 4040 [ "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4040
4075 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4075 4041 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4041
4076 [ "sys", "objects", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4076 ! 4042 [ "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4042
4077 [ "sys", "objects", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4077 ! 4043 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4043
4078 [ "sys", "objects", "nr", "sys", "dependency_columns_on_indexes", "VIEW" ] 4078 ! 4044 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4044
4079 [ "sys", "keys", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4079 ! 4045 [ "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4045
4080 [ "sys", "keys", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4080 ! 4046 [ "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4046
4081 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4081 ! 4047 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4047
4082 [ "sys", "keys", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4082 ! 4048 [ "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4048
4083 [ "sys", "objects", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4083 ! 4049 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4049
4084 [ "sys", "objects", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4084 ! 4050 [ "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4050
4085 [ "sys", "objects", "nr", "sys", "dependency_columns_on_keys", "VIEW" ] 4085 ! 4051 [ "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4051
+ 4052 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4052
+ 4053 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4053
+ 4054 [ "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4054
4086 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4086 4055 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4055
..................
#select s1.name, t1.name, c1.name, s2.na
4094 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4094 4063 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4063
4095 [ "sys", "triggers", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4095 ! 4064 [ "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4064
4096 [ "sys", "triggers", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4096 ! 4065 [ "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4065
+ 4066 [ "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4066
4097 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4097 4067 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4067
..................
#select s1.name, t1.name, c1.name, s2.na
4125 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4125 4095 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4095
4126 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4126 ! 4096 [ "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4096
4127 [ "sys", "triggers", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4127 ! 4097 [ "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4097
4128 [ "sys", "triggers", "table_id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4128 ! 4098 [ "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4098
+ 4099 [ "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4099
4129 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4129 4100 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4100
..................
#select s1.name, t1.name, c1.name, s2.na
4142 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4142 4113 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4113
4143 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4143 ! 4114 [ "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4114
4144 [ "sys", "keys", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4144 ! 4115 [ "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4115
4145 [ "sys", "keys", "rkey", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4145 ! 4116 [ "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4116
4146 [ "sys", "keys", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4146 ! 4117 [ "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4117
4147 [ "sys", "keys", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4147 ! 4118 [ "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4118
+ 4119 [ "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4119
4148 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4148 4120 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4120
..................
#select s1.name, t1.name, c1.name, s2.na
4154 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4154 4126 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4126
4155 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4155 ! 4127 [ "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4127
4156 [ "sys", "keys", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4156 ! 4128 [ "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4128
4157 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4157 ! 4129 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4129
4158 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4158 ! 4130 [ "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4130
4159 [ "sys", "keys", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4159 ! 4131 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4131
+ 4132 [ "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4132
4160 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4160 4133 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4133
..................
#select s1.name, t1.name, c1.name, s2.na
4165 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4165 4138 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4138
4166 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4166 ! 4139 [ "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4139
4167 [ "sys", "idxs", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4167 ! 4140 [ "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4140
4168 [ "sys", "idxs", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4168 ! 4141 [ "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4141
4169 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4169 ! 4142 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4142
4170 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4170 ! 4143 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4143
+ 4144 [ "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4144
4171 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4171 4145 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4145
..................
#select s1.name, t1.name, c1.name, s2.na
4180 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4180 4154 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4154
4181 [ "sys", "triggers", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4181 ! 4155 [ "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4155
4182 [ "sys", "triggers", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4182 ! 4156 [ "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4156
4183 [ "sys", "triggers", "table_id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4183 ! 4157 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4157
+ 4158 [ "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4158
4184 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4184 4159 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4159
..................
#select s1.name, t1.name, c1.name, s2.na
4205 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4205 4180 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4180
+ 4181 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4181
4206 [ "sys", "_columns", "id", "sys", "ids", "VIEW" ] 4206 ! 4182 [ "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4182
4207 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4207 ! 4183 [ "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4183
4208 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4208 4184 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4184
+ 4185 [ "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4185
4209 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4209 -
4210 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4210 -
4211 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4211 ! 4186 [ "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4186
+ 4187 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4187
+ 4188 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4188
4212 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4212 ! 4189 [ "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4189
4213 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4213 4190 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4190
..................
#select s1.name, t1.name, c1.name, s2.na
4221 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4221 4198 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4198
4222 [ "sys", "idxs", "id", "sys", "ids", "VIEW" ] 4222 ! 4199 [ "sys", "keys", "action", "sys", "ids", "VIEW" ] 4199
+ 4200 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4200
4223 [ "sys", "idxs", "name", "sys", "ids", "VIEW" ] 4223 ! 4201 [ "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4201
+ 4202 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4202
4224 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4224 ! 4203 [ "sys", "keys", "type", "sys", "ids", "VIEW" ] 4203
4225 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4225 ! 4204 [ "sys", "objects", "id", "sys", "ids", "VIEW" ] 4204
4226 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4226 -
4227 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4227 -
4228 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4228 4205 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4205
..................
#select s1.name, t1.name, c1.name, s2.na
4232 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4232 4209 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4209
4233 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4233 ! 4210 [ "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4210
4234 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4234 ! 4211 [ "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4211
4235 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4235 ! 4212 [ "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4212
+ 4213 [ "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4213
4236 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4236 4214 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4214
..................
#select s1.name, t1.name, c1.name, s2.na
4238 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4238 4216 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4216
+ 4217 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4217
4239 [ "tmp", "_columns", "id", "sys", "ids", "VIEW" ] 4239 ! 4218 [ "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4218
4240 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4240 -
4241 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4241 -
4242 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4242 -
4243 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4243 -
4244 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4244 ! 4219 [ "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4219
+ 4220 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4220
4245 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4245 ! 4221 [ "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4221
4246 [ "tmp", "idxs", "id", "sys", "ids", "VIEW" ] 4246 ! 4222 [ "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4222
+ 4223 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4223
+ 4224 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4224
4247 [ "tmp", "idxs", "name", "sys", "ids", "VIEW" ] 4247 ! 4225 [ "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4225
4248 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4248 ! 4226 [ "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4226
+ 4227 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4227
4249 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4249 ! 4228 [ "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4228
4250 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4250 -
4251 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4251 4229 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4229
4252 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4252 ! 4230 [ "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4230
4253 [ "tmp", "triggers", "name", "sys", "ids", "VIEW" ] 4253 -
4254 [ "tmp", "triggers", "table_id", "sys", "ids", "VIEW" ] 4254 -
4255 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4255 4231 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4231
..................
# .t, .g, .L3, .L4, .L5,
4912 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 4912 4888 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 4888
4913 [ "_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();" ] 4913 ! 4889 [ 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();" ] 4889
4914 [ "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();" ] 4914 4890 [ "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();" ] 4890