From 5e4c8b4a1c6a1126f75816ccdb32d465c4a5d88f Mon Sep 17 00:00:00 2001 From: gmc Date: Tue, 26 Apr 2011 13:14:56 +0000 Subject: [PATCH] LP#771187: fix syntax error in stored procedure def Author: Jason Stephenson Signed-off-by: Galen Charlton git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_2_1@20310 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/030.schema.metabib.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/0525.schema.phys-char-regression.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql index a33dd69283..2f6539f145 100644 --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql @@ -1067,7 +1067,7 @@ BEGIN ELSIF attr_def.phys_char_sf IS NOT NULL THEN -- a named Physical Characteristic, see config.marc21_physical_characteristic_*_map SELECT m.value INTO attr_value FROM biblio.marc21_physical_characteristics(NEW.id) v - config.marc21_physical_characteristic_value_map m ON (m.id = v.value) + JOIN config.marc21_physical_characteristic_value_map m ON (m.id = v.value) WHERE v.subfield = attr_def.phys_char_sf LIMIT 1; -- Just in case ... diff --git a/Open-ILS/src/sql/Pg/upgrade/0525.schema.phys-char-regression.sql b/Open-ILS/src/sql/Pg/upgrade/0525.schema.phys-char-regression.sql index 17c381b451..ddbc1f0eca 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0525.schema.phys-char-regression.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0525.schema.phys-char-regression.sql @@ -89,7 +89,7 @@ BEGIN ELSIF attr_def.phys_char_sf IS NOT NULL THEN -- a named Physical Characteristic, see config.marc21_physical_characteristic_*_map SELECT m.value INTO attr_value FROM biblio.marc21_physical_characteristics(NEW.id) v - config.marc21_physical_characteristic_value_map m ON (m.id = v.value) + JOIN config.marc21_physical_characteristic_value_map m ON (m.id = v.value) WHERE v.subfield = attr_def.phys_char_sf LIMIT 1; -- Just in case ... -- 2.11.0