bin/db-update -p: care about versions, too

1 files changed, 7 insertions, 1 deletions

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