From 2f9f42738048957455006e01902de84cecaaf00f Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 15 Jul 2009 16:50:30 +0000 Subject: [PATCH] Merging 13602 from trunk: check for a null circ mod on an item when doing a non-null circ_mod test git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_6_0@13604 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/100.circ_matrix.sql | 2 +- Open-ILS/src/sql/Pg/110.hold_matrix.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/100.circ_matrix.sql b/Open-ILS/src/sql/Pg/100.circ_matrix.sql index 33733e4f5e..24a5d42b2f 100644 --- a/Open-ILS/src/sql/Pg/100.circ_matrix.sql +++ b/Open-ILS/src/sql/Pg/100.circ_matrix.sql @@ -166,7 +166,7 @@ BEGIN CASE WHEN m.usr_age_upper_bound IS NOT NULL THEN 0.5 ELSE 0 END DESC LOOP IF current_mp.circ_modifier IS NOT NULL THEN - CONTINUE WHEN current_mp.circ_modifier <> item_object.circ_modifier; + CONTINUE WHEN current_mp.circ_modifier <> item_object.circ_modifier OR item_object.circ_modifier IS NULL; END IF; IF current_mp.marc_type IS NOT NULL THEN diff --git a/Open-ILS/src/sql/Pg/110.hold_matrix.sql b/Open-ILS/src/sql/Pg/110.hold_matrix.sql index a966737252..2da8808670 100644 --- a/Open-ILS/src/sql/Pg/110.hold_matrix.sql +++ b/Open-ILS/src/sql/Pg/110.hold_matrix.sql @@ -93,7 +93,7 @@ BEGIN current_mp_weight := 5.0; IF current_mp.circ_modifier IS NOT NULL THEN - CONTINUE WHEN current_mp.circ_modifier <> item_object.circ_modifier; + CONTINUE WHEN current_mp.circ_modifier <> item_object.circ_modifier OR item_object.circ_modifier IS NULL; END IF; IF current_mp.marc_type IS NOT NULL THEN -- 2.11.0