From cd71ffe67de695de22e0db973b22388c2271e325 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Tue, 15 Jan 2019 12:43:45 +0100 Subject: bin/db-update -p: care about versions, too --- bin/db-update | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/bin/db-update b/bin/db-update index ed2efe4..468ac34 100755 --- a/bin/db-update +++ b/bin/db-update @@ -250,12 +250,18 @@ for source_stability in \ mysql_join_binary_packages_dependencies 'old_bp' mysql_join_dependencies_dependency_types printf ' AND `dependency_types`.`relevant_for_binary_packages`' + mysql_join_dependencies_versions '' 'd_v' printf ' WHERE NOT EXISTS (' printf 'SELECT 1 FROM `install_target_providers`' mysql_join_install_target_providers_binary_packages_in_repositories mysql_join_binary_packages_in_repositories_repositories + mysql_join_install_target_providers_versions '' 'itp_v' printf ' WHERE `install_target_providers`.`install_target`=`dependencies`.`depending_on`' - # TODO: we should probably care about versions here, too + printf ' AND' + mysql_query_ordering_correct \ + '`d_v`.`order`' \ + '`itp_v`.`order`' \ + '`dependencies`.`version_relation`' printf ' AND `repositories`.`architecture`=`old_r`.`architecture`' # TODO: also, we might want to consider the stability of the repo # For this, we would need to determine the least stable package -- cgit v1.2.3-70-g09d2