Bugzilla – Attachment 117916 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: [20.05] (follow-up) Update to use sanitize_zero_date
Bug-7806-2005-follow-up-Update-to-use-sanitizezero.patch (text/plain), 1.41 KB, created by
Jonathan Druart
on 2021-03-08 11:07:28 UTC
(
hide
)
Description:
Bug 7806: [20.05] (follow-up) Update to use sanitize_zero_date
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2021-03-08 11:07:28 UTC
Size:
1.41 KB
patch
obsolete
>From c88b10d8ce78b1a6244757481535fc2e0eb9f582 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: [20.05] (follow-up) Update to use > sanitize_zero_date > >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.20.1
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