summaryrefslogtreecommitdiff
path: root/bin/db-update
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-06-22 22:12:31 +0200
committerErich Eckner <git@eckner.net>2018-06-22 22:12:31 +0200
commit7d7be2ea8e78214535066497b399d408161890ac (patch)
tree43ecc82555a5fcceccf2ad6a3b9831e5d30a1b8a /bin/db-update
parentdeb72750138ff6ef454bd1eaa15a7a03fc4f0f6c (diff)
downloadbuilder-7d7be2ea8e78214535066497b399d408161890ac.tar.xz
bin/db-update: FROM_stability - not TO_stability
Diffstat (limited to 'bin/db-update')
-rwxr-xr-xbin/db-update7
1 files 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