Test check.SQL.py (id fe8055a86502) (err)
check.stable.out.int128.FILTERED 2019-09-12 10:32:11.772672107 +0200check.test.out.FILTERED 2019-09-12 10:32:12.023674036 +0200
1 Statistics about stdout of test 'check` in directory 'sql/test/emptydb-upgrade-chain-hge`: 1 1 Statistics about stdout of test 'check` in directory 'sql/test/emptydb-upgrade-chain-hge`: 1
2 5341 lines, 210916 words, 1375789 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 5318 lines, 210250 words, 1371385 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 5341 lines, 210916 words, 1375789 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 5318 lines, 210250 words, 1371385 chars in lines not matching '^$|^(\| |)#` 3
4 # 5422 lines, 213355 words, 1392941 chars in all lines 4 ! 4 # 5399 lines, 212688 words, 1388732 chars in all lines 4
5 5 5 5
..................
# 10:17:18 >
195 \dSf sys."left_shift_assign" 195 195 \dSf sys."left_shift_assign" 195
196 \dSf sys."lidarattach" 196 -
197 \dSf sys."lidarexport" 197 -
198 \dSf sys."lidarload" 198 -
199 \dSf sys."like" 199 196 \dSf sys."like" 196
..................
# 10:17:18 >
249 \dSf sys."settimeout" 249 246 \dSf sys."settimeout" 246
250 \dSf sys."shpattach" 250 -
251 \dSf sys."shpload" 251 -
252 \dSf sys."shrink" 252 247 \dSf sys."shrink" 247
..................
# 10:17:18 >
578 SYSTEM FUNCTION sys.levenshtein 578 573 SYSTEM FUNCTION sys.levenshtein 573
579 SYSTEM PROCEDURE sys.lidarattach 579 -
580 SYSTEM PROCEDURE sys.lidarexport 580 -
581 SYSTEM PROCEDURE sys.lidarload 581 -
582 SYSTEM FILTER FUNCTION sys.like 582 574 SYSTEM FILTER FUNCTION sys.like 574
..................
# 10:17:18 >
697 SYSTEM PROCEDURE sys.settimeout 697 689 SYSTEM PROCEDURE sys.settimeout 689
698 SYSTEM PROCEDURE sys.shpattach 698 -
699 SYSTEM PROCEDURE sys.shpload 699 -
700 SYSTEM PROCEDURE sys.shrink 700 690 SYSTEM PROCEDURE sys.shrink 690
..................
# 10:17:18 >
987 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 987 977 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 977
988 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 988 -
989 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 989 -
990 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 990 978 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 978
991 create function sys.generate_series(first bigint, "limit" bigint) returns table (value bigint) external name generator.series; 991 ! 979 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 979
992 create function sys.generate_series(first bigint, "limit" bigint, stepsize bigint) returns table (value bigint) external name generator.series; 992 ! 980 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 980
993 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; 993 ! 981 create function sys.generate_series(first hugeint, last hugeint) returns table (value hugeint) external name generator.series; 981
994 create function sys.generate_series(first double, "limit" double, stepsize double) returns table (value double) external name generator.series; 994 ! 982 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 982
995 create function sys.generate_series(first hugeint, "limit" hugeint) returns table (value hugeint) external name generator.series; 995 ! 983 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 983
996 create function sys.generate_series(first hugeint, "limit" hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 996 ! 984 create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series; 984
997 create function sys.generate_series(first int, "limit" int) returns table (value int) external name generator.series; 997 ! 985 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; 985
998 create function sys.generate_series(first int, "limit" int, stepsize int) returns table (value int) external name generator.series; 998 ! 986 create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series; 986
999 create function sys.generate_series(first real, "limit" real, stepsize real) returns table (value real) external name generator.series; 999 ! 987 create function sys.generate_series(first hugeint, last hugeint, stepsize hugeint) returns table (value hugeint) external name generator.series; 987
1000 create function sys.generate_series(first smallint, "limit" smallint) returns table (value smallint) external name generator.series; 1000 ! 988 create function sys.generate_series(first int, last int) returns table (value int) external name generator.series; 988
1001 create function sys.generate_series(first smallint, "limit" smallint, stepsize smallint) returns table (value smallint) external name generator.series; 1001 ! 989 create function sys.generate_series(first int, last int, stepsize int) returns table (value int) external name generator.series; 989
1002 create function sys.generate_series(first timestamp, "limit" timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1002 ! 990 create function sys.generate_series(first real, last real, stepsize real) returns table (value real) external name generator.series; 990
1003 create function sys.generate_series(first tinyint, "limit" tinyint) returns table (value tinyint) external name generator.series; 1003 ! 991 create function sys.generate_series(first smallint, last smallint) returns table (value smallint) external name generator.series; 991
1004 create function sys.generate_series(first tinyint, "limit" tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1004 ! 992 create function sys.generate_series(first smallint, last smallint, stepsize smallint) returns table (value smallint) external name generator.series; 992
+ 993 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 993
+ 994 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 994
1005 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 1005 995 create function geometrytype(geom geometry) returns string external name geom."GeometryType1"; 995
..................
# 10:17:18 >
1036 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1036 1026 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1026
1037 create procedure lidarattach(fname string) external name lidar.attach; 1037 ! 1027 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1027
1038 create procedure lidarexport(tname string, fname string, format string) external name lidar.export; 1038 -
1039 create procedure lidarload(tname string) external name lidar.load; 1039 -
1040 create filter function "like"(val string, pat string) external name algebra."like"; 1040 1028 create filter function "like"(val string, pat string) external name algebra."like"; 1028
1041 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1041 -
1042 create procedure listdir(dirname string) external name fits.listdir; 1042 1029 create procedure listdir(dirname string) external name fits.listdir; 1029
..................
# 10:17:18 >
1076 create function sys.password_hash (username string) returns string external name sql.password; 1076 1063 create function sys.password_hash (username string) returns string external name sql.password; 1063
+ 1064 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1064
1077 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1077 1065 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1065
1078 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1078 -
1079 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1079 1066 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1066
..................
# 10:17:18 >
1124 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1124 1111 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1111
1125 create procedure shpattach(fname string) external name shp.attach; 1125 -
1126 create procedure shpload(fid integer) external name shp.import; 1126 -
1127 create procedure shpload(fid integer, filter geometry) external name shp.import; 1127 -
1128 create procedure shrink(sys string, tab string) external name sql.shrink; 1128 1112 create procedure shrink(sys string, tab string) external name sql.shrink; 1112
..................
# 10:17:18 >
1257 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1257 1241 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1241
+ 1242 create aggregate stddev_samp(val hugeint) returns double external name "aggr"."stdev"; 1242
+ 1243 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1243
1258 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1258 1244 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1244
..................
# 10:17:18 >
1260 create aggregate stddev_samp(val double) returns double external name "aggr"."stdev"; 1260 1246 create aggregate stddev_samp(val double) returns double external name "aggr"."stdev"; 1246
1261 create aggregate stddev_samp(val hugeint) returns double external name "aggr"."stdev"; 1261 -
1262 create aggregate stddev_samp(val integer) returns double external name "aggr"."stdev"; 1262 1247 create aggregate stddev_samp(val integer) returns double external name "aggr"."stdev"; 1247
..................
# 10:17:18 >
1266 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1266 1251 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1251
1267 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1267 -
1268 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1268 1252 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1252
..................
# .s, .f, .L4, .L6, .f,
2375 [ "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 ] 2375 2359 [ "sys", "fuse", "SYSTEM", "create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse;", "udf", "MAL", "Scalar function", false, false, false, "result", "smallint", 16, 0, "out", "one", "tinyint", 8, 0, "in", "two", "tinyint", 8, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2359
2376 [ "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 ] 2376 ! 2360 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "bigint", 64, 0, "out", "first", "bigint", 64, 0, "in", "last", "bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2360
2377 [ "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 ] 2377 ! 2361 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first bigint, last bigint, stepsize bigint) returns table (value bigint) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "bigint", 64, 0, "out", "first", "bigint", 64, 0, "in", "last", "bigint", 64, 0, "in", "stepsize", "bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2361
2378 [ "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 ] 2378 ! 2362 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first decimal(10,2), last decimal(10,2), stepsize decimal(10,2)) returns table (value decimal(10,2)) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "decimal", 10, 2, "out", "first", "decimal", 10, 2, "in", "last", "decimal", 10, 2, "in", "stepsize", "decimal", 10, 2, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2362
2379 [ "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 ] 2379 ! 2363 [ "sys", "generate_series", "SYSTEM", "create function sys.generate_series(first double, last double, stepsize double) returns table (value double) external name generator.series;", "generator", "MAL", "Function returning a table", false, false, false, "value", "double", 53, 0, "out", "first", "double", 53, 0, "in", "last", "double", 53, 0, "in", "stepsize", "double", 53, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2363
2380 [ "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 ] 2380 ! 2364 [ "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 ] 2364
2381 [ "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 ] 2381 ! 2365 [ "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 ] 2365
2382 [ "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 ] 2382 ! 2366 [ "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 ] 2366
2383 [ "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 ] 2383 ! 2367 [ "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 ] 2367
2384 [ "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 ] 2384 ! 2368 [ "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 ] 2368
2385 [ "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 ] 2385 ! 2369 [ "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 ] 2369
2386 [ "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 ] 2386 ! 2370 [ "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 ] 2370
2387 [ "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 ] 2387 ! 2371 [ "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 ] 2371
2388 [ "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 ] 2388 ! 2372 [ "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 ] 2372
2389 [ "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 ] 2389 ! 2373 [ "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 ] 2373
2390 [ "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 ] 2390 2374 [ "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 ] 2374
..................
# .s, .f, .L4, .L6, .f,
2498 [ "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 ] 2498 2482 [ "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 ] 2482
2499 [ "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 ] 2499 -
2500 [ "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 ] 2500 -
2501 [ "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 ] 2501 -
2502 [ "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 ] 2502 2483 [ "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 ] 2483
..................
# .s, .f, .L4, .L6, .f,
3403 [ "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 ] 3403 3384 [ "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 ] 3384
3404 [ "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 ] 3404 -
3405 [ "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 ] 3405 -
3406 [ "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 ] 3406 -
3407 [ "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 ] 3407 3385 [ "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 ] 3385
..................
#select s1.name, f1.name, s2.name, f2.na
4053 % 3, 17, 3, 13, 8 # length 4053 4031 % 3, 17, 3, 13, 8 # length 4031
+ 4032 [ "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 4032
4054 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4054 4033 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 4033
..................
#select s1.name, t.name, c.name, s2.name
4076 % 3, 17, 13, 3, 16, 9 # length 4076 4055 % 3, 17, 13, 3, 16, 9 # length 4055
4077 [ "sys", "spatial_ref_sys", "auth_name", "sys", "getproj4", "FUNCTION" ] 4077 -
4078 [ "sys", "spatial_ref_sys", "auth_srid", "sys", "getproj4", "FUNCTION" ] 4078 -
4079 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 4079 4056 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 4056
4080 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 4080 4057 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 4057
4081 [ "sys", "spatial_ref_sys", "srtext", "sys", "getproj4", "FUNCTION" ] 4081 -
4082 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 4082 4058 [ "sys", "keys", "action", "sys", "storagemodelinit", "PROCEDURE" ] 4058
..................
#select s1.name, f1.name, s2.name, t2.na
4111 % varchar, varchar, varchar, varchar, varchar # type 4111 4087 % varchar, varchar, varchar, varchar, varchar # type 4087
4112 % 3, 11, 3, 17, 4 # length 4112 ! 4088 % 3, 16, 3, 17, 4 # length 4088
4113 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 4113 4089 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 4089
..................
#select s1.name, f1.name, s2.name, t2.na
4115 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 4115 4091 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 4091
+ 4092 [ "sys", "optimizers", "sys", "optimizers", "VIEW" ] 4092
+ 4093 [ "sys", "querylog_catalog", "sys", "querylog_catalog", "VIEW" ] 4093
+ 4094 [ "sys", "queue", "sys", "queue", "VIEW" ] 4094
+ 4095 [ "sys", "rejects", "sys", "rejects", "VIEW" ] 4095
+ 4096 [ "sys", "sessions", "sys", "sessions", "VIEW" ] 4096
4116 [ "sys", "columnsize", "sys", "storagemodel", "VIEW" ] 4116 4097 [ "sys", "columnsize", "sys", "storagemodel", "VIEW" ] 4097
..................
#select s1.name, f1.name, s2.name, t2.na
4123 [ "sys", "imprintsize", "sys", "tablestoragemodel", "VIEW" ] 4123 4104 [ "sys", "imprintsize", "sys", "tablestoragemodel", "VIEW" ] 4104
+ 4105 [ "sys", "tracelog", "sys", "tracelog", "VIEW" ] 4105
4124 #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; 4124 4106 #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; 4106
..................
#select s1.name, t1.name, s2.name, t2.na
4139 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 4139 4121 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 4121
4140 [ "sys", "idxs", "sys", "dependency_columns_on_indexes", "VIEW" ] 4140 -
4141 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 4141 4122 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 4122
4142 [ "sys", "objects", "sys", "dependency_columns_on_indexes", "VIEW" ] 4142 -
4143 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 4143 4123 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 4123
4144 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 4144 4124 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 4124
4145 [ "sys", "keys", "sys", "dependency_columns_on_keys", "VIEW" ] 4145 -
4146 [ "sys", "objects", "sys", "dependency_columns_on_keys", "VIEW" ] 4146 -
4147 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 4147 4125 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 4125
..................
#select s1.name, t1.name, s2.name, t2.na
4153 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 4153 4131 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 4131
4154 [ "sys", "triggers", "sys", "dependency_columns_on_triggers", "VIEW" ] 4154 -
4155 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 4155 4132 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 4132
..................
#select s1.name, t1.name, s2.name, t2.na
4167 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 4167 4144 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 4144
4168 [ "sys", "triggers", "sys", "dependency_functions_on_triggers", "VIEW" ] 4168 -
4169 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 4169 4145 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 4145
..................
#select s1.name, t1.name, s2.name, t2.na
4174 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 4174 4150 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 4150
4175 [ "sys", "keys", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4175 -
4176 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 4176 4151 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 4151
..................
#select s1.name, t1.name, s2.name, t2.na
4179 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 4179 4154 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 4154
4180 [ "sys", "keys", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4180 -
4181 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4181 4155 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4155
..................
#select s1.name, t1.name, s2.name, t2.na
4184 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 4184 4158 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 4158
4185 [ "sys", "idxs", "sys", "dependency_tables_on_indexes", "VIEW" ] 4185 -
4186 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 4186 4159 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 4159
..................
#select s1.name, t1.name, s2.name, t2.na
4192 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4192 4165 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4165
4193 [ "sys", "triggers", "sys", "dependency_tables_on_triggers", "VIEW" ] 4193 -
4194 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4194 4166 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4166
..................
#select s1.name, t1.name, s2.name, t2.na
4207 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4207 4179 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4179
4208 [ "sys", "_columns", "sys", "ids", "VIEW" ] 4208 -
4209 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4209 4180 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4180
..................
#select s1.name, t1.name, s2.name, t2.na
4212 [ "sys", "functions", "sys", "ids", "VIEW" ] 4212 4183 [ "sys", "functions", "sys", "ids", "VIEW" ] 4183
4213 [ "sys", "idxs", "sys", "ids", "VIEW" ] 4213 -
4214 [ "sys", "keys", "sys", "ids", "VIEW" ] 4214 4184 [ "sys", "keys", "sys", "ids", "VIEW" ] 4184
..................
#select s1.name, t1.name, s2.name, t2.na
4216 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4216 4186 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4186
4217 [ "sys", "triggers", "sys", "ids", "VIEW" ] 4217 -
4218 [ "sys", "types", "sys", "ids", "VIEW" ] 4218 4187 [ "sys", "types", "sys", "ids", "VIEW" ] 4187
4219 [ "tmp", "_columns", "sys", "ids", "VIEW" ] 4219 -
4220 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4220 4188 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4188
4221 [ "tmp", "idxs", "sys", "ids", "VIEW" ] 4221 -
4222 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4222 4189 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4189
4223 [ "tmp", "triggers", "sys", "ids", "VIEW" ] 4223 -
4224 [ "sys", "auths", "sys", "roles", "VIEW" ] 4224 4190 [ "sys", "auths", "sys", "roles", "VIEW" ] 4190
..................
#select s1.name, t1.name, c1.name, s2.na
4258 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4258 4224 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4224
4259 [ "sys", "idxs", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4259 ! 4225 [ "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4225
4260 [ "sys", "idxs", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4260 ! 4226 [ "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4226
4261 [ "sys", "idxs", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4261 ! 4227 [ "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4227
4262 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4262 ! 4228 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4228
4263 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4263 ! 4229 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4229
+ 4230 [ "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4230
4264 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4264 4231 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4231
4265 [ "sys", "objects", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4265 ! 4232 [ "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4232
4266 [ "sys", "objects", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4266 ! 4233 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4233
4267 [ "sys", "objects", "nr", "sys", "dependency_columns_on_indexes", "VIEW" ] 4267 ! 4234 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4234
4268 [ "sys", "keys", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4268 ! 4235 [ "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4235
4269 [ "sys", "keys", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4269 ! 4236 [ "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4236
4270 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4270 ! 4237 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4237
4271 [ "sys", "keys", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4271 ! 4238 [ "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4238
4272 [ "sys", "objects", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4272 ! 4239 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4239
4273 [ "sys", "objects", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4273 ! 4240 [ "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4240
4274 [ "sys", "objects", "nr", "sys", "dependency_columns_on_keys", "VIEW" ] 4274 ! 4241 [ "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4241
+ 4242 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4242
+ 4243 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4243
+ 4244 [ "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4244
4275 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4275 4245 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4245
..................
#select s1.name, t1.name, c1.name, s2.na
4283 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4283 4253 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4253
4284 [ "sys", "triggers", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4284 ! 4254 [ "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4254
4285 [ "sys", "triggers", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4285 ! 4255 [ "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4255
+ 4256 [ "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4256
4286 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4286 4257 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4257
..................
#select s1.name, t1.name, c1.name, s2.na
4314 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4314 4285 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4285
4315 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4315 ! 4286 [ "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4286
4316 [ "sys", "triggers", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4316 ! 4287 [ "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4287
4317 [ "sys", "triggers", "table_id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4317 ! 4288 [ "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4288
+ 4289 [ "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4289
4318 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4318 4290 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4290
..................
#select s1.name, t1.name, c1.name, s2.na
4331 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4331 4303 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4303
4332 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4332 ! 4304 [ "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4304
4333 [ "sys", "keys", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4333 ! 4305 [ "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4305
4334 [ "sys", "keys", "rkey", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4334 ! 4306 [ "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4306
4335 [ "sys", "keys", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4335 ! 4307 [ "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4307
4336 [ "sys", "keys", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4336 ! 4308 [ "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4308
+ 4309 [ "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4309
4337 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4337 4310 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4310
..................
#select s1.name, t1.name, c1.name, s2.na
4343 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4343 4316 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4316
4344 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4344 ! 4317 [ "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4317
4345 [ "sys", "keys", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4345 ! 4318 [ "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4318
4346 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4346 ! 4319 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4319
4347 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4347 ! 4320 [ "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4320
4348 [ "sys", "keys", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4348 ! 4321 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4321
+ 4322 [ "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4322
4349 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4349 4323 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4323
..................
#select s1.name, t1.name, c1.name, s2.na
4354 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4354 4328 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4328
4355 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4355 ! 4329 [ "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4329
4356 [ "sys", "idxs", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4356 ! 4330 [ "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4330
4357 [ "sys", "idxs", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4357 ! 4331 [ "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4331
4358 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4358 ! 4332 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4332
4359 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4359 ! 4333 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4333
+ 4334 [ "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4334
4360 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4360 4335 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4335
..................
#select s1.name, t1.name, c1.name, s2.na
4369 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4369 4344 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4344
4370 [ "sys", "triggers", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4370 ! 4345 [ "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4345
4371 [ "sys", "triggers", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4371 ! 4346 [ "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4346
4372 [ "sys", "triggers", "table_id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4372 ! 4347 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4347
+ 4348 [ "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4348
4373 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4373 4349 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4349
..................
#select s1.name, t1.name, c1.name, s2.na
4394 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4394 4370 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4370
+ 4371 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4371
4395 [ "sys", "_columns", "id", "sys", "ids", "VIEW" ] 4395 ! 4372 [ "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4372
4396 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4396 ! 4373 [ "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4373
4397 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4397 4374 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4374
+ 4375 [ "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4375
4398 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4398 -
4399 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4399 -
4400 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4400 ! 4376 [ "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4376
+ 4377 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4377
+ 4378 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4378
4401 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4401 ! 4379 [ "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4379
4402 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4402 4380 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4380
..................
#select s1.name, t1.name, c1.name, s2.na
4410 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4410 4388 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4388
4411 [ "sys", "idxs", "id", "sys", "ids", "VIEW" ] 4411 ! 4389 [ "sys", "keys", "action", "sys", "ids", "VIEW" ] 4389
+ 4390 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4390
4412 [ "sys", "idxs", "name", "sys", "ids", "VIEW" ] 4412 ! 4391 [ "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4391
+ 4392 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4392
4413 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4413 ! 4393 [ "sys", "keys", "type", "sys", "ids", "VIEW" ] 4393
4414 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4414 ! 4394 [ "sys", "objects", "id", "sys", "ids", "VIEW" ] 4394
4415 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4415 -
4416 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4416 -
4417 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4417 4395 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4395
..................
#select s1.name, t1.name, c1.name, s2.na
4421 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4421 4399 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4399
4422 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4422 ! 4400 [ "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4400
4423 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4423 ! 4401 [ "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4401
4424 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4424 ! 4402 [ "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4402
+ 4403 [ "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4403
4425 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4425 4404 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4404
..................
#select s1.name, t1.name, c1.name, s2.na
4427 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4427 4406 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4406
+ 4407 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4407
4428 [ "tmp", "_columns", "id", "sys", "ids", "VIEW" ] 4428 ! 4408 [ "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4408
4429 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4429 -
4430 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4430 -
4431 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4431 -
4432 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4432 -
4433 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4433 ! 4409 [ "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4409
+ 4410 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4410
4434 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4434 ! 4411 [ "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4411
4435 [ "tmp", "idxs", "id", "sys", "ids", "VIEW" ] 4435 ! 4412 [ "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4412
+ 4413 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4413
+ 4414 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4414
4436 [ "tmp", "idxs", "name", "sys", "ids", "VIEW" ] 4436 ! 4415 [ "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4415
4437 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4437 ! 4416 [ "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4416
+ 4417 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4417
4438 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4438 ! 4418 [ "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4418
4439 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4439 -
4440 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4440 4419 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4419
4441 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4441 ! 4420 [ "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4420
4442 [ "tmp", "triggers", "name", "sys", "ids", "VIEW" ] 4442 -
4443 [ "tmp", "triggers", "table_id", "sys", "ids", "VIEW" ] 4443 -
4444 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4444 4421 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4421
..................
# .t, .g, .L4, .L6, .L10,
5110 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5110 5087 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 5087
5111 [ "_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();" ] 5111 ! 5088 [ 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();" ] 5088
5112 [ "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();" ] 5112 5089 [ "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();" ] 5089