-- called by /home/master/builder/bin/sanity-check
SELECT CONCAT("\"",`ba_arch`.`name`,"\" build-assignment building \"",`bp_arch`.`name`,"\" binary package: ",`binary_packages`.`pkgname`) FROM `binary_packages` JOIN `build_assignments` ON `binary_packages`.`build_assignment`=`build_assignments`.`id` JOIN `architectures` AS `bp_arch` ON `binary_packages`.`architecture`=`bp_arch`.`id` JOIN `architectures` AS `ba_arch` ON `build_assignments`.`architecture`=`ba_arch`.`id` LEFT JOIN `architecture_compatibilities` ON `architecture_compatibilities`.`runs_on`=`build_assignments`.`architecture` AND `architecture_compatibilities`.`built_for`=`binary_packages`.`architecture` AND `architecture_compatibilities`.`fully_compatible` WHERE `architecture_compatibilities`.`id` IS NULL;
SELECT DISTINCT CONCAT("package multiple times in equally stable repositories: ",`a_ra`.`name`,"/{",`a_r`.`name`,",",`b_r`.`name`,"}/",`a`.`pkgname`) FROM `binary_packages` AS `a` JOIN `binary_packages_in_repositories` AS `a_bir` ON `a`.`id`=`a_bir`.`package` JOIN `repositories` AS `a_r` ON `a_bir`.`repository`=`a_r`.`id` JOIN `architectures` AS `a_ra` ON `a_r`.`architecture`=`a_ra`.`id` JOIN `repositories` AS `b_r` ON `a_r`.`stability`=`b_r`.`stability` AND `a_r`.`architecture`=`b_r`.`architecture` JOIN `binary_packages_in_repositories` AS `b_bir` ON `b_r`.`id`=`b_bir`.`repository` JOIN `binary_packages` AS `b` ON `b_bir`.`package`=`b`.`id` AND `a`.`pkgname`=`b`.`pkgname` AND `a`.`id`!=`b`.`id` AND (`a_r`.`architecture`!=1 OR `a`.`architecture`=`b`.`architecture`) WHERE `a_r`.`stability` NOT IN (6,7) AND `b_r`.`stability` NOT IN (6,7);
SELECT DISTINCT CONCAT("split-package with differing sub_pkgrels on the build-list: ",`a`.`pkgname`) FROM `binary_packages` AS `a` JOIN `binary_packages` AS `b` ON `a`.`build_assignment`=`b`.`build_assignment` JOIN `binary_packages_in_repositories` AS `a_bir` ON `a`.`id`=`a_bir`.`package` JOIN `binary_packages_in_repositories` AS `b_bir` ON `b`.`id`=`b_bir`.`package` WHERE `a`.`sub_pkgrel`!=`b`.`sub_pkgrel` AND `a_bir`.`repository`=9 AND `b_bir`.`repository`=9;
SELECT DISTINCT CONCAT("non-virtual binary-package without checksum: ",CONCAT(`binary_packages`.`pkgname`,"-",IF(`binary_packages`.`epoch`=0,"",CONCAT(`binary_packages`.`epoch`,":")),`binary_packages`.`pkgver`,"-",`binary_packages`.`pkgrel`,IF(`binary_packages`.`sub_pkgrel_omitted`,"",CONCAT(".",`binary_packages`.`sub_pkgrel`)),"-",`architectures`.`name`,".pkg.",IF(`compressions`.`suffix` IS NULL,"tar.zst",`compressions`.`suffix`))) FROM `binary_packages` JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id` LEFT JOIN `compressions` ON `binary_packages`.`compression`=`compressions`.`id` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` WHERE `repositories`.`is_on_master_mirror` AND `binary_packages`.`sha512sum` IS NULL;
SELECT DISTINCT CONCAT("non-virtual binary-package without signature: ",CONCAT(`binary_packages`.`pkgname`,"-",IF(`binary_packages`.`epoch`=0,"",CONCAT(`binary_packages`.`epoch`,":")),`binary_packages`.`pkgver`,"-",`binary_packages`.`pkgrel`,IF(`binary_packages`.`sub_pkgrel_omitted`,"",CONCAT(".",`binary_packages`.`sub_pkgrel`)),"-",`architectures`.`name`,".pkg.",IF(`compressions`.`suffix` IS NULL,"tar.zst",`compressions`.`suffix`))) FROM `binary_packages` JOIN `architectures` ON `binary_packages`.`architecture`=`architectures`.`id` LEFT JOIN `compressions` ON `binary_packages`.`compression`=`compressions`.`id` JOIN `binary_packages_in_repositories` ON `binary_packages`.`id`=`binary_packages_in_repositories`.`package` JOIN `repositories` ON `binary_packages_in_repositories`.`repository`=`repositories`.`id` WHERE `repositories`.`is_on_master_mirror` AND `binary_packages`.`signing_key` IS NULL;