lib/mysql-functions: new test in mysql_sanity_check()

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 '