Bugzilla – Attachment 34995 Details for
Bug 9351
item type not recorded correctly in statistics for returns and some local use
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
[SIGNED-OFF] Bug 9351 - sql update on existing statistics
SIGNED-OFF-Bug-9351---sql-update-on-existing-stati.patch (text/plain), 1.40 KB, created by
Kyle M Hall (khall)
on 2015-01-07 12:04:59 UTC
(
hide
)
Description:
[SIGNED-OFF] Bug 9351 - sql update on existing statistics
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2015-01-07 12:04:59 UTC
Size:
1.40 KB
patch
obsolete
>From 1b687ca8f866bfb4316a1632fb3a6e84d9d92446 Mon Sep 17 00:00:00 2001 >From: Fridolin Somers <fridolin.somers@biblibre.com> >Date: Mon, 29 Dec 2014 17:35:26 +0100 >Subject: [PATCH] [SIGNED-OFF] Bug 9351 - sql update on existing statistics > >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >--- > installer/data/mysql/updatedatabase.pl | 21 +++++++++++++++++++++ > 1 files changed, 21 insertions(+), 0 deletions(-) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index d2b03c3..3f32555 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -9656,6 +9656,27 @@ if(CheckVersion($DBversion)) { > SetVersion($DBversion); > } > >+$DBversion = "3.19.00.XXX"; >+if ( CheckVersion($DBversion) ) { >+ $dbh->do(q{ >+ UPDATE statistics >+ SET itemtype = >+ ( >+ SELECT u.itype FROM >+ ( >+ SELECT itype,itemnumber FROM items >+ UNION ALL >+ SELECT itype,itemnumber FROM deleteditems >+ ) u >+ WHERE statistics.itemnumber = u.itemnumber >+ LIMIT 1 >+ ) >+ WHERE type IN ('localuse', 'return') >+ }); >+ print "upgrade to $DBversion done (Bug 9351 - item type not recorded correctly in statistics for returns and some local use)\n"; >+ SetVersion ($DBversion); >+} >+ > =head1 FUNCTIONS > > =head2 TableExists($table) >-- >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 9351
:
18545
|
18626
|
18627
|
18699
|
23692
|
34818
|
34819
|
34994
|
34995
|
35578
|
35712
|
35713
|
35714
|
39456
|
39457
|
39458