Changeset: 3b777efc61b7 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3b777efc61b7 Modified Files: sql/test/Dependencies/Tests/Dependencies.stable.out sql/test/Dependencies/dependency_DBobjects.sql sql/test/Dependencies/dependency_owner_schema_3.sql Branch: Feb2013 Log Message:
sort results to yield same deterministic output with any number of threads diffs (truncated from 516 to 300 lines): diff --git a/sql/test/Dependencies/Tests/Dependencies.stable.out b/sql/test/Dependencies/Tests/Dependencies.stable.out --- a/sql/test/Dependencies/Tests/Dependencies.stable.out +++ b/sql/test/Dependencies/Tests/Dependencies.stable.out @@ -199,100 +199,100 @@ Dependencies between database objects % varchar, varchar, varchar # type % 2, 8, 9 # length [ "id", "id_index", "DEP_INDEX" ] -#SELECT c.name, f.name,'DEP_FUNC' from functions as f, columns as c, dependencies as dep where c.id = dep.id AND f.id = dep.depend_id AND dep.depend_type = 7; -% .c, .f, .L1 # table_name -% name, name, L1 # name +#SELECT c.name, f.name, 'DEP_FUNC' from functions as f, columns as c, 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; +% .c, .f, . # table_name +% name, name, single_value # name % varchar, varchar, varchar # type % 11, 35, 8 # length -[ "id", "dependencies_owners_on_schemas", "DEP_FUNC" ] -[ "id", "dependencies_schemas_on_users", "DEP_FUNC" ] -[ "name", "dependencies_owners_on_schemas", "DEP_FUNC" ] -[ "name", "dependencies_schemas_on_users", "DEP_FUNC" ] -[ "owner", "dependencies_owners_on_schemas", "DEP_FUNC" ] -[ "id", "dependencies_functions_os_triggers", "DEP_FUNC" ] -[ "id", "dependencies_functions_on_functions", "DEP_FUNC" ] -[ "id", "dependencies_views_on_functions", "DEP_FUNC" ] -[ "id", "dependencies_columns_on_functions", "DEP_FUNC" ] -[ "id", "dependencies_tables_on_functions", "DEP_FUNC" ] -[ "name", "dependencies_functions_os_triggers", "DEP_FUNC" ] -[ "name", "dependencies_functions_on_functions", "DEP_FUNC" ] -[ "name", "dependencies_views_on_functions", "DEP_FUNC" ] -[ "name", "dependencies_columns_on_functions", "DEP_FUNC" ] -[ "name", "dependencies_tables_on_functions", "DEP_FUNC" ] -[ "id", "dependencies_functions_os_triggers", "DEP_FUNC" ] -[ "id", "dependencies_functions_on_functions", "DEP_FUNC" ] -[ "id", "dependencies_views_on_triggers", "DEP_FUNC" ] -[ "id", "dependencies_views_on_functions", "DEP_FUNC" ] -[ "id", "dependencies_columns_on_triggers", "DEP_FUNC" ] -[ "id", "dependencies_columns_on_functions", "DEP_FUNC" ] -[ "id", "dependencies_columns_on_views", "DEP_FUNC" ] -[ "id", "dependencies_tables_on_functions", "DEP_FUNC" ] -[ "id", "dependencies_tables_on_triggers", "DEP_FUNC" ] -[ "id", "dependencies_tables_on_views", "DEP_FUNC" ] +[ "atomwidth", "storagemodel", "DEP_FUNC" ] +[ "column", "storagemodel", "DEP_FUNC" ] +[ "count", "storagemodel", "DEP_FUNC" ] +[ "depend_id", "dependencies_columns_on_functions", "DEP_FUNC" ] +[ "depend_id", "dependencies_columns_on_triggers", "DEP_FUNC" ] +[ "depend_id", "dependencies_columns_on_views", "DEP_FUNC" ] +[ "depend_id", "dependencies_functions_on_functions", "DEP_FUNC" ] [ "depend_id", "dependencies_functions_os_triggers", "DEP_FUNC" ] -[ "depend_id", "dependencies_functions_on_functions", "DEP_FUNC" ] -[ "depend_id", "dependencies_views_on_triggers", "DEP_FUNC" ] -[ "depend_id", "dependencies_views_on_functions", "DEP_FUNC" ] -[ "depend_id", "dependencies_columns_on_triggers", "DEP_FUNC" ] -[ "depend_id", "dependencies_columns_on_functions", "DEP_FUNC" ] -[ "depend_id", "dependencies_columns_on_views", "DEP_FUNC" ] [ "depend_id", "dependencies_tables_on_functions", "DEP_FUNC" ] [ "depend_id", "dependencies_tables_on_triggers", "DEP_FUNC" ] [ "depend_id", "dependencies_tables_on_views", "DEP_FUNC" ] +[ "depend_id", "dependencies_views_on_functions", "DEP_FUNC" ] +[ "depend_id", "dependencies_views_on_triggers", "DEP_FUNC" ] +[ "depend_type", "dependencies_columns_on_functions", "DEP_FUNC" ] +[ "depend_type", "dependencies_columns_on_triggers", "DEP_FUNC" ] +[ "depend_type", "dependencies_columns_on_views", "DEP_FUNC" ] +[ "depend_type", "dependencies_functions_on_functions", "DEP_FUNC" ] [ "depend_type", "dependencies_functions_os_triggers", "DEP_FUNC" ] -[ "depend_type", "dependencies_functions_on_functions", "DEP_FUNC" ] -[ "depend_type", "dependencies_views_on_triggers", "DEP_FUNC" ] -[ "depend_type", "dependencies_views_on_functions", "DEP_FUNC" ] -[ "depend_type", "dependencies_columns_on_triggers", "DEP_FUNC" ] -[ "depend_type", "dependencies_columns_on_functions", "DEP_FUNC" ] -[ "depend_type", "dependencies_columns_on_views", "DEP_FUNC" ] [ "depend_type", "dependencies_tables_on_functions", "DEP_FUNC" ] [ "depend_type", "dependencies_tables_on_triggers", "DEP_FUNC" ] [ "depend_type", "dependencies_tables_on_views", "DEP_FUNC" ] +[ "depend_type", "dependencies_views_on_functions", "DEP_FUNC" ] +[ "depend_type", "dependencies_views_on_triggers", "DEP_FUNC" ] +[ "distinct", "storagemodel", "DEP_FUNC" ] +[ "id", "dependencies_columns_on_functions", "DEP_FUNC" ] +[ "id", "dependencies_columns_on_functions", "DEP_FUNC" ] +[ "id", "dependencies_columns_on_indexes", "DEP_FUNC" ] +[ "id", "dependencies_columns_on_indexes", "DEP_FUNC" ] +[ "id", "dependencies_columns_on_keys", "DEP_FUNC" ] +[ "id", "dependencies_columns_on_keys", "DEP_FUNC" ] +[ "id", "dependencies_columns_on_triggers", "DEP_FUNC" ] +[ "id", "dependencies_columns_on_triggers", "DEP_FUNC" ] +[ "id", "dependencies_columns_on_views", "DEP_FUNC" ] +[ "id", "dependencies_functions_on_functions", "DEP_FUNC" ] +[ "id", "dependencies_functions_on_functions", "DEP_FUNC" ] +[ "id", "dependencies_functions_os_triggers", "DEP_FUNC" ] +[ "id", "dependencies_functions_os_triggers", "DEP_FUNC" ] +[ "id", "dependencies_functions_os_triggers", "DEP_FUNC" ] [ "id", "dependencies_keys_on_foreignkeys", "DEP_FUNC" ] -[ "id", "dependencies_columns_on_keys", "DEP_FUNC" ] +[ "id", "dependencies_owners_on_schemas", "DEP_FUNC" ] +[ "id", "dependencies_owners_on_schemas", "DEP_FUNC" ] +[ "id", "dependencies_schemas_on_users", "DEP_FUNC" ] [ "id", "dependencies_tables_on_foreignkeys", "DEP_FUNC" ] +[ "id", "dependencies_tables_on_functions", "DEP_FUNC" ] +[ "id", "dependencies_tables_on_functions", "DEP_FUNC" ] +[ "id", "dependencies_tables_on_triggers", "DEP_FUNC" ] +[ "id", "dependencies_tables_on_triggers", "DEP_FUNC" ] +[ "id", "dependencies_tables_on_views", "DEP_FUNC" ] +[ "id", "dependencies_views_on_functions", "DEP_FUNC" ] +[ "id", "dependencies_views_on_functions", "DEP_FUNC" ] +[ "id", "dependencies_views_on_triggers", "DEP_FUNC" ] +[ "id", "dependencies_views_on_triggers", "DEP_FUNC" ] +[ "id", "f2", "DEP_FUNC" ] +[ "name", "dependencies_columns_on_functions", "DEP_FUNC" ] +[ "name", "dependencies_columns_on_indexes", "DEP_FUNC" ] +[ "name", "dependencies_columns_on_indexes", "DEP_FUNC" ] +[ "name", "dependencies_columns_on_indexes", "DEP_FUNC" ] +[ "name", "dependencies_columns_on_keys", "DEP_FUNC" ] +[ "name", "dependencies_columns_on_keys", "DEP_FUNC" ] +[ "name", "dependencies_columns_on_triggers", "DEP_FUNC" ] +[ "name", "dependencies_functions_on_functions", "DEP_FUNC" ] +[ "name", "dependencies_functions_os_triggers", "DEP_FUNC" ] +[ "name", "dependencies_functions_os_triggers", "DEP_FUNC" ] +[ "name", "dependencies_keys_on_foreignkeys", "DEP_FUNC" ] +[ "name", "dependencies_owners_on_schemas", "DEP_FUNC" ] +[ "name", "dependencies_owners_on_schemas", "DEP_FUNC" ] +[ "name", "dependencies_schemas_on_users", "DEP_FUNC" ] +[ "name", "dependencies_tables_on_foreignkeys", "DEP_FUNC" ] +[ "name", "dependencies_tables_on_functions", "DEP_FUNC" ] +[ "name", "dependencies_tables_on_indexes", "DEP_FUNC" ] +[ "name", "dependencies_tables_on_indexes", "DEP_FUNC" ] +[ "name", "dependencies_tables_on_triggers", "DEP_FUNC" ] +[ "name", "dependencies_views_on_functions", "DEP_FUNC" ] +[ "name", "dependencies_views_on_triggers", "DEP_FUNC" ] +[ "name", "f2", "DEP_FUNC" ] +[ "owner", "dependencies_owners_on_schemas", "DEP_FUNC" ] +[ "reference", "storagemodel", "DEP_FUNC" ] +[ "rkey", "dependencies_columns_on_keys", "DEP_FUNC" ] +[ "rkey", "dependencies_keys_on_foreignkeys", "DEP_FUNC" ] +[ "rkey", "dependencies_tables_on_foreignkeys", "DEP_FUNC" ] +[ "schema", "storagemodel", "DEP_FUNC" ] +[ "sorted", "storagemodel", "DEP_FUNC" ] +[ "table", "storagemodel", "DEP_FUNC" ] +[ "table_id", "dependencies_columns_on_indexes", "DEP_FUNC" ] [ "table_id", "dependencies_columns_on_keys", "DEP_FUNC" ] [ "table_id", "dependencies_tables_on_foreignkeys", "DEP_FUNC" ] -[ "name", "dependencies_keys_on_foreignkeys", "DEP_FUNC" ] -[ "name", "dependencies_columns_on_indexes", "DEP_FUNC" ] -[ "name", "dependencies_columns_on_keys", "DEP_FUNC" ] -[ "name", "dependencies_tables_on_foreignkeys", "DEP_FUNC" ] -[ "name", "dependencies_tables_on_indexes", "DEP_FUNC" ] -[ "rkey", "dependencies_keys_on_foreignkeys", "DEP_FUNC" ] -[ "rkey", "dependencies_columns_on_keys", "DEP_FUNC" ] -[ "rkey", "dependencies_tables_on_foreignkeys", "DEP_FUNC" ] -[ "id", "dependencies_columns_on_indexes", "DEP_FUNC" ] -[ "table_id", "dependencies_columns_on_indexes", "DEP_FUNC" ] [ "table_id", "dependencies_tables_on_indexes", "DEP_FUNC" ] -[ "name", "dependencies_columns_on_indexes", "DEP_FUNC" ] -[ "name", "dependencies_tables_on_indexes", "DEP_FUNC" ] -[ "id", "dependencies_functions_os_triggers", "DEP_FUNC" ] -[ "id", "dependencies_views_on_triggers", "DEP_FUNC" ] -[ "id", "dependencies_columns_on_triggers", "DEP_FUNC" ] -[ "id", "dependencies_tables_on_triggers", "DEP_FUNC" ] -[ "name", "dependencies_functions_os_triggers", "DEP_FUNC" ] -[ "name", "dependencies_views_on_triggers", "DEP_FUNC" ] -[ "name", "dependencies_columns_on_triggers", "DEP_FUNC" ] -[ "name", "dependencies_tables_on_triggers", "DEP_FUNC" ] [ "table_id", "dependencies_tables_on_triggers", "DEP_FUNC" ] -[ "id", "dependencies_columns_on_indexes", "DEP_FUNC" ] -[ "id", "dependencies_columns_on_keys", "DEP_FUNC" ] -[ "name", "dependencies_columns_on_indexes", "DEP_FUNC" ] -[ "name", "dependencies_columns_on_keys", "DEP_FUNC" ] -[ "id", "dependencies_owners_on_schemas", "DEP_FUNC" ] -[ "name", "dependencies_owners_on_schemas", "DEP_FUNC" ] -[ "schema", "storagemodel", "DEP_FUNC" ] -[ "table", "storagemodel", "DEP_FUNC" ] -[ "column", "storagemodel", "DEP_FUNC" ] [ "type", "storagemodel", "DEP_FUNC" ] -[ "count", "storagemodel", "DEP_FUNC" ] -[ "distinct", "storagemodel", "DEP_FUNC" ] -[ "atomwidth", "storagemodel", "DEP_FUNC" ] -[ "reference", "storagemodel", "DEP_FUNC" ] -[ "sorted", "storagemodel", "DEP_FUNC" ] -[ "id", "f2", "DEP_FUNC" ] -[ "name", "f2", "DEP_FUNC" ] #SELECT c.name, tri.name, 'DEP_TRIGGER' from columns as c, triggers as tri, dependencies as dep where dep.id = c.id AND dep.depend_id =tri.id AND dep.depend_type = 8; % .c, .tri, .L1 # table_name % name, name, L1 # name @@ -698,98 +698,98 @@ Cleanup % name, name, single_value # name % varchar, varchar, varchar # type % 0, 0, 0 # length -#SELECT c.name, f.name,'DEP_FUNC' from functions as f, columns as c, dependencies as dep where c.id = dep.id AND f.id = dep.depend_id AND dep.depend_type = 7; -% .c, .f, .L1 # table_name -% name, name, L1 # name +#SELECT c.name, f.name, 'DEP_FUNC' from functions as f, columns as c, 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; +% .c, .f, . # table_name +% name, name, single_value # name % varchar, varchar, varchar # type % 11, 35, 8 # length -[ "id", "dependencies_owners_on_schemas", "DEP_FUNC" ] -[ "id", "dependencies_schemas_on_users", "DEP_FUNC" ] -[ "name", "dependencies_owners_on_schemas", "DEP_FUNC" ] -[ "name", "dependencies_schemas_on_users", "DEP_FUNC" ] -[ "owner", "dependencies_owners_on_schemas", "DEP_FUNC" ] -[ "id", "dependencies_functions_os_triggers", "DEP_FUNC" ] -[ "id", "dependencies_functions_on_functions", "DEP_FUNC" ] -[ "id", "dependencies_views_on_functions", "DEP_FUNC" ] -[ "id", "dependencies_columns_on_functions", "DEP_FUNC" ] -[ "id", "dependencies_tables_on_functions", "DEP_FUNC" ] -[ "name", "dependencies_functions_os_triggers", "DEP_FUNC" ] -[ "name", "dependencies_functions_on_functions", "DEP_FUNC" ] -[ "name", "dependencies_views_on_functions", "DEP_FUNC" ] -[ "name", "dependencies_columns_on_functions", "DEP_FUNC" ] -[ "name", "dependencies_tables_on_functions", "DEP_FUNC" ] -[ "id", "dependencies_functions_os_triggers", "DEP_FUNC" ] -[ "id", "dependencies_functions_on_functions", "DEP_FUNC" ] -[ "id", "dependencies_views_on_triggers", "DEP_FUNC" ] -[ "id", "dependencies_views_on_functions", "DEP_FUNC" ] -[ "id", "dependencies_columns_on_triggers", "DEP_FUNC" ] -[ "id", "dependencies_columns_on_functions", "DEP_FUNC" ] -[ "id", "dependencies_columns_on_views", "DEP_FUNC" ] -[ "id", "dependencies_tables_on_functions", "DEP_FUNC" ] -[ "id", "dependencies_tables_on_triggers", "DEP_FUNC" ] -[ "id", "dependencies_tables_on_views", "DEP_FUNC" ] +[ "atomwidth", "storagemodel", "DEP_FUNC" ] +[ "column", "storagemodel", "DEP_FUNC" ] +[ "count", "storagemodel", "DEP_FUNC" ] +[ "depend_id", "dependencies_columns_on_functions", "DEP_FUNC" ] +[ "depend_id", "dependencies_columns_on_triggers", "DEP_FUNC" ] +[ "depend_id", "dependencies_columns_on_views", "DEP_FUNC" ] +[ "depend_id", "dependencies_functions_on_functions", "DEP_FUNC" ] [ "depend_id", "dependencies_functions_os_triggers", "DEP_FUNC" ] -[ "depend_id", "dependencies_functions_on_functions", "DEP_FUNC" ] -[ "depend_id", "dependencies_views_on_triggers", "DEP_FUNC" ] -[ "depend_id", "dependencies_views_on_functions", "DEP_FUNC" ] -[ "depend_id", "dependencies_columns_on_triggers", "DEP_FUNC" ] -[ "depend_id", "dependencies_columns_on_functions", "DEP_FUNC" ] -[ "depend_id", "dependencies_columns_on_views", "DEP_FUNC" ] [ "depend_id", "dependencies_tables_on_functions", "DEP_FUNC" ] [ "depend_id", "dependencies_tables_on_triggers", "DEP_FUNC" ] [ "depend_id", "dependencies_tables_on_views", "DEP_FUNC" ] +[ "depend_id", "dependencies_views_on_functions", "DEP_FUNC" ] +[ "depend_id", "dependencies_views_on_triggers", "DEP_FUNC" ] +[ "depend_type", "dependencies_columns_on_functions", "DEP_FUNC" ] +[ "depend_type", "dependencies_columns_on_triggers", "DEP_FUNC" ] +[ "depend_type", "dependencies_columns_on_views", "DEP_FUNC" ] +[ "depend_type", "dependencies_functions_on_functions", "DEP_FUNC" ] [ "depend_type", "dependencies_functions_os_triggers", "DEP_FUNC" ] -[ "depend_type", "dependencies_functions_on_functions", "DEP_FUNC" ] -[ "depend_type", "dependencies_views_on_triggers", "DEP_FUNC" ] -[ "depend_type", "dependencies_views_on_functions", "DEP_FUNC" ] -[ "depend_type", "dependencies_columns_on_triggers", "DEP_FUNC" ] -[ "depend_type", "dependencies_columns_on_functions", "DEP_FUNC" ] -[ "depend_type", "dependencies_columns_on_views", "DEP_FUNC" ] [ "depend_type", "dependencies_tables_on_functions", "DEP_FUNC" ] [ "depend_type", "dependencies_tables_on_triggers", "DEP_FUNC" ] [ "depend_type", "dependencies_tables_on_views", "DEP_FUNC" ] +[ "depend_type", "dependencies_views_on_functions", "DEP_FUNC" ] +[ "depend_type", "dependencies_views_on_triggers", "DEP_FUNC" ] +[ "distinct", "storagemodel", "DEP_FUNC" ] +[ "id", "dependencies_columns_on_functions", "DEP_FUNC" ] +[ "id", "dependencies_columns_on_functions", "DEP_FUNC" ] +[ "id", "dependencies_columns_on_indexes", "DEP_FUNC" ] +[ "id", "dependencies_columns_on_indexes", "DEP_FUNC" ] +[ "id", "dependencies_columns_on_keys", "DEP_FUNC" ] +[ "id", "dependencies_columns_on_keys", "DEP_FUNC" ] +[ "id", "dependencies_columns_on_triggers", "DEP_FUNC" ] +[ "id", "dependencies_columns_on_triggers", "DEP_FUNC" ] +[ "id", "dependencies_columns_on_views", "DEP_FUNC" ] +[ "id", "dependencies_functions_on_functions", "DEP_FUNC" ] +[ "id", "dependencies_functions_on_functions", "DEP_FUNC" ] +[ "id", "dependencies_functions_os_triggers", "DEP_FUNC" ] +[ "id", "dependencies_functions_os_triggers", "DEP_FUNC" ] +[ "id", "dependencies_functions_os_triggers", "DEP_FUNC" ] [ "id", "dependencies_keys_on_foreignkeys", "DEP_FUNC" ] -[ "id", "dependencies_columns_on_keys", "DEP_FUNC" ] +[ "id", "dependencies_owners_on_schemas", "DEP_FUNC" ] +[ "id", "dependencies_owners_on_schemas", "DEP_FUNC" ] +[ "id", "dependencies_schemas_on_users", "DEP_FUNC" ] [ "id", "dependencies_tables_on_foreignkeys", "DEP_FUNC" ] +[ "id", "dependencies_tables_on_functions", "DEP_FUNC" ] +[ "id", "dependencies_tables_on_functions", "DEP_FUNC" ] +[ "id", "dependencies_tables_on_triggers", "DEP_FUNC" ] +[ "id", "dependencies_tables_on_triggers", "DEP_FUNC" ] +[ "id", "dependencies_tables_on_views", "DEP_FUNC" ] +[ "id", "dependencies_views_on_functions", "DEP_FUNC" ] +[ "id", "dependencies_views_on_functions", "DEP_FUNC" ] +[ "id", "dependencies_views_on_triggers", "DEP_FUNC" ] +[ "id", "dependencies_views_on_triggers", "DEP_FUNC" ] +[ "name", "dependencies_columns_on_functions", "DEP_FUNC" ] +[ "name", "dependencies_columns_on_indexes", "DEP_FUNC" ] +[ "name", "dependencies_columns_on_indexes", "DEP_FUNC" ] +[ "name", "dependencies_columns_on_indexes", "DEP_FUNC" ] +[ "name", "dependencies_columns_on_keys", "DEP_FUNC" ] +[ "name", "dependencies_columns_on_keys", "DEP_FUNC" ] +[ "name", "dependencies_columns_on_triggers", "DEP_FUNC" ] +[ "name", "dependencies_functions_on_functions", "DEP_FUNC" ] +[ "name", "dependencies_functions_os_triggers", "DEP_FUNC" ] +[ "name", "dependencies_functions_os_triggers", "DEP_FUNC" ] +[ "name", "dependencies_keys_on_foreignkeys", "DEP_FUNC" ] +[ "name", "dependencies_owners_on_schemas", "DEP_FUNC" ] +[ "name", "dependencies_owners_on_schemas", "DEP_FUNC" ] +[ "name", "dependencies_schemas_on_users", "DEP_FUNC" ] +[ "name", "dependencies_tables_on_foreignkeys", "DEP_FUNC" ] +[ "name", "dependencies_tables_on_functions", "DEP_FUNC" ] +[ "name", "dependencies_tables_on_indexes", "DEP_FUNC" ] _______________________________________________ checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
