projects / evergreen / pines.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 77c1fa3) | patch
Full Circ Count View Amplifies Legacy Circs
authorDan Wells <dbw2@calvin.edu>
Thu, 29 Sep 2011 13:23:49 +0000 (09:23 -0400)
committerMike Rylander <mrylander@gmail.com>
Tue, 15 Nov 2011 21:22:34 +0000 (16:22 -0500)
commitee338f4a96ac14c37e694c0168bfdafc3aaf7b1a
treefb504c1bf15343df96a78ac6bfb94185644a0e89tree
parent77c1fa3a13d58c0850a84308d02fa058e1d3e1bacommit | 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>
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 [new file with mode: 0644] blob
Evergreen working repo (PINES)