Test check.SQL.py (id b41f8504324f) (err)
check.stable.out.int128.FILTERED 2018-05-31 00:47:45.175335330 +0200check.test.out.FILTERED 2018-05-31 00:47:45.422336656 +0200
1 Statistics about stdout of test 'check` in directory 'sql/test/emptydb-upgrade-chain`: 1 1 Statistics about stdout of test 'check` in directory 'sql/test/emptydb-upgrade-chain`: 1
2 7169 lines, 207291 words, 1346235 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 7042 lines, 205842 words, 1333720 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 7169 lines, 207291 words, 1346235 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 7042 lines, 205842 words, 1333720 chars in lines not matching '^$|^(\| |)#` 3
4 # 7248 lines, 209653 words, 1362844 chars in all lines 4 ! 4 # 7121 lines, 208202 words, 1350418 chars in all lines 4
5 5 5 5
..................
# 10:17:18 >
206 \dSf sys."left_shift_assign" 206 206 \dSf sys."left_shift_assign" 206
207 \dSf sys."lidarattach" 207 -
208 \dSf sys."lidarexport" 208 -
209 \dSf sys."lidarload" 209 -
210 \dSf sys."like" 210 207 \dSf sys."like" 207
..................
# 10:17:18 >
259 \dSf sys."settimeout" 259 256 \dSf sys."settimeout" 256
260 \dSf sys."shpattach" 260 -
261 \dSf sys."shpload" 261 -
262 \dSf sys."shrink" 262 257 \dSf sys."shrink" 257
..................
# 10:17:18 >
591 SYSTEM FUNCTION sys.levenshtein 591 586 SYSTEM FUNCTION sys.levenshtein 586
592 SYSTEM PROCEDURE sys.lidarattach 592 -
593 SYSTEM PROCEDURE sys.lidarexport 593 -
594 SYSTEM PROCEDURE sys.lidarload 594 -
595 SYSTEM FILTER FUNCTION sys.like 595 587 SYSTEM FILTER FUNCTION sys.like 587
..................
# 10:17:18 >
701 SYSTEM PROCEDURE sys.settimeout 701 693 SYSTEM PROCEDURE sys.settimeout 693
702 SYSTEM PROCEDURE sys.shpattach 702 -
703 SYSTEM PROCEDURE sys.shpload 703 -
704 SYSTEM PROCEDURE sys.shrink 704 694 SYSTEM PROCEDURE sys.shrink 694
..................
# 10:17:18 >
1000 create procedure sys.flush_log () external name sql."flush_log"; 1000 990 create procedure sys.flush_log () external name sql."flush_log"; 990
+ 991 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 991
1001 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 1001 ! 992 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 992
1002 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 1002 993 create function fuse(one integer, two integer) returns bigint external name udf.fuse; 993
1003 create function fuse(one smallint, two smallint) returns integer external name udf.fuse; 1003 ! 994 create function fuse(one bigint, two bigint) returns hugeint external name udf.fuse; 994
1004 create function fuse(one tinyint, two tinyint) returns smallint external name udf.fuse; 1004 ! 995 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 995
1005 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 1005 996 create function sys.generate_series(first bigint, last bigint) returns table (value bigint) external name generator.series; 996
..................
# 10:17:18 >
1016 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1016 1007 create function sys.generate_series(first timestamp, last timestamp, stepsize interval second) returns table (value timestamp) external name generator.series; 1007
1017 create function sys.generate_series(first tinyint, last tinyint) returns table (value tinyint) external name generator.series; 1017 -
1018 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1018 1008 create function sys.generate_series(first tinyint, last tinyint, stepsize tinyint) returns table (value tinyint) external name generator.series; 1008
..................
# 10:17:18 >
1050 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1050 1040 create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external name inet."<<="; 1040
1051 create procedure lidarattach(fname string) external name lidar.attach; 1051 ! 1041 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1041
1052 create procedure lidarexport(tname string, fname string, format string) external name lidar.export; 1052 -
1053 create procedure lidarload(tname string) external name lidar.load; 1053 -
1054 create filter function "like"(val string, pat string) external name algebra."like"; 1054 1042 create filter function "like"(val string, pat string) external name algebra."like"; 1042
1055 create filter function "like"(val string, pat string, esc string) external name algebra."like"; 1055 -
1056 create procedure listdir(dirname string) external name fits.listdir; 1056 1043 create procedure listdir(dirname string) external name fits.listdir; 1043
..................
# 10:17:18 >
1090 create function sys.password_hash (username string) returns string external name sql.password; 1090 1077 create function sys.password_hash (username string) returns string external name sql.password; 1077
+ 1078 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1078
1091 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1091 1079 create procedure sys.pause(tag bigint) external name sql.sysmon_pause; 1079
1092 create procedure sys.pause(tag int) external name sql.sysmon_pause; 1092 -
1093 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1093 1080 create aggregate quantile(val bigint, q double) returns bigint external name "aggr"."quantile"; 1080
..................
# 10:17:18 >
1137 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1137 1124 create procedure sys.settimeout("query" bigint, "session" bigint) external name clients.settimeout; 1124
1138 create procedure shpattach(fname string) external name shp.attach; 1138 -
1139 create procedure shpload(fid integer) external name shp.import; 1139 -
1140 create procedure shpload(fid integer, filter geometry) external name shp.import; 1140 -
1141 create procedure shrink(sys string, tab string) external name sql.shrink; 1141 1125 create procedure shrink(sys string, tab string) external name sql.shrink; 1125
..................
# 10:17:18 >
1270 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1270 1254 create aggregate stddev_pop(val tinyint) returns double external name "aggr"."stdevp"; 1254
+ 1255 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1255
1271 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1271 1256 create aggregate stddev_samp(val bigint) returns double external name "aggr"."stdev"; 1256
..................
# 10:17:18 >
1279 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1279 1264 create aggregate stddev_samp(val timestamp) returns double external name "aggr"."stdev"; 1264
1280 create aggregate stddev_samp(val tinyint) returns double external name "aggr"."stdev"; 1280 -
1281 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1281 1265 create procedure sys.stop(tag bigint) external name sql.sysmon_stop; 1265
..................
# .s, .f, .L4, .f, .fl,
2440 [ "sys", "levenshtein", "levenshtein", "txtsim", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "varchar", 0, 0, "in", "arg_2", "varchar", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2440 2424 [ "sys", "levenshtein", "levenshtein", "txtsim", "Internal C", "Scalar function", false, false, false, "res_0", "int", 32, 0, "out", "arg_1", "varchar", 0, 0, "in", "arg_2", "varchar", 0, 0, "in", "arg_3", "int", 32, 0, "in", "arg_4", "int", 32, 0, "in", "arg_5", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2424
2441 [ "sys", "lidarattach", "create procedure lidarattach(fname string) external name lidar.attach;", "lidar", "MAL", "Procedure", true, false, false, "fname", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2441 -
2442 [ "sys", "lidarexport", "create procedure lidarexport(tname string, fname string, format string) external name lidar.export;", "lidar", "MAL", "Procedure", true, false, false, "tname", "clob", 0, 0, "in", "fname", "clob", 0, 0, "in", "format", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2442 -
2443 [ "sys", "lidarload", "create procedure lidarload(tname string) external name lidar.load;", "lidar", "MAL", "Procedure", true, false, false, "tname", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2443 -
2444 [ "sys", "like", "create filter function \"like\"(val string, pat string) external name algebra.\"like\";", "algebra", "MAL", "Filter function", false, false, false, "val", "clob", 0, 0, "in", "pat", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2444 2425 [ "sys", "like", "create filter function \"like\"(val string, pat string) external name algebra.\"like\";", "algebra", "MAL", "Filter function", false, false, false, "val", "clob", 0, 0, "in", "pat", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 2425
..................
# .s, .f, .L4, .f, .fl,
3312 [ "sys", "settimeout", "create procedure sys.settimeout(\"query\" bigint, \"session\" bigint) external name clients.settimeout;", "clients", "MAL", "Procedure", true, false, false, "query", "bigint", 64, 0, "in", "session", "bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3312 3293 [ "sys", "settimeout", "create procedure sys.settimeout(\"query\" bigint, \"session\" bigint) external name clients.settimeout;", "clients", "MAL", "Procedure", true, false, false, "query", "bigint", 64, 0, "in", "session", "bigint", 64, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3293
3313 [ "sys", "shpattach", "create procedure shpattach(fname string) external name shp.attach;", "shp", "MAL", "Procedure", true, false, false, "fname", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3313 -
3314 [ "sys", "shpload", "create procedure shpload(fid integer) external name shp.import;", "shp", "MAL", "Procedure", true, false, false, "fid", "int", 32, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3314 -
3315 [ "sys", "shpload", "create procedure shpload(fid integer, filter geometry) external name shp.import;", "shp", "MAL", "Procedure", true, false, false, "fid", "int", 32, 0, "in", "filter", "geometry", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3315 -
3316 [ "sys", "shrink", "create procedure shrink(sys string, tab string) external name sql.shrink;", "sql", "MAL", "Procedure", true, false, false, "sys", "clob", 0, 0, "in", "tab", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3316 3294 [ "sys", "shrink", "create procedure shrink(sys string, tab string) external name sql.shrink;", "sql", "MAL", "Procedure", true, false, false, "sys", "clob", 0, 0, "in", "tab", "clob", 0, 0, "in", NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ] 3294
..................
#select s1.name, f1.name, s2.name, f2.na
3921 % 3, 17, 3, 13, 8 # length 3921 3899 % 3, 17, 3, 13, 8 # length 3899
+ 3900 [ "sys", "ms_trunc", "sys", "ms_round", "FUNCTION" ] 3900
3922 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3922 3901 [ "sys", "st_numgeometries", "sys", "st_numpatches", "FUNCTION" ] 3901
..................
#select s1.name, t.name, s2.name, f.name
3935 % 3, 17, 3, 35, 9 # length 3935 3914 % 3, 17, 3, 35, 9 # length 3914
3936 [ "sys", "columns", "sys", "dependencies_columns_on_functions", "FUNCTION" ] 3936 -
3937 [ "sys", "dependencies", "sys", "dependencies_columns_on_functions", "FUNCTION" ] 3937 3915 [ "sys", "dependencies", "sys", "dependencies_columns_on_functions", "FUNCTION" ] 3915
3938 [ "sys", "functions", "sys", "dependencies_columns_on_functions", "FUNCTION" ] 3938 3916 [ "sys", "functions", "sys", "dependencies_columns_on_functions", "FUNCTION" ] 3916
3939 [ "sys", "columns", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 3939 -
3940 [ "sys", "idxs", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 3940 3917 [ "sys", "idxs", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 3917
..................
#select s1.name, t.name, s2.name, f.name
3942 [ "sys", "objects", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 3942 3919 [ "sys", "objects", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 3919
3943 [ "sys", "columns", "sys", "dependencies_columns_on_keys", "FUNCTION" ] 3943 -
3944 [ "sys", "keys", "sys", "dependencies_columns_on_keys", "FUNCTION" ] 3944 3920 [ "sys", "keys", "sys", "dependencies_columns_on_keys", "FUNCTION" ] 3920
3945 [ "sys", "objects", "sys", "dependencies_columns_on_keys", "FUNCTION" ] 3945 3921 [ "sys", "objects", "sys", "dependencies_columns_on_keys", "FUNCTION" ] 3921
3946 [ "sys", "columns", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 3946 -
3947 [ "sys", "dependencies", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 3947 3922 [ "sys", "dependencies", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 3922
3948 [ "sys", "triggers", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 3948 3923 [ "sys", "triggers", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 3923
3949 [ "sys", "columns", "sys", "dependencies_columns_on_views", "FUNCTION" ] 3949 -
3950 [ "sys", "dependencies", "sys", "dependencies_columns_on_views", "FUNCTION" ] 3950 3924 [ "sys", "dependencies", "sys", "dependencies_columns_on_views", "FUNCTION" ] 3924
3951 [ "sys", "tables", "sys", "dependencies_columns_on_views", "FUNCTION" ] 3951 -
3952 [ "sys", "dependencies", "sys", "dependencies_functions_on_functions", "FUNCTION" ] 3952 3925 [ "sys", "dependencies", "sys", "dependencies_functions_on_functions", "FUNCTION" ] 3925
..................
#select s1.name, t.name, s2.name, f.name
3955 [ "sys", "functions", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 3955 3928 [ "sys", "functions", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 3928
+ 3929 [ "sys", "idxs", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 3929
3956 [ "sys", "triggers", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 3956 3930 [ "sys", "triggers", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 3930
..................
#select s1.name, t.name, s2.name, f.name
3962 [ "sys", "keys", "sys", "dependencies_tables_on_foreignkeys", "FUNCTION" ] 3962 3936 [ "sys", "keys", "sys", "dependencies_tables_on_foreignkeys", "FUNCTION" ] 3936
3963 [ "sys", "tables", "sys", "dependencies_tables_on_foreignkeys", "FUNCTION" ] 3963 -
3964 [ "sys", "dependencies", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 3964 3937 [ "sys", "dependencies", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 3937
3965 [ "sys", "functions", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 3965 3938 [ "sys", "functions", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 3938
3966 [ "sys", "tables", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 3966 -
3967 [ "sys", "idxs", "sys", "dependencies_tables_on_indexes", "FUNCTION" ] 3967 3939 [ "sys", "idxs", "sys", "dependencies_tables_on_indexes", "FUNCTION" ] 3939
3968 [ "sys", "keys", "sys", "dependencies_tables_on_indexes", "FUNCTION" ] 3968 3940 [ "sys", "keys", "sys", "dependencies_tables_on_indexes", "FUNCTION" ] 3940
3969 [ "sys", "tables", "sys", "dependencies_tables_on_indexes", "FUNCTION" ] 3969 -
3970 [ "sys", "dependencies", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 3970 3941 [ "sys", "dependencies", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 3941
3971 [ "sys", "tables", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 3971 -
3972 [ "sys", "triggers", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 3972 3942 [ "sys", "triggers", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 3942
3973 [ "sys", "dependencies", "sys", "dependencies_tables_on_views", "FUNCTION" ] 3973 3943 [ "sys", "dependencies", "sys", "dependencies_tables_on_views", "FUNCTION" ] 3943
3974 [ "sys", "tables", "sys", "dependencies_tables_on_views", "FUNCTION" ] 3974 -
3975 [ "sys", "dependencies", "sys", "dependencies_views_on_functions", "FUNCTION" ] 3975 3944 [ "sys", "dependencies", "sys", "dependencies_views_on_functions", "FUNCTION" ] 3944
3976 [ "sys", "functions", "sys", "dependencies_views_on_functions", "FUNCTION" ] 3976 3945 [ "sys", "functions", "sys", "dependencies_views_on_functions", "FUNCTION" ] 3945
3977 [ "sys", "tables", "sys", "dependencies_views_on_functions", "FUNCTION" ] 3977 -
3978 [ "sys", "dependencies", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 3978 3946 [ "sys", "dependencies", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 3946
3979 [ "sys", "tables", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 3979 -
3980 [ "sys", "triggers", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 3980 3947 [ "sys", "triggers", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 3947
..................
#select s1.name, t.name, c.name, s2.name
3995 [ "sys", "dependencies", "id", "sys", "dependencies_columns_on_functions", "FUNCTION" ] 3995 3962 [ "sys", "dependencies", "id", "sys", "dependencies_columns_on_functions", "FUNCTION" ] 3962
3996 [ "sys", "functions", "func", "sys", "dependencies_columns_on_functions", "FUNCTION" ] 3996 -
3997 [ "sys", "functions", "id", "sys", "dependencies_columns_on_functions", "FUNCTION" ] 3997 3963 [ "sys", "functions", "id", "sys", "dependencies_columns_on_functions", "FUNCTION" ] 3963
3998 [ "sys", "functions", "language", "sys", "dependencies_columns_on_functions", "FUNCTION" ] 3998 -
3999 [ "sys", "functions", "mod", "sys", "dependencies_columns_on_functions", "FUNCTION" ] 3999 -
4000 [ "sys", "functions", "name", "sys", "dependencies_columns_on_functions", "FUNCTION" ] 4000 3964 [ "sys", "functions", "name", "sys", "dependencies_columns_on_functions", "FUNCTION" ] 3964
4001 [ "sys", "functions", "schema_id", "sys", "dependencies_columns_on_functions", "FUNCTION" ] 4001 -
4002 [ "sys", "functions", "side_effect", "sys", "dependencies_columns_on_functions", "FUNCTION" ] 4002 -
4003 [ "sys", "functions", "type", "sys", "dependencies_columns_on_functions", "FUNCTION" ] 4003 -
4004 [ "sys", "functions", "vararg", "sys", "dependencies_columns_on_functions", "FUNCTION" ] 4004 -
4005 [ "sys", "functions", "varres", "sys", "dependencies_columns_on_functions", "FUNCTION" ] 4005 -
4006 [ "sys", "idxs", "id", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 4006 3965 [ "sys", "idxs", "id", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 3965
..................
#select s1.name, t.name, c.name, s2.name
4008 [ "sys", "idxs", "table_id", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 4008 3967 [ "sys", "idxs", "table_id", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 3967
4009 [ "sys", "idxs", "type", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 4009 -
4010 [ "sys", "keys", "action", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 4010 -
4011 [ "sys", "keys", "id", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 4011 -
4012 [ "sys", "keys", "name", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 4012 3968 [ "sys", "keys", "name", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 3968
4013 [ "sys", "keys", "rkey", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 4013 -
4014 [ "sys", "keys", "table_id", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 4014 -
4015 [ "sys", "keys", "type", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 4015 -
4016 [ "sys", "objects", "id", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 4016 3969 [ "sys", "objects", "id", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 3969
4017 [ "sys", "objects", "name", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 4017 3970 [ "sys", "objects", "name", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 3970
4018 [ "sys", "objects", "nr", "sys", "dependencies_columns_on_indexes", "FUNCTION" ] 4018 -
4019 [ "sys", "keys", "action", "sys", "dependencies_columns_on_keys", "FUNCTION" ] 4019 -
4020 [ "sys", "keys", "id", "sys", "dependencies_columns_on_keys", "FUNCTION" ] 4020 3971 [ "sys", "keys", "id", "sys", "dependencies_columns_on_keys", "FUNCTION" ] 3971
..................
#select s1.name, t.name, c.name, s2.name
4023 [ "sys", "keys", "table_id", "sys", "dependencies_columns_on_keys", "FUNCTION" ] 4023 3974 [ "sys", "keys", "table_id", "sys", "dependencies_columns_on_keys", "FUNCTION" ] 3974
4024 [ "sys", "keys", "type", "sys", "dependencies_columns_on_keys", "FUNCTION" ] 4024 -
4025 [ "sys", "objects", "id", "sys", "dependencies_columns_on_keys", "FUNCTION" ] 4025 3975 [ "sys", "objects", "id", "sys", "dependencies_columns_on_keys", "FUNCTION" ] 3975
4026 [ "sys", "objects", "name", "sys", "dependencies_columns_on_keys", "FUNCTION" ] 4026 3976 [ "sys", "objects", "name", "sys", "dependencies_columns_on_keys", "FUNCTION" ] 3976
4027 [ "sys", "objects", "nr", "sys", "dependencies_columns_on_keys", "FUNCTION" ] 4027 -
4028 [ "sys", "dependencies", "depend_id", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 4028 3977 [ "sys", "dependencies", "depend_id", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 3977
..................
#select s1.name, t.name, c.name, s2.name
4030 [ "sys", "dependencies", "id", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 4030 3979 [ "sys", "dependencies", "id", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 3979
4031 [ "sys", "triggers", "condition", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 4031 -
4032 [ "sys", "triggers", "event", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 4032 -
4033 [ "sys", "triggers", "id", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 4033 3980 [ "sys", "triggers", "id", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 3980
4034 [ "sys", "triggers", "name", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 4034 3981 [ "sys", "triggers", "name", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 3981
4035 [ "sys", "triggers", "new_name", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 4035 -
4036 [ "sys", "triggers", "old_name", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 4036 -
4037 [ "sys", "triggers", "orientation", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 4037 -
4038 [ "sys", "triggers", "statement", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 4038 -
4039 [ "sys", "triggers", "table_id", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 4039 -
4040 [ "sys", "triggers", "time", "sys", "dependencies_columns_on_triggers", "FUNCTION" ] 4040 -
4041 [ "sys", "dependencies", "depend_id", "sys", "dependencies_columns_on_views", "FUNCTION" ] 4041 3982 [ "sys", "dependencies", "depend_id", "sys", "dependencies_columns_on_views", "FUNCTION" ] 3982
..................
#select s1.name, t.name, c.name, s2.name
4046 [ "sys", "dependencies", "id", "sys", "dependencies_functions_on_functions", "FUNCTION" ] 4046 3987 [ "sys", "dependencies", "id", "sys", "dependencies_functions_on_functions", "FUNCTION" ] 3987
4047 [ "sys", "functions", "func", "sys", "dependencies_functions_on_functions", "FUNCTION" ] 4047 -
4048 [ "sys", "functions", "id", "sys", "dependencies_functions_on_functions", "FUNCTION" ] 4048 3988 [ "sys", "functions", "id", "sys", "dependencies_functions_on_functions", "FUNCTION" ] 3988
4049 [ "sys", "functions", "language", "sys", "dependencies_functions_on_functions", "FUNCTION" ] 4049 -
4050 [ "sys", "functions", "mod", "sys", "dependencies_functions_on_functions", "FUNCTION" ] 4050 -
4051 [ "sys", "functions", "name", "sys", "dependencies_functions_on_functions", "FUNCTION" ] 4051 3989 [ "sys", "functions", "name", "sys", "dependencies_functions_on_functions", "FUNCTION" ] 3989
4052 [ "sys", "functions", "schema_id", "sys", "dependencies_functions_on_functions", "FUNCTION" ] 4052 -
4053 [ "sys", "functions", "side_effect", "sys", "dependencies_functions_on_functions", "FUNCTION" ] 4053 -
4054 [ "sys", "functions", "type", "sys", "dependencies_functions_on_functions", "FUNCTION" ] 4054 -
4055 [ "sys", "functions", "vararg", "sys", "dependencies_functions_on_functions", "FUNCTION" ] 4055 -
4056 [ "sys", "functions", "varres", "sys", "dependencies_functions_on_functions", "FUNCTION" ] 4056 -
4057 [ "sys", "dependencies", "depend_id", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4057 3990 [ "sys", "dependencies", "depend_id", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 3990
..................
#select s1.name, t.name, c.name, s2.name
4069 [ "sys", "functions", "varres", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4069 4002 [ "sys", "functions", "varres", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4002
4070 [ "sys", "triggers", "condition", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4070 ! 4003 [ "sys", "idxs", "id", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4003
4071 [ "sys", "triggers", "event", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4071 ! 4004 [ "sys", "idxs", "name", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4004
4072 [ "sys", "triggers", "id", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4072 -
4073 [ "sys", "triggers", "name", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4073 ! 4005 [ "sys", "idxs", "table_id", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4005
4074 [ "sys", "triggers", "new_name", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4074 ! 4006 [ "sys", "idxs", "type", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4006
4075 [ "sys", "triggers", "old_name", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4075 ! 4007 [ "sys", "keys", "action", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4007
4076 [ "sys", "triggers", "orientation", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4076 ! 4008 [ "sys", "keys", "name", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4008
4077 [ "sys", "triggers", "statement", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4077 ! 4009 [ "sys", "keys", "rkey", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4009
4078 [ "sys", "triggers", "table_id", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4078 ! 4010 [ "sys", "keys", "type", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4010
+ 4011 [ "sys", "triggers", "id", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4011
4079 [ "sys", "triggers", "time", "sys", "dependencies_functions_on_triggers", "FUNCTION" ] 4079 -
4080 [ "sys", "keys", "action", "sys", "dependencies_keys_on_foreignkeys", "FUNCTION" ] 4080 -
4081 [ "sys", "keys", "id", "sys", "dependencies_keys_on_foreignkeys", "FUNCTION" ] 4081 4012 [ "sys", "keys", "id", "sys", "dependencies_keys_on_foreignkeys", "FUNCTION" ] 4012
..................
#select s1.name, t.name, c.name, s2.name
4083 [ "sys", "keys", "rkey", "sys", "dependencies_keys_on_foreignkeys", "FUNCTION" ] 4083 4014 [ "sys", "keys", "rkey", "sys", "dependencies_keys_on_foreignkeys", "FUNCTION" ] 4014
4084 [ "sys", "keys", "table_id", "sys", "dependencies_keys_on_foreignkeys", "FUNCTION" ] 4084 -
4085 [ "sys", "keys", "type", "sys", "dependencies_keys_on_foreignkeys", "FUNCTION" ] 4085 -
4086 [ "sys", "auths", "grantor", "sys", "dependencies_owners_on_schemas", "FUNCTION" ] 4086 -
4087 [ "sys", "auths", "id", "sys", "dependencies_owners_on_schemas", "FUNCTION" ] 4087 4015 [ "sys", "auths", "id", "sys", "dependencies_owners_on_schemas", "FUNCTION" ] 4015
4088 [ "sys", "auths", "name", "sys", "dependencies_owners_on_schemas", "FUNCTION" ] 4088 4016 [ "sys", "auths", "name", "sys", "dependencies_owners_on_schemas", "FUNCTION" ] 4016
4089 [ "sys", "schemas", "authorization", "sys", "dependencies_owners_on_schemas", "FUNCTION" ] 4089 -
4090 [ "sys", "schemas", "id", "sys", "dependencies_owners_on_schemas", "FUNCTION" ] 4090 -
4091 [ "sys", "schemas", "name", "sys", "dependencies_owners_on_schemas", "FUNCTION" ] 4091 4017 [ "sys", "schemas", "name", "sys", "dependencies_owners_on_schemas", "FUNCTION" ] 4017
4092 [ "sys", "schemas", "owner", "sys", "dependencies_owners_on_schemas", "FUNCTION" ] 4092 4018 [ "sys", "schemas", "owner", "sys", "dependencies_owners_on_schemas", "FUNCTION" ] 4018
4093 [ "sys", "schemas", "system", "sys", "dependencies_owners_on_schemas", "FUNCTION" ] 4093 -
4094 [ "sys", "schemas", "authorization", "sys", "dependencies_schemas_on_users", "FUNCTION" ] 4094 -
4095 [ "sys", "schemas", "id", "sys", "dependencies_schemas_on_users", "FUNCTION" ] 4095 4019 [ "sys", "schemas", "id", "sys", "dependencies_schemas_on_users", "FUNCTION" ] 4019
4096 [ "sys", "schemas", "name", "sys", "dependencies_schemas_on_users", "FUNCTION" ] 4096 4020 [ "sys", "schemas", "name", "sys", "dependencies_schemas_on_users", "FUNCTION" ] 4020
4097 [ "sys", "schemas", "owner", "sys", "dependencies_schemas_on_users", "FUNCTION" ] 4097 -
4098 [ "sys", "schemas", "system", "sys", "dependencies_schemas_on_users", "FUNCTION" ] 4098 -
4099 [ "sys", "keys", "action", "sys", "dependencies_tables_on_foreignkeys", "FUNCTION" ] 4099 -
4100 [ "sys", "keys", "id", "sys", "dependencies_tables_on_foreignkeys", "FUNCTION" ] 4100 4021 [ "sys", "keys", "id", "sys", "dependencies_tables_on_foreignkeys", "FUNCTION" ] 4021
..................
#select s1.name, t.name, c.name, s2.name
4103 [ "sys", "keys", "table_id", "sys", "dependencies_tables_on_foreignkeys", "FUNCTION" ] 4103 4024 [ "sys", "keys", "table_id", "sys", "dependencies_tables_on_foreignkeys", "FUNCTION" ] 4024
4104 [ "sys", "keys", "type", "sys", "dependencies_tables_on_foreignkeys", "FUNCTION" ] 4104 -
4105 [ "sys", "dependencies", "depend_id", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 4105 4025 [ "sys", "dependencies", "depend_id", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 4025
..................
#select s1.name, t.name, c.name, s2.name
4107 [ "sys", "dependencies", "id", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 4107 4027 [ "sys", "dependencies", "id", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 4027
4108 [ "sys", "functions", "func", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 4108 -
4109 [ "sys", "functions", "id", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 4109 4028 [ "sys", "functions", "id", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 4028
4110 [ "sys", "functions", "language", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 4110 -
4111 [ "sys", "functions", "mod", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 4111 -
4112 [ "sys", "functions", "name", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 4112 4029 [ "sys", "functions", "name", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 4029
4113 [ "sys", "functions", "schema_id", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 4113 -
4114 [ "sys", "functions", "side_effect", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 4114 -
4115 [ "sys", "functions", "type", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 4115 -
4116 [ "sys", "functions", "vararg", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 4116 -
4117 [ "sys", "functions", "varres", "sys", "dependencies_tables_on_functions", "FUNCTION" ] 4117 -
4118 [ "sys", "idxs", "id", "sys", "dependencies_tables_on_indexes", "FUNCTION" ] 4118 -
4119 [ "sys", "idxs", "name", "sys", "dependencies_tables_on_indexes", "FUNCTION" ] 4119 4030 [ "sys", "idxs", "name", "sys", "dependencies_tables_on_indexes", "FUNCTION" ] 4030
4120 [ "sys", "idxs", "table_id", "sys", "dependencies_tables_on_indexes", "FUNCTION" ] 4120 4031 [ "sys", "idxs", "table_id", "sys", "dependencies_tables_on_indexes", "FUNCTION" ] 4031
4121 [ "sys", "idxs", "type", "sys", "dependencies_tables_on_indexes", "FUNCTION" ] 4121 -
4122 [ "sys", "keys", "action", "sys", "dependencies_tables_on_indexes", "FUNCTION" ] 4122 -
4123 [ "sys", "keys", "id", "sys", "dependencies_tables_on_indexes", "FUNCTION" ] 4123 -
4124 [ "sys", "keys", "name", "sys", "dependencies_tables_on_indexes", "FUNCTION" ] 4124 4032 [ "sys", "keys", "name", "sys", "dependencies_tables_on_indexes", "FUNCTION" ] 4032
4125 [ "sys", "keys", "rkey", "sys", "dependencies_tables_on_indexes", "FUNCTION" ] 4125 -
4126 [ "sys", "keys", "table_id", "sys", "dependencies_tables_on_indexes", "FUNCTION" ] 4126 -
4127 [ "sys", "keys", "type", "sys", "dependencies_tables_on_indexes", "FUNCTION" ] 4127 -
4128 [ "sys", "dependencies", "depend_id", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 4128 4033 [ "sys", "dependencies", "depend_id", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 4033
..................
#select s1.name, t.name, c.name, s2.name
4130 [ "sys", "dependencies", "id", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 4130 4035 [ "sys", "dependencies", "id", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 4035
4131 [ "sys", "triggers", "condition", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 4131 -
4132 [ "sys", "triggers", "event", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 4132 -
4133 [ "sys", "triggers", "id", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 4133 4036 [ "sys", "triggers", "id", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 4036
4134 [ "sys", "triggers", "name", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 4134 4037 [ "sys", "triggers", "name", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 4037
4135 [ "sys", "triggers", "new_name", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 4135 -
4136 [ "sys", "triggers", "old_name", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 4136 -
4137 [ "sys", "triggers", "orientation", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 4137 -
4138 [ "sys", "triggers", "statement", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 4138 -
4139 [ "sys", "triggers", "table_id", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 4139 4038 [ "sys", "triggers", "table_id", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 4038
4140 [ "sys", "triggers", "time", "sys", "dependencies_tables_on_triggers", "FUNCTION" ] 4140 -
4141 [ "sys", "dependencies", "depend_id", "sys", "dependencies_tables_on_views", "FUNCTION" ] 4141 4039 [ "sys", "dependencies", "depend_id", "sys", "dependencies_tables_on_views", "FUNCTION" ] 4039
..................
#select s1.name, t.name, c.name, s2.name
4146 [ "sys", "dependencies", "id", "sys", "dependencies_views_on_functions", "FUNCTION" ] 4146 4044 [ "sys", "dependencies", "id", "sys", "dependencies_views_on_functions", "FUNCTION" ] 4044
4147 [ "sys", "functions", "func", "sys", "dependencies_views_on_functions", "FUNCTION" ] 4147 -
4148 [ "sys", "functions", "id", "sys", "dependencies_views_on_functions", "FUNCTION" ] 4148 4045 [ "sys", "functions", "id", "sys", "dependencies_views_on_functions", "FUNCTION" ] 4045
4149 [ "sys", "functions", "language", "sys", "dependencies_views_on_functions", "FUNCTION" ] 4149 -
4150 [ "sys", "functions", "mod", "sys", "dependencies_views_on_functions", "FUNCTION" ] 4150 -
4151 [ "sys", "functions", "name", "sys", "dependencies_views_on_functions", "FUNCTION" ] 4151 4046 [ "sys", "functions", "name", "sys", "dependencies_views_on_functions", "FUNCTION" ] 4046
4152 [ "sys", "functions", "schema_id", "sys", "dependencies_views_on_functions", "FUNCTION" ] 4152 -
4153 [ "sys", "functions", "side_effect", "sys", "dependencies_views_on_functions", "FUNCTION" ] 4153 -
4154 [ "sys", "functions", "type", "sys", "dependencies_views_on_functions", "FUNCTION" ] 4154 -
4155 [ "sys", "functions", "vararg", "sys", "dependencies_views_on_functions", "FUNCTION" ] 4155 -
4156 [ "sys", "functions", "varres", "sys", "dependencies_views_on_functions", "FUNCTION" ] 4156 -
4157 [ "sys", "dependencies", "depend_id", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 4157 4047 [ "sys", "dependencies", "depend_id", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 4047
..................
#select s1.name, t.name, c.name, s2.name
4159 [ "sys", "dependencies", "id", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 4159 4049 [ "sys", "dependencies", "id", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 4049
4160 [ "sys", "triggers", "condition", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 4160 -
4161 [ "sys", "triggers", "event", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 4161 -
4162 [ "sys", "triggers", "id", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 4162 4050 [ "sys", "triggers", "id", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 4050
4163 [ "sys", "triggers", "name", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 4163 4051 [ "sys", "triggers", "name", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 4051
4164 [ "sys", "triggers", "new_name", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 4164 -
4165 [ "sys", "triggers", "old_name", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 4165 -
4166 [ "sys", "triggers", "orientation", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 4166 -
4167 [ "sys", "triggers", "statement", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 4167 -
4168 [ "sys", "triggers", "table_id", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 4168 -
4169 [ "sys", "triggers", "time", "sys", "dependencies_views_on_triggers", "FUNCTION" ] 4169 -
4170 [ "sys", "spatial_ref_sys", "auth_name", "sys", "getproj4", "FUNCTION" ] 4170 -
4171 [ "sys", "spatial_ref_sys", "auth_srid", "sys", "getproj4", "FUNCTION" ] 4171 -
4172 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 4172 4052 [ "sys", "spatial_ref_sys", "proj4text", "sys", "getproj4", "FUNCTION" ] 4052
4173 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 4173 4053 [ "sys", "spatial_ref_sys", "srid", "sys", "getproj4", "FUNCTION" ] 4053
4174 [ "sys", "spatial_ref_sys", "srtext", "sys", "getproj4", "FUNCTION" ] 4174 -
4175 [ "sys", "storagemodelinput", "atomwidth", "sys", "storagemodel", "FUNCTION" ] 4175 4054 [ "sys", "storagemodelinput", "atomwidth", "sys", "storagemodel", "FUNCTION" ] 4054
..................
#select s1.name, f1.name, s2.name, t2.na
4218 % varchar, varchar, varchar, varchar, varchar # type 4218 4097 % varchar, varchar, varchar, varchar, varchar # type 4097
4219 % 3, 8, 3, 16, 4 # length 4219 ! 4098 % 3, 16, 3, 16, 4 # length 4098
4220 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 4220 4099 [ "sys", "get_type", "sys", "geometry_columns", "VIEW" ] 4099
..................
#select s1.name, f1.name, s2.name, t2.na
4222 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 4222 4101 [ "sys", "has_z", "sys", "geometry_columns", "VIEW" ] 4101
+ 4102 [ "sys", "optimizers", "sys", "optimizers", "VIEW" ] 4102
+ 4103 [ "sys", "querylog_catalog", "sys", "querylog_catalog", "VIEW" ] 4103
+ 4104 [ "sys", "queue", "sys", "queue", "VIEW" ] 4104
+ 4105 [ "sys", "rejects", "sys", "rejects", "VIEW" ] 4105
+ 4106 [ "sys", "sessions", "sys", "sessions", "VIEW" ] 4106
+ 4107 [ "sys", "tracelog", "sys", "tracelog", "VIEW" ] 4107
4223 #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; 4223 4108 #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; 4108
..................
#select s1.name, t1.name, s2.name, t2.na
4238 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 4238 4123 [ "sys", "columns", "sys", "dependency_columns_on_indexes", "VIEW" ] 4123
4239 [ "sys", "idxs", "sys", "dependency_columns_on_indexes", "VIEW" ] 4239 -
4240 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 4240 4124 [ "sys", "keys", "sys", "dependency_columns_on_indexes", "VIEW" ] 4124
4241 [ "sys", "objects", "sys", "dependency_columns_on_indexes", "VIEW" ] 4241 -
4242 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 4242 4125 [ "sys", "tables", "sys", "dependency_columns_on_indexes", "VIEW" ] 4125
4243 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 4243 4126 [ "sys", "columns", "sys", "dependency_columns_on_keys", "VIEW" ] 4126
4244 [ "sys", "keys", "sys", "dependency_columns_on_keys", "VIEW" ] 4244 -
4245 [ "sys", "objects", "sys", "dependency_columns_on_keys", "VIEW" ] 4245 -
4246 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 4246 4127 [ "sys", "tables", "sys", "dependency_columns_on_keys", "VIEW" ] 4127
..................
#select s1.name, t1.name, s2.name, t2.na
4252 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 4252 4133 [ "sys", "tables", "sys", "dependency_columns_on_triggers", "VIEW" ] 4133
4253 [ "sys", "triggers", "sys", "dependency_columns_on_triggers", "VIEW" ] 4253 -
4254 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 4254 4134 [ "sys", "columns", "sys", "dependency_columns_on_types", "VIEW" ] 4134
..................
#select s1.name, t1.name, s2.name, t2.na
4266 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 4266 4146 [ "sys", "functions", "sys", "dependency_functions_on_triggers", "VIEW" ] 4146
4267 [ "sys", "triggers", "sys", "dependency_functions_on_triggers", "VIEW" ] 4267 -
4268 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 4268 4147 [ "sys", "dependencies", "sys", "dependency_functions_on_types", "VIEW" ] 4147
..................
#select s1.name, t1.name, s2.name, t2.na
4273 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 4273 4152 [ "sys", "tables", "sys", "dependency_functions_on_views", "VIEW" ] 4152
4274 [ "sys", "keys", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4274 -
4275 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 4275 4153 [ "sys", "auths", "sys", "dependency_owners_on_schemas", "VIEW" ] 4153
..................
#select s1.name, t1.name, s2.name, t2.na
4278 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 4278 4156 [ "sys", "users", "sys", "dependency_schemas_on_users", "VIEW" ] 4156
4279 [ "sys", "keys", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4279 -
4280 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4280 4157 [ "sys", "tables", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4157
..................
#select s1.name, t1.name, s2.name, t2.na
4283 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 4283 4160 [ "sys", "tables", "sys", "dependency_tables_on_functions", "VIEW" ] 4160
4284 [ "sys", "idxs", "sys", "dependency_tables_on_indexes", "VIEW" ] 4284 -
4285 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 4285 4161 [ "sys", "keys", "sys", "dependency_tables_on_indexes", "VIEW" ] 4161
..................
#select s1.name, t1.name, s2.name, t2.na
4291 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4291 4167 [ "sys", "tables", "sys", "dependency_tables_on_triggers", "VIEW" ] 4167
4292 [ "sys", "triggers", "sys", "dependency_tables_on_triggers", "VIEW" ] 4292 -
4293 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4293 4168 [ "sys", "dependencies", "sys", "dependency_tables_on_views", "VIEW" ] 4168
..................
#select s1.name, t1.name, s2.name, t2.na
4306 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4306 4181 [ "sys", "types", "sys", "geometry_columns", "VIEW" ] 4181
4307 [ "sys", "_columns", "sys", "ids", "VIEW" ] 4307 -
4308 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4308 4182 [ "sys", "_tables", "sys", "ids", "VIEW" ] 4182
..................
#select s1.name, t1.name, s2.name, t2.na
4311 [ "sys", "functions", "sys", "ids", "VIEW" ] 4311 4185 [ "sys", "functions", "sys", "ids", "VIEW" ] 4185
4312 [ "sys", "idxs", "sys", "ids", "VIEW" ] 4312 -
4313 [ "sys", "keys", "sys", "ids", "VIEW" ] 4313 4186 [ "sys", "keys", "sys", "ids", "VIEW" ] 4186
..................
#select s1.name, t1.name, s2.name, t2.na
4315 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4315 4188 [ "sys", "sequences", "sys", "ids", "VIEW" ] 4188
4316 [ "sys", "triggers", "sys", "ids", "VIEW" ] 4316 -
4317 [ "sys", "types", "sys", "ids", "VIEW" ] 4317 4189 [ "sys", "types", "sys", "ids", "VIEW" ] 4189
4318 [ "tmp", "_columns", "sys", "ids", "VIEW" ] 4318 -
4319 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4319 4190 [ "tmp", "_tables", "sys", "ids", "VIEW" ] 4190
4320 [ "tmp", "idxs", "sys", "ids", "VIEW" ] 4320 -
4321 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4321 4191 [ "tmp", "keys", "sys", "ids", "VIEW" ] 4191
4322 [ "tmp", "triggers", "sys", "ids", "VIEW" ] 4322 -
4323 [ "sys", "auths", "sys", "roles", "VIEW" ] 4323 4192 [ "sys", "auths", "sys", "roles", "VIEW" ] 4192
..................
#select s1.name, t1.name, c1.name, s2.na
4350 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4350 4219 [ "sys", "functions", "type", "sys", "dependency_columns_on_functions", "VIEW" ] 4219
4351 [ "sys", "idxs", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4351 ! 4220 [ "sys", "_columns", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4220
4352 [ "sys", "idxs", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4352 ! 4221 [ "sys", "_columns", "number", "sys", "dependency_columns_on_indexes", "VIEW" ] 4221
4353 [ "sys", "idxs", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4353 ! 4222 [ "sys", "_columns", "storage", "sys", "dependency_columns_on_indexes", "VIEW" ] 4222
4354 [ "sys", "idxs", "type", "sys", "dependency_columns_on_indexes", "VIEW" ] 4354 ! 4223 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4223
4355 [ "sys", "keys", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4355 ! 4224 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_indexes", "VIEW" ] 4224
+ 4225 [ "sys", "keys", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4225
4356 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4356 4226 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4226
4357 [ "sys", "objects", "id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4357 ! 4227 [ "sys", "triggers", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4227
4358 [ "sys", "objects", "name", "sys", "dependency_columns_on_indexes", "VIEW" ] 4358 ! 4228 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_indexes", "VIEW" ] 4228
4359 [ "sys", "objects", "nr", "sys", "dependency_columns_on_indexes", "VIEW" ] 4359 ! 4229 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_indexes", "VIEW" ] 4229
4360 [ "sys", "keys", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4360 ! 4230 [ "sys", "triggers", "time", "sys", "dependency_columns_on_indexes", "VIEW" ] 4230
4361 [ "sys", "keys", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4361 ! 4231 [ "sys", "_columns", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4231
4362 [ "sys", "keys", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4362 ! 4232 [ "sys", "_columns", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4232
4363 [ "sys", "keys", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4363 ! 4233 [ "sys", "_columns", "type", "sys", "dependency_columns_on_keys", "VIEW" ] 4233
4364 [ "sys", "objects", "id", "sys", "dependency_columns_on_keys", "VIEW" ] 4364 ! 4234 [ "sys", "_columns", "type_digits", "sys", "dependency_columns_on_keys", "VIEW" ] 4234
4365 [ "sys", "objects", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4365 ! 4235 [ "sys", "_columns", "type_scale", "sys", "dependency_columns_on_keys", "VIEW" ] 4235
4366 [ "sys", "objects", "nr", "sys", "dependency_columns_on_keys", "VIEW" ] 4366 ! 4236 [ "sys", "triggers", "name", "sys", "dependency_columns_on_keys", "VIEW" ] 4236
+ 4237 [ "sys", "triggers", "orientation", "sys", "dependency_columns_on_keys", "VIEW" ] 4237
+ 4238 [ "sys", "triggers", "table_id", "sys", "dependency_columns_on_keys", "VIEW" ] 4238
+ 4239 [ "sys", "triggers", "time", "sys", "dependency_columns_on_keys", "VIEW" ] 4239
4367 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4367 4240 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_procedures", "VIEW" ] 4240
..................
#select s1.name, t1.name, c1.name, s2.na
4375 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4375 4248 [ "sys", "dependencies", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4248
4376 [ "sys", "triggers", "id", "sys", "dependency_columns_on_triggers", "VIEW" ] 4376 ! 4249 [ "sys", "keys", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4249
4377 [ "sys", "triggers", "name", "sys", "dependency_columns_on_triggers", "VIEW" ] 4377 ! 4250 [ "sys", "keys", "rkey", "sys", "dependency_columns_on_triggers", "VIEW" ] 4250
+ 4251 [ "sys", "keys", "type", "sys", "dependency_columns_on_triggers", "VIEW" ] 4251
4378 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4378 4252 [ "sys", "dependencies", "depend_id", "sys", "dependency_columns_on_types", "VIEW" ] 4252
..................
#select s1.name, t1.name, c1.name, s2.na
4406 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4406 4280 [ "sys", "functions", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4280
4407 [ "sys", "triggers", "id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4407 ! 4281 [ "sys", "keys", "action", "sys", "dependency_functions_on_triggers", "VIEW" ] 4281
4408 [ "sys", "triggers", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4408 ! 4282 [ "sys", "keys", "name", "sys", "dependency_functions_on_triggers", "VIEW" ] 4282
4409 [ "sys", "triggers", "table_id", "sys", "dependency_functions_on_triggers", "VIEW" ] 4409 ! 4283 [ "sys", "keys", "rkey", "sys", "dependency_functions_on_triggers", "VIEW" ] 4283
+ 4284 [ "sys", "keys", "type", "sys", "dependency_functions_on_triggers", "VIEW" ] 4284
4410 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4410 4285 [ "sys", "dependencies", "depend_id", "sys", "dependency_functions_on_types", "VIEW" ] 4285
..................
#select s1.name, t1.name, c1.name, s2.na
4423 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4423 4298 [ "sys", "functions", "schema_id", "sys", "dependency_functions_on_views", "VIEW" ] 4298
4424 [ "sys", "keys", "id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4424 ! 4299 [ "sys", "_columns", "default", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4299
4425 [ "sys", "keys", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4425 ! 4300 [ "sys", "_columns", "name", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4300
4426 [ "sys", "keys", "rkey", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4426 ! 4301 [ "sys", "_columns", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4301
4427 [ "sys", "keys", "table_id", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4427 ! 4302 [ "sys", "_columns", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4302
4428 [ "sys", "keys", "type", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4428 ! 4303 [ "sys", "_columns", "type_digits", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4303
+ 4304 [ "sys", "_columns", "type_scale", "sys", "dependency_keys_on_foreignkeys", "VIEW" ] 4304
4429 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4429 4305 [ "sys", "auths", "id", "sys", "dependency_owners_on_schemas", "VIEW" ] 4305
..................
#select s1.name, t1.name, c1.name, s2.na
4435 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4435 4311 [ "sys", "schemas", "name", "sys", "dependency_schemas_on_users", "VIEW" ] 4311
4436 [ "sys", "keys", "id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4436 ! 4312 [ "sys", "_columns", "default", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4312
4437 [ "sys", "keys", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4437 ! 4313 [ "sys", "_columns", "name", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4313
4438 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4438 ! 4314 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4314
4439 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4439 ! 4315 [ "sys", "_columns", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4315
4440 [ "sys", "keys", "type", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4440 ! 4316 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4316
+ 4317 [ "sys", "_columns", "type_scale", "sys", "dependency_tables_on_foreignkeys", "VIEW" ] 4317
4441 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4441 4318 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_functions", "VIEW" ] 4318
..................
#select s1.name, t1.name, c1.name, s2.na
4446 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4446 4323 [ "sys", "functions", "type", "sys", "dependency_tables_on_functions", "VIEW" ] 4323
4447 [ "sys", "idxs", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4447 ! 4324 [ "sys", "_columns", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4324
4448 [ "sys", "idxs", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4448 ! 4325 [ "sys", "_columns", "number", "sys", "dependency_tables_on_indexes", "VIEW" ] 4325
4449 [ "sys", "idxs", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4449 ! 4326 [ "sys", "_columns", "storage", "sys", "dependency_tables_on_indexes", "VIEW" ] 4326
4450 [ "sys", "idxs", "type", "sys", "dependency_tables_on_indexes", "VIEW" ] 4450 ! 4327 [ "sys", "_columns", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4327
4451 [ "sys", "keys", "name", "sys", "dependency_tables_on_indexes", "VIEW" ] 4451 ! 4328 [ "sys", "_columns", "type_digits", "sys", "dependency_tables_on_indexes", "VIEW" ] 4328
+ 4329 [ "sys", "keys", "id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4329
4452 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4452 4330 [ "sys", "keys", "table_id", "sys", "dependency_tables_on_indexes", "VIEW" ] 4330
..................
#select s1.name, t1.name, c1.name, s2.na
4461 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4461 4339 [ "sys", "dependencies", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4339
4462 [ "sys", "triggers", "id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4462 ! 4340 [ "sys", "keys", "action", "sys", "dependency_tables_on_triggers", "VIEW" ] 4340
4463 [ "sys", "triggers", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4463 ! 4341 [ "sys", "keys", "name", "sys", "dependency_tables_on_triggers", "VIEW" ] 4341
4464 [ "sys", "triggers", "table_id", "sys", "dependency_tables_on_triggers", "VIEW" ] 4464 ! 4342 [ "sys", "keys", "rkey", "sys", "dependency_tables_on_triggers", "VIEW" ] 4342
+ 4343 [ "sys", "keys", "type", "sys", "dependency_tables_on_triggers", "VIEW" ] 4343
4465 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4465 4344 [ "sys", "dependencies", "depend_id", "sys", "dependency_tables_on_views", "VIEW" ] 4344
..................
#select s1.name, t1.name, c1.name, s2.na
4486 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4486 4365 [ "sys", "types", "systemname", "sys", "geometry_columns", "VIEW" ] 4365
+ 4366 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4366
4487 [ "sys", "_columns", "id", "sys", "ids", "VIEW" ] 4487 ! 4367 [ "sys", "_columns", "number", "sys", "ids", "VIEW" ] 4367
4488 [ "sys", "_columns", "name", "sys", "ids", "VIEW" ] 4488 ! 4368 [ "sys", "_columns", "storage", "sys", "ids", "VIEW" ] 4368
4489 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4489 4369 [ "sys", "_columns", "table_id", "sys", "ids", "VIEW" ] 4369
+ 4370 [ "sys", "_columns", "type", "sys", "ids", "VIEW" ] 4370
4490 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4490 -
4491 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4491 -
4492 [ "sys", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4492 ! 4371 [ "sys", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4371
+ 4372 [ "sys", "_tables", "id", "sys", "ids", "VIEW" ] 4372
+ 4373 [ "sys", "_tables", "name", "sys", "ids", "VIEW" ] 4373
4493 [ "sys", "_tables", "type", "sys", "ids", "VIEW" ] 4493 ! 4374 [ "sys", "_tables", "system", "sys", "ids", "VIEW" ] 4374
4494 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4494 4375 [ "sys", "args", "func_id", "sys", "ids", "VIEW" ] 4375
..................
#select s1.name, t1.name, c1.name, s2.na
4502 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4502 4383 [ "sys", "functions", "type", "sys", "ids", "VIEW" ] 4383
4503 [ "sys", "idxs", "id", "sys", "ids", "VIEW" ] 4503 ! 4384 [ "sys", "keys", "action", "sys", "ids", "VIEW" ] 4384
+ 4385 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4385
4504 [ "sys", "idxs", "name", "sys", "ids", "VIEW" ] 4504 ! 4386 [ "sys", "keys", "rkey", "sys", "ids", "VIEW" ] 4386
+ 4387 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4387
4505 [ "sys", "idxs", "table_id", "sys", "ids", "VIEW" ] 4505 ! 4388 [ "sys", "keys", "type", "sys", "ids", "VIEW" ] 4388
4506 [ "sys", "keys", "id", "sys", "ids", "VIEW" ] 4506 ! 4389 [ "sys", "objects", "id", "sys", "ids", "VIEW" ] 4389
4507 [ "sys", "keys", "name", "sys", "ids", "VIEW" ] 4507 -
4508 [ "sys", "keys", "table_id", "sys", "ids", "VIEW" ] 4508 -
4509 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4509 4390 [ "sys", "schemas", "id", "sys", "ids", "VIEW" ] 4390
..................
#select s1.name, t1.name, c1.name, s2.na
4513 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4513 4394 [ "sys", "sequences", "schema_id", "sys", "ids", "VIEW" ] 4394
4514 [ "sys", "triggers", "id", "sys", "ids", "VIEW" ] 4514 ! 4395 [ "sys", "triggers", "condition", "sys", "ids", "VIEW" ] 4395
4515 [ "sys", "triggers", "name", "sys", "ids", "VIEW" ] 4515 ! 4396 [ "sys", "triggers", "new_name", "sys", "ids", "VIEW" ] 4396
4516 [ "sys", "triggers", "table_id", "sys", "ids", "VIEW" ] 4516 ! 4397 [ "sys", "triggers", "old_name", "sys", "ids", "VIEW" ] 4397
+ 4398 [ "sys", "triggers", "statement", "sys", "ids", "VIEW" ] 4398
4517 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4517 4399 [ "sys", "types", "id", "sys", "ids", "VIEW" ] 4399
..................
#select s1.name, t1.name, c1.name, s2.na
4519 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4519 4401 [ "sys", "types", "sqlname", "sys", "ids", "VIEW" ] 4401
+ 4402 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4402
4520 [ "tmp", "_columns", "id", "sys", "ids", "VIEW" ] 4520 ! 4403 [ "tmp", "_columns", "number", "sys", "ids", "VIEW" ] 4403
4521 [ "tmp", "_columns", "name", "sys", "ids", "VIEW" ] 4521 -
4522 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4522 -
4523 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4523 -
4524 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4524 -
4525 [ "tmp", "_tables", "schema_id", "sys", "ids", "VIEW" ] 4525 ! 4404 [ "tmp", "_columns", "storage", "sys", "ids", "VIEW" ] 4404
+ 4405 [ "tmp", "_columns", "table_id", "sys", "ids", "VIEW" ] 4405
4526 [ "tmp", "_tables", "type", "sys", "ids", "VIEW" ] 4526 ! 4406 [ "tmp", "_columns", "type", "sys", "ids", "VIEW" ] 4406
4527 [ "tmp", "idxs", "id", "sys", "ids", "VIEW" ] 4527 ! 4407 [ "tmp", "_columns", "type_digits", "sys", "ids", "VIEW" ] 4407
+ 4408 [ "tmp", "_tables", "id", "sys", "ids", "VIEW" ] 4408
+ 4409 [ "tmp", "_tables", "name", "sys", "ids", "VIEW" ] 4409
4528 [ "tmp", "idxs", "name", "sys", "ids", "VIEW" ] 4528 ! 4410 [ "tmp", "_tables", "system", "sys", "ids", "VIEW" ] 4410
4529 [ "tmp", "idxs", "table_id", "sys", "ids", "VIEW" ] 4529 ! 4411 [ "tmp", "keys", "action", "sys", "ids", "VIEW" ] 4411
+ 4412 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4412
4530 [ "tmp", "keys", "id", "sys", "ids", "VIEW" ] 4530 ! 4413 [ "tmp", "keys", "rkey", "sys", "ids", "VIEW" ] 4413
4531 [ "tmp", "keys", "name", "sys", "ids", "VIEW" ] 4531 -
4532 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4532 4414 [ "tmp", "keys", "table_id", "sys", "ids", "VIEW" ] 4414
4533 [ "tmp", "triggers", "id", "sys", "ids", "VIEW" ] 4533 ! 4415 [ "tmp", "keys", "type", "sys", "ids", "VIEW" ] 4415
4534 [ "tmp", "triggers", "name", "sys", "ids", "VIEW" ] 4534 -
4535 [ "tmp", "triggers", "table_id", "sys", "ids", "VIEW" ] 4535 -
4536 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4536 4416 [ "sys", "auths", "grantor", "sys", "roles", "VIEW" ] 4416
..................
#select f.name, a.name, pc.privilege_cod
4872 [ "degrees", "public", "EXECUTE", "monetdb", 0 ] 4872 4752 [ "degrees", "public", "EXECUTE", "monetdb", 0 ] 4752
4873 [ "env", "public", "EXECUTE", NULL, 0 ] 4873 -
4874 [ "epoch", "public", "EXECUTE", "monetdb", 0 ] 4874 4753 [ "epoch", "public", "EXECUTE", "monetdb", 0 ] 4753
..................
#select f.name from sys.systemfunctions
5482 [ "levenshtein" ] 5482 5361 [ "levenshtein" ] 5361
5483 [ "lidarattach" ] 5483 -
5484 [ "lidarexport" ] 5484 -
5485 [ "lidarload" ] 5485 -
5486 [ "like" ] 5486 5362 [ "like" ] 5362
..................
#select f.name from sys.systemfunctions
6362 [ "settimeout" ] 6362 6238 [ "settimeout" ] 6238
6363 [ "shpattach" ] 6363 -
6364 [ "shpload" ] 6364 -
6365 [ "shpload" ] 6365 -
6366 [ "shrink" ] 6366 6239 [ "shrink" ] 6239
..................
# .t, .g, .L4, .L6, .L10,
6937 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 6937 6810 % 7, 21, 10, 9, 6, 0, 0, 0, 110 # length 6810
6938 [ "_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();" ] 6938 ! 6811 [ 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();" ] 6811
6939 [ "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();" ] 6939 6812 [ "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();" ] 6812