From 88030d684a8923b86468daa069dd921d609e34ea Mon Sep 17 00:00:00 2001 From: Fridolin Somers 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 Signed-off-by: Nick --- installer/data/mysql/updatedatabase.pl | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 7e00df3..9782f6a 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -9732,6 +9732,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.10.4