Test check.SQL.py (id 85ca3a09c8e6) (err)
check.stable.out.int128.FILTERED 2018-12-05 20:01:09.137494308 +0100check.test.out.FILTERED 2018-12-05 20:01:09.410495839 +0100
1 Statistics about stdout of test 'check` in directory 'sql/test/emptydb-upgrade-chain-hge`: 1 1 Statistics about stdout of test 'check` in directory 'sql/test/emptydb-upgrade-chain-hge`: 1
2 6862 lines, 202511 words, 1305320 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 6832 lines, 201826 words, 1300848 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 6862 lines, 202511 words, 1305320 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 6832 lines, 201826 words, 1300848 chars in lines not matching '^$|^(\| |)#` 3
4 # 6941 lines, 204873 words, 1321929 chars in all lines 4 ! 4 # 6911 lines, 204186 words, 1317513 chars in all lines 4
5 5 5 5
..................
# 10:17:18 >
189 \dSf sys."left_shift_assign" 189 189 \dSf sys."left_shift_assign" 189
190 \dSf sys."lidarattach" 190 -
191 \dSf sys."lidarexport" 191 -
192 \dSf sys."lidarload" 192 -
193 \dSf sys."like" 193 190 \dSf sys."like" 190
..................
# 10:17:18 >
242 \dSf sys."settimeout" 242 239 \dSf sys."settimeout" 239
243 \dSf sys."shpattach" 243 -
244 \dSf sys."shpload" 244 -
245 \dSf sys."shrink" 245 240 \dSf sys."shrink" 240
..................
# 10:17:18 >
557 SYSTEM FUNCTION sys.levenshtein 557 552 SYSTEM FUNCTION sys.levenshtein 552
558 SYSTEM PROCEDURE sys.lidarattach 558 -
559 SYSTEM PROCEDURE sys.lidarexport 559 -
560 SYSTEM PROCEDURE sys.lidarload 560 -
561 SYSTEM FILTER FUNCTION sys.like 561 553 SYSTEM FILTER FUNCTION sys.like 553
..................
# 10:17:18 >
667 SYSTEM PROCEDURE sys.settimeout 667 659 SYSTEM PROCEDURE sys.settimeout 659
668 SYSTEM PROCEDURE sys.shpattach 668 -
669 SYSTEM PROCEDURE sys.shpload 669 -
670 SYSTEM PROCEDURE sys.shrink 670 660 SYSTEM PROCEDURE sys.shrink 660
..................
# 10:17:18 >
950 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 950 940 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 940
951 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 951 -
952 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 952 -
953 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 953 941 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 941
954 create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; 954 ! 942 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 942
955 create function sys.generate_series(first bigint, "limit" bigint, stepsize bigint) returns table (value bigint) external name generator.series; 955 ! 943 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 943
956 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; 956 ! 944 create function sys.generate_series(first hugeint, last hugeint) returns table (value hugeint) external name generator.series; 944
957 create function sys.generate_series(first double, "limit" double, stepsize double) returns table (value double) external name generator.series; 957 ! 945 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 945
958 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 958 ! 946 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 946
959 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 959 ! 947 create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series; 947
960 create function sys.generate_series(first int, "limit" int) returns table (value int) external name generator.series; 960 ! 948 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; 948
961 create function sys.generate_series(first int, "limit" int, stepsize int) returns table (value int) external name generator.series; 961 ! 949 create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series; 949
962 create function sys.generate_series(first real, "limit" real, stepsize real) returns table (value real) external name generator.series; 962 ! 950 create function sys.generate_series(first hugeint, last hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 950
963 create function sys.generate_series(first smallint, "limit" smallint) returns table (value smallint) external name generator.series; 963 ! 951 create function sys.generate_series(first int, last int) returns table (value int) external name generator.series; 951
964 create function sys.generate_series(first smallint, "limit" smallint, stepsize smallint) returns table (value smallint) external name generator.series; 964 ! 952 create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series; 952
965 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 965 ! 953 create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series; 953
966 create function sys.generate_series(first tinyint, "limit" tinyint) returns table (value tinyint) external name generator.series; 966 ! 954 create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series; 954
967 create function sys.generate_series(first tinyint, "limit" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 967 ! 955 create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series; 955
+ 956 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 956
+ 957 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 957
968 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 968 958 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 958
..................
# 10:17:18 >
999 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 999 989 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 989
1000 create procedure lidarattach(fname string) external name lidar.attach; 1000 ! 990 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 990
1001 create procedure lidarexport(tname string, fname string, format string) external name lidar.export; 1001 -
1002 create procedure lidarload(tname string) external name lidar.load; 1002 -
1003 create filter function "like"(val string, pat string) external name algebra."like"; 1003 991 create filter function "like"(val string, pat string) external name algebra."like"; 991
1004 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1004 -
1005 create procedure listdir(dirname string) external name fits.listdir; 1005 992 create procedure listdir(dirname string) external name fits.listdir; 992
..................
# 10:17:18 >
1039 create function sys.password_hash (username string) returns string external name sql.password; 1039 1026 create function sys.password_hash (username string) returns string external name sql.password; 1026
+ 1027 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1027
1040 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1040 1028 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1028
1041 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1041 -
1042 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1042 1029 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1029
..................
# 10:17:18 >
1086 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1086 1073 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1073
1087 create procedure shpattach(fname string) external name shp.attach; 1087 -
1088 create procedure shpload(fid integer) external name shp.import; 1088 -
1089 create procedure shpload(fid integer, filter geometry) external name shp.import; 1089 -
1090 create procedure shrink(sys string, tab string) external name sql.shrink; 1090 1074 create procedure shrink(sys string, tab string) external name sql.shrink; 1074
..................
# 10:17:18 >
1219 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1219 1203 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1203
+ 1204 create aggregate stddev_samp(val hugeint) returns double external name "aggr"."stdev"; 1204
+ 1205 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1205
1220 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1220 1206 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1206
..................
# 10:17:18 >
1222 create aggregate stddev_samp(val double) returns double external name "aggr"."stdev"; 1222 1208 create aggregate stddev_samp(val double) returns double external name "aggr"."stdev"; 1208
1223 create aggregate stddev_samp(val hugeint) returns double external name "aggr"."stdev"; 1223 -
1224 create aggregate stddev_samp(val integer) returns double external name "aggr"."stdev"; 1224 1209 create aggregate stddev_samp(val integer) returns double external name "aggr"."stdev"; 1209
..................
# 10:17:18 >
1228 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1228 1213 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1213
1229 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1229 -
1230 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1230 1214 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1214
..................
# .s, .f, .L4, .f, .fl,
2275 [ "sys", "fuse", "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 ] 2275 2259 [ "sys", "fuse", "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 ] 2259
2276 [ "sys", "generate_series", "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 ] 2276 ! 2260 [ "sys", "generate_series", "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 ] 2260
2277 [ "sys", "generate_series", "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 ] 2277 ! 2261 [ "sys", "generate_series", "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 ] 2261
2278 [ "sys", "generate_series", "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 ] 2278 ! 2262 [ "sys", "generate_series", "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 ] 2262
2279 [ "sys", "generate_series", "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 ] 2279 ! 2263 [ "sys", "generate_series", "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 ] 2263
2280 [ "sys", "generate_series", "create function sys.generate_series(first hugeint, \"limit\" hugeint) returns table (value hugeint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "hugeint", 128, 0, "out", "first", "hugeint", 128, 0, "in", "limit", "hugeint", 128, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2280 ! 2264 [ "sys", "generate_series", "create function sys.generate_series(first hugeint, last hugeint) returns table (value hugeint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "hugeint", 128, 0, "out", "first", "hugeint", 128, 0, "in", "last", "hugeint", 128, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2264
2281 [ "sys", "generate_series", "create function sys.generate_series(first hugeint, \"limit\" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "hugeint", 128, 0, "out", "first", "hugeint", 128, 0, "in", "limit", "hugeint", 128, 0, "in", "stepsize", "hugeint", 128, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2281 ! 2265 [ "sys", "generate_series", "create function sys.generate_series(first hugeint, last hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "hugeint", 128, 0, "out", "first", "hugeint", 128, 0, "in", "last", "hugeint", 128, 0, "in", "stepsize", "hugeint", 128, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2265
2282 [ "sys", "generate_series", "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 ] 2282 ! 2266 [ "sys", "generate_series", "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 ] 2266
2283 [ "sys", "generate_series", "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 ] 2283 ! 2267 [ "sys", "generate_series", "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 ] 2267
2284 [ "sys", "generate_series", "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 ] 2284 ! 2268 [ "sys", "generate_series", "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 ] 2268
2285 [ "sys", "generate_series", "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 ] 2285 ! 2269 [ "sys", "generate_series", "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 ] 2269
2286 [ "sys", "generate_series", "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 ] 2286 ! 2270 [ "sys", "generate_series", "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 ] 2270
2287 [ "sys", "generate_series", "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 ] 2287 ! 2271 [ "sys", "generate_series", "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 ] 2271
2288 [ "sys", "generate_series", "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 ] 2288 ! 2272 [ "sys", "generate_series", "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 ] 2272
2289 [ "sys", "generate_series", "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 ] 2289 ! 2273 [ "sys", "generate_series", "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 ] 2273
2290 [ "sys", "geometrytype", "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 ] 2290 2274 [ "sys", "geometrytype", "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 ] 2274
..................
# .s, .f, .L4, .f, .fl,
2372 [ "sys", "levenshtein", "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 ] 2372 2356 [ "sys", "levenshtein", "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 ] 2356
2373 [ "sys", "lidarattach", "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 ] 2373 -
2374 [ "sys", "lidarexport", "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 ] 2374 -
2375 [ "sys", "lidarload", "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 ] 2375 -
2376 [ "sys", "like", "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 ] 2376 2357 [ "sys", "like", "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 ] 2357
..................
# .s, .f, .L4, .f, .fl,
3244 [ "sys", "settimeout", "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 ] 3244 3225 [ "sys", "settimeout", "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 ] 3225
3245 [ "sys", "shpattach", "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 ] 3245 -
3246 [ "sys", "shpload", "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 ] 3246 -
3247 [ "sys", "shpload", "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 ] 3247 -
3248 [ "sys", "shrink", "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 ] 3248 3226 [ "sys", "shrink", "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 ] 3226
..................
#select s1.name, f1.name, s2.name, f2.na
3853 % 3, 17, 3, 13, 8 # length 3853 3831 % 3, 17, 3, 13, 8 # length 3831
+ 3832 [ "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3832
3854 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3854 3833 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3833
..................
#select s1.name, t.name, c.name, s2.name
3879 % 3, 17, 13, 3, 16, 9 # length 3879 3858 % 3, 17, 13, 3, 16, 9 # length 3858
3880 [ "sys", "spatial_ref_sys", "auth_name", "sys", "getproj4", "FUNCTION" ] 3880 -
3881 [ "sys", "spatial_ref_sys", "auth_srid", "sys", "getproj4", "FUNCTION" ] 3881 -
3882 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 3882 3859 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 3859
3883 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 3883 3860 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 3860
3884 [ "sys", "spatial_ref_sys", "srtext", "sys", "getproj4", "FUNCTION" ] 3884 -
3885 [ "sys", "storagemodelinput", "atomwidth", "sys", "storagemodel", "FUNCTION" ] 3885 3861 [ "sys", "storagemodelinput", "atomwidth", "sys", "storagemodel", "FUNCTION" ] 3861
..................
#select s1.name, f1.name, s2.name, t2.na
3928 % varchar, varchar, varchar, varchar, varchar # type 3928 3904 % varchar, varchar, varchar, varchar, varchar # type 3904
3929 % 3, 8, 3, 16, 4 # length 3929 ! 3905 % 3, 16, 3, 16, 4 # length 3905
3930 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 3930 3906 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 3906
..................
#select s1.name, f1.name, s2.name, t2.na
3932 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 3932 3908 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 3908
+ 3909 [ "sys", "optimizers", "sys", "optimizers", "VIEW" ] 3909
+ 3910 [ "sys", "querylog_catalog", "sys", "querylog_catalog", "VIEW" ] 3910
+ 3911 [ "sys", "queue", "sys", "queue", "VIEW" ] 3911
+ 3912 [ "sys", "rejects", "sys", "rejects", "VIEW" ] 3912
+ 3913 [ "sys", "sessions", "sys", "sessions", "VIEW" ] 3913
+ 3914 [ "sys", "tracelog", "sys", "tracelog", "VIEW" ] 3914
3933 #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; 3933 3915 #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; 3915
..................
#select s1.name, t1.name, s2.name, t2.na
3948 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 3948 3930 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 3930
3949 [ "sys", "idxs", "sys", "dependency_columns_on_indexes", "VIEW" ] 3949 -
3950 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 3950 3931 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 3931
3951 [ "sys", "objects", "sys", "dependency_columns_on_indexes", "VIEW" ] 3951 -
3952 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 3952 3932 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 3932
3953 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 3953 3933 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 3933
3954 [ "sys", "keys", "sys", "dependency_columns_on_keys", "VIEW" ] 3954 -
3955 [ "sys", "objects", "sys", "dependency_columns_on_keys", "VIEW" ] 3955 -
3956 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 3956 3934 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 3934
..................
#select s1.name, t1.name, s2.name, t2.na
3962 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 3962 3940 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 3940
3963 [ "sys", "triggers", "sys", "dependency_columns_on_triggers", "VIEW" ] 3963 -
3964 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 3964 3941 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 3941
..................
#select s1.name, t1.name, s2.name, t2.na
3976 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 3976 3953 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 3953
3977 [ "sys", "triggers", "sys", "dependency_functions_on_triggers", "VIEW" ] 3977 -
3978 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 3978 3954 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 3954
..................
#select s1.name, t1.name, s2.name, t2.na
3983 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 3983 3959 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 3959
3984 [ "sys", "keys", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 3984 -
3985 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 3985 3960 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 3960
..................
#select s1.name, t1.name, s2.name, t2.na
3988 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 3988 3963 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 3963
3989 [ "sys", "keys", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 3989 -
3990 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 3990 3964 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 3964
..................
#select s1.name, t1.name, s2.name, t2.na
3993 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 3993 3967 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 3967
3994 [ "sys", "idxs", "sys", "dependency_tables_on_indexes", "VIEW" ] 3994 -
3995 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 3995 3968 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 3968
..................
#select s1.name, t1.name, s2.name, t2.na
4001 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4001 3974 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 3974
4002 [ "sys", "triggers", "sys", "dependency_tables_on_triggers", "VIEW" ] 4002 -
4003 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4003 3975 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 3975
..................
#select s1.name, t1.name, s2.name, t2.na
4016 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4016 3988 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 3988
4017 [ "sys", "_columns", "sys", "ids", "VIEW" ] 4017 -
4018 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4018 3989 [ "sys", "_tables", "sys", "ids", "VIEW" ] 3989
..................
#select s1.name, t1.name, s2.name, t2.na
4021 [ "sys", "functions", "sys", "ids", "VIEW" ] 4021 3992 [ "sys", "functions", "sys", "ids", "VIEW" ] 3992
4022 [ "sys", "idxs", "sys", "ids", "VIEW" ] 4022 -
4023 [ "sys", "keys", "sys", "ids", "VIEW" ] 4023 3993 [ "sys", "keys", "sys", "ids", "VIEW" ] 3993
..................
#select s1.name, t1.name, s2.name, t2.na
4025 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4025 3995 [ "sys", "sequences", "sys", "ids", "VIEW" ] 3995
4026 [ "sys", "triggers", "sys", "ids", "VIEW" ] 4026 -
4027 [ "sys", "types", "sys", "ids", "VIEW" ] 4027 3996 [ "sys", "types", "sys", "ids", "VIEW" ] 3996
4028 [ "tmp", "_columns", "sys", "ids", "VIEW" ] 4028 -
4029 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4029 3997 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 3997
4030 [ "tmp", "idxs", "sys", "ids", "VIEW" ] 4030 -
4031 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4031 3998 [ "tmp", "keys", "sys", "ids", "VIEW" ] 3998
4032 [ "tmp", "triggers", "sys", "ids", "VIEW" ] 4032 -
4033 [ "sys", "auths", "sys", "roles", "VIEW" ] 4033 3999 [ "sys", "auths", "sys", "roles", "VIEW" ] 3999
..................
#select s1.name, t1.name, c1.name, s2.na
4060 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4060 4026 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4026
4061 [ "sys", "idxs", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4061 ! 4027 [ "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4027
4062 [ "sys", "idxs", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4062 ! 4028 [ "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4028
4063 [ "sys", "idxs", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4063 ! 4029 [ "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4029
4064 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4064 ! 4030 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4030
4065 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4065 ! 4031 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4031
+ 4032 [ "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4032
4066 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4066 4033 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4033
4067 [ "sys", "objects", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4067 ! 4034 [ "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4034
4068 [ "sys", "objects", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4068 ! 4035 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4035
4069 [ "sys", "objects", "nr", "sys", "dependency_columns_on_indexes", "VIEW" ] 4069 ! 4036 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4036
4070 [ "sys", "keys", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4070 ! 4037 [ "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4037
4071 [ "sys", "keys", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4071 ! 4038 [ "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4038
4072 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4072 ! 4039 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4039
4073 [ "sys", "keys", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4073 ! 4040 [ "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4040
4074 [ "sys", "objects", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4074 ! 4041 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4041
4075 [ "sys", "objects", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4075 ! 4042 [ "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4042
4076 [ "sys", "objects", "nr", "sys", "dependency_columns_on_keys", "VIEW" ] 4076 ! 4043 [ "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4043
+ 4044 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4044
+ 4045 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4045
+ 4046 [ "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4046
4077 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4077 4047 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4047
..................
#select s1.name, t1.name, c1.name, s2.na
4085 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4085 4055 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4055
4086 [ "sys", "triggers", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4086 ! 4056 [ "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4056
4087 [ "sys", "triggers", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4087 ! 4057 [ "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4057
+ 4058 [ "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4058
4088 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4088 4059 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4059
..................
#select s1.name, t1.name, c1.name, s2.na
4116 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4116 4087 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4087
4117 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4117 ! 4088 [ "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4088
4118 [ "sys", "triggers", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4118 ! 4089 [ "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4089
4119 [ "sys", "triggers", "table_id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4119 ! 4090 [ "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4090
+ 4091 [ "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4091
4120 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4120 4092 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4092
..................
#select s1.name, t1.name, c1.name, s2.na
4133 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4133 4105 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4105
4134 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4134 ! 4106 [ "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4106
4135 [ "sys", "keys", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4135 ! 4107 [ "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4107
4136 [ "sys", "keys", "rkey", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4136 ! 4108 [ "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4108
4137 [ "sys", "keys", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4137 ! 4109 [ "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4109
4138 [ "sys", "keys", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4138 ! 4110 [ "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4110
+ 4111 [ "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4111
4139 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4139 4112 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4112
..................
#select s1.name, t1.name, c1.name, s2.na
4145 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4145 4118 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4118
4146 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4146 ! 4119 [ "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4119
4147 [ "sys", "keys", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4147 ! 4120 [ "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4120
4148 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4148 ! 4121 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4121
4149 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4149 ! 4122 [ "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4122
4150 [ "sys", "keys", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4150 ! 4123 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4123
+ 4124 [ "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4124
4151 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4151 4125 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4125
..................
#select s1.name, t1.name, c1.name, s2.na
4156 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4156 4130 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4130
4157 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4157 ! 4131 [ "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4131
4158 [ "sys", "idxs", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4158 ! 4132 [ "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4132
4159 [ "sys", "idxs", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4159 ! 4133 [ "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4133
4160 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4160 ! 4134 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4134
4161 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4161 ! 4135 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4135
+ 4136 [ "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4136
4162 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4162 4137 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4137
..................
#select s1.name, t1.name, c1.name, s2.na
4171 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4171 4146 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4146
4172 [ "sys", "triggers", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4172 ! 4147 [ "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4147
4173 [ "sys", "triggers", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4173 ! 4148 [ "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4148
4174 [ "sys", "triggers", "table_id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4174 ! 4149 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4149
+ 4150 [ "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4150
4175 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4175 4151 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4151
..................
#select s1.name, t1.name, c1.name, s2.na
4196 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4196 4172 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4172
+ 4173 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4173
4197 [ "sys", "_columns", "id", "sys", "ids", "VIEW" ] 4197 ! 4174 [ "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4174
4198 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4198 ! 4175 [ "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4175
4199 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4199 4176 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4176
+ 4177 [ "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4177
4200 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4200 -
4201 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4201 -
4202 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4202 ! 4178 [ "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4178
+ 4179 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4179
+ 4180 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4180
4203 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4203 ! 4181 [ "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4181
4204 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4204 4182 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4182
..................
#select s1.name, t1.name, c1.name, s2.na
4212 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4212 4190 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4190
4213 [ "sys", "idxs", "id", "sys", "ids", "VIEW" ] 4213 ! 4191 [ "sys", "keys", "action", "sys", "ids", "VIEW" ] 4191
+ 4192 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4192
4214 [ "sys", "idxs", "name", "sys", "ids", "VIEW" ] 4214 ! 4193 [ "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4193
+ 4194 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4194
4215 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4215 ! 4195 [ "sys", "keys", "type", "sys", "ids", "VIEW" ] 4195
4216 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4216 ! 4196 [ "sys", "objects", "id", "sys", "ids", "VIEW" ] 4196
4217 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4217 -
4218 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4218 -
4219 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4219 4197 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4197
..................
#select s1.name, t1.name, c1.name, s2.na
4223 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4223 4201 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4201
4224 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4224 ! 4202 [ "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4202
4225 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4225 ! 4203 [ "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4203
4226 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4226 ! 4204 [ "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4204
+ 4205 [ "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4205
4227 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4227 4206 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4206
..................
#select s1.name, t1.name, c1.name, s2.na
4229 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4229 4208 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4208
+ 4209 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4209
4230 [ "tmp", "_columns", "id", "sys", "ids", "VIEW" ] 4230 ! 4210 [ "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4210
4231 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4231 -
4232 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4232 -
4233 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4233 -
4234 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4234 -
4235 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4235 ! 4211 [ "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4211
+ 4212 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4212
4236 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4236 ! 4213 [ "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4213
4237 [ "tmp", "idxs", "id", "sys", "ids", "VIEW" ] 4237 ! 4214 [ "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4214
+ 4215 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4215
+ 4216 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4216
4238 [ "tmp", "idxs", "name", "sys", "ids", "VIEW" ] 4238 ! 4217 [ "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4217
4239 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4239 ! 4218 [ "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4218
+ 4219 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4219
4240 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4240 ! 4220 [ "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4220
4241 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4241 -
4242 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4242 4221 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4221
4243 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4243 ! 4222 [ "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4222
4244 [ "tmp", "triggers", "name", "sys", "ids", "VIEW" ] 4244 -
4245 [ "tmp", "triggers", "table_id", "sys", "ids", "VIEW" ] 4245 -
4246 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4246 4223 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4223
..................
#select f.name, a.name, pc.privilege_cod
4582 [ "degrees", "public", "EXECUTE", "monetdb", 0 ] 4582 4559 [ "degrees", "public", "EXECUTE", "monetdb", 0 ] 4559
4583 [ "env", "public", "EXECUTE", NULL, 0 ] 4583 -
4584 [ "epoch", "public", "EXECUTE", "monetdb", 0 ] 4584 4560 [ "epoch", "public", "EXECUTE", "monetdb", 0 ] 4560
..................
#select f.name from sys.systemfunctions
5175 [ "levenshtein" ] 5175 5151 [ "levenshtein" ] 5151
5176 [ "lidarattach" ] 5176 -
5177 [ "lidarexport" ] 5177 -
5178 [ "lidarload" ] 5178 -
5179 [ "like" ] 5179 5152 [ "like" ] 5152
..................
#select f.name from sys.systemfunctions
6055 [ "settimeout" ] 6055 6028 [ "settimeout" ] 6028
6056 [ "shpattach" ] 6056 -
6057 [ "shpload" ] 6057 -
6058 [ "shpload" ] 6058 -
6059 [ "shrink" ] 6059 6029 [ "shrink" ] 6029
..................
# .t, .g, .L4, .L6, .L10,
6630 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 6630 6600 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 6600
6631 [ "_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();" ] 6631 ! 6601 [ 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();" ] 6601
6632 [ "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();" ] 6632 6602 [ "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();" ] 6602