[Koha-bugs] [Bug 14472] Wrong ISSN search index in record matching rules

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14472

Amit Gupta <amitddng135 at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #40801|0                           |1
        is obsolete|                            |

--- Comment #9 from Amit Gupta <amitddng135 at gmail.com> ---
Created attachment 40840
  -->
http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=40840&action=edit
Bug 14472 - Wrong ISSN search index in record matching  rules

Bug 14472 - Wrong ISSN search index in record matching  rules

TEST PLAN
---------
 1) Apply the patch
 2) Export some MARC bibliographic records from Koha
 3) Import those same MARC bibliographic records using the
     "ISSN(022$a)" record matching rule.
 4) The incoming records should match perfectly
 5) Check the mysql tables (marc_matchers, matchpoints,
      matcher_matchpoints, matchpoint_components,
      matchpoint_component_norms) to make sure the values were
     inserted as expected.
For new Koha installation
1) create the koha database
2) Go to the staff client page, and do a "fresh" install making
     sure to select lots of optional marc 21 matching rules so
     the .../marc21/optional/marc21_default_matching_rules.sql
     gets triggered.
3) Check the mysql tables (marc_matchers, matchpoints,
      matcher_matchpoints, matchpoint_components,
      matchpoint_component_norms) to make sure the values were
      inserted as expected.

Fix SQL:

UPDATE matchpoints SET search_index ='issn' where matcher_id = (SELECT
matcher_id FROM marc_matchers WHERE code = 'ISSN');

-- 
You are receiving this mail because:
You are watching all bug changes.