1 files changed, 4 insertions, 1 deletions

diff --git a/bin/return-assignment b/bin/return-assignment
index 40733c1..6b64bf4 100755
--- a/bin/return-assignment
+++ b/bin/return-assignment
@@ -420,7 +420,10 @@ if [ "$6" = 'ERROR' ]; then
       mysql_join_binary_packages_binary_packages_in_repositories
       printf ' AND `binary_packages_in_repositories`.`repository`=%s' \
         "${repository_ids__any_build_list}"
-      printf ' SET `build_assignments`.`priority`=GREATEST(0,@`max_priority`+IF(`build_assignments`.`is_broken`,-1,1));\n'
+      printf ' SET `build_assignments`.`priority`=GREATEST('
+        printf '`build_assignments`.`priority`,'
+        printf '@`max_priority`+IF(`build_assignments`.`is_broken`,-1,1)'
+      printf ');\n'
 
       printf 'SELECT DISTINCT `broken`.`pkgname`'
       printf ' FROM `broken`'