Changeset: ef8da24bef1b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ef8da24bef1b Modified Files: sql/test/Dependencies/Tests/dependency_DBobjects.test sql/test/Dependencies/Tests/dependency_functions.test sql/test/Dependencies/Tests/dependency_loop.test sql/test/Dependencies/Tests/dependency_owner_schema_3.test Branch: monetdbe-proxy Log Message:
Approve dependency tests. diffs (truncated from 428 to 300 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 @@ -174,6 +174,12 @@ DEP_FUNC comments describe_table DEP_FUNC +dump_statements +current_size_dump_statements +DEP_FUNC +dump_statements +dump_database +DEP_FUNC function_languages describe_function DEP_FUNC @@ -198,6 +204,9 @@ DEP_FUNC t1 f2 DEP_FUNC +table_partitions +get_merge_table_partition_expressions +DEP_FUNC table_types describe_table DEP_FUNC @@ -292,7 +301,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 ---- -255 values hashing to e2d9a3e1109be2f236e4d7f734331ef0 +372 values hashing to 78fd640e374ca620ee5f10465e0caf4a 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 @@ -319,6 +328,63 @@ DEP_TRIGGER query TTT rowsort SELECT v.name, f.name, 'DEP_FUNC' from sys.functions as f, sys.tables as v, sys.dependencies as dep where v.id = dep.id AND f.id = dep.depend_id AND dep.depend_type = 7 AND v.type IN (1, 11) ORDER BY v.name, f.name ---- +columns +get_merge_table_partition_expressions +DEP_FUNC +dump_add_schemas_to_users +dump_database +DEP_FUNC +dump_column_defaults +dump_database +DEP_FUNC +dump_comments +dump_database +DEP_FUNC +dump_create_roles +dump_database +DEP_FUNC +dump_create_schemas +dump_database +DEP_FUNC +dump_create_users +dump_database +DEP_FUNC +dump_foreign_keys +dump_database +DEP_FUNC +dump_functions +dump_database +DEP_FUNC +dump_grant_user_priviledges +dump_database +DEP_FUNC +dump_indices +dump_database +DEP_FUNC +dump_partition_tables +dump_database +DEP_FUNC +dump_privileges +dump_database +DEP_FUNC +dump_sequences +dump_database +DEP_FUNC +dump_start_sequences +dump_database +DEP_FUNC +dump_table_constraint_type +dump_database +DEP_FUNC +dump_tables +dump_database +DEP_FUNC +dump_triggers +dump_database +DEP_FUNC +dump_user_defined_types +dump_database +DEP_FUNC v1 f2 DEP_FUNC @@ -334,12 +400,33 @@ SELECT v.name, tri.name, 'DEP_TRIGGER' f query TTT rowsort SELECT f1.name, f2.name, 'DEP_FUNC' from sys.functions as f1, sys.functions as f2, sys.dependencies as dep where f1.id = dep.id AND f2.id = dep.depend_id AND dep.depend_type = 7 order by f2.name, f1.name ---- +current_size_dump_statements +dump_database +DEP_FUNC describe_type describe_columns DEP_FUNC +dq +fqn +DEP_FUNC +dq +get_merge_table_partition_expressions +DEP_FUNC +dq +prepare_esc +DEP_FUNC +dump_table_data +dump_database +DEP_FUNC f1 f2 DEP_FUNC +fqn +alter_table +DEP_FUNC +fqn +schema_guard +DEP_FUNC getproj4 st_transform DEP_FUNC @@ -349,6 +436,15 @@ DEP_FUNC ms_trunc ms_round DEP_FUNC +remote_table_credentials +get_remote_table_expressions +DEP_FUNC +replace_first +schema_guard +DEP_FUNC +sq +get_remote_table_expressions +DEP_FUNC st_geometryn st_patchn DEP_FUNC diff --git a/sql/test/Dependencies/Tests/dependency_functions.test b/sql/test/Dependencies/Tests/dependency_functions.test --- a/sql/test/Dependencies/Tests/dependency_functions.test +++ b/sql/test/Dependencies/Tests/dependency_functions.test @@ -43,9 +43,24 @@ END query TTT rowsort SELECT f1.name, f2.name, 'DEP_FUNC' from sys.functions as f1, sys.functions as f2, sys.dependencies as dep where f1.id = dep.id AND f2.id = dep.depend_id AND dep.depend_type = 7 order by f2.name, f1.name ---- +current_size_dump_statements +dump_database +DEP_FUNC describe_type describe_columns DEP_FUNC +dq +fqn +DEP_FUNC +dq +get_merge_table_partition_expressions +DEP_FUNC +dq +prepare_esc +DEP_FUNC +dump_table_data +dump_database +DEP_FUNC f1 f2 DEP_FUNC @@ -55,6 +70,12 @@ DEP_FUNC f1 f3 DEP_FUNC +fqn +alter_table +DEP_FUNC +fqn +schema_guard +DEP_FUNC getproj4 st_transform DEP_FUNC @@ -64,6 +85,15 @@ DEP_FUNC ms_trunc ms_round DEP_FUNC +remote_table_credentials +get_remote_table_expressions +DEP_FUNC +replace_first +schema_guard +DEP_FUNC +sq +get_remote_table_expressions +DEP_FUNC st_geometryn st_patchn DEP_FUNC @@ -86,9 +116,30 @@ DROP ALL FUNCTION f1 query TTT rowsort SELECT f1.name, f2.name, 'DEP_FUNC' from sys.functions as f1, sys.functions as f2, sys.dependencies as dep where f1.id = dep.id AND f2.id = dep.depend_id AND dep.depend_type = 7 order by f2.name, f1.name ---- +current_size_dump_statements +dump_database +DEP_FUNC describe_type describe_columns DEP_FUNC +dq +fqn +DEP_FUNC +dq +get_merge_table_partition_expressions +DEP_FUNC +dq +prepare_esc +DEP_FUNC +dump_table_data +dump_database +DEP_FUNC +fqn +alter_table +DEP_FUNC +fqn +schema_guard +DEP_FUNC getproj4 st_transform DEP_FUNC @@ -98,6 +149,15 @@ DEP_FUNC ms_trunc ms_round DEP_FUNC +remote_table_credentials +get_remote_table_expressions +DEP_FUNC +replace_first +schema_guard +DEP_FUNC +sq +get_remote_table_expressions +DEP_FUNC st_geometryn st_patchn 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,6 +174,6 @@ UNION query I rowsort select count(*) from dependencies where depend_type = 5 ---- -585 +1001 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 ---- -324 values hashing to e020d09504870ef9571021d508055252 +564 values hashing to 2296fb6b8831002f7203b6982a75ac62 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,12 @@ DEP_FUNC comments describe_table DEP_FUNC +dump_statements +current_size_dump_statements +DEP_FUNC +dump_statements +dump_database +DEP_FUNC function_languages describe_function DEP_FUNC @@ -110,6 +116,9 @@ DEP_FUNC spatial_ref_sys getproj4 DEP_FUNC +table_partitions +get_merge_table_partition_expressions +DEP_FUNC table_types describe_table DEP_FUNC @@ -120,7 +129,7 @@ DEP_FUNC _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
