diff options
| -rwxr-xr-x | bin/sanity-check | 10 |
1 files changed, 7 insertions, 3 deletions
diff --git a/bin/sanity-check b/bin/sanity-check index b9b287c..ee521d3 100755 --- a/bin/sanity-check +++ b/bin/sanity-check @@ -217,9 +217,13 @@ while [ $# -gt 0 ]; do printf ' AND `a_r`.`name`="build-list"' printf ' JOIN `binary_packages` AS `b`' printf ' ON `a`.`pkgname`=`b`.`pkgname`' - printf ' JOIN `architecture_compatibilities`' - printf ' ON `architecture_compatibilities`.`built_for`=`a`.`architecture`' - printf ' AND `architecture_compatibilities`.`runs_on`=`b`.`architecture`' + printf ' JOIN `architecture_compatibilities` AS `ac_a`' + printf ' ON `ac_a`.`fully_compatible`' + printf ' AND `ac_a`.`built_for`=`a`.`architecture`' + printf ' JOIN `architecture_compatibilities` AS `ac_b`' + printf ' ON `ac_b`.`fully_compatible`' + printf ' AND `ac_b`.`built_for`=`b`.`architecture`' + printf ' AND `ac_a`.`runs_on`=`ac_b`.`runs_on`' mysql_join_binary_packages_binary_packages_in_repositories 'b' 'bir' mysql_join_binary_packages_in_repositories_repositories 'bir' 'b_r' printf ' AND `b_r`.`name`="deletion-list";\n' |