From 571444e99c8b069ac7e7651d1da2d294f4858ae8 Mon Sep 17 00:00:00 2001 From: Tomas Cohen Arazi Date: Sat, 12 Jun 2021 10:43:09 -0300 Subject: [PATCH] Bug 15788: (QA follow-up) Simplify query in update Signed-off-by: Tomas Cohen Arazi Signed-off-by: Jonathan Druart --- installer/data/mysql/atomicupdate/bug_15788.perl | 8 +++----- 1 file changed, 3 insertions(+), 5 deletions(-) diff --git a/installer/data/mysql/atomicupdate/bug_15788.perl b/installer/data/mysql/atomicupdate/bug_15788.perl index 98e5d27430..44e67c5b6e 100644 --- a/installer/data/mysql/atomicupdate/bug_15788.perl +++ b/installer/data/mysql/atomicupdate/bug_15788.perl @@ -9,12 +9,10 @@ if ( CheckVersion($DBversion) ) { } ); - $dbh->do( - qq{ + $dbh->do(q{ INSERT IGNORE INTO user_permissions (borrowernumber, module_bit, code) - SELECT borrowernumber, 4, 'delete_borrowers' FROM borrowers WHERE borrowernumber IN ( SELECT borrowernumber FROM user_permissions WHERE code = 'edit_borrowers') - } - ); + SELECT borrowernumber, 4, 'delete_borrowers' FROM user_permissions WHERE code = 'edit_borrowers' + }); NewVersion( $DBversion, 15788, "Split edit_borrowers permission" ); } -- 2.39.5