Bugzilla – Attachment 10565 Details for
Bug 8329
GetLostItems in C4::Items.pm has a SELECT *
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Reduced memory requirements of a massive select statement
0001-Bug-8329-GetLostItems-in-C4-Items.pm-has-a-SELECT.patch (text/plain), 1.02 KB, created by
Mark Tompsett
on 2012-06-29 14:52:04 UTC
(
hide
)
Description:
Reduced memory requirements of a massive select statement
Filename:
MIME Type:
Creator:
Mark Tompsett
Created:
2012-06-29 14:52:04 UTC
Size:
1.02 KB
patch
obsolete
>From 932b7365028fb13c013b2acac8ef4396b87f9c47 Mon Sep 17 00:00:00 2001 >From: Mark Tompsett <mtompset@hotmail.com> >Date: Fri, 29 Jun 2012 22:40:24 +0800 >Subject: [PATCH] Bug 8329 - GetLostItems in C4::Items.pm has a SELECT * > Provided a smaller list based on reports/itemlost.tt >Content-Type: text/plain; charset="utf-8" > >--- > C4/Items.pm | 3 ++- > 1 file changed, 2 insertions(+), 1 deletion(-) > >diff --git a/C4/Items.pm b/C4/Items.pm >index 2afe537..0aa2ed9 100644 >--- a/C4/Items.pm >+++ b/C4/Items.pm >@@ -908,7 +908,8 @@ sub GetLostItems { > my $dbh = C4::Context->dbh; > > my $query = " >- SELECT * >+ SELECT title, author, lib, itemlost, authorised_value, barcode, datelastseen, price, replacementprice, homebranch, >+ itype, itemtype, holdingbranch, location, itemnotes, items.biblionumber as biblionumber > FROM items > LEFT JOIN biblio ON (items.biblionumber = biblio.biblionumber) > LEFT JOIN biblioitems ON (items.biblionumber = biblioitems.biblionumber) >-- >1.7.9.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 8329
:
10565
|
11102