Summary: | Wrong itemtype usage count when deleting an itemtype | ||
---|---|---|---|
Product: | Koha | Reporter: | Tomás Cohen Arazi (tcohen) <tomascohen> |
Component: | System Administration | Assignee: | Bugs List <koha-bugs> |
Status: | CLOSED FIXED | QA Contact: | Testopia <testopia> |
Severity: | minor | ||
Priority: | P5 - low | CC: | gmcharlt |
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
Change sponsored?: | --- | Patch complexity: | Trivial patch |
Documentation contact: | Documentation submission: | ||
Text to go in the release notes: | Version(s) released in: | ||
Circulation function: | |||
Attachments: |
Bug 11163: Wrong itemtype usage count when deleting an itemtype
[SIGNED-OFF] Bug 11163: Wrong itemtype usage count when deleting an itemtype Bug 11163: Wrong itemtype usage count when deleting an itemtype |
Description
Tomás Cohen Arazi (tcohen)
2013-10-29 21:36:35 UTC
Created attachment 22530 [details] [review] 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. Regards To+ Created attachment 22941 [details] [review] [SIGNED-OFF] 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> Created attachment 22954 [details] [review] 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> Pushed to master and 3.14.x. Thanks, Tomás! This patch has been pushed to 3.12.x, will be in 3.12.8. |