From dfa9ccf49a8f0613cb95d3e666172b5ce3cae23f 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 --- 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.32.0