do not address deletion-list directly, but rather by its stability "forbidden"

1 files changed, 6 insertions, 6 deletions

diff --git a/lib/mysql-functions b/lib/mysql-functions
index a984508..bb58ca0 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -633,12 +633,12 @@ mysql_sanity_check() {
     mysql_join_binary_packages_in_repositories_binary_packages 'b_bir' 'b'
     printf ' AND `a`.`pkgname`=`b`.`pkgname`'
     printf ' AND `a`.`id`!=`b`.`id`'
-    printf ' WHERE `a_r`.`id` NOT IN (%s,%s)' \
-      "${repository_ids__any_deletion_list}" \
-      "${repository_ids__any_to_be_decided}"
-    printf ' AND `b_r`.`id` NOT IN (%s,%s);\n' \
-      "${repository_ids__any_deletion_list}" \
-      "${repository_ids__any_to_be_decided}"
+    printf ' WHERE `a_r`.`stability` NOT IN (%s,%s)' \
+      "${repository_stability_ids__forbidden}" \
+      "${repository_stability_ids__virtual}"
+    printf ' AND `b_r`.`stability` NOT IN (%s,%s);\n' \
+      "${repository_stability_ids__forbidden}" \
+      "${repository_stability_ids__virtual}"
     printf 'SELECT DISTINCT CONCAT("split-package with differing sub_pkgrels on the build-list: ",`a`.`pkgname`)'
     printf ' FROM `binary_packages` AS `a`'
     printf ' JOIN `binary_packages` AS `b` ON `a`.`build_assignment`=`b`.`build_assignment`'