View | Details | Raw Unified | Return to bug 14472
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_14472_Wrong_ISSN_search_index_in_record_matching_rules.sql (+1 lines)
Line 0 Link Here
1
UPDATE matchpoints SET search_index ='issn' where matcher_id = (SELECT matcher_id FROM marc_matchers WHERE code = 'ISSN');
(-)a/installer/data/mysql/de-DE/marcflavour/marc21/optional/marc21_default_matching_rules.sql (-1 / +1 lines)
Lines 29-35 INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_ Link Here
29
29
30
INSERT INTO marc_matchers (code, description, record_type, threshold) 
30
INSERT INTO marc_matchers (code, description, record_type, threshold) 
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers;
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'issn', 1000 FROM marc_matchers;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) 
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) 
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
(-)a/installer/data/mysql/en/marcflavour/marc21/optional/marc21_default_matching_rules.sql (-1 / +1 lines)
Lines 29-35 INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_ Link Here
29
29
30
INSERT INTO marc_matchers (code, description, record_type, threshold) 
30
INSERT INTO marc_matchers (code, description, record_type, threshold) 
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers;
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'issn', 1000 FROM marc_matchers;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) 
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) 
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
(-)a/installer/data/mysql/es-ES/marcflavour/marc21/optional/marc21_default_matching_rules.sql (-1 / +1 lines)
Lines 29-35 INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_ Link Here
29
29
30
INSERT INTO marc_matchers (code, description, record_type, threshold) 
30
INSERT INTO marc_matchers (code, description, record_type, threshold) 
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers;
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'issn', 1000 FROM marc_matchers;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) 
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) 
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
(-)a/installer/data/mysql/fr-FR/marcflavour/marc21/Optionnel/marc21_default_matching_rules.sql (-1 / +1 lines)
Lines 29-35 INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_ Link Here
29
29
30
INSERT INTO marc_matchers (code, description, record_type, threshold) 
30
INSERT INTO marc_matchers (code, description, record_type, threshold) 
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers;
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'issn', 1000 FROM marc_matchers;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) 
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) 
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
(-)a/installer/data/mysql/it-IT/marcflavour/marc21/optional/marc21_default_matching_rules.sql (-1 / +1 lines)
Lines 29-35 INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_ Link Here
29
29
30
INSERT INTO marc_matchers (code, description, record_type, threshold) 
30
INSERT INTO marc_matchers (code, description, record_type, threshold) 
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers;
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'issn', 1000 FROM marc_matchers;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) 
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) 
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
(-)a/installer/data/mysql/nb-NO/marcflavour/marc21/optional/marc21_default_matching_rules.sql (-1 / +1 lines)
Lines 29-35 INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_ Link Here
29
29
30
INSERT INTO marc_matchers (code, description, record_type, threshold) 
30
INSERT INTO marc_matchers (code, description, record_type, threshold) 
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers;
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'issn', 1000 FROM marc_matchers;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) 
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields) 
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
(-)a/installer/data/mysql/pl-PL/marcflavour/marc21/optional/marc21_default_matching_rules.sql (-1 / +1 lines)
Lines 29-35 INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_ Link Here
29
29
30
INSERT INTO marc_matchers (code, description, record_type, threshold)
30
INSERT INTO marc_matchers (code, description, record_type, threshold)
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers;
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'issn', 1000 FROM marc_matchers;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
(-)a/installer/data/mysql/ru-RU/marcflavour/marc21/optional/marc21_default_matching_rules.sql (-1 / +1 lines)
Lines 29-35 INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_ Link Here
29
29
30
INSERT INTO marc_matchers (code, description, record_type, threshold)
30
INSERT INTO marc_matchers (code, description, record_type, threshold)
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers;
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'issn', 1000 FROM marc_matchers;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
(-)a/installer/data/mysql/uk-UA/marcflavour/marc21/optional/marc21_default_matching_rules.sql (-2 / +1 lines)
Lines 29-35 INSERT INTO matchpoint_component_norms (matchpoint_component_id, sequence, norm_ Link Here
29
29
30
INSERT INTO marc_matchers (code, description, record_type, threshold)
30
INSERT INTO marc_matchers (code, description, record_type, threshold)
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
31
    VALUES ('ISSN', '022$a', 'biblio', 1000);
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'isbn', 1000 FROM marc_matchers;
32
INSERT INTO matchpoints (matcher_id, search_index, score) SELECT MAX(matcher_id), 'issn', 1000 FROM marc_matchers;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
33
INSERT INTO matcher_matchpoints SELECT MAX(matcher_id), MAX(matchpoint_id) FROM matchpoints;
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
34
INSERT INTO matchpoint_components (matchpoint_id, sequence, tag, subfields)
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
35
    SELECT MAX(matchpoint_id), 1, '022', 'a' FROM matchpoints;
36
- 

Return to bug 14472