LP932540: Fix ISSN indexing user/dbs/lp932540_fix_issn_indexing
authorDan Scott <dan@coffeecode.net>
Thu, 22 Mar 2012 02:39:40 +0000 (22:39 -0400)
committerDan Scott <dan@coffeecode.net>
Thu, 22 Mar 2012 02:51:03 +0000 (22:51 -0400)
commit0d9464dc317561cd0358915179d065ce45cdde3e
treeb309ccf26efed6c223138d33032b906f05b19305
parent21b72b3848b27a2d71c88b8833a365cec4fb7325
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]