projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 0d56368) | patch
Full Circ Count View Amplifies Legacy Circs
authorDan Wells <dbw2@calvin.edu>
Thu, 29 Sep 2011 13:23:49 +0000 (09:23 -0400)
committerDan Wells <dbw2@calvin.edu>
Thu, 29 Sep 2011 13:23:49 +0000 (09:23 -0400)
commit539cd8f3c4a8e6dc2b5b398983d21b99ca6aeb5f
tree884a53469eac8549b6b04343da4b320d045a9161tree
parent0d5636809fbb11784edc37fd611ac1471c9e1f29commit | diff
Full Circ Count View Amplifies Legacy Circs

The current extend_reported.full_circ_count sums the legacy circ count
column, but this results in amplifying the count by the number of current
circs in the system.  This commit adds the legacy count to the GROUP BY
instead of summing it.

Signed-off-by: Dan Wells <dbw2@calvin.edu>
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 [new file with mode: 0644] blob
Evergreen ILS