summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rwxr-xr-xbin/return-assignment5
1 files changed, 3 insertions, 2 deletions
diff --git a/bin/return-assignment b/bin/return-assignment
index 3e62003..5bf4c51 100755
--- a/bin/return-assignment
+++ b/bin/return-assignment
@@ -100,7 +100,7 @@ if [ "$6" = 'ERROR' ]; then
# shellcheck disable=SC2016
infos=$(
{
- printf 'SELECT DISTINCT'
+ printf 'SELECT'
printf ' `build_assignments`.`id`,'
printf 'IF(`build_assignments`.`is_broken`,"true","false"),'
printf '`ba_a`.`name`'
@@ -130,8 +130,9 @@ if [ "$6" = 'ERROR' ]; then
"$(printf '%s' "$4" | base64 -w0)"
printf ' AND `architectures`.`name`=from_base64("%s")' \
"$(printf '%s' "$5" | base64 -w0)"
- printf ' AND `binary_packages_in_repositories`.`repository`=%s;\n' \
+ printf ' AND `binary_packages_in_repositories`.`repository`=%s' \
"${repository_ids__any_build_list}"
+ printf ' LIMIT 1;\n'
} | \
mysql_run_query | \
tr '\t' ' '