From 5ee235d17331f7515d1411dbc6c79bb548de0fb3 Mon Sep 17 00:00:00 2001 From: Kyle M Hall Date: Thu, 9 May 2019 06:57:12 -0400 Subject: [PATCH] Bug 22610: (QA follow-up) Make upgrade query more accurate Signed-off-by: Kyle M Hall --- installer/data/mysql/atomicupdate/bug_22610.perl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_22610.perl b/installer/data/mysql/atomicupdate/bug_22610.perl index b2948dbd5a..b31285f10f 100644 --- a/installer/data/mysql/atomicupdate/bug_22610.perl +++ b/installer/data/mysql/atomicupdate/bug_22610.perl @@ -40,7 +40,7 @@ if ( CheckVersion($DBversion) ) { accounttype = 'Pay02'; }); - my $sth = $dbh->prepare( qq{SELECT * FROM accountlines WHERE accounttype LIKE "Pay%" AND accounttype != "Pay" } ); + my $sth = $dbh->prepare( qq{SELECT * FROM accountlines WHERE accounttype REGEXP '^Pay[[:digit:]]{2}$' } ); $sth->execute(); my $seen = {}; while (my $row = $sth->fetchrow_hashref) { -- 2.20.1 (Apple Git-117)