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

(-)a/installer/data/mysql/atomicupdate/bug_38330.pl (-7 / +6 lines)
Lines 22-32 return { Link Here
22
                    JOIN biblio_metadata m ON b.biblionumber = m.biblionumber
22
                    JOIN biblio_metadata m ON b.biblionumber = m.biblionumber
23
                    SET b.opac_suppressed = 
23
                    SET b.opac_suppressed = 
24
                        CASE
24
                        CASE
25
                            WHEN ExtractValue(m.metadata, '//datafield[@tag="952"]/subfield[@code="n"]') REGEXP '^[01]$' THEN
25
                            WHEN ExtractValue(m.metadata, '//datafield[@tag="942"]/subfield[@code="n"]') REGEXP '^[01]$' THEN
26
                                ExtractValue(m.metadata, '//datafield[@tag="952"]/subfield[@code="n"]')
26
                                ExtractValue(m.metadata, '//datafield[@tag="942"]/subfield[@code="n"]')
27
                            ELSE 0
27
                            ELSE 0
28
                        END
28
                        END
29
                    WHERE m.metadata LIKE '%<datafield tag="952">%';
29
                    WHERE m.metadata LIKE '%<datafield tag="942">%';
30
                }
30
                }
31
            );
31
            );
32
32
Lines 47-57 return { Link Here
47
                    JOIN deletedbiblio_metadata m ON b.biblionumber = m.biblionumber
47
                    JOIN deletedbiblio_metadata m ON b.biblionumber = m.biblionumber
48
                    SET b.opac_suppressed = 
48
                    SET b.opac_suppressed = 
49
                        CASE
49
                        CASE
50
                            WHEN ExtractValue(m.metadata, '//datafield[@tag="952"]/subfield[@code="n"]') REGEXP '^[01]$' THEN
50
                            WHEN ExtractValue(m.metadata, '//datafield[@tag="942"]/subfield[@code="n"]') REGEXP '^[01]$' THEN
51
                                ExtractValue(m.metadata, '//datafield[@tag="952"]/subfield[@code="n"]')
51
                                ExtractValue(m.metadata, '//datafield[@tag="942"]/subfield[@code="n"]')
52
                            ELSE 0
52
                            ELSE 0
53
                        END
53
                        END
54
                    WHERE m.metadata LIKE '%<datafield tag="952">%';
54
                    WHERE m.metadata LIKE '%<datafield tag="942">%';
55
                }
55
                }
56
            );
56
            );
57
57
58
- 

Return to bug 38330