From d18734c6d5755dbb6d4e9a90bbbbca50a2c71b77 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Mon, 17 Jun 2013 11:52:46 -0400 Subject: [PATCH] SQL typo would prevent ingest, which is terrible Signed-off-by: Dan Scott --- Open-ILS/src/sql/Pg/030.schema.metabib.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/030.schema.metabib.sql b/Open-ILS/src/sql/Pg/030.schema.metabib.sql index 9223e36c03..68d44fd102 100644 --- a/Open-ILS/src/sql/Pg/030.schema.metabib.sql +++ b/Open-ILS/src/sql/Pg/030.schema.metabib.sql @@ -646,7 +646,7 @@ BEGIN -- (for example, for titles of songs in music albums) IF (ind_data.search_field OR ind_data.browse_field) AND NOT b_skip_search THEN EXECUTE 'SELECT 1 FROM metabib.' || ind_data.field_class || - '_field_entry WHERE field = $1 source = $2 AND value = $3' + '_field_entry WHERE field = $1 AND source = $2 AND value = $3' INTO mbe_id USING ind_data.field, ind_data.source, ind_data.value; -- RAISE NOTICE 'Search for an already matching row returned %', mbe_id; IF mbe_id IS NULL THEN -- 2.11.0