Test check.SQL.py (id 17b2ceb6cb52) (err)
check.stable.out.int128.FILTERED 2019-02-11 20:39:33.153607831 +0100check.test.out.FILTERED 2019-02-11 20:39:33.400609118 +0100
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 5325 lines, 210617 words, 1373273 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5301 lines, 209944 words, 1368848 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5325 lines, 210617 words, 1373273 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5301 lines, 209944 words, 1368848 chars in lines not matching '^$|^(\| |)#` 3
4 # 5406 lines, 213056 words, 1390431 chars in all lines 4 ! 4 # 5382 lines, 212381 words, 1386054 chars in all lines 4
5 5 5 5
..................
# 10:17:18 >
194 \dSf sys."left_shift_assign" 194 194 \dSf sys."left_shift_assign" 194
195 \dSf sys."lidarattach" 195 -
196 \dSf sys."lidarexport" 196 -
197 \dSf sys."lidarload" 197 -
198 \dSf sys."like" 198 195 \dSf sys."like" 195
..................
# 10:17:18 >
247 \dSf sys."settimeout" 247 244 \dSf sys."settimeout" 244
248 \dSf sys."shpattach" 248 -
249 \dSf sys."shpload" 249 -
250 \dSf sys."shrink" 250 245 \dSf sys."shrink" 245
..................
# 10:17:18 >
575 SYSTEM FUNCTION sys.levenshtein 575 570 SYSTEM FUNCTION sys.levenshtein 570
576 SYSTEM PROCEDURE sys.lidarattach 576 -
577 SYSTEM PROCEDURE sys.lidarexport 577 -
578 SYSTEM PROCEDURE sys.lidarload 578 -
579 SYSTEM FILTER FUNCTION sys.like 579 571 SYSTEM FILTER FUNCTION sys.like 571
..................
# 10:17:18 >
693 SYSTEM PROCEDURE sys.settimeout 693 685 SYSTEM PROCEDURE sys.settimeout 685
694 SYSTEM PROCEDURE sys.shpattach 694 -
695 SYSTEM PROCEDURE sys.shpload 695 -
696 SYSTEM PROCEDURE sys.shrink 696 686 SYSTEM PROCEDURE sys.shrink 686
..................
# 10:17:18 >
981 create procedure sys.flush_log () external name sql."flush_log"; 981 971 create procedure sys.flush_log () external name sql."flush_log"; 971
+ 972 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 972
982 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 982 ! 973 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 973
983 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 983 974 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 974
984 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 984 ! 975 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 975
985 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 985 ! 976 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 976
986 create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; 986 ! 977 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 977
987 create function sys.generate_series(first bigint, "limit" bigint, stepsize bigint) returns table (value bigint) external name generator.series; 987 ! 978 create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series; 978
988 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; 988 ! 979 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; 979
989 create function sys.generate_series(first double, "limit" double, stepsize double) returns table (value double) external name generator.series; 989 ! 980 create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series; 980
990 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 990 981 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 981
991 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 991 982 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 982
992 create function sys.generate_series(first int, "limit" int) returns table (value int) external name generator.series; 992 ! 983 create function sys.generate_series(first int, last int) returns table (value int) external name generator.series; 983
993 create function sys.generate_series(first int, "limit" int, stepsize int) returns table (value int) external name generator.series; 993 ! 984 create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series; 984
994 create function sys.generate_series(first real, "limit" real, stepsize real) returns table (value real) external name generator.series; 994 ! 985 create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series; 985
995 create function sys.generate_series(first smallint, "limit" smallint) returns table (value smallint) external name generator.series; 995 ! 986 create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series; 986
996 create function sys.generate_series(first smallint, "limit" smallint, stepsize smallint) returns table (value smallint) external name generator.series; 996 ! 987 create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series; 987
997 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 997 ! 988 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 988
998 create function sys.generate_series(first tinyint, "limit" tinyint) returns table (value tinyint) external name generator.series; 998 ! 989 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 989
999 create function sys.generate_series(first tinyint, "limit" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 999 -
1000 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1000 990 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 990
..................
# 10:17:18 >
1031 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1031 1021 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1021
1032 create procedure lidarattach(fname string) external name lidar.attach; 1032 ! 1022 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1022
1033 create procedure lidarexport(tname string, fname string, format string) external name lidar.export; 1033 -
1034 create procedure lidarload(tname string) external name lidar.load; 1034 -
1035 create filter function "like"(val string, pat string) external name algebra."like"; 1035 1023 create filter function "like"(val string, pat string) external name algebra."like"; 1023
1036 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1036 -
1037 create procedure listdir(dirname string) external name fits.listdir; 1037 1024 create procedure listdir(dirname string) external name fits.listdir; 1024
..................
# 10:17:18 >
1071 create function sys.password_hash (username string) returns string external name sql.password; 1071 1058 create function sys.password_hash (username string) returns string external name sql.password; 1058
+ 1059 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1059
1072 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1072 1060 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1060
1073 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1073 -
1074 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1074 1061 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1061
..................
# 10:17:18 >
1118 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1118 1105 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1105
1119 create procedure shpattach(fname string) external name shp.attach; 1119 -
1120 create procedure shpload(fid integer) external name shp.import; 1120 -
1121 create procedure shpload(fid integer, filter geometry) external name shp.import; 1121 -
1122 create procedure shrink(sys string, tab string) external name sql.shrink; 1122 1106 create procedure shrink(sys string, tab string) external name sql.shrink; 1106
..................
# 10:17:18 >
1251 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1251 1235 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1235
+ 1236 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1236
1252 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1252 1237 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1237
..................
# 10:17:18 >
1260 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1260 1245 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1245
1261 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1261 -
1262 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1262 1246 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1246
..................
# .s, .f, .L4, .L6, .f,
2368 [ "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 ] 2368 2352 [ "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 ] 2352
2369 [ "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 ] 2369 ! 2353 [ "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 ] 2353
2370 [ "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 ] 2370 ! 2354 [ "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 ] 2354
2371 [ "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 ] 2371 ! 2355 [ "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 ] 2355
2372 [ "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 ] 2372 ! 2356 [ "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 ] 2356
2373 [ "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 ] 2373 2357 [ "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 ] 2357
2374 [ "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 ] 2374 2358 [ "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 ] 2358
2375 [ "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 ] 2375 ! 2359 [ "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 ] 2359
2376 [ "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 ] 2376 ! 2360 [ "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 ] 2360
2377 [ "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 ] 2377 ! 2361 [ "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 ] 2361
2378 [ "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 ] 2378 ! 2362 [ "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 ] 2362
2379 [ "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 ] 2379 ! 2363 [ "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 ] 2363
2380 [ "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 ] 2380 ! 2364 [ "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 ] 2364
2381 [ "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 ] 2381 ! 2365 [ "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 ] 2365
2382 [ "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 ] 2382 ! 2366 [ "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 ] 2366
2383 [ "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 ] 2383 2367 [ "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 ] 2367
..................
# .s, .f, .L4, .L6, .f,
2491 [ "sys", "levenshtein", "SYSTEM", "levenshtein", "txtsim", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "varchar", 0, 0, "in", "arg_2", "varchar", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2491 2475 [ "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 ] 2475
2492 [ "sys", "lidarattach", "SYSTEM", "create procedure lidarattach(fname string) external name lidar.attach;", "lidar", "MAL", "Procedure", true, false, false, "fname", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2492 -
2493 [ "sys", "lidarexport", "SYSTEM", "create procedure lidarexport(tname string, fname string, format string) external name lidar.export;", "lidar", "MAL", "Procedure", true, false, false, "tname", "clob", 0, 0, "in", "fname", "clob", 0, 0, "in", "format", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2493 -
2494 [ "sys", "lidarload", "SYSTEM", "create procedure lidarload(tname string) external name lidar.load;", "lidar", "MAL", "Procedure", true, false, false, "tname", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2494 -
2495 [ "sys", "like", "SYSTEM", "create filter function \"like\"(val string, pat string) external name algebra.\"like\";", "algebra", "MAL", "Filter function", false, false, false, "val", "clob", 0, 0, "in", "pat", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2495 2476 [ "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 ] 2476
..................
# .s, .f, .L4, .L6, .f,
3395 [ "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 ] 3395 3376 [ "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 ] 3376
3396 [ "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 ] 3396 -
3397 [ "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 ] 3397 -
3398 [ "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 ] 3398 -
3399 [ "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 ] 3399 3377 [ "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 ] 3377
..................
#select s1.name, f1.name, s2.name, f2.na
4045 % 3, 17, 3, 13, 8 # length 4045 4023 % 3, 17, 3, 13, 8 # length 4023
+ 4024 [ "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 4024
4046 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4046 4025 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4025
..................
#select s1.name, t.name, c.name, s2.name
4068 % 3, 17, 13, 3, 16, 9 # length 4068 4047 % 3, 17, 13, 3, 16, 9 # length 4047
4069 [ "sys", "spatial_ref_sys", "auth_name", "sys", "getproj4", "FUNCTION" ] 4069 -
4070 [ "sys", "spatial_ref_sys", "auth_srid", "sys", "getproj4", "FUNCTION" ] 4070 -
4071 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 4071 4048 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 4048
4072 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 4072 4049 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 4049
4073 [ "sys", "spatial_ref_sys", "srtext", "sys", "getproj4", "FUNCTION" ] 4073 -
4074 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 4074 4050 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 4050
..................
#select s1.name, f1.name, s2.name, t2.na
4103 % varchar, varchar, varchar, varchar, varchar # type 4103 4079 % varchar, varchar, varchar, varchar, varchar # type 4079
4104 % 3, 11, 3, 17, 4 # length 4104 ! 4080 % 3, 16, 3, 17, 4 # length 4080
4105 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 4105 4081 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 4081
..................
#select s1.name, f1.name, s2.name, t2.na
4107 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 4107 4083 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 4083
+ 4084 [ "sys", "optimizers", "sys", "optimizers", "VIEW" ] 4084
+ 4085 [ "sys", "querylog_catalog", "sys", "querylog_catalog", "VIEW" ] 4085
+ 4086 [ "sys", "queue", "sys", "queue", "VIEW" ] 4086
+ 4087 [ "sys", "rejects", "sys", "rejects", "VIEW" ] 4087
+ 4088 [ "sys", "sessions", "sys", "sessions", "VIEW" ] 4088
4108 [ "sys", "columnsize", "sys", "storagemodel", "VIEW" ] 4108 4089 [ "sys", "columnsize", "sys", "storagemodel", "VIEW" ] 4089
..................
#select s1.name, f1.name, s2.name, t2.na
4115 [ "sys", "imprintsize", "sys", "tablestoragemodel", "VIEW" ] 4115 4096 [ "sys", "imprintsize", "sys", "tablestoragemodel", "VIEW" ] 4096
+ 4097 [ "sys", "tracelog", "sys", "tracelog", "VIEW" ] 4097
4116 #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; 4116 4098 #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; 4098
..................
#select s1.name, t1.name, s2.name, t2.na
4131 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 4131 4113 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 4113
4132 [ "sys", "idxs", "sys", "dependency_columns_on_indexes", "VIEW" ] 4132 -
4133 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 4133 4114 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 4114
4134 [ "sys", "objects", "sys", "dependency_columns_on_indexes", "VIEW" ] 4134 -
4135 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 4135 4115 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 4115
4136 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 4136 4116 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 4116
4137 [ "sys", "keys", "sys", "dependency_columns_on_keys", "VIEW" ] 4137 -
4138 [ "sys", "objects", "sys", "dependency_columns_on_keys", "VIEW" ] 4138 -
4139 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 4139 4117 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 4117
..................
#select s1.name, t1.name, s2.name, t2.na
4145 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 4145 4123 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 4123
4146 [ "sys", "triggers", "sys", "dependency_columns_on_triggers", "VIEW" ] 4146 -
4147 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 4147 4124 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 4124
..................
#select s1.name, t1.name, s2.name, t2.na
4159 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 4159 4136 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 4136
4160 [ "sys", "triggers", "sys", "dependency_functions_on_triggers", "VIEW" ] 4160 -
4161 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 4161 4137 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 4137
..................
#select s1.name, t1.name, s2.name, t2.na
4166 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 4166 4142 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 4142
4167 [ "sys", "keys", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4167 -
4168 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 4168 4143 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 4143
..................
#select s1.name, t1.name, s2.name, t2.na
4171 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 4171 4146 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 4146
4172 [ "sys", "keys", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4172 -
4173 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4173 4147 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4147
..................
#select s1.name, t1.name, s2.name, t2.na
4176 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 4176 4150 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 4150
4177 [ "sys", "idxs", "sys", "dependency_tables_on_indexes", "VIEW" ] 4177 -
4178 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 4178 4151 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 4151
..................
#select s1.name, t1.name, s2.name, t2.na
4184 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4184 4157 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4157
4185 [ "sys", "triggers", "sys", "dependency_tables_on_triggers", "VIEW" ] 4185 -
4186 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4186 4158 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4158
..................
#select s1.name, t1.name, s2.name, t2.na
4199 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4199 4171 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4171
4200 [ "sys", "_columns", "sys", "ids", "VIEW" ] 4200 -
4201 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4201 4172 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4172
..................
#select s1.name, t1.name, s2.name, t2.na
4204 [ "sys", "functions", "sys", "ids", "VIEW" ] 4204 4175 [ "sys", "functions", "sys", "ids", "VIEW" ] 4175
4205 [ "sys", "idxs", "sys", "ids", "VIEW" ] 4205 -
4206 [ "sys", "keys", "sys", "ids", "VIEW" ] 4206 4176 [ "sys", "keys", "sys", "ids", "VIEW" ] 4176
..................
#select s1.name, t1.name, s2.name, t2.na
4208 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4208 4178 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4178
4209 [ "sys", "triggers", "sys", "ids", "VIEW" ] 4209 -
4210 [ "sys", "types", "sys", "ids", "VIEW" ] 4210 4179 [ "sys", "types", "sys", "ids", "VIEW" ] 4179
4211 [ "tmp", "_columns", "sys", "ids", "VIEW" ] 4211 -
4212 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4212 4180 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4180
4213 [ "tmp", "idxs", "sys", "ids", "VIEW" ] 4213 -
4214 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4214 4181 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4181
4215 [ "tmp", "triggers", "sys", "ids", "VIEW" ] 4215 -
4216 [ "sys", "auths", "sys", "roles", "VIEW" ] 4216 4182 [ "sys", "auths", "sys", "roles", "VIEW" ] 4182
..................
#select s1.name, t1.name, c1.name, s2.na
4250 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4250 4216 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4216
4251 [ "sys", "idxs", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4251 ! 4217 [ "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4217
4252 [ "sys", "idxs", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4252 ! 4218 [ "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4218
4253 [ "sys", "idxs", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4253 ! 4219 [ "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4219
4254 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4254 ! 4220 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4220
4255 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4255 ! 4221 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4221
+ 4222 [ "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4222
4256 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4256 4223 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4223
4257 [ "sys", "objects", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4257 ! 4224 [ "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4224
4258 [ "sys", "objects", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4258 ! 4225 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4225
4259 [ "sys", "objects", "nr", "sys", "dependency_columns_on_indexes", "VIEW" ] 4259 ! 4226 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4226
4260 [ "sys", "keys", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4260 ! 4227 [ "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4227
4261 [ "sys", "keys", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4261 ! 4228 [ "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4228
4262 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4262 ! 4229 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4229
4263 [ "sys", "keys", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4263 ! 4230 [ "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4230
4264 [ "sys", "objects", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4264 ! 4231 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4231
4265 [ "sys", "objects", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4265 ! 4232 [ "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4232
4266 [ "sys", "objects", "nr", "sys", "dependency_columns_on_keys", "VIEW" ] 4266 ! 4233 [ "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4233
+ 4234 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4234
+ 4235 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4235
+ 4236 [ "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4236
4267 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4267 4237 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4237
..................
#select s1.name, t1.name, c1.name, s2.na
4275 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4275 4245 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4245
4276 [ "sys", "triggers", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4276 ! 4246 [ "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4246
4277 [ "sys", "triggers", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4277 ! 4247 [ "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4247
+ 4248 [ "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4248
4278 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4278 4249 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4249
..................
#select s1.name, t1.name, c1.name, s2.na
4306 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4306 4277 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4277
4307 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4307 ! 4278 [ "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4278
4308 [ "sys", "triggers", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4308 ! 4279 [ "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4279
4309 [ "sys", "triggers", "table_id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4309 ! 4280 [ "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4280
+ 4281 [ "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4281
4310 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4310 4282 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4282
..................
#select s1.name, t1.name, c1.name, s2.na
4323 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4323 4295 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4295
4324 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4324 ! 4296 [ "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4296
4325 [ "sys", "keys", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4325 ! 4297 [ "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4297
4326 [ "sys", "keys", "rkey", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4326 ! 4298 [ "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4298
4327 [ "sys", "keys", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4327 ! 4299 [ "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4299
4328 [ "sys", "keys", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4328 ! 4300 [ "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4300
+ 4301 [ "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4301
4329 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4329 4302 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4302
..................
#select s1.name, t1.name, c1.name, s2.na
4335 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4335 4308 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4308
4336 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4336 ! 4309 [ "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4309
4337 [ "sys", "keys", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4337 ! 4310 [ "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4310
4338 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4338 ! 4311 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4311
4339 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4339 ! 4312 [ "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4312
4340 [ "sys", "keys", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4340 ! 4313 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4313
+ 4314 [ "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4314
4341 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4341 4315 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4315
..................
#select s1.name, t1.name, c1.name, s2.na
4346 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4346 4320 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4320
4347 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4347 ! 4321 [ "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4321
4348 [ "sys", "idxs", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4348 ! 4322 [ "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4322
4349 [ "sys", "idxs", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4349 ! 4323 [ "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4323
4350 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4350 ! 4324 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4324
4351 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4351 ! 4325 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4325
+ 4326 [ "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4326
4352 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4352 4327 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4327
..................
#select s1.name, t1.name, c1.name, s2.na
4361 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4361 4336 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4336
4362 [ "sys", "triggers", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4362 ! 4337 [ "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4337
4363 [ "sys", "triggers", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4363 ! 4338 [ "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4338
4364 [ "sys", "triggers", "table_id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4364 ! 4339 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4339
+ 4340 [ "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4340
4365 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4365 4341 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4341
..................
#select s1.name, t1.name, c1.name, s2.na
4386 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4386 4362 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4362
+ 4363 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4363
4387 [ "sys", "_columns", "id", "sys", "ids", "VIEW" ] 4387 ! 4364 [ "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4364
4388 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4388 ! 4365 [ "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4365
4389 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4389 4366 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4366
+ 4367 [ "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4367
4390 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4390 -
4391 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4391 -
4392 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4392 ! 4368 [ "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4368
+ 4369 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4369
+ 4370 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4370
4393 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4393 ! 4371 [ "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4371
4394 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4394 4372 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4372
..................
#select s1.name, t1.name, c1.name, s2.na
4402 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4402 4380 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4380
4403 [ "sys", "idxs", "id", "sys", "ids", "VIEW" ] 4403 ! 4381 [ "sys", "keys", "action", "sys", "ids", "VIEW" ] 4381
+ 4382 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4382
4404 [ "sys", "idxs", "name", "sys", "ids", "VIEW" ] 4404 ! 4383 [ "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4383
+ 4384 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4384
4405 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4405 ! 4385 [ "sys", "keys", "type", "sys", "ids", "VIEW" ] 4385
4406 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4406 ! 4386 [ "sys", "objects", "id", "sys", "ids", "VIEW" ] 4386
4407 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4407 -
4408 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4408 -
4409 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4409 4387 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4387
..................
#select s1.name, t1.name, c1.name, s2.na
4413 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4413 4391 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4391
4414 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4414 ! 4392 [ "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4392
4415 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4415 ! 4393 [ "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4393
4416 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4416 ! 4394 [ "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4394
+ 4395 [ "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4395
4417 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4417 4396 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4396
..................
#select s1.name, t1.name, c1.name, s2.na
4419 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4419 4398 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4398
+ 4399 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4399
4420 [ "tmp", "_columns", "id", "sys", "ids", "VIEW" ] 4420 ! 4400 [ "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4400
4421 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4421 -
4422 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4422 -
4423 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4423 -
4424 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4424 -
4425 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4425 ! 4401 [ "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4401
+ 4402 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4402
4426 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4426 ! 4403 [ "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4403
4427 [ "tmp", "idxs", "id", "sys", "ids", "VIEW" ] 4427 ! 4404 [ "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4404
+ 4405 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4405
+ 4406 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4406
4428 [ "tmp", "idxs", "name", "sys", "ids", "VIEW" ] 4428 ! 4407 [ "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4407
4429 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4429 ! 4408 [ "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4408
+ 4409 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4409
4430 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4430 ! 4410 [ "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4410
4431 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4431 -
4432 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4432 4411 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4411
4433 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4433 ! 4412 [ "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4412
4434 [ "tmp", "triggers", "name", "sys", "ids", "VIEW" ] 4434 -
4435 [ "tmp", "triggers", "table_id", "sys", "ids", "VIEW" ] 4435 -
4436 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4436 4413 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4413
..................
#select f.name, a.name, pc.privilege_cod
4800 [ "degrees", "public", "EXECUTE", "monetdb", 0 ] 4800 4777 [ "degrees", "public", "EXECUTE", "monetdb", 0 ] 4777
4801 [ "env", "public", "EXECUTE", NULL, 0 ] 4801 -
4802 [ "epoch", "public", "EXECUTE", "monetdb", 0 ] 4802 4778 [ "epoch", "public", "EXECUTE", "monetdb", 0 ] 4778
..................
# .t, .g, .L4, .L6, .L10,
5094 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5094 5070 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5070
5095 [ "_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();" ] 5095 ! 5071 [ 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();" ] 5071
5096 [ "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();" ] 5096 5072 [ "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();" ] 5072