projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 539cd8f) | patch
Use DISTINCT in counts to avoid dupes collab/dbwells/full_circ_count_view
authorThomas Berezansky <tsbere@mvlc.org>
Thu, 29 Sep 2011 14:44:26 +0000 (10:44 -0400)
committerThomas Berezansky <tsbere@mvlc.org>
Thu, 29 Sep 2011 14:44:26 +0000 (10:44 -0400)
commitdbbaa938e683064a3b0423417ab7b612f7566250
tree42f12ba7a71c501fdc83325f9901fee63beff015tree
parent539cd8f3c4a8e6dc2b5b398983d21b99ca6aeb5fcommit | 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>
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 ILS