LP932540: Fix ISSN indexing user/dbs/lp932540_fix_issn_indexing_rel_2_1
authorDan Scott <dan@coffeecode.net>
Thu, 22 Mar 2012 02:48:46 +0000 (22:48 -0400)
committerDan Scott <dan@coffeecode.net>
Thu, 22 Mar 2012 02:48:46 +0000 (22:48 -0400)
commit9b977d1fe24d26d1ad2e60245fa0480faa14e4aa
treec1af5965a7741f25c0497145867290fffcee9540
parentc0e3515dbbf5ac7941b183d6f0f063d1e2b992d0
LP932540: Fix ISSN indexing

The default config.metabib_field_index_norm_map contains a 'replace'
entry for the ISSN identifier field that replaces spaces with "". That
was meant to handle ISSNs that incorrectly contain a space instead of a
hyphen; it normalizes them from: "1234 1234" to "12341234".

However, that breaks indexing ISSNs if there are multiple ISSNs in the
record, or even if there is an extra character in the same subfield as
the primary ISSN, as all spaces are removed.

This commit removes the 'replace' entry for the ISSN identifier field
and reindexes potentially damaged ISSN index entries.

Signed-off-by: Dan Scott <dan@coffeecode.net>
Open-ILS/src/sql/Pg/950.data.seed-values.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.do_not_despace_issns.sql [new file with mode: 0644]