Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/lib/mysql-functions
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-05-31 11:18:00 +0200
committerErich Eckner <git@eckner.net>2018-05-31 11:18:00 +0200
commitdf9ca294a7fa249bade83928f811973c02d810c5 (patch)
treeeb210c569c50e3d3fc5256ae5c3e1425633515d4 /lib/mysql-functions
parent105d3a57f96300b824c818f36397eeee75005963 (diff)
lib/mysql-functions: deletion-list packages may have a checksum
Diffstat (limited to 'lib/mysql-functions')
-rwxr-xr-xlib/mysql-functions7
1 files changed, 6 insertions, 1 deletions
diff --git a/lib/mysql-functions b/lib/mysql-functions
index 0aad61a..7a6ba03 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -742,7 +742,12 @@ mysql_sanity_check() {
printf '`architectures`.`name`'
printf ' FROM `binary_packages`'
mysql_join_binary_packages_architectures
- printf ' WHERE `binary_packages`.`sha512sum` IS NOT NULL'
+ printf ' WHERE NOT EXISTS ('
+ printf 'SELECT 1 FROM `binary_packages_in_repositories`'
+ mysql_join_binary_packages_in_repositories_repositories
+ printf ' WHERE NOT `repositories`.`is_on_master_mirror`'
+ printf ' AND `binary_packages_in_repositories`.`package`=`binary_packages`.`id`'
+ printf ')'
} | \
mysql_run_query | \
sed '