Use DISTINCT in counts to avoid dupes
authorThomas Berezansky <tsbere@mvlc.org>
Thu, 29 Sep 2011 14:44:26 +0000 (10:44 -0400)
committerMike Rylander <mrylander@gmail.com>
Tue, 15 Nov 2011 21:18:54 +0000 (16:18 -0500)
commitdbbb3a30c5f3fdfbd7f423e399d0e3707f4ae515
tree27a5b4de993b0d8c5db31f49ea47dcd043615089
parente6a0371eee20b373d2f09d27f0b44e712d481991
Use DISTINCT in counts to avoid dupes

Otherwise you get:
Legacy count + 2(normal count)(aged count)

Signed-off-by: Thomas Berezansky <tsbere@mvlc.org>
Signed-off-by: Mike Rylander <mrylander@gmail.com>
Open-ILS/src/sql/Pg/extend-reporter.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_full_circ_count_view.sql