Bugzilla – Attachment 117362 Details for
Bug 7806
Don't use 0000-00-00 to signal a non-existing date
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 7806: (follow-up) Update to use sanitize_zero_date
Bug-7806-follow-up-Update-to-use-sanitizezerodate.patch (text/plain), 1.44 KB, created by
Marcel de Rooy
on 2021-02-26 08:14:05 UTC
(
hide
)
Description:
Bug 7806: (follow-up) Update to use sanitize_zero_date
Filename:
MIME Type:
Creator:
Marcel de Rooy
Created:
2021-02-26 08:14:05 UTC
Size:
1.44 KB
patch
obsolete
>From ef917684568fdf684cb6c703355e363c1a1a78d7 Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Wed, 24 Feb 2021 15:07:38 +0000 >Subject: [PATCH] Bug 7806: (follow-up) Update to use sanitize_zero_date >Content-Type: text/plain; charset=utf-8 > >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> > >Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl> >--- > installer/data/mysql/atomicupdate/bug_7806.perl | 15 ++------------- > 1 file changed, 2 insertions(+), 13 deletions(-) > >diff --git a/installer/data/mysql/atomicupdate/bug_7806.perl b/installer/data/mysql/atomicupdate/bug_7806.perl >index d30776d548..c027d2f2a1 100644 >--- a/installer/data/mysql/atomicupdate/bug_7806.perl >+++ b/installer/data/mysql/atomicupdate/bug_7806.perl >@@ -1,19 +1,8 @@ > $DBversion = 'XXX'; # will be replaced by the RM > if( CheckVersion( $DBversion ) ) { > >- eval { >- local $dbh->{PrintError} = 0; >- $dbh->do(q| >- UPDATE aqorders >- SET datecancellationprinted = NULL >- WHERE datecancellationprinted = '0000-00-00' >- |); >- $dbh->do(q| >- UPDATE old_issues >- SET returndate = NULL >- WHERE returndate = '0000-00-00' >- |); >+ sanitize_zero_date('aqorders', 'datecancellationprinted'); >+ sanitize_zero_date('old_issues', 'returndate'); > >- }; > NewVersion( $DBversion, 7806, "Remove remaining possible 0000-00-00 values"); > } >-- >2.11.0
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 7806
:
114528
|
117266
|
117267
|
117361
| 117362 |
117915
|
117916