Bugzilla – Attachment 182145 Details for
Bug 38330
Make bib-level suppression a biblio table field instead of part of a MARC tag
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 38330: (QA follow-up) Fix WHERE clause in SQL update and re-word warning
Bug-38330-QA-follow-up-Fix-WHERE-clause-in-SQL-upd.patch (text/plain), 1.90 KB, created by
David Cook
on 2025-05-09 03:19:02 UTC
(
hide
)
Description:
Bug 38330: (QA follow-up) Fix WHERE clause in SQL update and re-word warning
Filename:
MIME Type:
Creator:
David Cook
Created:
2025-05-09 03:19:02 UTC
Size:
1.90 KB
patch
obsolete
>From 2deb1b44a64b6f33766a8a8a6385066c9ccd1300 Mon Sep 17 00:00:00 2001 >From: David Cook <dcook@prosentient.com.au> >Date: Fri, 9 May 2025 02:34:19 +0000 >Subject: [PATCH] Bug 38330: (QA follow-up) Fix WHERE clause in SQL update and > re-word warning > >Signed-off-by: David Cook <dcook@prosentient.com.au> >--- > installer/data/mysql/atomicupdate/bug_38330.pl | 9 ++++++--- > 1 file changed, 6 insertions(+), 3 deletions(-) > >diff --git a/installer/data/mysql/atomicupdate/bug_38330.pl b/installer/data/mysql/atomicupdate/bug_38330.pl >index b751fb453e..b004c92312 100755 >--- a/installer/data/mysql/atomicupdate/bug_38330.pl >+++ b/installer/data/mysql/atomicupdate/bug_38330.pl >@@ -27,7 +27,7 @@ return { > WHEN LOWER(TRIM(ExtractValue(m.metadata, '//datafield[@tag="942"]/subfield[@code="n"]'))) IN ('0', 'no', 'false', '') THEN 0 > ELSE 0 > END >- WHERE m.metadata LIKE '%<datafield tag="942">%'; >+ WHERE m.metadata LIKE '%<datafield tag="942" %'; > } > ); > >@@ -52,7 +52,7 @@ return { > WHEN LOWER(TRIM(ExtractValue(m.metadata, '//datafield[@tag="942"]/subfield[@code="n"]'))) IN ('0', 'no', 'false', '') THEN 0 > ELSE 0 > END >- WHERE m.metadata LIKE '%<datafield tag="942">%'; >+ WHERE m.metadata LIKE '%<datafield tag="942" %'; > } > ); > >@@ -66,6 +66,9 @@ return { > ); > > say $out "Set the 942\$n => biblio.opac_suppressed mapping for all MARC frameworks"; >- say_warning( $out, "You need to run the `maintenance/touch_all_biblios.pl` script" ); >+ say_warning( >+ $out, >+ "The biblio.opac_suppressed column should be updated, but you can run the `maintenance/touch_all_biblios.pl` script to be certain" >+ ); > }, > }; >-- >2.39.5
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 38330
:
175648
|
175649
|
175650
|
175651
|
175767
|
175768
|
175769
|
175770
|
179335
|
179336
|
179337
|
179338
|
179339
|
179340
|
179341
|
182094
|
182095
|
182096
|
182097
|
182098
|
182099
|
182100
|
182101
|
182102
|
182135
|
182136
|
182137
|
182138
|
182139
|
182140
|
182141
|
182142
|
182143
|
182144
| 182145