From 8eecfbf4903f2f95890bce1c4f3282ee94fbaabd Mon Sep 17 00:00:00 2001 From: gmc Date: Tue, 26 Apr 2011 13:14:06 +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/trunk@20309 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/030.schema.metabib.sql | 2 +- .../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 a33dd69..2f6539f 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 17c381b..ddbc1f0 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 ... -- 1.7.2.5