From 393632c4b4ecc30f7a4553e4e8220e99e9a86720 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 26 Feb 2016 17:43:18 -0500 Subject: [PATCH] JBAS-1245 2.7 SQL upgrade repair call-number extracts; part 2 Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql b/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql index fb85be4b4a..c62ee01a40 100644 --- a/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql +++ b/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql @@ -5297,6 +5297,7 @@ BEGIN output_row.sort_value = public.naco_normalize_keep_decimal(raw_text,''); output_row.value = raw_text; ELSE + output_row.field_class = idx.field_class; output_row.value = BTRIM(REGEXP_REPLACE( REGEXP_REPLACE(raw_text, E'\\s+', ' ', 'g'), E'\\.+', '', 'g')); END IF; -- 2.11.0