projects / evergreen / joelewis.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: e6a0371) | patch
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
tree27a5b4de993b0d8c5db31f49ea47dcd043615089tree
parente6a0371eee20b373d2f09d27f0b44e712d481991commit | diff
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 diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_full_circ_count_view.sql diff | blob | history
Evergreen working repo (Joseph Lewis)