diff options
| author | Erich Eckner <git@eckner.net> | 2018-06-06 07:08:27 +0200 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2018-06-06 07:08:27 +0200 |
| commit | 4cf2cfcc0f07501a26c73cf7d9f8884d8ba262c9 (patch) | |
| tree | 3bc9c98718dd1d3560b320eaff5dd90c5a12d772 | |
| parent | c167926813104d298ca9cab5f106e8eeed07afbe (diff) | |
| download | builder-4cf2cfcc0f07501a26c73cf7d9f8884d8ba262c9.tar.xz | |
lib/mysql-functions: fix some queries
| -rwxr-xr-x | lib/mysql-functions | 6 |
1 files changed, 3 insertions, 3 deletions
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' \ |