Test check.SQL.py (id fe8055a86502) (err)
check.stable.out.FILTERED 2019-09-12 11:19:07.844315483 +0200check.test.out.FILTERED 2019-09-12 11:19:08.184331048 +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 5114 lines, 191266 words, 1252016 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5091 lines, 190600 words, 1247630 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5114 lines, 191266 words, 1252016 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5091 lines, 190600 words, 1247630 chars in lines not matching '^$|^(\| |)#` 3
4 # 5195 lines, 193705 words, 1269168 chars in all lines 4 ! 4 # 5172 lines, 193034 words, 1264795 chars in all lines 4
5 5 5 5
..................
# 10:17:18 >
195 \dSf sys."left_shift_assign" 195 195 \dSf sys."left_shift_assign" 195
196 \dSf sys."lidarattach" 196 -
197 \dSf sys."lidarexport" 197 -
198 \dSf sys."lidarload" 198 -
199 \dSf sys."like" 199 196 \dSf sys."like" 196
..................
# 10:17:18 >
249 \dSf sys."settimeout" 249 246 \dSf sys."settimeout" 246
250 \dSf sys."shpattach" 250 -
251 \dSf sys."shpload" 251 -
252 \dSf sys."shrink" 252 247 \dSf sys."shrink" 247
..................
# 10:17:18 >
578 SYSTEM FUNCTION sys.levenshtein 578 573 SYSTEM FUNCTION sys.levenshtein 573
579 SYSTEM PROCEDURE sys.lidarattach 579 -
580 SYSTEM PROCEDURE sys.lidarexport 580 -
581 SYSTEM PROCEDURE sys.lidarload 581 -
582 SYSTEM FILTER FUNCTION sys.like 582 574 SYSTEM FILTER FUNCTION sys.like 574
..................
# 10:17:18 >
697 SYSTEM PROCEDURE sys.settimeout 697 689 SYSTEM PROCEDURE sys.settimeout 689
698 SYSTEM PROCEDURE sys.shpattach 698 -
699 SYSTEM PROCEDURE sys.shpload 699 -
700 SYSTEM PROCEDURE sys.shrink 700 690 SYSTEM PROCEDURE sys.shrink 690
..................
# 10:17:18 >
985 create procedure sys.flush_log () external name sql."flush_log"; 985 975 create procedure sys.flush_log () external name sql."flush_log"; 975
+ 976 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 976
986 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 986 ! 977 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 977
987 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 987 ! 978 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 978
988 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 988 ! 979 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 979
989 create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; 989 ! 980 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 980
990 create function sys.generate_series(first bigint, "limit" bigint, stepsize bigint) returns table (value bigint) external name generator.series; 990 ! 981 create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series; 981
991 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; 991 ! 982 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; 982
992 create function sys.generate_series(first double, "limit" double, stepsize double) returns table (value double) external name generator.series; 992 ! 983 create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series; 983
993 create function sys.generate_series(first int, "limit" int) returns table (value int) external name generator.series; 993 ! 984 create function sys.generate_series(first int, last int) returns table (value int) external name generator.series; 984
994 create function sys.generate_series(first int, "limit" int, stepsize int) returns table (value int) external name generator.series; 994 ! 985 create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series; 985
995 create function sys.generate_series(first real, "limit" real, stepsize real) returns table (value real) external name generator.series; 995 ! 986 create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series; 986
996 create function sys.generate_series(first smallint, "limit" smallint) returns table (value smallint) external name generator.series; 996 ! 987 create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series; 987
997 create function sys.generate_series(first smallint, "limit" smallint, stepsize smallint) returns table (value smallint) external name generator.series; 997 ! 988 create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series; 988
998 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 998 ! 989 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 989
999 create function sys.generate_series(first tinyint, "limit" tinyint) returns table (value tinyint) external name generator.series; 999 -
1000 create function sys.generate_series(first tinyint, "limit" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1000 ! 990 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 990
1001 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1001 991 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 991
..................
# 10:17:18 >
1032 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1032 1022 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1022
1033 create procedure lidarattach(fname string) external name lidar.attach; 1033 ! 1023 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1023
1034 create procedure lidarexport(tname string, fname string, format string) external name lidar.export; 1034 -
1035 create procedure lidarload(tname string) external name lidar.load; 1035 -
1036 create filter function "like"(val string, pat string) external name algebra."like"; 1036 1024 create filter function "like"(val string, pat string) external name algebra."like"; 1024
1037 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1037 -
1038 create procedure listdir(dirname string) external name fits.listdir; 1038 1025 create procedure listdir(dirname string) external name fits.listdir; 1025
..................
# 10:17:18 >
1071 create function sys.password_hash (username string) returns string external name sql.password; 1071 1058 create function sys.password_hash (username string) returns string external name sql.password; 1058
+ 1059 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1059
1072 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1072 1060 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1060
1073 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1073 -
1074 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1074 1061 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1061
..................
# 10:17:18 >
1118 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1118 1105 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1105
1119 create procedure shpattach(fname string) external name shp.attach; 1119 -
1120 create procedure shpload(fid integer) external name shp.import; 1120 -
1121 create procedure shpload(fid integer, filter geometry) external name shp.import; 1121 -
1122 create procedure shrink(sys string, tab string) external name sql.shrink; 1122 1106 create procedure shrink(sys string, tab string) external name sql.shrink; 1106
..................
# 10:17:18 >
1250 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1250 1234 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1234
+ 1235 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1235
1251 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1251 1236 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1236
..................
# 10:17:18 >
1258 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1258 1243 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1243
1259 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1259 -
1260 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1260 1244 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1244
..................
#select t.name, c.name, c.type, c.type_d
2004 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 2004 1988 [ "storagemodel", "imprintsize", "bigint", 64, 0, NULL, true, 8, NULL ] 1988
2005 [ "storagemodel", "orderidxsize", "bigint", 64, 0, NULL, true, 9, NULL ] 2005 ! 1989 [ "storagemodel", "orderidxsize", "bigint", 63, 0, NULL, true, 9, NULL ] 1989
2006 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 2006 1990 [ "storagemodel", "sorted", "boolean", 1, 0, NULL, true, 10, NULL ] 1990
..................
# .s, .f, .L4, .L6, .f,
2350 [ "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 ] 2350 2334 [ "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 ] 2334
2351 [ "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 ] 2351 ! 2335 [ "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 ] 2335
2352 [ "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 ] 2352 ! 2336 [ "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 ] 2336
2353 [ "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 ] 2353 ! 2337 [ "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 ] 2337
2354 [ "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 ] 2354 ! 2338 [ "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 ] 2338
2355 [ "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 ] 2355 ! 2339 [ "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 ] 2339
2356 [ "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 ] 2356 ! 2340 [ "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 ] 2340
2357 [ "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 ] 2357 ! 2341 [ "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 ] 2341
2358 [ "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 ] 2358 ! 2342 [ "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 ] 2342
2359 [ "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 ] 2359 ! 2343 [ "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 ] 2343
2360 [ "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 ] 2360 ! 2344 [ "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 ] 2344
2361 [ "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 ] 2361 ! 2345 [ "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 ] 2345
2362 [ "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 ] 2362 ! 2346 [ "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 ] 2346
2363 [ "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 ] 2363 2347 [ "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 ] 2347
..................
# .s, .f, .L4, .L6, .f,
2465 [ "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 ] 2465 2449 [ "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 ] 2449
2466 [ "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 ] 2466 -
2467 [ "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 ] 2467 -
2468 [ "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 ] 2468 -
2469 [ "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 ] 2469 2450 [ "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 ] 2450
..................
# .s, .f, .L4, .L6, .f,
3261 [ "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 ] 3261 3242 [ "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 ] 3242
3262 [ "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 ] 3262 -
3263 [ "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 ] 3263 -
3264 [ "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 ] 3264 -
3265 [ "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 ] 3265 3243 [ "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 ] 3243
..................
#select s1.name, f1.name, s2.name, f2.na
3837 % 3, 17, 3, 13, 8 # length 3837 3815 % 3, 17, 3, 13, 8 # length 3815
+ 3816 [ "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3816
3838 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3838 3817 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3817
..................
#select s1.name, t.name, c.name, s2.name
3860 % 3, 17, 13, 3, 16, 9 # length 3860 3839 % 3, 17, 13, 3, 16, 9 # length 3839
3861 [ "sys", "spatial_ref_sys", "auth_name", "sys", "getproj4", "FUNCTION" ] 3861 -
3862 [ "sys", "spatial_ref_sys", "auth_srid", "sys", "getproj4", "FUNCTION" ] 3862 -
3863 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 3863 3840 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 3840
3864 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 3864 3841 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 3841
3865 [ "sys", "spatial_ref_sys", "srtext", "sys", "getproj4", "FUNCTION" ] 3865 -
3866 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 3866 3842 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 3842
..................
#select s1.name, f1.name, s2.name, t2.na
3895 % varchar, varchar, varchar, varchar, varchar # type 3895 3871 % varchar, varchar, varchar, varchar, varchar # type 3871
3896 % 3, 11, 3, 17, 4 # length 3896 ! 3872 % 3, 16, 3, 17, 4 # length 3872
3897 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 3897 3873 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 3873
..................
#select s1.name, f1.name, s2.name, t2.na
3899 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 3899 3875 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 3875
+ 3876 [ "sys", "optimizers", "sys", "optimizers", "VIEW" ] 3876
+ 3877 [ "sys", "querylog_catalog", "sys", "querylog_catalog", "VIEW" ] 3877
+ 3878 [ "sys", "queue", "sys", "queue", "VIEW" ] 3878
+ 3879 [ "sys", "rejects", "sys", "rejects", "VIEW" ] 3879
+ 3880 [ "sys", "sessions", "sys", "sessions", "VIEW" ] 3880
3900 [ "sys", "columnsize", "sys", "storagemodel", "VIEW" ] 3900 3881 [ "sys", "columnsize", "sys", "storagemodel", "VIEW" ] 3881
..................
#select s1.name, f1.name, s2.name, t2.na
3907 [ "sys", "imprintsize", "sys", "tablestoragemodel", "VIEW" ] 3907 3888 [ "sys", "imprintsize", "sys", "tablestoragemodel", "VIEW" ] 3888
+ 3889 [ "sys", "tracelog", "sys", "tracelog", "VIEW" ] 3889
3908 #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; 3908 3890 #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; 3890
..................
#select s1.name, t1.name, s2.name, t2.na
3923 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 3923 3905 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 3905
3924 [ "sys", "idxs", "sys", "dependency_columns_on_indexes", "VIEW" ] 3924 -
3925 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 3925 3906 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 3906
3926 [ "sys", "objects", "sys", "dependency_columns_on_indexes", "VIEW" ] 3926 -
3927 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 3927 3907 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 3907
3928 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 3928 3908 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 3908
3929 [ "sys", "keys", "sys", "dependency_columns_on_keys", "VIEW" ] 3929 -
3930 [ "sys", "objects", "sys", "dependency_columns_on_keys", "VIEW" ] 3930 -
3931 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 3931 3909 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 3909
..................
#select s1.name, t1.name, s2.name, t2.na
3937 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 3937 3915 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 3915
3938 [ "sys", "triggers", "sys", "dependency_columns_on_triggers", "VIEW" ] 3938 -
3939 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 3939 3916 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 3916
..................
#select s1.name, t1.name, s2.name, t2.na
3951 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 3951 3928 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 3928
3952 [ "sys", "triggers", "sys", "dependency_functions_on_triggers", "VIEW" ] 3952 -
3953 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 3953 3929 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 3929
..................
#select s1.name, t1.name, s2.name, t2.na
3958 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 3958 3934 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 3934
3959 [ "sys", "keys", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 3959 -
3960 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 3960 3935 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 3935
..................
#select s1.name, t1.name, s2.name, t2.na
3963 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 3963 3938 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 3938
3964 [ "sys", "keys", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 3964 -
3965 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 3965 3939 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 3939
..................
#select s1.name, t1.name, s2.name, t2.na
3968 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 3968 3942 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 3942
3969 [ "sys", "idxs", "sys", "dependency_tables_on_indexes", "VIEW" ] 3969 -
3970 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 3970 3943 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 3943
..................
#select s1.name, t1.name, s2.name, t2.na
3976 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 3976 3949 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 3949
3977 [ "sys", "triggers", "sys", "dependency_tables_on_triggers", "VIEW" ] 3977 -
3978 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 3978 3950 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 3950
..................
#select s1.name, t1.name, s2.name, t2.na
3991 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 3991 3963 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 3963
3992 [ "sys", "_columns", "sys", "ids", "VIEW" ] 3992 -
3993 [ "sys", "_tables", "sys", "ids", "VIEW" ] 3993 3964 [ "sys", "_tables", "sys", "ids", "VIEW" ] 3964
..................
#select s1.name, t1.name, s2.name, t2.na
3996 [ "sys", "functions", "sys", "ids", "VIEW" ] 3996 3967 [ "sys", "functions", "sys", "ids", "VIEW" ] 3967
3997 [ "sys", "idxs", "sys", "ids", "VIEW" ] 3997 -
3998 [ "sys", "keys", "sys", "ids", "VIEW" ] 3998 3968 [ "sys", "keys", "sys", "ids", "VIEW" ] 3968
..................
#select s1.name, t1.name, s2.name, t2.na
4000 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4000 3970 [ "sys", "sequences", "sys", "ids", "VIEW" ] 3970
4001 [ "sys", "triggers", "sys", "ids", "VIEW" ] 4001 -
4002 [ "sys", "types", "sys", "ids", "VIEW" ] 4002 3971 [ "sys", "types", "sys", "ids", "VIEW" ] 3971
4003 [ "tmp", "_columns", "sys", "ids", "VIEW" ] 4003 -
4004 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4004 3972 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 3972
4005 [ "tmp", "idxs", "sys", "ids", "VIEW" ] 4005 -
4006 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4006 3973 [ "tmp", "keys", "sys", "ids", "VIEW" ] 3973
4007 [ "tmp", "triggers", "sys", "ids", "VIEW" ] 4007 -
4008 [ "sys", "auths", "sys", "roles", "VIEW" ] 4008 3974 [ "sys", "auths", "sys", "roles", "VIEW" ] 3974
..................
#select s1.name, t1.name, c1.name, s2.na
4042 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4042 4008 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4008
4043 [ "sys", "idxs", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4043 ! 4009 [ "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4009
4044 [ "sys", "idxs", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4044 ! 4010 [ "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4010
4045 [ "sys", "idxs", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4045 ! 4011 [ "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4011
4046 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4046 ! 4012 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4012
4047 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4047 ! 4013 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4013
+ 4014 [ "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4014
4048 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4048 4015 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4015
4049 [ "sys", "objects", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4049 ! 4016 [ "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4016
4050 [ "sys", "objects", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4050 ! 4017 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4017
4051 [ "sys", "objects", "nr", "sys", "dependency_columns_on_indexes", "VIEW" ] 4051 ! 4018 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4018
4052 [ "sys", "keys", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4052 ! 4019 [ "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4019
4053 [ "sys", "keys", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4053 ! 4020 [ "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4020
4054 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4054 ! 4021 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4021
4055 [ "sys", "keys", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4055 ! 4022 [ "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4022
4056 [ "sys", "objects", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4056 ! 4023 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4023
4057 [ "sys", "objects", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4057 ! 4024 [ "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4024
4058 [ "sys", "objects", "nr", "sys", "dependency_columns_on_keys", "VIEW" ] 4058 ! 4025 [ "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4025
+ 4026 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4026
+ 4027 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4027
+ 4028 [ "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4028
4059 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4059 4029 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4029
..................
#select s1.name, t1.name, c1.name, s2.na
4067 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4067 4037 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4037
4068 [ "sys", "triggers", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4068 ! 4038 [ "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4038
4069 [ "sys", "triggers", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4069 ! 4039 [ "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4039
+ 4040 [ "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4040
4070 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4070 4041 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4041
..................
#select s1.name, t1.name, c1.name, s2.na
4098 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4098 4069 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4069
4099 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4099 ! 4070 [ "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4070
4100 [ "sys", "triggers", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4100 ! 4071 [ "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4071
4101 [ "sys", "triggers", "table_id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4101 ! 4072 [ "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4072
+ 4073 [ "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4073
4102 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4102 4074 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4074
..................
#select s1.name, t1.name, c1.name, s2.na
4115 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4115 4087 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4087
4116 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4116 ! 4088 [ "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4088
4117 [ "sys", "keys", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4117 ! 4089 [ "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4089
4118 [ "sys", "keys", "rkey", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4118 ! 4090 [ "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4090
4119 [ "sys", "keys", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4119 ! 4091 [ "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4091
4120 [ "sys", "keys", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4120 ! 4092 [ "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4092
+ 4093 [ "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4093
4121 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4121 4094 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4094
..................
#select s1.name, t1.name, c1.name, s2.na
4127 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4127 4100 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4100
4128 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4128 ! 4101 [ "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4101
4129 [ "sys", "keys", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4129 ! 4102 [ "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4102
4130 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4130 ! 4103 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4103
4131 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4131 ! 4104 [ "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4104
4132 [ "sys", "keys", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4132 ! 4105 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4105
+ 4106 [ "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4106
4133 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4133 4107 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4107
..................
#select s1.name, t1.name, c1.name, s2.na
4138 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4138 4112 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4112
4139 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4139 ! 4113 [ "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4113
4140 [ "sys", "idxs", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4140 ! 4114 [ "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4114
4141 [ "sys", "idxs", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4141 ! 4115 [ "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4115
4142 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4142 ! 4116 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4116
4143 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4143 ! 4117 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4117
+ 4118 [ "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4118
4144 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4144 4119 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4119
..................
#select s1.name, t1.name, c1.name, s2.na
4153 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4153 4128 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4128
4154 [ "sys", "triggers", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4154 ! 4129 [ "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4129
4155 [ "sys", "triggers", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4155 ! 4130 [ "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4130
4156 [ "sys", "triggers", "table_id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4156 ! 4131 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4131
+ 4132 [ "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4132
4157 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4157 4133 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4133
..................
#select s1.name, t1.name, c1.name, s2.na
4178 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4178 4154 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4154
+ 4155 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4155
4179 [ "sys", "_columns", "id", "sys", "ids", "VIEW" ] 4179 ! 4156 [ "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4156
4180 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4180 ! 4157 [ "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4157
4181 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4181 4158 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4158
+ 4159 [ "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4159
4182 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4182 -
4183 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4183 -
4184 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4184 ! 4160 [ "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4160
+ 4161 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4161
+ 4162 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4162
4185 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4185 ! 4163 [ "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4163
4186 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4186 4164 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4164
..................
#select s1.name, t1.name, c1.name, s2.na
4194 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4194 4172 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4172
4195 [ "sys", "idxs", "id", "sys", "ids", "VIEW" ] 4195 ! 4173 [ "sys", "keys", "action", "sys", "ids", "VIEW" ] 4173
+ 4174 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4174
4196 [ "sys", "idxs", "name", "sys", "ids", "VIEW" ] 4196 ! 4175 [ "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4175
+ 4176 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4176
4197 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4197 ! 4177 [ "sys", "keys", "type", "sys", "ids", "VIEW" ] 4177
4198 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4198 ! 4178 [ "sys", "objects", "id", "sys", "ids", "VIEW" ] 4178
4199 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4199 -
4200 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4200 -
4201 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4201 4179 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4179
..................
#select s1.name, t1.name, c1.name, s2.na
4205 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4205 4183 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4183
4206 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4206 ! 4184 [ "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4184
4207 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4207 ! 4185 [ "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4185
4208 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4208 ! 4186 [ "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4186
+ 4187 [ "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4187
4209 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4209 4188 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4188
..................
#select s1.name, t1.name, c1.name, s2.na
4211 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4211 4190 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4190
+ 4191 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4191
4212 [ "tmp", "_columns", "id", "sys", "ids", "VIEW" ] 4212 ! 4192 [ "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4192
4213 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4213 -
4214 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4214 -
4215 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4215 -
4216 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4216 -
4217 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4217 ! 4193 [ "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4193
+ 4194 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4194
4218 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4218 ! 4195 [ "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4195
4219 [ "tmp", "idxs", "id", "sys", "ids", "VIEW" ] 4219 ! 4196 [ "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4196
+ 4197 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4197
+ 4198 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4198
4220 [ "tmp", "idxs", "name", "sys", "ids", "VIEW" ] 4220 ! 4199 [ "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4199
4221 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4221 ! 4200 [ "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4200
+ 4201 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4201
4222 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4222 ! 4202 [ "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4202
4223 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4223 -
4224 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4224 4203 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4203
4225 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4225 ! 4204 [ "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4204
4226 [ "tmp", "triggers", "name", "sys", "ids", "VIEW" ] 4226 -
4227 [ "tmp", "triggers", "table_id", "sys", "ids", "VIEW" ] 4227 -
4228 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4228 4205 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4205
..................
# .t, .g, .L4, .L6, .L10,
4885 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 4885 4862 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 4862
4886 [ "_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();" ] 4886 ! 4863 [ 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();" ] 4863
4887 [ "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();" ] 4887 4864 [ "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();" ] 4864