Mercurial > hg > MonetDB
changeset 86130:8f96e8f80079 userprofile
Approve test.
| author | Sjoerd Mullender <sjoerd@acm.org> |
|---|---|
| date | Wed, 20 Jul 2022 16:29:30 +0200 |
| parents | 48c729f50515 |
| children | 76dbc360494f |
| files | sql/test/Dependencies/Tests/dependency_owner_schema_3.test |
| diffstat | 1 files changed, 6 insertions(+), 3 deletions(-) [+] |
line wrap: on
line diff
--- a/sql/test/Dependencies/Tests/dependency_owner_schema_3.test +++ b/sql/test/Dependencies/Tests/dependency_owner_schema_3.test @@ -48,7 +48,7 @@ DEP_SCHEMA query TTT rowsort SELECT t.name, v.name, 'DEP_VIEW' from sys.tables as t, sys.tables as v, sys.dependencies as dep where t.id = dep.id AND v.id = dep.depend_id AND dep.depend_type = 5 AND v.type in (1, 11, 21, 31) order by t.name, v.name ---- -654 values hashing to 75fcd59f98bb9c99829c223f28561712 +654 values hashing to c1625b745d5b152775c4672ef35a4978 query TTT rowsort SELECT t.name, i.name, 'DEP_INDEX' from sys.tables as t, sys.idxs as i where i.table_id = t.id and i.name not in (select name from sys.keys) and t.type in (0, 10, 20, 30) order by t.name, i.name @@ -89,6 +89,9 @@ DEP_FUNC comments describe_table DEP_FUNC +db_user_info +db_users +DEP_FUNC dump_statements dump_database DEP_FUNC @@ -126,7 +129,7 @@ DEP_FUNC query TTT rowsort SELECT c.name, v.name, 'DEP_VIEW' from sys.columns as c, sys.tables as v, sys.dependencies as dep where c.id = dep.id AND v.id = dep.depend_id AND dep.depend_type = 5 AND v.type in (1, 11, 21, 31) order by c.name, v.name ---- -2292 values hashing to 5a1f740e3400c356cbaba50c980ca188 +2289 values hashing to e640ec7c86f357c8f9135af496fc3b2b query TTT rowsort SELECT c.name, k.name, 'DEP_KEY' from sys.columns as c, sys.objects as kc, sys.keys as k where kc."name" = c.name AND kc.id = k.id AND k.table_id = c.table_id AND k.rkey = -1 order by c.name, k.name @@ -193,7 +196,7 @@ SELECT c.name, i.name, 'DEP_INDEX' from query TTT rowsort SELECT c.name, f.name, 'DEP_FUNC' from sys.functions as f, sys.columns as c, sys.dependencies as dep where c.id = dep.id AND f.id = dep.depend_id AND dep.depend_type = 7 ORDER BY c.name, f.name ---- -270 values hashing to cffffcc5c307d9fbc2f33b06858b20fa +273 values hashing to 9ef14ef0bd961ee521581c23fdc30a09 query TTT rowsort SELECT c.name, tri.name, 'DEP_TRIGGER' from sys.columns as c, sys.objects as tri, sys.dependencies as dep where dep.id = c.id AND dep.depend_id =tri.id AND dep.depend_type = 8 order by c.name, tri.name
