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