Bug 11163: display correct itemtype usage count when deleting an itemtype
authorTomas Cohen Arazi <tomascohen@gmail.com>
Tue, 29 Oct 2013 21:39:22 +0000 (18:39 -0300)
committerGalen Charlton <gmc@esilibrary.com>
Fri, 15 Nov 2013 15:34:33 +0000 (15:34 +0000)
commit39a656c6ba555a542d468e47874be52223402c21
tree85ab0102ba5400e2fb726e3ff35e682ce445e2d6
parenta1d4af3d73bacd552fa7411e29b4963c9350ea20
Bug 11163: display correct 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.

Signed-off-by: Owen Leonard <oleonard@myacpl.org>
Signed-off-by: Jonathan Druart <jonathan.druart@biblibre.com>
Signed-off-by: Galen Charlton <gmc@esilibrary.com>
admin/itemtypes.pl