Bugzilla – Attachment 24495 Details for
Bug 11309
Duplicated patterns when subscription table is updated
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 11309: Duplicated patterns when subscription table is updated
Bug-11309-Duplicated-patterns-when-subscription-ta.patch (text/plain), 3.06 KB, created by
Kyle M Hall (khall)
on 2014-01-17 13:30:57 UTC
(
hide
)
Description:
Bug 11309: Duplicated patterns when subscription table is updated
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2014-01-17 13:30:57 UTC
Size:
3.06 KB
patch
obsolete
>From 9c95b75a4b7809505d08cbe99650868eabfdc0f9 Mon Sep 17 00:00:00 2001 >From: =?UTF-8?q?Nu=C3=B1o=20L=C3=B3pez=20Ans=C3=B3tegui?= <nunyo@masmedios.com> >Date: Tue, 26 Nov 2013 18:38:43 +0100 >Subject: [PATCH] Bug 11309: Duplicated patterns when subscription table is updated > >Signed-off-by: Julian Maurice <julian.maurice@biblibre.com> >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >--- > installer/data/mysql/updatedatabase.pl | 22 ++++++++++++---------- > 1 files changed, 12 insertions(+), 10 deletions(-) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 80ab210..aa19845 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -7472,11 +7472,13 @@ if ( CheckVersion($DBversion) ) { > |); > my $check_numberpatterns_sth = $dbh->prepare(qq| > SELECT * FROM subscription_numberpatterns >- WHERE add1 = ? AND add2 = ? AND add3 = ? >- AND every1 = ? AND every2 = ? AND every3 = ? >- AND whenmorethan1 = ? AND whenmorethan2 = ? AND whenmorethan3 = ? >- AND setto1 = ? AND setto2 = ? AND setto3 = ? >- AND numberingmethod = ? >+ WHERE (add1 = ? OR (add1 IS NULL AND ? IS NULL)) AND (add2 = ? OR (add2 IS NULL AND ? IS NULL)) >+ AND (add3 = ? OR (add3 IS NULL AND ? IS NULL)) AND (every1 = ? OR (every1 IS NULL AND ? IS NULL)) >+ AND (every2 = ? OR (every2 IS NULL AND ? IS NULL)) AND (every3 = ? OR (every3 IS NULL AND ? IS NULL)) >+ AND (whenmorethan1 = ? OR (whenmorethan1 IS NULL AND ? IS NULL)) AND (whenmorethan2 = ? OR (whenmorethan2 IS NULL AND ? IS NULL)) >+ AND (whenmorethan3 = ? OR (whenmorethan3 IS NULL AND ? IS NULL)) AND (setto1 = ? OR (setto1 IS NULL AND ? IS NULL)) >+ AND (setto2 = ? OR (setto2 IS NULL AND ? IS NULL)) AND (setto3 = ? OR (setto3 IS NULL AND ? IS NULL)) >+ AND (numberingmethod = ? OR (numberingmethod IS NULL AND ? IS NULL)) > LIMIT 1 > |); > my $update_subscription_sth = $dbh->prepare(qq| >@@ -7489,11 +7491,11 @@ if ( CheckVersion($DBversion) ) { > my $i = 1; > while(my $sub = $sth->fetchrow_hashref) { > $check_numberpatterns_sth->execute( >- $sub->{add1}, $sub->{add2}, $sub->{add3}, >- $sub->{every1}, $sub->{every2}, $sub->{every3}, >- $sub->{whenmorethan1}, $sub->{whenmorethan2}, $sub->{whenmorethan3}, >- $sub->{setto1}, $sub->{setto2}, $sub->{setto3}, >- $sub->{numberingmethod} >+ $sub->{add1}, $sub->{add1}, $sub->{add2}, $sub->{add2}, $sub->{add3}, $sub->{add3}, >+ $sub->{every1}, $sub->{every1}, $sub->{every2}, $sub->{every2}, $sub->{every3}, $sub->{every3}, >+ $sub->{whenmorethan1}, $sub->{whenmorethan1}, $sub->{whenmorethan2}, $sub->{whenmorethan2}, >+ $sub->{whenmorethan3}, $sub->{whenmorethan3}, $sub->{setto1}, $sub->{setto1}, $sub->{setto2}, >+ $sub->{setto2}, $sub->{setto3}, $sub->{setto3}, $sub->{numberingmethod}, $sub->{numberingmethod} > ); > my $p = $check_numberpatterns_sth->fetchrow_hashref; > if (defined $p) { >-- >1.7.2.5
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 11309
:
23177
|
24004
| 24495