From 26e44f205c0db16d1e74427e5320b6a56ae320a4 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Thu, 31 May 2018 11:25:12 +0200 Subject: lib/mysql-functions: new test in mysql_sanity_check() --- lib/mysql-functions | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'lib') 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 ' -- cgit v1.2.3