bin/sanity-check: modify check: being on build- and deletion-list simultanously is ok iff the architectures are fitting

1 files changed, 5 insertions, 1 deletions

diff --git a/bin/sanity-check b/bin/sanity-check
index 5e74edb..57c77fd 100755
--- a/bin/sanity-check
+++ b/bin/sanity-check
@@ -215,7 +215,11 @@ while [ $# -gt 0 ]; do
           mysql_join_binary_packages_binary_packages_in_repositories 'a' 'air'
           mysql_join_binary_packages_in_repositories_repositories 'air' 'a_r'
           printf ' AND `a_r`.`name`="build-list"'
-          printf ' JOIN `binary_packages` AS `b` ON `a`.`pkgname`=`b`.`pkgname`'
+          printf ' JOIN `binary_packages` AS `b`'
+          printf ' ON `a`.`pkgname`=`b`.`pkgname`'
+          printf ' JOIN `architecture_compatibilities`'
+          printf ' ON `architecture_compatibilities`.`built_for`=`a`.`architecture`'
+          printf ' AND `architecture_compatibilities`.`runs_on`=`b`.`architecture`'
           mysql_join_binary_packages_binary_packages_in_repositories 'b' 'bir'
           mysql_join_binary_packages_in_repositories_repositories 'bir' 'b_r'
           printf ' AND `b_r`.`name`="deletion-list";\n'