bin/return-assignment: cleanup linebreakremovalmess

1 files changed, 2 insertions, 10 deletions

diff --git a/bin/return-assignment b/bin/return-assignment
index 2253986..cd6d30e 100755
--- a/bin/return-assignment
+++ b/bin/return-assignment
@@ -91,19 +91,11 @@ if [ "$5" = 'ERROR' ]; then
       printf 'INSERT INTO `failures` (`date`,`reason`,`log_file`) VALUES'
       fail_reason_identifiers=$(
         {
-          printf 'SELECT `fail_reasons`.`id`,to_base64(`fail_reasons`.`identifier`),"%%END%%"'
+          printf 'SELECT `fail_reasons`.`id`,replace(to_base64(`fail_reasons`.`identifier`),"\\n","")'
           printf ' FROM `fail_reasons` ORDER BY `fail_reasons`.`severity`'
         } | \
           ${mysql_command} --raw --batch | \
-          sed '
-            1d
-            :start
-            s/\s%END%$//
-            t
-            N
-            s/\n//g
-            b start
-          '
+          sed '1d'
       )
       for saved_build_log in ${saved_build_logs}; do
         printf '%s' "${fail_reason_identifiers}" | \