From d40e05972f1e025b1453fdf013db3cc134d6fff1 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 12 Jun 2015 16:47:14 -0400 Subject: [PATCH] JBAS-756 Retain bib call number normalizers Avoid deleting the bib call number normalizer during 2.5 SQL upgrade. KCLS uses bib call number searches and the normalizers are set up as they should be. Specifically, this changes allows us to include punctuation in call number searches, e.g. 641.5951 Signed-off-by: Bill Erickson --- KCLS/sql/jbas-495/01.2.4.1-2.5.7-upgrade.sql | 13 +++++++------ 1 file changed, 7 insertions(+), 6 deletions(-) diff --git a/KCLS/sql/jbas-495/01.2.4.1-2.5.7-upgrade.sql b/KCLS/sql/jbas-495/01.2.4.1-2.5.7-upgrade.sql index f360c261a8..7f75ce968b 100644 --- a/KCLS/sql/jbas-495/01.2.4.1-2.5.7-upgrade.sql +++ b/KCLS/sql/jbas-495/01.2.4.1-2.5.7-upgrade.sql @@ -4019,12 +4019,13 @@ UPDATE authority.control_set_authority_field SET linking_subfield = '0' WHERE ta -- check whether patch can be applied SELECT evergreen.upgrade_deps_block_check('0838', :eg_version); -DELETE FROM config.metabib_field_index_norm_map - WHERE field = 25 AND norm IN ( - SELECT id - FROM config.index_normalizer - WHERE func IN ('search_normalize','split_date_range') - ); +-- KCLS uses bib call number searches. +-- DELETE FROM config.metabib_field_index_norm_map +-- WHERE field = 25 AND norm IN ( +-- SELECT id +-- FROM config.index_normalizer +-- WHERE func IN ('search_normalize','split_date_range') +-- ); -- check whether patch can be applied -- 2.11.0