Changeset: c4097969d6a5 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c4097969d6a5
Modified Files:
clients/Tests/SQL-dump.SQL.py
clients/Tests/SQL-dump.stable.out
clients/Tests/SQL-dump.stable.out.int128
sql/test/emptydb-upgrade-chain-hge/Tests/check.stable.out.int128
sql/test/emptydb-upgrade-chain/Tests/check.stable.out
sql/test/emptydb-upgrade-chain/Tests/check.stable.out.int128
sql/test/emptydb-upgrade-hge/Tests/check.stable.out.int128
sql/test/emptydb-upgrade/Tests/check.stable.out
sql/test/emptydb-upgrade/Tests/check.stable.out.int128
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.int128
Branch: Jun2016
Log Message:
Check contents of sys.dependencies table.
diffs (truncated from 3856 to 300 lines):
diff --git a/clients/Tests/SQL-dump.SQL.py b/clients/Tests/SQL-dump.SQL.py
--- a/clients/Tests/SQL-dump.SQL.py
+++ b/clients/Tests/SQL-dump.SQL.py
@@ -81,7 +81,15 @@ select server, port, db, db_alias, user,
-- db_user_info
select u.name, u.fullname, s.name from sys.db_user_info u left outer join
sys.schemas s on u.default_schema = s.id order by u.name;
-- dependencies
-select count(*) from sys.dependencies;
+select s1.name, f1.name, s2.name, f2.name from sys.dependencies d,
sys.functions f1, sys.functions f2, sys.schemas s1, sys.schemas s2 where d.id =
f1.id and d.depend_id = f2.id and f1.schema_id = s1.id and f2.schema_id = s2.id
order by s2.name, f2.name, s1.name, f1.name;
+select s1.name, t.name, s2.name, f.name from sys.dependencies d, sys._tables
t, sys.schemas s1, sys.functions f, sys.schemas s2 where d.id = t.id and
d.depend_id = f.id and t.schema_id = s1.id and f.schema_id = s2.id order by
s2.name, f.name, s1.name, t.name;
+select s1.name, t.name, c.name, s2.name, f.name from sys.dependencies d,
sys._columns c, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2
where d.id = c.id and d.depend_id = f.id and c.table_id = t.id and t.schema_id
= s1.id and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name,
c.name;
+select s1.name, f1.name, s2.name, t2.name from schemas s1, functions f1,
schemas s2, _tables t2, dependencies d where d.id = f1.id and f1.schema_id =
s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name,
t2.name, s1.name, f1.name;
+select s1.name, t1.name, s2.name, t2.name from schemas s1, _tables t1, schemas
s2, _tables t2, dependencies d 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;
+select s1.name, t1.name, c1.name, s2.name, t2.name from schemas s1, _tables
t1, _columns c1, schemas s2, _tables t2, dependencies d where d.id = c1.id and
c1.table_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;
+select s1.name, t1.name, c1.name, s2.name, t2.name, k2.name from dependencies
d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, keys k2 where
d.id = c1.id and d.depend_id = k2.id and c1.table_id = t1.id and t1.schema_id =
s1.id and k2.table_id = t2.id and t2.schema_id = s2.id order by s2.name,
t2.name, k2.name, s1.name, t1.name, c1.name;
+select s1.name, t1.name, c1.name, s2.name, t2.name, i2.name from dependencies
d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, idxs i2 where
d.id = c1.id and d.depend_id = i2.id and c1.table_id = t1.id and t1.schema_id =
s1.id and i2.table_id = t2.id and t2.schema_id = s2.id order by s2.name,
t2.name, i2.name, s1.name, t1.name, c1.name;
+select t.systemname, t.sqlname, s.name, f.name from types t, functions f,
schemas s, dependencies d where d.id = t.id and d.depend_id = f.id and
f.schema_id = s.id order by s.name, f.name, t.systemname, t.sqlname;
-- idxs
select t.name, i.name, i.type from sys.idxs i left outer join sys._tables t on
t.id = i.table_id order by t.name, i.name;
-- keys
diff --git a/clients/Tests/SQL-dump.stable.out
b/clients/Tests/SQL-dump.stable.out
--- a/clients/Tests/SQL-dump.stable.out
+++ b/clients/Tests/SQL-dump.stable.out
@@ -927,12 +927,6 @@ create function sys.hashsize(b boolean,
create function sys.heapsize(tpe string, i bigint, w int) returns bigint begin
if tpe <> 'varchar' and tpe <> 'clob' then return 0; end if; return 10240 + i *
w; end;
create function "host" (p inet) returns clob external name inet."host";
create function "hostmask" (p inet) returns inet external name inet."hostmask";
-ilike
-ilike
-ilike
-ilike
-ilike
-ilike
create filter function "ilike"(val string, pat string, esc string) external
name algebra."ilike";
create filter function "ilike"(val string, pat string) external name
algebra."ilike";
create function sys.imprintsize(i bigint, nme string) returns bigint begin if
nme = 'boolean' or nme = 'tinyint' or nme = 'smallint' or nme = 'int' or nme =
'bigint' or nme = 'hugeint' or nme = 'decimal' or nme = 'date' or nme =
'timestamp' or nme = 'real' or nme = 'double' then return cast(i * 0.12 as
bigint); end if ; return 0; end;
@@ -940,26 +934,8 @@ create function internaltransform(geom g
create function isaurl(theurl url) returns bool external name url."isaURL";
create function sys.isauuid(u uuid) returns uuid external name uuid."isaUUID";
create function sys.isauuid(u string) returns uuid external name
uuid."isaUUID";
-mbrLeft
-mbrLeft
-<<
-<<
-<<
-<<
-<<
-<<
-<<
-<<
-<<
-<<
create function "left_shift"(i1 inet, i2 inet) returns boolean external name
inet."<<";
create function "left_shift_assign"(i1 inet, i2 inet) returns boolean external
name inet."<<=";
-like
-like
-like
-like
-like
-like
create filter function "like"(val string, pat string, esc string) external
name algebra."like";
create filter function "like"(val string, pat string) external name
algebra."like";
@@ -1022,18 +998,6 @@ create procedure sys.resume(tag int) ext
create procedure sys.resume(tag bigint) external name sql.sysmon_resume;
create procedure reuse(sys string, tab string) external name sql.reuse;
create function reverse(src string) returns string external name udf.reverse;
-mbrRight
-mbrRight
->>
->>
->>
->>
->>
->>
->>
->>
->>
->>
create function "right_shift"(i1 inet, i2 inet) returns boolean external name
inet.">>";
create function "right_shift_assign"(i1 inet, i2 inet) returns boolean
external name inet.">>=";
create function sys.sessions() returns table("user" string, "login" timestamp,
"sessiontimeout" bigint, "lastcommand" timestamp, "querytimeout" bigint,
"active" bool) external name sql.sessions;
@@ -1247,7 +1211,15 @@ select server, port, db, db_alias, user,
-- db_user_info
select u.name, u.fullname, s.name from sys.db_user_info u left outer join
sys.schemas s on u.default_schema = s.id order by u.name;
-- dependencies
-select count(*) from sys.dependencies;
+select s1.name, f1.name, s2.name, f2.name from sys.dependencies d,
sys.functions f1, sys.functions f2, sys.schemas s1, sys.schemas s2 where d.id =
f1.id and d.depend_id = f2.id and f1.schema_id = s1.id and f2.schema_id = s2.id
order by s2.name, f2.name, s1.name, f1.name;
+select s1.name, t.name, s2.name, f.name from sys.dependencies d, sys._tables
t, sys.schemas s1, sys.functions f, sys.schemas s2 where d.id = t.id and
d.depend_id = f.id and t.schema_id = s1.id and f.schema_id = s2.id order by
s2.name, f.name, s1.name, t.name;
+select s1.name, t.name, c.name, s2.name, f.name from sys.dependencies d,
sys._columns c, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2
where d.id = c.id and d.depend_id = f.id and c.table_id = t.id and t.schema_id
= s1.id and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name,
c.name;
+select s1.name, f1.name, s2.name, t2.name from schemas s1, functions f1,
schemas s2, _tables t2, dependencies d where d.id = f1.id and f1.schema_id =
s1.id and d.depend_id = t2.id and t2.schema_id = s2.id order by s2.name,
t2.name, s1.name, f1.name;
+select s1.name, t1.name, s2.name, t2.name from schemas s1, _tables t1, schemas
s2, _tables t2, dependencies d 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;
+select s1.name, t1.name, c1.name, s2.name, t2.name from schemas s1, _tables
t1, _columns c1, schemas s2, _tables t2, dependencies d where d.id = c1.id and
c1.table_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;
+select s1.name, t1.name, c1.name, s2.name, t2.name, k2.name from dependencies
d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, keys k2 where
d.id = c1.id and d.depend_id = k2.id and c1.table_id = t1.id and t1.schema_id =
s1.id and k2.table_id = t2.id and t2.schema_id = s2.id order by s2.name,
t2.name, k2.name, s1.name, t1.name, c1.name;
+select s1.name, t1.name, c1.name, s2.name, t2.name, i2.name from dependencies
d, _tables t1, _tables t2, schemas s1, schemas s2, _columns c1, idxs i2 where
d.id = c1.id and d.depend_id = i2.id and c1.table_id = t1.id and t1.schema_id =
s1.id and i2.table_id = t2.id and t2.schema_id = s2.id order by s2.name,
t2.name, i2.name, s1.name, t1.name, c1.name;
+select t.systemname, t.sqlname, s.name, f.name from types t, functions f,
schemas s, dependencies d where d.id = t.id and d.depend_id = f.id and
f.schema_id = s.id order by s.name, f.name, t.systemname, t.sqlname;
-- idxs
select t.name, i.name, i.type from sys.idxs i left outer join sys._tables t on
t.id = i.table_id order by t.name, i.name;
-- keys
@@ -7989,12 +7961,358 @@ drop function pcre_replace(string, strin
% varchar, varchar, varchar # type
% 7, 13, 3 # length
[ "monetdb", "MonetDB Admin", "sys" ]
-#select count(*) from sys.dependencies;
-% sys.L1 # table_name
-% L1 # name
-% wrd # type
-% 3 # length
-[ 310 ]
+#select s1.name, f1.name, s2.name, f2.name from sys.dependencies d,
sys.functions f1, sys.functions f2, sys.schemas s1, sys.schemas s2 where d.id =
f1.id and d.depend_id = f2.id and f1.schema_id = s1.id and f2.schema_id = s2.id
order by s2.name, f2.name, s1.name, f1.name;
+% sys.s1, sys.f1, sys.s2, sys.f2 # table_name
+% name, name, name, name # name
+% varchar, varchar, varchar, varchar # type
+% 3, 17, 3, 31 # length
+[ "sys", "=", "sys", "columnsize" ]
+[ "sys", "left_shift", "sys", "columnsize" ]
+[ "sys", "sql_mul", "sys", "columnsize" ]
+[ "sys", "pi", "sys", "degrees" ]
+[ "sys", "sql_div", "sys", "degrees" ]
+[ "sys", "sql_mul", "sys", "degrees" ]
+[ "sys", "=", "sys", "dependencies_columns_on_indexes" ]
+[ "sys", "hash", "sys", "dependencies_columns_on_indexes" ]
+[ "sys", "rotate_xor_hash", "sys",
"dependencies_columns_on_indexes" ]
+[ "sys", "=", "sys", "dependencies_columns_on_keys" ]
+[ "sys", "hash", "sys", "dependencies_columns_on_keys" ]
+[ "sys", "rotate_xor_hash", "sys", "dependencies_columns_on_keys"
]
+[ "sys", "sql_neg", "sys", "dependencies_columns_on_keys" ]
+[ "sys", "zero_or_one", "sys", "getproj4" ]
+[ "sys", "=", "sys", "hashsize" ]
+[ "sys", "sql_mul", "sys", "hashsize" ]
+[ "sys", "<>", "sys", "heapsize" ]
+[ "sys", "and", "sys", "heapsize" ]
+[ "sys", "sql_add", "sys", "heapsize" ]
+[ "sys", "sql_mul", "sys", "heapsize" ]
+[ "sys", "=", "sys", "imprintsize" ]
+[ "sys", "or", "sys", "imprintsize" ]
+[ "sys", "sql_mul", "sys", "imprintsize" ]
+[ "sys", "=", "sys", "ms_round" ]
+[ "sys", "isnull", "sys", "ms_round" ]
+[ "sys", "ms_trunc", "sys", "ms_round" ]
+[ "sys", "not", "sys", "ms_round" ]
+[ "sys", "or", "sys", "ms_round" ]
+[ "sys", "round", "sys", "ms_round" ]
+[ "sys", "<", "sys", "ms_stuff" ]
+[ "sys", ">", "sys", "ms_stuff" ]
+[ "sys", "concat", "sys", "ms_stuff" ]
+[ "sys", "length", "sys", "ms_stuff" ]
+[ "sys", "or", "sys", "ms_stuff" ]
+[ "sys", "sql_add", "sys", "ms_stuff" ]
+[ "sys", "sql_sub", "sys", "ms_stuff" ]
+[ "sys", "substring", "sys", "ms_stuff" ]
+[ "sys", "pi", "sys", "radians" ]
+[ "sys", "sql_div", "sys", "radians" ]
+[ "sys", "sql_mul", "sys", "radians" ]
+[ "sys", "st_numgeometries", "sys", "st_numpatches" ]
+[ "sys", "st_geometryn", "sys", "st_patchn" ]
+[ "sys", "getproj4", "sys", "st_transform" ]
+[ "sys", "internaltransform", "sys", "st_transform" ]
+[ "sys", "isnull", "sys", "st_transform" ]
+[ "sys", "not", "sys", "st_transform" ]
+[ "sys", "or", "sys", "st_transform" ]
+[ "sys", "st_srid", "sys", "st_transform" ]
+[ "sys", "columnsize", "sys", "storagemodel" ]
+[ "sys", "hashsize", "sys", "storagemodel" ]
+[ "sys", "heapsize", "sys", "storagemodel" ]
+[ "sys", "imprintsize", "sys", "storagemodel" ]
+#select s1.name, t.name, s2.name, f.name from sys.dependencies d, sys._tables
t, sys.schemas s1, sys.functions f, sys.schemas s2 where d.id = t.id and
d.depend_id = f.id and t.schema_id = s1.id and f.schema_id = s2.id order by
s2.name, f.name, s1.name, t.name;
+% sys.s1, sys.t, sys.s2, sys.f # table_name
+% name, name, name, name # name
+% varchar, varchar, varchar, varchar # type
+% 3, 17, 3, 35 # length
+[ "sys", "columns", "sys", "dependencies_columns_on_functions"
]
+[ "sys", "dependencies", "sys", "dependencies_columns_on_functions"
]
+[ "sys", "functions", "sys", "dependencies_columns_on_functions"
]
+[ "sys", "columns", "sys", "dependencies_columns_on_indexes"
]
+[ "sys", "idxs", "sys", "dependencies_columns_on_indexes" ]
+[ "sys", "keys", "sys", "dependencies_columns_on_indexes" ]
+[ "sys", "objects", "sys", "dependencies_columns_on_indexes"
]
+[ "sys", "columns", "sys", "dependencies_columns_on_keys" ]
+[ "sys", "keys", "sys", "dependencies_columns_on_keys" ]
+[ "sys", "objects", "sys", "dependencies_columns_on_keys" ]
+[ "sys", "columns", "sys", "dependencies_columns_on_triggers"
]
+[ "sys", "dependencies", "sys", "dependencies_columns_on_triggers"
]
+[ "sys", "triggers", "sys", "dependencies_columns_on_triggers"
]
+[ "sys", "columns", "sys", "dependencies_columns_on_views" ]
+[ "sys", "dependencies", "sys", "dependencies_columns_on_views" ]
+[ "sys", "tables", "sys", "dependencies_columns_on_views" ]
+[ "sys", "dependencies", "sys", "dependencies_functions_on_functions"
]
+[ "sys", "functions", "sys", "dependencies_functions_on_functions"
]
+[ "sys", "dependencies", "sys", "dependencies_functions_os_triggers"
]
+[ "sys", "functions", "sys", "dependencies_functions_os_triggers"
]
+[ "sys", "triggers", "sys", "dependencies_functions_os_triggers"
]
+[ "sys", "keys", "sys", "dependencies_keys_on_foreignkeys" ]
+[ "sys", "auths", "sys", "dependencies_owners_on_schemas"
]
+[ "sys", "schemas", "sys", "dependencies_owners_on_schemas"
]
+[ "sys", "schemas", "sys", "dependencies_schemas_on_users" ]
+[ "sys", "users", "sys", "dependencies_schemas_on_users" ]
+[ "sys", "keys", "sys", "dependencies_tables_on_foreignkeys" ]
+[ "sys", "tables", "sys", "dependencies_tables_on_foreignkeys"
]
+[ "sys", "dependencies", "sys", "dependencies_tables_on_functions"
]
+[ "sys", "functions", "sys", "dependencies_tables_on_functions"
]
+[ "sys", "tables", "sys", "dependencies_tables_on_functions"
]
+[ "sys", "idxs", "sys", "dependencies_tables_on_indexes" ]
+[ "sys", "keys", "sys", "dependencies_tables_on_indexes" ]
+[ "sys", "tables", "sys", "dependencies_tables_on_indexes"
]
+[ "sys", "dependencies", "sys", "dependencies_tables_on_triggers"
]
+[ "sys", "tables", "sys", "dependencies_tables_on_triggers"
]
+[ "sys", "triggers", "sys", "dependencies_tables_on_triggers"
]
+[ "sys", "dependencies", "sys", "dependencies_tables_on_views" ]
+[ "sys", "tables", "sys", "dependencies_tables_on_views" ]
+[ "sys", "dependencies", "sys", "dependencies_views_on_functions"
]
+[ "sys", "functions", "sys", "dependencies_views_on_functions"
]
+[ "sys", "tables", "sys", "dependencies_views_on_functions"
]
+[ "sys", "dependencies", "sys", "dependencies_views_on_triggers"
]
+[ "sys", "tables", "sys", "dependencies_views_on_triggers"
]
+[ "sys", "triggers", "sys", "dependencies_views_on_triggers"
]
+[ "sys", "spatial_ref_sys", "sys", "getproj4" ]
+[ "sys", "storagemodelinput", "sys", "storagemodel" ]
+[ "sys", "storagemodelinput", "sys", "storagemodelinit" ]
+#select s1.name, t.name, c.name, s2.name, f.name from sys.dependencies d,
sys._columns c, sys._tables t, sys.schemas s1, sys.functions f, sys.schemas s2
where d.id = c.id and d.depend_id = f.id and c.table_id = t.id and t.schema_id
= s1.id and f.schema_id = s2.id order by s2.name, f.name, s1.name, t.name,
c.name;
+% sys.s1, sys.t, sys.c, sys.s2, sys.f # table_name
+% name, name, name, name, name # name
+% varchar, varchar, varchar, varchar, varchar # type
+% 3, 17, 11, 3, 35 # length
+[ "sys", "dependencies", "depend_id", "sys",
"dependencies_columns_on_functions" ]
+[ "sys", "dependencies", "depend_type", "sys",
"dependencies_columns_on_functions" ]
+[ "sys", "dependencies", "id", "sys",
"dependencies_columns_on_functions" ]
+[ "sys", "functions", "id", "sys",
"dependencies_columns_on_functions" ]
+[ "sys", "functions", "name", "sys",
"dependencies_columns_on_functions" ]
+[ "sys", "idxs", "id", "sys", "dependencies_columns_on_indexes"
]
+[ "sys", "idxs", "name", "sys", "dependencies_columns_on_indexes"
]
+[ "sys", "idxs", "table_id", "sys",
"dependencies_columns_on_indexes" ]
+[ "sys", "keys", "name", "sys", "dependencies_columns_on_indexes"
]
+[ "sys", "objects", "id", "sys",
"dependencies_columns_on_indexes" ]
+[ "sys", "objects", "name", "sys",
"dependencies_columns_on_indexes" ]
+[ "sys", "keys", "id", "sys", "dependencies_columns_on_keys" ]
+[ "sys", "keys", "name", "sys", "dependencies_columns_on_keys" ]
+[ "sys", "keys", "rkey", "sys", "dependencies_columns_on_keys" ]
+[ "sys", "keys", "table_id", "sys", "dependencies_columns_on_keys"
]
+[ "sys", "objects", "id", "sys", "dependencies_columns_on_keys"
]
+[ "sys", "objects", "name", "sys", "dependencies_columns_on_keys"
]
+[ "sys", "dependencies", "depend_id", "sys",
"dependencies_columns_on_triggers" ]
+[ "sys", "dependencies", "depend_type", "sys",
"dependencies_columns_on_triggers" ]
+[ "sys", "dependencies", "id", "sys",
"dependencies_columns_on_triggers" ]
+[ "sys", "triggers", "id", "sys",
"dependencies_columns_on_triggers" ]
+[ "sys", "triggers", "name", "sys",
"dependencies_columns_on_triggers" ]
+[ "sys", "dependencies", "depend_id", "sys",
"dependencies_columns_on_views" ]
+[ "sys", "dependencies", "depend_type", "sys",
"dependencies_columns_on_views" ]
+[ "sys", "dependencies", "id", "sys", "dependencies_columns_on_views"
]
+[ "sys", "dependencies", "depend_id", "sys",
"dependencies_functions_on_functions" ]
+[ "sys", "dependencies", "depend_type", "sys",
"dependencies_functions_on_functions" ]
+[ "sys", "dependencies", "id", "sys",
"dependencies_functions_on_functions" ]
+[ "sys", "functions", "id", "sys",
"dependencies_functions_on_functions" ]
+[ "sys", "functions", "name", "sys",
"dependencies_functions_on_functions" ]
+[ "sys", "dependencies", "depend_id", "sys",
"dependencies_functions_os_triggers" ]
+[ "sys", "dependencies", "depend_type", "sys",
"dependencies_functions_os_triggers" ]
+[ "sys", "dependencies", "id", "sys",
"dependencies_functions_os_triggers" ]
+[ "sys", "functions", "id", "sys",
"dependencies_functions_os_triggers" ]
+[ "sys", "functions", "name", "sys",
"dependencies_functions_os_triggers" ]
+[ "sys", "triggers", "id", "sys",
"dependencies_functions_os_triggers" ]
+[ "sys", "triggers", "name", "sys",
"dependencies_functions_os_triggers" ]
+[ "sys", "keys", "id", "sys", "dependencies_keys_on_foreignkeys"
]
+[ "sys", "keys", "name", "sys", "dependencies_keys_on_foreignkeys"
]
+[ "sys", "keys", "rkey", "sys", "dependencies_keys_on_foreignkeys"
]
+[ "sys", "auths", "id", "sys",
"dependencies_owners_on_schemas" ]
+[ "sys", "auths", "name", "sys",
"dependencies_owners_on_schemas" ]
+[ "sys", "schemas", "name", "sys",
"dependencies_owners_on_schemas" ]
+[ "sys", "schemas", "owner", "sys",
"dependencies_owners_on_schemas" ]
+[ "sys", "schemas", "id", "sys", "dependencies_schemas_on_users"
]
+[ "sys", "schemas", "name", "sys", "dependencies_schemas_on_users"
]
+[ "sys", "keys", "id", "sys", "dependencies_tables_on_foreignkeys"
]
+[ "sys", "keys", "name", "sys", "dependencies_tables_on_foreignkeys"
]
+[ "sys", "keys", "rkey", "sys", "dependencies_tables_on_foreignkeys"
]
+[ "sys", "keys", "table_id", "sys",
"dependencies_tables_on_foreignkeys" ]
+[ "sys", "dependencies", "depend_id", "sys",
"dependencies_tables_on_functions" ]
+[ "sys", "dependencies", "depend_type", "sys",
"dependencies_tables_on_functions" ]
+[ "sys", "dependencies", "id", "sys",
"dependencies_tables_on_functions" ]
+[ "sys", "functions", "id", "sys",
"dependencies_tables_on_functions" ]
+[ "sys", "functions", "name", "sys",
"dependencies_tables_on_functions" ]
+[ "sys", "idxs", "name", "sys", "dependencies_tables_on_indexes"
]
+[ "sys", "idxs", "table_id", "sys",
"dependencies_tables_on_indexes" ]
+[ "sys", "keys", "name", "sys", "dependencies_tables_on_indexes"
]
+[ "sys", "dependencies", "depend_id", "sys",
"dependencies_tables_on_triggers" ]
+[ "sys", "dependencies", "depend_type", "sys",
"dependencies_tables_on_triggers" ]
+[ "sys", "dependencies", "id", "sys",
"dependencies_tables_on_triggers" ]
+[ "sys", "triggers", "id", "sys",
"dependencies_tables_on_triggers" ]
+[ "sys", "triggers", "name", "sys",
"dependencies_tables_on_triggers" ]
+[ "sys", "triggers", "table_id", "sys",
"dependencies_tables_on_triggers" ]
+[ "sys", "dependencies", "depend_id", "sys",
"dependencies_tables_on_views" ]
+[ "sys", "dependencies", "depend_type", "sys",
"dependencies_tables_on_views" ]
+[ "sys", "dependencies", "id", "sys", "dependencies_tables_on_views"
]
+[ "sys", "dependencies", "depend_id", "sys",
"dependencies_views_on_functions" ]
+[ "sys", "dependencies", "depend_type", "sys",
"dependencies_views_on_functions" ]
+[ "sys", "dependencies", "id", "sys",
"dependencies_views_on_functions" ]
+[ "sys", "functions", "id", "sys",
"dependencies_views_on_functions" ]
+[ "sys", "functions", "name", "sys",
"dependencies_views_on_functions" ]
+[ "sys", "dependencies", "depend_id", "sys",
"dependencies_views_on_triggers" ]
+[ "sys", "dependencies", "depend_type", "sys",
"dependencies_views_on_triggers" ]
+[ "sys", "dependencies", "id", "sys",
"dependencies_views_on_triggers" ]
+[ "sys", "triggers", "id", "sys",
"dependencies_views_on_triggers" ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
