Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2019-04-15 10:51:34 +0200
committerErich Eckner <git@eckner.net>2019-04-15 10:51:34 +0200
commit084e5210aeb6e6ddbaf03e4d3c1dfef5995d2924 (patch)
treef152b69827fcd82bf5b5e5ae76a57a8140142ada
parent1fa3ad8e1c8a81f04904d0aed6401955809d390f (diff)
lib/mysql-functions: mysql_sanity_check() we have more architectures now, thus we have also more invalid architecture combinations build_assignment <-> binary_package
-rwxr-xr-xlib/mysql-functions16
1 files changed, 13 insertions, 3 deletions
diff --git a/lib/mysql-functions b/lib/mysql-functions
index 9d8aa91..1994184 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -619,13 +619,23 @@ mysql_generate_package_metadata() {
mysql_sanity_check() {
{
- printf 'SELECT CONCAT("\\"any\\" build-assignment building \\"",`bp_arch`.`name`,"\\" binary package: ",`binary_packages`.`pkgname`)'
+ printf 'SELECT CONCAT('
+ printf '"\\"",'
+ printf '`ba_arch`.`name`,'
+ printf '"\\" build-assignment building \\"",'
+ printf '`bp_arch`.`name`,'
+ printf '"\\" binary package: ",'
+ printf '`binary_packages`.`pkgname`'
+ printf ')'
printf ' FROM `binary_packages`'
mysql_join_binary_packages_build_assignments
mysql_join_binary_packages_architectures '' 'bp_arch'
mysql_join_build_assignments_architectures '' 'ba_arch'
- printf ' WHERE `bp_arch`.`name`!="any"'
- printf ' AND `ba_arch`.`name`="any";\n'
+ printf ' LEFT JOIN `architecture_compatibilities`'
+ printf ' ON `architecture_compatibilities`.`runs_on`=`build_assignments`.`architecture`'
+ printf ' AND `architecture_compatibilities`.`built_for`=`binary_packages`.`architecture`'
+ printf ' AND `architecture_compatibilities`.`fully_compatible`'
+ printf ' WHERE `architecture_compatibilities`.`id` IS NULL;\n'
printf 'SELECT DISTINCT CONCAT("package multiple times in equally stable repositories: {",`a_r`.`name`,",",`b_r`.`name`,"}/",`a`.`pkgname`)'
printf ' FROM `binary_packages` AS `a`'
mysql_join_binary_packages_binary_packages_in_repositories 'a' 'a_bir'