Patch from Thomas Berezansky addressing his recent dynamic circ/hold field weighting...
authormiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 10 Feb 2011 14:56:01 +0000 (14:56 +0000)
committermiker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Thu, 10 Feb 2011 14:56:01 +0000 (14:56 +0000)
commit866d1fe3f0d7fa68ecfb0dbc09a5c536624fca9a
tree7084824ef3c656ec78a58a230ed906d6f33ddd3a
parent91ed77750301c2a952464feec36d161e31348d60
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/trunk@19422 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]