From c0302a5bd43d2f87ffbd592482325e39ee9214b9 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Thu, 29 Feb 2024 10:18:03 +0000 Subject: [PATCH] Bug 29509: Correction to bitwise check I was using it wrong :( --- installer/data/mysql/atomicupdate/bug_29509.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_29509.pl b/installer/data/mysql/atomicupdate/bug_29509.pl index 24dd5aab099..e667e5bd5ee 100755 --- a/installer/data/mysql/atomicupdate/bug_29509.pl +++ b/installer/data/mysql/atomicupdate/bug_29509.pl @@ -9,7 +9,7 @@ return { my ( $dbh, $out ) = @$args{qw(dbh out)}; # Users to exclude from update, (superlibrarians or borrowers flags) - my $sth = $dbh->prepare("SELECT borrowernumber FROM borrowers WHERE flags = 1 OR (flags & 4) > 0"); + my $sth = $dbh->prepare("SELECT borrowernumber FROM borrowers WHERE flags = 1 OR flags & (1<<4)"); $sth->execute(); my @exclusions = map { $_->[0] } @{ $sth->fetchall_arrayref }; -- 2.44.0