From e6a20e404220f11b5dcb89a26487e1bbca79230a Mon Sep 17 00:00:00 2001
From: Erich Eckner <git@eckner.net>
Date: Thu, 20 Feb 2020 15:00:12 +0100
Subject: lib/mysql-functions: mysql_query_delete_packages(): make regex less
 restrictive, fix some column names

---
 lib/mysql-functions | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'lib')

diff --git a/lib/mysql-functions b/lib/mysql-functions
index 706a11d..abd7488 100755
--- a/lib/mysql-functions
+++ b/lib/mysql-functions
@@ -1787,9 +1787,9 @@ mysql_query_delete_packages() {
           mysql_join_binary_packages_in_repositories_repositories 'keep_bpir' 'keep_r'
           printf ' AND %s' "${repositories_condition}" \
           | sed '
-            s/\b`repositories`\b/`keep_r`/g
+            s/`repositories`/`keep_r`/g
           '
-        printf ') ON `keep_bpir`.`binary_package`=`binary_packages`.`id`'
+        printf ') ON `keep_bpir`.`package`=`binary_packages`.`id`'
       ;;
       '3')
         printf ' LEFT JOIN ('
@@ -1798,7 +1798,7 @@ mysql_query_delete_packages() {
           mysql_join_binary_packages_in_repositories_repositories 'keep_bpir' 'keep_r'
           printf ' AND NOT (%s)' "${repositories_condition}" \
           | sed '
-            s/\b`repositories`\b/`keep_r`/g
+            s/`repositories`/`keep_r`/g
           '
         printf ') ON `keep_bp`.`build_assignment`=`build_assignments`.`id`'
       ;;
@@ -1810,7 +1810,7 @@ mysql_query_delete_packages() {
           mysql_join_binary_packages_in_repositories_repositories 'keep_bpir' 'keep_r'
           printf ' AND %s' "${repositories_condition}" \
           | sed '
-            s/\b`repositories`\b/`keep_r`/g
+            s/`repositories`/`keep_r`/g
           '
         printf ') ON `keep_ba`.`package_source`=`package_sources`.`id`'
       ;;
-- 
cgit v1.2.3