From e2f5e61ff6a66bbf49af4d6f07f87eae6b4c3474 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Mon, 12 Feb 2018 06:24:09 +0100 Subject: bin/mysql-functions: mysql_sanity_check: add check for differing sub_pkgrels on the build-list --- bin/mysql-functions | 9 +++++++++ 1 file changed, 9 insertions(+) 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 ' -- cgit v1.2.3-54-g00ecf