projects / evergreen / pines.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: ee338f4) | 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:22:34 +0000 (16:22 -0500)
commit778ef89f5ab6ffdf8c250f2a6211203519fd3533
tree91e0436d1db7b162290a811e9d129c4319230e4atree
parentee338f4a96ac14c37e694c0168bfdafc3aaf7b1acommit | 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 (PINES)