Changeset: f23afaadf652 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f23afaadf652 Modified Files: sql/test/Dependencies/Tests/dependency_DBobjects.test sql/test/Dependencies/Tests/dependency_loop.test sql/test/Dependencies/Tests/dependency_owner_schema_3.test Branch: default Log Message:
Approved output diffs (132 lines): diff --git a/sql/test/Dependencies/Tests/dependency_DBobjects.test b/sql/test/Dependencies/Tests/dependency_DBobjects.test --- a/sql/test/Dependencies/Tests/dependency_DBobjects.test +++ b/sql/test/Dependencies/Tests/dependency_DBobjects.test @@ -298,7 +298,7 @@ DEP_INDEX 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 ---- -273 values hashing to 5f62003db3521c560782b24e0f07db0d +279 values hashing to 4c42714c4678cb65faf29e6a113e146b query TTT rowsort SELECT c.name, tri.name, 'DEP_TRIGGER' from sys.columns as c, sys.triggers 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 @@ -328,6 +328,9 @@ DEP_FUNC dump_column_defaults dump_database DEP_FUNC +dump_column_grants +dump_database +DEP_FUNC dump_comments dump_database DEP_FUNC @@ -343,6 +346,9 @@ DEP_FUNC dump_foreign_keys dump_database DEP_FUNC +dump_function_grants +dump_database +DEP_FUNC dump_functions dump_database DEP_FUNC @@ -355,9 +361,6 @@ DEP_FUNC dump_partition_tables dump_database DEP_FUNC -dump_privileges -dump_database -DEP_FUNC dump_sequences dump_database DEP_FUNC @@ -367,6 +370,9 @@ DEP_FUNC dump_table_constraint_type dump_database DEP_FUNC +dump_table_grants +dump_database +DEP_FUNC dump_tables dump_database DEP_FUNC diff --git a/sql/test/Dependencies/Tests/dependency_loop.test b/sql/test/Dependencies/Tests/dependency_loop.test --- a/sql/test/Dependencies/Tests/dependency_loop.test +++ b/sql/test/Dependencies/Tests/dependency_loop.test @@ -174,5 +174,5 @@ UNION query I rowsort select count(*) from dependencies where depend_type = 5 ---- -988 +1080 diff --git a/sql/test/Dependencies/Tests/dependency_owner_schema_3.test b/sql/test/Dependencies/Tests/dependency_owner_schema_3.test --- 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 ---- -567 values hashing to 8b580f5d307e1080938ac3d092a712b1 +627 values hashing to ba31ce2ed151ea27b635fb7be420a269 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 @@ -126,7 +126,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 ---- -1986 values hashing to c139c99ef312a3411f9f4f0fc090e3de +2178 values hashing to 50df54353d1b5c45b536250115f70c64 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 @@ -190,7 +190,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 ---- -264 values hashing to 8de72aae52a67c02cd49a46842f5a171 +270 values hashing to cffffcc5c307d9fbc2f33b06858b20fa 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 @@ -208,6 +208,9 @@ DEP_FUNC dump_column_defaults dump_database DEP_FUNC +dump_column_grants +dump_database +DEP_FUNC dump_comments dump_database DEP_FUNC @@ -223,6 +226,9 @@ DEP_FUNC dump_foreign_keys dump_database DEP_FUNC +dump_function_grants +dump_database +DEP_FUNC dump_functions dump_database DEP_FUNC @@ -235,9 +241,6 @@ DEP_FUNC dump_partition_tables dump_database DEP_FUNC -dump_privileges -dump_database -DEP_FUNC dump_sequences dump_database DEP_FUNC @@ -247,6 +250,9 @@ DEP_FUNC dump_table_constraint_type dump_database DEP_FUNC +dump_table_grants +dump_database +DEP_FUNC dump_tables dump_database DEP_FUNC _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
