Changeset: e2fec4c6f0a7 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/e2fec4c6f0a7 Modified Files: sql/test/Dependencies/Tests/dependency_owner_schema_3.test Branch: default Log Message:
Changes dependency tests for new describe sql script func diffs (truncated from 1006 to 300 lines): 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 @@ -1,3 +1,5 @@ +hash-threshold 1000 + statement ok ALTER USER "monet_test" SET SCHEMA "sys" @@ -42,7 +44,678 @@ 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 c1625b745d5b152775c4672ef35a4978 +_columns +columns +DEP_VIEW +_columns +columns +DEP_VIEW +_columns +describe_indices +DEP_VIEW +_columns +describe_tables +DEP_VIEW +_columns +ids +DEP_VIEW +_columns +ids +DEP_VIEW +_tables +describe_comments +DEP_VIEW +_tables +describe_constraints +DEP_VIEW +_tables +describe_foreign_keys +DEP_VIEW +_tables +describe_indices +DEP_VIEW +_tables +describe_partition_tables +DEP_VIEW +_tables +ids +DEP_VIEW +_tables +ids +DEP_VIEW +_tables +tables +DEP_VIEW +_tables +tables +DEP_VIEW +args +dependency_args_on_types +DEP_VIEW +args +describe_functions +DEP_VIEW +args +dump_function_grants +DEP_VIEW +args +fully_qualified_functions +DEP_VIEW +args +ids +DEP_VIEW +auths +dependency_owners_on_schemas +DEP_VIEW +auths +describe_privileges +DEP_VIEW +auths +dump_column_grants +DEP_VIEW +auths +dump_create_roles +DEP_VIEW +auths +dump_create_schemas +DEP_VIEW +auths +dump_function_grants +DEP_VIEW +auths +dump_grant_user_privileges +DEP_VIEW +auths +dump_table_grants +DEP_VIEW +auths +ids +DEP_VIEW +auths +roles +DEP_VIEW +columns +dependency_columns_on_functions +DEP_VIEW +columns +dependency_columns_on_indexes +DEP_VIEW +columns +dependency_columns_on_keys +DEP_VIEW +columns +dependency_columns_on_procedures +DEP_VIEW +columns +dependency_columns_on_triggers +DEP_VIEW +columns +dependency_columns_on_types +DEP_VIEW +columns +dependency_columns_on_views +DEP_VIEW +columns +describe_column_defaults +DEP_VIEW +columns +describe_comments +DEP_VIEW +columns +describe_privileges +DEP_VIEW +columns +dump_column_grants +DEP_VIEW +columns +geometry_columns +DEP_VIEW +comments +describe_comments +DEP_VIEW +db_user_info +dependency_schemas_on_users +DEP_VIEW +db_user_info +dump_add_schemas_to_users +DEP_VIEW +db_user_info +dump_create_roles +DEP_VIEW +db_user_info +dump_create_users +DEP_VIEW +db_user_info +roles +DEP_VIEW +db_user_info +users +DEP_VIEW +dependencies +dependencies_vw +DEP_VIEW +dependencies +dependency_args_on_types +DEP_VIEW +dependencies +dependency_columns_on_functions +DEP_VIEW +dependencies +dependency_columns_on_procedures +DEP_VIEW +dependencies +dependency_columns_on_triggers +DEP_VIEW +dependencies +dependency_columns_on_types +DEP_VIEW +dependencies +dependency_columns_on_views +DEP_VIEW +dependencies +dependency_functions_on_functions +DEP_VIEW +dependencies +dependency_functions_on_procedures +DEP_VIEW +dependencies +dependency_functions_on_triggers +DEP_VIEW +dependencies +dependency_functions_on_types +DEP_VIEW +dependencies +dependency_functions_on_views +DEP_VIEW +dependencies +dependency_tables_on_functions +DEP_VIEW +dependencies +dependency_tables_on_procedures +DEP_VIEW +dependencies +dependency_tables_on_triggers +DEP_VIEW +dependencies +dependency_tables_on_views +DEP_VIEW +dependencies +dependency_views_on_functions +DEP_VIEW +dependencies +dependency_views_on_procedures +DEP_VIEW +dependencies +dependency_views_on_views +DEP_VIEW +dependencies +describe_partition_tables +DEP_VIEW +dependency_types +dependencies_vw +DEP_VIEW +describe_column_defaults +dump_column_defaults +DEP_VIEW +describe_comments +dump_comments +DEP_VIEW +describe_constraints +dump_table_constraint_type +DEP_VIEW +describe_foreign_keys +dump_foreign_keys +DEP_VIEW +describe_functions +dump_functions +DEP_VIEW +describe_indices +dump_indices +DEP_VIEW +describe_partition_tables +dump_partition_tables +DEP_VIEW +describe_sequences +dump_sequences +DEP_VIEW +describe_sequences +dump_start_sequences +DEP_VIEW +describe_tables +dump_tables +DEP_VIEW +describe_triggers +dump_triggers +DEP_VIEW +describe_user_defined_types +dump_user_defined_types +DEP_VIEW +fkey_actions +fkeys +DEP_VIEW +fully_qualified_functions +describe_comments +DEP_VIEW +fully_qualified_functions +describe_privileges +DEP_VIEW +function_languages +describe_functions +DEP_VIEW +function_types +describe_comments +DEP_VIEW +function_types +describe_functions +DEP_VIEW +function_types +dump_function_grants +DEP_VIEW +function_types +fully_qualified_functions +DEP_VIEW +function_types +ids +DEP_VIEW +functions +dependency_args_on_types +DEP_VIEW +functions +dependency_columns_on_functions +DEP_VIEW +functions +dependency_columns_on_procedures +DEP_VIEW +functions +dependency_functions_on_functions +DEP_VIEW +functions _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
