bin/mysql-functions: bugfix in mysql_cleanup

1 files 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}"