From 1c595b8d9b92a57b9e48d55d30e215a00afadcfe Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Mon, 22 Jul 2013 12:35:46 -0400 Subject: [PATCH] Fixing LP 1203796. The alternate view in the Item Status screen shows a "Total Circs" field that was under-counting circulations because UNION filtered out duplicates. This commit replaces UNION with UNION ALL, which allows duplicate rows. Signed-off-by: Chris Sharp Signed-off-by: Ben Shum --- Open-ILS/examples/fm_IDL.xml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml index f4c24406c3..6107b95a1d 100644 --- a/Open-ILS/examples/fm_IDL.xml +++ b/Open-ILS/examples/fm_IDL.xml @@ -10444,7 +10444,7 @@ SELECT usr, asset.copy cp JOIN action.circulation circ ON (cp.id = circ.target_copy) GROUP BY 1, 3, 4 - UNION + UNION ALL SELECT cp.id as copy, COUNT(circ.id), @@ -10454,7 +10454,7 @@ SELECT usr, asset.copy cp JOIN action.aged_circulation circ ON (cp.id = circ.target_copy) GROUP BY 1, 3, 4 - UNION + UNION ALL SELECT id as copy, circ_count, -- 2.11.0