From aa33575a41d00320b92c6ca528dbbf3df257b765 Mon Sep 17 00:00:00 2001 From: miker Date: Tue, 20 Jan 2009 19:58:33 +0000 Subject: [PATCH] fix an sql typo git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_4@11890 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/100.circ_matrix.sql | 4 ++-- 1 file 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 3be5d55a56..82637962b9 100644 --- a/Open-ILS/src/sql/Pg/100.circ_matrix.sql +++ b/Open-ILS/src/sql/Pg/100.circ_matrix.sql @@ -342,7 +342,7 @@ BEGIN WHERE circ.usr = match_user AND (circ_test.org_depth IS NULL OR (circ_test.org_depth IS NOT NULL AND circ_lib IN ( SELECT * FROM explode_array(overdue_orgs) ))) AND circ.checkin_time IS NULL - AND (circ.stop_fines IN ('MAXFINES','LONGOVERDUE') OR circ.stop_fines IS NULL) + AND (circ.stop_fines IN ('MAXFINES','LONGOVERDUE') OR circ.stop_fines IS NULL) AND cp.circ_modifier = out_by_circ_mod.circ_mod; IF items_out >= out_by_circ_mod.items_out THEN result.fail_part := 'config.circ_matrix_circ_mod_test'; @@ -360,7 +360,7 @@ BEGIN AND (circ_test.org_depth IS NULL OR (circ_test.org_depth IS NOT NULL AND circ_lib IN ( SELECT * FROM explode_array(overdue_orgs) ))) AND checkin_time IS NULL AND due_date < NOW() - AND (circ.stop_fines IN ('MAXFINES','LONGOVERDUE') OR circ.stop_fines IS NULL); + AND (stop_fines IN ('MAXFINES','LONGOVERDUE') OR stop_fines IS NULL); IF items_overdue >= circ_test.max_overdue THEN result.fail_part := 'config.circ_matrix_test.max_overdue'; result.success := FALSE; -- 2.11.0