From 4cf2cfcc0f07501a26c73cf7d9f8884d8ba262c9 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Wed, 6 Jun 2018 07:08:27 +0200 Subject: lib/mysql-functions: fix some queries --- lib/mysql-functions | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) (limited to 'lib') diff --git a/lib/mysql-functions b/lib/mysql-functions index 5ebff8f..1c8a3f0 100755 --- a/lib/mysql-functions +++ b/lib/mysql-functions @@ -787,9 +787,9 @@ mysql_find_build_assignment_loops() { mysql_join_dependencies_binary_packages '' 'packages_dependent' mysql_join_binary_packages_binary_packages_in_repositories 'packages_dependency' 'packages_in_repository_dependency' mysql_join_binary_packages_binary_packages_in_repositories 'packages_dependent' 'packages_in_repository_dependent' - printf ' WHERE `packages_in_repositories_dependent`.`repository`=%s' \ + printf ' WHERE `packages_in_repository_dependent`.`repository`=%s' \ "${repository_ids__any_build_list}" - printf ' AND `packages_in_repositories_dependency`.`repository`=%s;\n' \ + printf ' AND `packages_in_repository_dependency`.`repository`=%s;\n' \ "${repository_ids__any_build_list}" } | \ mysql_run_query | \ @@ -876,7 +876,7 @@ mysql_cleanup() { if [ "${operator}" = 'DELETE' ]; then printf 'UPDATE `repositories`' else - printf 'SELECT COUNT(DISTINCT `build_slaves`.`id`) FROM `repositories`' + printf 'SELECT COUNT(DISTINCT `build_slaves`.`id`) FROM `binary_packages_in_repositories`' fi mysql_join_binary_packages_in_repositories_binary_packages printf ' AND `binary_packages_in_repositories`.`repository`=%s' \ -- cgit v1.2.3