Bugzilla – Attachment 91643 Details for
Bug 22610
SIP Payment Types should be moved out of accountype
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 22610: (QA follow-up) Make upgrade query more accurate
Bug-22610-QA-follow-up-Make-upgrade-query-more-acc.patch (text/plain), 1.10 KB, created by
Martin Renvoize (ashimema)
on 2019-07-19 11:42:44 UTC
(
hide
)
Description:
Bug 22610: (QA follow-up) Make upgrade query more accurate
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2019-07-19 11:42:44 UTC
Size:
1.10 KB
patch
obsolete
>From b303ac1694074bea5ee47b2d56ed41cecf33e986 Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Thu, 9 May 2019 06:57:12 -0400 >Subject: [PATCH] Bug 22610: (QA follow-up) Make upgrade query more accurate > >Signed-off-by: Liz Rea <wizzyrea@gmail.com> >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >--- > 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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 22610
:
88619
|
88620
|
89460
|
89461
|
89470
|
89471
|
89492
|
89493
|
89494
|
89495
|
89496
|
89498
|
89499
|
89500
|
89501
|
89502
|
89503
|
91638
|
91639
|
91640
|
91641
|
91642
| 91643