From ecdd40f803b9a0632939ba05439517a219630af6 Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 16 Oct 2009 00:20:16 +0000 Subject: [PATCH] protect 0-param normalizers from null params value git-svn-id: svn://svn.open-ils.org/ILS/trunk@14463 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- .../sql/Pg/upgrade/0034.schema.in-db-indexing-normalization.sql | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/0034.schema.in-db-indexing-normalization.sql b/Open-ILS/src/sql/Pg/upgrade/0034.schema.in-db-indexing-normalization.sql index e73b3f2ada..bb8a0d5dfc 100644 --- a/Open-ILS/src/sql/Pg/upgrade/0034.schema.in-db-indexing-normalization.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0034.schema.in-db-indexing-normalization.sql @@ -12,13 +12,20 @@ BEGIN IF TG_TABLE_NAME::TEXT ~ 'field_entry$' THEN FOR normalizer IN SELECT n.func AS func, + n.param_count AS param_count, m.params AS params FROM config.index_normalizer n JOIN config.metabib_field_index_norm_map m ON (m.norm = n.id) WHERE field = NEW.field ORDER BY m.pos LOOP - EXECUTE 'SELECT ' || normalizer.func || '(' || quote_literal( value ) || ',' || BTRIM(normalizer.params,'[]') || ')' INTO value; + EXECUTE 'SELECT ' || normalizer.func || '(' || + quote_literal( value ) || + CASE + WHEN normalizer.param_count > 0 THEN ',' || BTRIM(normalizer.params,'[]') + ELSE '' + END || + ')' INTO value; END LOOP; END IF; -- 2.11.0