From 5b40c2766152357f448e1c425ae999d2f3d244d7 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Tue, 13 Feb 2018 15:21:31 +0100 Subject: bin/mysql-functions: bugfix in mysql_cleanup --- bin/mysql-functions | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) diff --git a/bin/mysql-functions b/bin/mysql-functions index 241c84b..1cd68cf 100755 --- a/bin/mysql-functions +++ b/bin/mysql-functions @@ -793,9 +793,11 @@ mysql_cleanup() { # remove failed_builds with unbroken build_assignments printf '%s FROM `failed_builds` ' \ "${operator}" - printf 'JOIN `build_assignments` ' - printf 'ON `failed_builds`.`build_assignment`=`build_assignments`.`id` ' - printf 'WHERE NOT `build_assignments`.`is_broken`;\n' + printf 'WHERE (' + printf 'SELECT NOT `build_assignments`.`is_broken`' + printf ' FROM `build_assignments` ' + printf ' WHERE `failed_builds`.`build_assignment`=`build_assignments`.`id`' + printf ');\n' # remove failed_builds w/o build_assignment printf '%s FROM `failed_builds` ' \ "${operator}" -- cgit v1.2.3-54-g00ecf