From 7d7be2ea8e78214535066497b399d408161890ac Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Fri, 22 Jun 2018 22:12:31 +0200 Subject: bin/db-update: FROM_stability - not TO_stability --- bin/db-update | 7 +++---- 1 file changed, 3 insertions(+), 4 deletions(-) diff --git a/bin/db-update b/bin/db-update index 6f4096c..f09db2d 100755 --- a/bin/db-update +++ b/bin/db-update @@ -186,6 +186,8 @@ for source_stability in \ printf ' FROM `binary_packages_in_repositories` AS `new_bpir`' mysql_join_binary_packages_in_repositories_binary_packages 'new_bpir' 'new_bp' mysql_join_binary_packages_in_repositories_repositories 'new_bpir' 'from_r' + printf ' AND `from_r`.`stability`=%s' \ + "${source_stability}" printf ' AND `from_r`.`is_on_master_mirror`' mysql_join_binary_packages_build_assignments 'new_bp' mysql_join_build_assignments_package_sources @@ -194,14 +196,11 @@ for source_stability in \ printf ' AND `repository_moves`.`from_repository`=`from_r`.`id`' printf ' JOIN `repositories` AS `to_r`' printf ' ON `repository_moves`.`to_repository`=`to_r`.`id`' - printf ' AND `to_r`.`stability`=%s' \ - "${source_stability}" printf ' JOIN `binary_packages` AS `old_bp`' printf ' ON `new_bp`.`pkgname`=`old_bp`.`pkgname`' mysql_join_binary_packages_binary_packages_in_repositories 'old_bp' 'old_bpir' mysql_join_binary_packages_in_repositories_repositories 'old_bpir' 'old_r' - printf ' AND `old_r`.`stability`=%s' \ - "${source_stability}" + printf ' AND `old_r`.`stability`=`to_r`.`stability`' printf ' AND `old_r`.`architecture`=`to_r`.`architecture`' mysql_join_binary_packages_dependencies 'old_bp' mysql_join_dependencies_dependency_types -- cgit v1.2.3