Bugzilla – Attachment 22954 Details for
Bug 11163
Wrong itemtype usage count when deleting an itemtype
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 11163: Wrong itemtype usage count when deleting an itemtype
Bug-11163-Wrong-itemtype-usage-count-when-deleting.patch (text/plain), 1.25 KB, created by
Jonathan Druart
on 2013-11-15 09:23:49 UTC
(
hide
)
Description:
Bug 11163: Wrong itemtype usage count when deleting an itemtype
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2013-11-15 09:23:49 UTC
Size:
1.25 KB
patch
obsolete
>From 457b8bfac3424de20b9d2ded02ef1dbfb9f53832 Mon Sep 17 00:00:00 2001 >From: Tomas Cohen Arazi <tomascohen@gmail.com> >Date: Tue, 29 Oct 2013 18:39:22 -0300 >Subject: [PATCH] Bug 11163: Wrong itemtype usage count when deleting an > itemtype > >Wrong usage of UNION instead of UNION ALL prevented the count to match >the expected value. > >Steps to reproduce: >- Create an itemtype. >- Create some biblios setting the created itemtype at biblio level. >- Create some items setting the created itemtype on them. >- Try to delete the itemtype in Home > Administration > Item types, the >count is 1 and doesn't match the expected result. > >Regards >To+ > >Signed-off-by: Owen Leonard <oleonard@myacpl.org> >Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com> >--- > admin/itemtypes.pl | 2 +- > 1 file changed, 1 insertion(+), 1 deletion(-) > >diff --git a/admin/itemtypes.pl b/admin/itemtypes.pl >index ee70238..3c33073 100755 >--- a/admin/itemtypes.pl >+++ b/admin/itemtypes.pl >@@ -200,7 +200,7 @@ elsif ( $op eq 'delete_confirm' ) { > my $sth = $dbh->prepare(' > SELECT COUNT(*) AS total FROM ( > SELECT itemtype AS t FROM biblioitems >- UNION >+ UNION ALL > SELECT itype AS t FROM items > ) AS tmp > WHERE tmp.t=? >-- >1.7.10.4
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 11163
:
22530
|
22941
| 22954