Send patches - preferably formatted by git format-patch - to patches at archlinux32 dot org.
summaryrefslogtreecommitdiff
path: root/bin/mysql-functions
diff options
context:
space:
mode:
authorErich Eckner <git@eckner.net>2018-02-12 06:24:09 +0100
committerErich Eckner <git@eckner.net>2018-02-12 06:24:09 +0100
commite2f5e61ff6a66bbf49af4d6f07f87eae6b4c3474 (patch)
tree224bae7a1d1e863dddaa283dc12b96d29b15a300 /bin/mysql-functions
parentc4a7f05c1eb634c5e2e6319c626c943ffb22f06f (diff)
bin/mysql-functions: mysql_sanity_check: add check for differing sub_pkgrels on the build-list
Diffstat (limited to 'bin/mysql-functions')
-rwxr-xr-xbin/mysql-functions9
1 files changed, 9 insertions, 0 deletions
diff --git a/bin/mysql-functions b/bin/mysql-functions
index 16c0141..262112e 100755
--- a/bin/mysql-functions
+++ b/bin/mysql-functions
@@ -638,6 +638,15 @@ mysql_sanity_check() {
printf ' JOIN `repositories`'
printf ' ON `a`.`repository`=`repositories`.`id`'
printf ' WHERE `repositories`.`name`="build-list";\n'
+ printf 'SELECT DISTINCT CONCAT("\\"split-package with differing sub_pkgrels on the build-list: ",`a`.`pkgname`)'
+ printf ' FROM `binary_packages` AS `a`'
+ printf ' JOIN `binary_packages` AS `b` ON `a`.`build_assignment`=`b`.`build_assignment`'
+ printf ' JOIN `repositories` AS `arep` ON `a`.`repository`=`arep`.`id`'
+ printf ' JOIN `repositories` AS `brep` ON `b`.`repository`=`brep`.`id`'
+ printf ' WHERE `a`.`sub_pkgrel`!=`b`.`sub_pkgrel`'
+ printf ' AND `%srep`.`name` = "build-list"' \
+ 'a' 'b'
+ printf ';\n'
} | \
${mysql_command} --raw --batch | \
sed '