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:25:12 +0200
committerErich Eckner <git@eckner.net>2018-05-31 11:25:12 +0200
commit26e44f205c0db16d1e74427e5320b6a56ae320a4 (patch)
tree319b52509015caef844888e3c773b048385cb166 /lib/mysql-functions
parent3a8822add79c536fb9c34c296c9b3d4fbddf2aa1 (diff)
lib/mysql-functions: new test in mysql_sanity_check()
Diffstat (limited to 'lib/mysql-functions')
-rwxr-xr-xlib/mysql-functions10
1 files changed, 10 insertions, 0 deletions
diff --git a/lib/mysql-functions b/lib/mysql-functions
index 0059298..b00e17d 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -656,6 +656,16 @@ mysql_sanity_check() {
'a' "${repository_ids__any_build_list}" \
'b' "${repository_ids__any_build_list}"
printf ';\n'
+ printf 'SELECT DISTINCT CONCAT("non-virtual binary-package without checksum: ",'
+ mysql_package_name_query
+ printf ') FROM `binary_packages`'
+ mysql_join_binary_packages_architectures
+ 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 ') AND `binary_packages`.`sha512sum` IS NULL;\n'
} | \
mysql_run_query | \
sed '