Bugzilla – Attachment 93986 Details for
Bug 23484
Holds to pull (pendingreserves.pl) uses removed default_branch_item_rules table
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 23484: (follow-up) add parenthesis in JOIN
Bug-23484-follow-up-add-parenthesis-in-JOIN.patch (text/plain), 1.25 KB, created by
Marcel de Rooy
on 2019-10-11 08:21:32 UTC
(
hide
)
Description:
Bug 23484: (follow-up) add parenthesis in JOIN
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2019-10-11 08:21:32 UTC
Size:
1.25 KB
patch
obsolete
>From 0113839c7aca77fa540c98f7d154bc803ea23b39 Mon Sep 17 00:00:00 2001 >From: Fridolin Somers <fridolin.somers@biblibre.com> >Date: Fri, 4 Oct 2019 12:02:59 +0200 >Subject: [PATCH] Bug 23484: (follow-up) add parenthesis in JOIN >Content-Type: text/plain; charset=utf-8 > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >--- > circ/pendingreserves.pl | 2 +- > 1 file changed, 1 insertion(+), 1 deletion(-) > >diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl >index 983bfdf41f..9f62b28b22 100755 >--- a/circ/pendingreserves.pl >+++ b/circ/pendingreserves.pl >@@ -214,7 +214,7 @@ my $strsth = > LEFT JOIN branchtransfers ON items.itemnumber=branchtransfers.itemnumber > LEFT JOIN issues ON items.itemnumber=issues.itemnumber > LEFT JOIN borrowers ON reserves.borrowernumber=borrowers.borrowernumber >- LEFT JOIN circulation_rules ON items.itype=circulation_rules.itemtype AND rule_name = 'holdallowed' AND circulation_rules.branchcode IS NULL AND circulation_rules.categorycode IS NULL >+ LEFT JOIN circulation_rules ON ( items.itype=circulation_rules.itemtype AND rule_name = 'holdallowed' AND circulation_rules.branchcode IS NULL AND circulation_rules.categorycode IS NULL ) > WHERE > reserves.found IS NULL > $sqldatewhere >-- >2.11.0
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 23484
:
92403
|
93728
|
93731
|
93985
| 93986