Test check.SQL.py (id 9f8602e8c51d) (err)
check.stable.out.int128.FILTERED 2018-10-18 00:52:34.979067616 +0200check.test.out.FILTERED 2018-10-18 00:52:35.216074480 +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 5154 lines, 199455 words, 1301695 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5130 lines, 198782 words, 1297253 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5154 lines, 199455 words, 1301695 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5130 lines, 198782 words, 1297253 chars in lines not matching '^$|^(\| |)#` 3
4 # 5235 lines, 201894 words, 1318853 chars in all lines 4 ! 4 # 5211 lines, 201219 words, 1314459 chars in all lines 4
5 5 5 5
..................
# 10:17:18 >
192 \dSf sys."left_shift_assign" 192 192 \dSf sys."left_shift_assign" 192
193 \dSf sys."lidarattach" 193 -
194 \dSf sys."lidarexport" 194 -
195 \dSf sys."lidarload" 195 -
196 \dSf sys."like" 196 193 \dSf sys."like" 193
..................
# 10:17:18 >
245 \dSf sys."settimeout" 245 242 \dSf sys."settimeout" 242
246 \dSf sys."shpattach" 246 -
247 \dSf sys."shpload" 247 -
248 \dSf sys."shrink" 248 243 \dSf sys."shrink" 243
..................
# 10:17:18 >
563 SYSTEM FUNCTION sys.levenshtein 563 558 SYSTEM FUNCTION sys.levenshtein 558
564 SYSTEM PROCEDURE sys.lidarattach 564 -
565 SYSTEM PROCEDURE sys.lidarexport 565 -
566 SYSTEM PROCEDURE sys.lidarload 566 -
567 SYSTEM FILTER FUNCTION sys.like 567 559 SYSTEM FILTER FUNCTION sys.like 559
..................
# 10:17:18 >
673 SYSTEM PROCEDURE sys.settimeout 673 665 SYSTEM PROCEDURE sys.settimeout 665
674 SYSTEM PROCEDURE sys.shpattach 674 -
675 SYSTEM PROCEDURE sys.shpload 675 -
676 SYSTEM PROCEDURE sys.shrink 676 666 SYSTEM PROCEDURE sys.shrink 666
..................
# 10:17:18 >
958 create procedure sys.flush_log () external name sql."flush_log"; 958 948 create procedure sys.flush_log () external name sql."flush_log"; 948
+ 949 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 949
959 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 959 ! 950 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 950
960 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 960 951 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 951
961 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 961 ! 952 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 952
962 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 962 ! 953 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 953
963 create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; 963 ! 954 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 954
964 create function sys.generate_series(first bigint, "limit" bigint, stepsize bigint) returns table (value bigint) external name generator.series; 964 ! 955 create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series; 955
965 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; 965 ! 956 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; 956
966 create function sys.generate_series(first double, "limit" double, stepsize double) returns table (value double) external name generator.series; 966 ! 957 create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series; 957
967 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 967 ! 958 create function sys.generate_series(first hugeint, last hugeint) returns table (value hugeint) external name generator.series; 958
968 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 968 ! 959 create function sys.generate_series(first hugeint, last hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 959
969 create function sys.generate_series(first int, "limit" int) returns table (value int) external name generator.series; 969 ! 960 create function sys.generate_series(first int, last int) returns table (value int) external name generator.series; 960
970 create function sys.generate_series(first int, "limit" int, stepsize int) returns table (value int) external name generator.series; 970 ! 961 create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series; 961
971 create function sys.generate_series(first real, "limit" real, stepsize real) returns table (value real) external name generator.series; 971 ! 962 create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series; 962
972 create function sys.generate_series(first smallint, "limit" smallint) returns table (value smallint) external name generator.series; 972 ! 963 create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series; 963
973 create function sys.generate_series(first smallint, "limit" smallint, stepsize smallint) returns table (value smallint) external name generator.series; 973 ! 964 create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series; 964
974 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 974 ! 965 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 965
975 create function sys.generate_series(first tinyint, "limit" tinyint) returns table (value tinyint) external name generator.series; 975 -
976 create function sys.generate_series(first tinyint, "limit" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 976 ! 966 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 966
977 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 977 967 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 967
..................
# 10:17:18 >
1008 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1008 998 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 998
1009 create procedure lidarattach(fname string) external name lidar.attach; 1009 ! 999 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 999
1010 create procedure lidarexport(tname string, fname string, format string) external name lidar.export; 1010 -
1011 create procedure lidarload(tname string) external name lidar.load; 1011 -
1012 create filter function "like"(val string, pat string) external name algebra."like"; 1012 1000 create filter function "like"(val string, pat string) external name algebra."like"; 1000
1013 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1013 -
1014 create procedure listdir(dirname string) external name fits.listdir; 1014 1001 create procedure listdir(dirname string) external name fits.listdir; 1001
..................
# 10:17:18 >
1048 create function sys.password_hash (username string) returns string external name sql.password; 1048 1035 create function sys.password_hash (username string) returns string external name sql.password; 1035
+ 1036 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1036
1049 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1049 1037 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1037
1050 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1050 -
1051 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1051 1038 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1038
..................
# 10:17:18 >
1095 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1095 1082 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1082
1096 create procedure shpattach(fname string) external name shp.attach; 1096 -
1097 create procedure shpload(fid integer) external name shp.import; 1097 -
1098 create procedure shpload(fid integer, filter geometry) external name shp.import; 1098 -
1099 create procedure shrink(sys string, tab string) external name sql.shrink; 1099 1083 create procedure shrink(sys string, tab string) external name sql.shrink; 1083
..................
# 10:17:18 >
1228 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1228 1212 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1212
+ 1213 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1213
1229 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1229 1214 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1214
..................
# 10:17:18 >
1237 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1237 1222 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1222
1238 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1238 -
1239 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1239 1223 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1223
..................
# .s, .f, .L4, .L6, .f,
2318 [ "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 ] 2318 2302 [ "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 ] 2302
2319 [ "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 ] 2319 ! 2303 [ "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 ] 2303
2320 [ "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 ] 2320 ! 2304 [ "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 ] 2304
2321 [ "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 ] 2321 ! 2305 [ "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 ] 2305
2322 [ "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 ] 2322 ! 2306 [ "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 ] 2306
2323 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first hugeint, \"limit\" hugeint) returns table (value hugeint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "hugeint", 128, 0, "out", "first", "hugeint", 128, 0, "in", "limit", "hugeint", 128, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2323 ! 2307 [ "sys", "generate_series", "SYSTEM", "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 ] 2307
2324 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first hugeint, \"limit\" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "hugeint", 128, 0, "out", "first", "hugeint", 128, 0, "in", "limit", "hugeint", 128, 0, "in", "stepsize", "hugeint", 128, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2324 ! 2308 [ "sys", "generate_series", "SYSTEM", "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 ] 2308
2325 [ "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 ] 2325 ! 2309 [ "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 ] 2309
2326 [ "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 ] 2326 ! 2310 [ "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 ] 2310
2327 [ "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 ] 2327 ! 2311 [ "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 ] 2311
2328 [ "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 ] 2328 ! 2312 [ "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 ] 2312
2329 [ "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 ] 2329 ! 2313 [ "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 ] 2313
2330 [ "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 ] 2330 ! 2314 [ "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 ] 2314
2331 [ "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 ] 2331 ! 2315 [ "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 ] 2315
2332 [ "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 ] 2332 ! 2316 [ "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 ] 2316
2333 [ "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 ] 2333 2317 [ "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 ] 2317
..................
# .s, .f, .L4, .L6, .f,
2415 [ "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 ] 2415 2399 [ "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 ] 2399
2416 [ "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 ] 2416 -
2417 [ "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 ] 2417 -
2418 [ "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 ] 2418 -
2419 [ "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 ] 2419 2400 [ "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 ] 2400
..................
# .s, .f, .L4, .L6, .f,
3287 [ "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 ] 3287 3268 [ "sys", "settimeout", "SYSTEM", "create procedure sys.settimeout(\"query\" bigint, \"session\" bigint) external name clients.settimeout;", "clients", "MAL", "Procedure", true, false, false, "query", "bigint", 64, 0, "in", "session", "bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3268
3288 [ "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 ] 3288 -
3289 [ "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 ] 3289 -
3290 [ "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 ] 3290 -
3291 [ "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 ] 3291 3269 [ "sys", "shrink", "SYSTEM", "create procedure shrink(sys string, tab string) external name sql.shrink;", "sql", "MAL", "Procedure", true, false, false, "sys", "clob", 0, 0, "in", "tab", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3269
..................
#select s1.name, f1.name, s2.name, f2.na
3896 % 3, 17, 3, 13, 8 # length 3896 3874 % 3, 17, 3, 13, 8 # length 3874
+ 3875 [ "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3875
3897 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3897 3876 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3876
..................
#select s1.name, t.name, c.name, s2.name
3922 % 3, 17, 13, 3, 16, 9 # length 3922 3901 % 3, 17, 13, 3, 16, 9 # length 3901
3923 [ "sys", "spatial_ref_sys", "auth_name", "sys", "getproj4", "FUNCTION" ] 3923 -
3924 [ "sys", "spatial_ref_sys", "auth_srid", "sys", "getproj4", "FUNCTION" ] 3924 -
3925 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 3925 3902 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 3902
3926 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 3926 3903 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 3903
3927 [ "sys", "spatial_ref_sys", "srtext", "sys", "getproj4", "FUNCTION" ] 3927 -
3928 [ "sys", "storagemodelinput", "atomwidth", "sys", "storagemodel", "FUNCTION" ] 3928 3904 [ "sys", "storagemodelinput", "atomwidth", "sys", "storagemodel", "FUNCTION" ] 3904
..................
#select s1.name, f1.name, s2.name, t2.na
3971 % varchar, varchar, varchar, varchar, varchar # type 3971 3947 % varchar, varchar, varchar, varchar, varchar # type 3947
3972 % 3, 8, 3, 16, 4 # length 3972 ! 3948 % 3, 16, 3, 16, 4 # length 3948
3973 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 3973 3949 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 3949
..................
#select s1.name, f1.name, s2.name, t2.na
3975 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 3975 3951 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 3951
+ 3952 [ "sys", "optimizers", "sys", "optimizers", "VIEW" ] 3952
+ 3953 [ "sys", "querylog_catalog", "sys", "querylog_catalog", "VIEW" ] 3953
+ 3954 [ "sys", "queue", "sys", "queue", "VIEW" ] 3954
+ 3955 [ "sys", "rejects", "sys", "rejects", "VIEW" ] 3955
+ 3956 [ "sys", "sessions", "sys", "sessions", "VIEW" ] 3956
+ 3957 [ "sys", "tracelog", "sys", "tracelog", "VIEW" ] 3957
3976 #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; 3976 3958 #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; 3958
..................
#select s1.name, t1.name, s2.name, t2.na
3991 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 3991 3973 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 3973
3992 [ "sys", "idxs", "sys", "dependency_columns_on_indexes", "VIEW" ] 3992 -
3993 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 3993 3974 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 3974
3994 [ "sys", "objects", "sys", "dependency_columns_on_indexes", "VIEW" ] 3994 -
3995 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 3995 3975 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 3975
3996 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 3996 3976 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 3976
3997 [ "sys", "keys", "sys", "dependency_columns_on_keys", "VIEW" ] 3997 -
3998 [ "sys", "objects", "sys", "dependency_columns_on_keys", "VIEW" ] 3998 -
3999 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 3999 3977 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 3977
..................
#select s1.name, t1.name, s2.name, t2.na
4005 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 4005 3983 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 3983
4006 [ "sys", "triggers", "sys", "dependency_columns_on_triggers", "VIEW" ] 4006 -
4007 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 4007 3984 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 3984
..................
#select s1.name, t1.name, s2.name, t2.na
4019 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 4019 3996 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 3996
4020 [ "sys", "triggers", "sys", "dependency_functions_on_triggers", "VIEW" ] 4020 -
4021 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 4021 3997 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 3997
..................
#select s1.name, t1.name, s2.name, t2.na
4026 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 4026 4002 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 4002
4027 [ "sys", "keys", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4027 -
4028 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 4028 4003 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 4003
..................
#select s1.name, t1.name, s2.name, t2.na
4031 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 4031 4006 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 4006
4032 [ "sys", "keys", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4032 -
4033 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4033 4007 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4007
..................
#select s1.name, t1.name, s2.name, t2.na
4036 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 4036 4010 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 4010
4037 [ "sys", "idxs", "sys", "dependency_tables_on_indexes", "VIEW" ] 4037 -
4038 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 4038 4011 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 4011
..................
#select s1.name, t1.name, s2.name, t2.na
4044 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4044 4017 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4017
4045 [ "sys", "triggers", "sys", "dependency_tables_on_triggers", "VIEW" ] 4045 -
4046 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4046 4018 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4018
..................
#select s1.name, t1.name, s2.name, t2.na
4059 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4059 4031 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4031
4060 [ "sys", "_columns", "sys", "ids", "VIEW" ] 4060 -
4061 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4061 4032 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4032
..................
#select s1.name, t1.name, s2.name, t2.na
4064 [ "sys", "functions", "sys", "ids", "VIEW" ] 4064 4035 [ "sys", "functions", "sys", "ids", "VIEW" ] 4035
4065 [ "sys", "idxs", "sys", "ids", "VIEW" ] 4065 -
4066 [ "sys", "keys", "sys", "ids", "VIEW" ] 4066 4036 [ "sys", "keys", "sys", "ids", "VIEW" ] 4036
..................
#select s1.name, t1.name, s2.name, t2.na
4068 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4068 4038 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4038
4069 [ "sys", "triggers", "sys", "ids", "VIEW" ] 4069 -
4070 [ "sys", "types", "sys", "ids", "VIEW" ] 4070 4039 [ "sys", "types", "sys", "ids", "VIEW" ] 4039
4071 [ "tmp", "_columns", "sys", "ids", "VIEW" ] 4071 -
4072 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4072 4040 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4040
4073 [ "tmp", "idxs", "sys", "ids", "VIEW" ] 4073 -
4074 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4074 4041 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4041
4075 [ "tmp", "triggers", "sys", "ids", "VIEW" ] 4075 -
4076 [ "sys", "auths", "sys", "roles", "VIEW" ] 4076 4042 [ "sys", "auths", "sys", "roles", "VIEW" ] 4042
..................
#select s1.name, t1.name, c1.name, s2.na
4104 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4104 4070 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4070
4105 [ "sys", "idxs", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4105 ! 4071 [ "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4071
4106 [ "sys", "idxs", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4106 ! 4072 [ "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4072
4107 [ "sys", "idxs", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4107 ! 4073 [ "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4073
4108 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4108 ! 4074 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4074
4109 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4109 ! 4075 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4075
+ 4076 [ "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4076
4110 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4110 4077 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4077
4111 [ "sys", "objects", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4111 ! 4078 [ "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4078
4112 [ "sys", "objects", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4112 ! 4079 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4079
4113 [ "sys", "objects", "nr", "sys", "dependency_columns_on_indexes", "VIEW" ] 4113 ! 4080 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4080
4114 [ "sys", "keys", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4114 ! 4081 [ "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4081
4115 [ "sys", "keys", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4115 ! 4082 [ "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4082
4116 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4116 ! 4083 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4083
4117 [ "sys", "keys", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4117 ! 4084 [ "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4084
4118 [ "sys", "objects", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4118 ! 4085 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4085
4119 [ "sys", "objects", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4119 ! 4086 [ "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4086
4120 [ "sys", "objects", "nr", "sys", "dependency_columns_on_keys", "VIEW" ] 4120 ! 4087 [ "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4087
+ 4088 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4088
+ 4089 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4089
+ 4090 [ "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4090
4121 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4121 4091 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4091
..................
#select s1.name, t1.name, c1.name, s2.na
4129 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4129 4099 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4099
4130 [ "sys", "triggers", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4130 ! 4100 [ "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4100
4131 [ "sys", "triggers", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4131 ! 4101 [ "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4101
+ 4102 [ "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4102
4132 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4132 4103 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4103
..................
#select s1.name, t1.name, c1.name, s2.na
4160 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4160 4131 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4131
4161 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4161 ! 4132 [ "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4132
4162 [ "sys", "triggers", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4162 ! 4133 [ "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4133
4163 [ "sys", "triggers", "table_id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4163 ! 4134 [ "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4134
+ 4135 [ "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4135
4164 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4164 4136 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4136
..................
#select s1.name, t1.name, c1.name, s2.na
4177 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4177 4149 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4149
4178 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4178 ! 4150 [ "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4150
4179 [ "sys", "keys", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4179 ! 4151 [ "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4151
4180 [ "sys", "keys", "rkey", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4180 ! 4152 [ "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4152
4181 [ "sys", "keys", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4181 ! 4153 [ "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4153
4182 [ "sys", "keys", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4182 ! 4154 [ "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4154
+ 4155 [ "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4155
4183 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4183 4156 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4156
..................
#select s1.name, t1.name, c1.name, s2.na
4189 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4189 4162 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4162
4190 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4190 ! 4163 [ "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4163
4191 [ "sys", "keys", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4191 ! 4164 [ "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4164
4192 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4192 ! 4165 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4165
4193 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4193 ! 4166 [ "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4166
4194 [ "sys", "keys", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4194 ! 4167 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4167
+ 4168 [ "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4168
4195 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4195 4169 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4169
..................
#select s1.name, t1.name, c1.name, s2.na
4200 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4200 4174 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4174
4201 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4201 ! 4175 [ "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4175
4202 [ "sys", "idxs", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4202 ! 4176 [ "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4176
4203 [ "sys", "idxs", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4203 ! 4177 [ "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4177
4204 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4204 ! 4178 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4178
4205 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4205 ! 4179 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4179
+ 4180 [ "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4180
4206 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4206 4181 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4181
..................
#select s1.name, t1.name, c1.name, s2.na
4215 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4215 4190 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4190
4216 [ "sys", "triggers", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4216 ! 4191 [ "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4191
4217 [ "sys", "triggers", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4217 ! 4192 [ "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4192
4218 [ "sys", "triggers", "table_id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4218 ! 4193 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4193
+ 4194 [ "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4194
4219 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4219 4195 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4195
..................
#select s1.name, t1.name, c1.name, s2.na
4240 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4240 4216 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4216
+ 4217 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4217
4241 [ "sys", "_columns", "id", "sys", "ids", "VIEW" ] 4241 ! 4218 [ "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4218
4242 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4242 ! 4219 [ "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4219
4243 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4243 4220 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4220
+ 4221 [ "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4221
4244 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4244 -
4245 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4245 -
4246 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4246 ! 4222 [ "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4222
+ 4223 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4223
+ 4224 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4224
4247 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4247 ! 4225 [ "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4225
4248 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4248 4226 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4226
..................
#select s1.name, t1.name, c1.name, s2.na
4256 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4256 4234 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4234
4257 [ "sys", "idxs", "id", "sys", "ids", "VIEW" ] 4257 ! 4235 [ "sys", "keys", "action", "sys", "ids", "VIEW" ] 4235
+ 4236 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4236
4258 [ "sys", "idxs", "name", "sys", "ids", "VIEW" ] 4258 ! 4237 [ "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4237
+ 4238 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4238
4259 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4259 ! 4239 [ "sys", "keys", "type", "sys", "ids", "VIEW" ] 4239
4260 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4260 ! 4240 [ "sys", "objects", "id", "sys", "ids", "VIEW" ] 4240
4261 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4261 -
4262 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4262 -
4263 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4263 4241 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4241
..................
#select s1.name, t1.name, c1.name, s2.na
4267 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4267 4245 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4245
4268 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4268 ! 4246 [ "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4246
4269 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4269 ! 4247 [ "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4247
4270 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4270 ! 4248 [ "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4248
+ 4249 [ "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4249
4271 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4271 4250 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4250
..................
#select s1.name, t1.name, c1.name, s2.na
4273 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4273 4252 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4252
+ 4253 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4253
4274 [ "tmp", "_columns", "id", "sys", "ids", "VIEW" ] 4274 ! 4254 [ "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4254
4275 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4275 -
4276 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4276 -
4277 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4277 -
4278 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4278 -
4279 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4279 ! 4255 [ "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4255
+ 4256 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4256
4280 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4280 ! 4257 [ "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4257
4281 [ "tmp", "idxs", "id", "sys", "ids", "VIEW" ] 4281 ! 4258 [ "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4258
+ 4259 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4259
+ 4260 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4260
4282 [ "tmp", "idxs", "name", "sys", "ids", "VIEW" ] 4282 ! 4261 [ "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4261
4283 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4283 ! 4262 [ "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4262
+ 4263 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4263
4284 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4284 ! 4264 [ "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4264
4285 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4285 -
4286 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4286 4265 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4265
4287 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4287 ! 4266 [ "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4266
4288 [ "tmp", "triggers", "name", "sys", "ids", "VIEW" ] 4288 -
4289 [ "tmp", "triggers", "table_id", "sys", "ids", "VIEW" ] 4289 -
4290 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4290 4267 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4267
..................
#select f.name, a.name, pc.privilege_cod
4631 [ "degrees", "public", "EXECUTE", "monetdb", 0 ] 4631 4608 [ "degrees", "public", "EXECUTE", "monetdb", 0 ] 4608
4632 [ "env", "public", "EXECUTE", NULL, 0 ] 4632 -
4633 [ "epoch", "public", "EXECUTE", "monetdb", 0 ] 4633 4609 [ "epoch", "public", "EXECUTE", "monetdb", 0 ] 4609
..................
# .t, .g, .L4, .L6, .L10,
4924 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 4924 4900 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 4900
4925 [ "_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();" ] 4925 ! 4901 [ 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();" ] 4901
4926 [ "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();" ] 4926 4902 [ "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();" ] 4902