diff options
-rwxr-xr-x | bin/mysql-functions | 8 |
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}" |