From bec12d71041dcfe0822bda36c740ee5f8a6260a3 Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Wed, 30 May 2018 13:54:23 +0200
Subject: bin/copy-to-build-support: do not write
 `binary_packages`.`repository`

---
 bin/copy-to-build-support | 13 ++++++-------
 1 file changed, 6 insertions(+), 7 deletions(-)

(limited to 'bin/copy-to-build-support')

diff --git a/bin/copy-to-build-support b/bin/copy-to-build-support
index dc45d07..f4647e1 100755
--- a/bin/copy-to-build-support
+++ b/bin/copy-to-build-support
@@ -133,17 +133,15 @@ sed -n '
 
     # shellcheck disable=SC2016
     {
-      printf 'INSERT IGNORE INTO `binary_packages`'
-      printf ' (`repository`'
+      printf 'INSERT IGNORE INTO `binary_packages` ('
       # shellcheck disable=SC2086
-      printf ',`%s`' ${to_copy}
+      printf ',`%s`' ${to_copy} | \
+        sed 's/^,//'
       printf ')'
       printf ' SELECT'
-      # shellcheck disable=SC2154
-      printf ' %s' \
-        "${repository_ids__i686_build_support}"
       # shellcheck disable=SC2086
-      printf ',`binary_packages`.`%s`' ${to_copy}
+      printf ',`binary_packages`.`%s`' ${to_copy} | \
+        sed 's/^,//'
       printf ' FROM `binary_packages`'
       mysql_join_binary_packages_architectures
       printf ' WHERE'
@@ -151,6 +149,7 @@ sed -n '
         "${id}"
       printf 'INSERT IGNORE INTO `binary_packages_in_repositories`'
       printf ' (`repository`,`package`)'
+      # shellcheck disable=SC2154
       printf ' SELECT %s,LAST_INSERT_ID();\n' \
         "${repository_ids__i686_build_support}"
     } >> \
-- 
cgit v1.2.3