]> git.evergreen-ils.org Git - Evergreen.git/commit
projects / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: a3b8fb1) | 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:24:22 +0000 (16:24 -0500)
commit94ad57aaa69534d0541406de6afa721a7f4ec9d4
tree40feb10122da45f40b7d9c36d6d185a325b36ea4tree
parenta3b8fb1d6057adacf9136690bfc1143c3b1dac9ecommit | 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 ILS