summaryrefslogtreecommitdiff
path: root/lib/mysql-functions
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2019-07-11 15:35:25 +0200
committerErich Eckner <git@eckner.net>2019-07-11 15:35:25 +0200
commitdfed6151c82db7f8055e9f252e952e5797586f2f (patch)
tree884a778b19175d101013e653bcb482d3cb4ab0b3 /lib/mysql-functions
parentcfb514e581806d6a5497089c22fbfa3d492b4203 (diff)
downloadbuilder-dfed6151c82db7f8055e9f252e952e5797586f2f.tar.xz
lib/mysql-functions: print architecture to offending repository
Diffstat (limited to 'lib/mysql-functions')
-rwxr-xr-xlib/mysql-functions3
1 files changed, 2 insertions, 1 deletions
diff --git a/lib/mysql-functions b/lib/mysql-functions
index 52b3fc1..bf66a73 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -638,10 +638,11 @@ mysql_sanity_check() {
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 'SELECT DISTINCT CONCAT("package multiple times in equally stable repositories: ",`a_ra`.`name`,"/{",`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'
mysql_join_binary_packages_in_repositories_repositories 'a_bir' 'a_r'
+ mysql_join_repositories_architectures 'a_r' 'a_ra'
printf ' JOIN `repositories` AS `b_r`'
printf ' ON `a_r`.`stability`=`b_r`.`stability`'
printf ' AND `a_r`.`architecture`=`b_r`.`architecture`'