Patch from Thomas Berezansky addressing his recent dynamic circ/hold field weighting...
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 10 Feb 2011 14:58:44 +0000 (14:58 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 10 Feb 2011 14:58:44 +0000 (14:58 +0000)
commitd1589c98c2f70ae6518dd01d54e65c4b48be1d0a
tree7084824ef3c656ec78a58a230ed906d6f33ddd3a
parent34bc7622dd201f7366fc720b0b8754ae78778650
Patch from Thomas Berezansky addressing his recent dynamic circ/hold field weighting patch.

Due to an oversight of auto-casting on my part dynamic weighting may incorrectly order similar rows that differ only in org unit or permission group.

Bad me for not testing for that case before now.

The attached patch should fix this. All it does is replace two functions, and in them replaces one INT variable with a NUMERIC(6,2) and a pile of integer constants with numeric constants (by virtue of adding .0 to them).

git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_2_1@19423 dcc99617-32d9-48b4-a31d-7c20da2025e4
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/100.circ_matrix.sql
Open-ILS/src/sql/Pg/110.hold_matrix.sql
Open-ILS/src/sql/Pg/upgrade/0483.dynamic_weights_fix.sql [new file with mode: 0644]