diff options
| author | Erich Eckner <git@eckner.net> | 2018-06-22 22:12:31 +0200 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2018-06-22 22:12:31 +0200 |
| commit | 7d7be2ea8e78214535066497b399d408161890ac (patch) | |
| tree | 43ecc82555a5fcceccf2ad6a3b9831e5d30a1b8a | |
| parent | deb72750138ff6ef454bd1eaa15a7a03fc4f0f6c (diff) | |
| download | builder-7d7be2ea8e78214535066497b399d408161890ac.tar.xz | |
bin/db-update: FROM_stability - not TO_stability
| -rwxr-xr-x | bin/db-update | 7 |
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 |