From 4f6b3c4a6173810bba24b89d82eb223226278b9c Mon Sep 17 00:00:00 2001 From: Aleisha Amohia Date: Thu, 16 Jul 2020 16:24:38 +1200 Subject: [PATCH] [19.11.x] Bug 25858: Use bitwise OR for setting a bit in borrowers.flag Signed-off-by: Aleisha Amohia --- installer/data/mysql/updatedatabase.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 454f74480b..ed8984faeb 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -20364,7 +20364,7 @@ if( CheckVersion( $DBversion ) ) { }); $dbh->do(q{ - UPDATE borrowers SET flags = flags + (1<<12) WHERE flags & (1 << 11) AND !(flags & (1 << 12)) + UPDATE borrowers SET flags = flags | (1<<12) WHERE flags & (1 << 11) }); SetVersion( $DBversion ); -- 2.39.5