bin/return-assignment: put built packages only in repos for those architectures, where the package runs

1 files changed, 3 insertions, 2 deletions

diff --git a/bin/return-assignment b/bin/return-assignment
index c37aef1..fe63e69 100755
--- a/bin/return-assignment
+++ b/bin/return-assignment
@@ -464,8 +464,6 @@ if [ ! -s "${tmp_dir}/package-ids" ]; then
   exit 4
 fi
 
-# TODO: we need to filter out some architectures here
-
 # shellcheck disable=SC2016
 {
   printf 'SELECT `binary_packages`.`id`,'
@@ -479,6 +477,9 @@ fi
   mysql_join_upstream_repositories_repository_moves
   printf ' JOIN `repositories` as `t` ON `t`.`id`=`repository_moves`.`to_repository`'
   mysql_join_repositories_architectures 't' 't_a'
+  printf ' JOIN `architecture_compatibilities`'
+  printf ' ON `architecture_compatibilities`.`built_for`=`binary_packages`.`architecture`'
+  printf ' AND `architecture_compatibilities`.`runs_for`=`t`.`architecture`'
   printf ' WHERE `repository_moves`.`from_repository`=%s' \
     "${repository_ids__any_build_list}"
   printf ' AND `build_assignments`.`id`=from_base64("%s");\n' \