Bugzilla – Attachment 122982 Details for
Bug 25260
Merge 'reserves' and 'old_reserves' into a new 'holds' table
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 25260: (QA follow-up) Fix any bad dates prior to migration
Bug-25260-QA-follow-up-Fix-any-bad-dates-prior-to-.patch (text/plain), 1.20 KB, created by
Tomás Cohen Arazi (tcohen)
on 2021-07-20 16:35:50 UTC
(
hide
)
Description:
Bug 25260: (QA follow-up) Fix any bad dates prior to migration
Filename:
MIME Type:
Creator:
Tomás Cohen Arazi (tcohen)
Created:
2021-07-20 16:35:50 UTC
Size:
1.20 KB
patch
obsolete
>From 483211142335d725a3c2ab60c6c07ac7b313fccf Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Thu, 4 Mar 2021 15:25:54 +0000 >Subject: [PATCH] Bug 25260: (QA follow-up) Fix any bad dates prior to > migration > >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io> >--- > installer/data/mysql/atomicupdate/bug_25260_holds_table.perl | 4 ++++ > 1 file changed, 4 insertions(+) > >diff --git a/installer/data/mysql/atomicupdate/bug_25260_holds_table.perl b/installer/data/mysql/atomicupdate/bug_25260_holds_table.perl >index fd2fb34e45..d5730b2f8b 100644 >--- a/installer/data/mysql/atomicupdate/bug_25260_holds_table.perl >+++ b/installer/data/mysql/atomicupdate/bug_25260_holds_table.perl >@@ -42,6 +42,10 @@ if( CheckVersion( $DBversion ) ) { > ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; > |); > >+ # fix dates prior to migrating >+ sanitize_zero_date('reserves', 'expirationdate'); >+ sanitize_zero_date('old_reserves', 'expirationdate'); >+ > # migrate 'reserves' and 'old_reserves' into 'holds' > $dbh->do(q| > INSERT INTO holds ( >-- >2.32.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 25260
:
103984
|
103985
|
103986
|
103987
|
103988
|
103989
|
103990
|
103991
|
103992
|
103993
|
104053
|
104054
|
104055
|
104056
|
104057
|
117745
|
117746
|
117747
|
117748
|
117749
|
117750
|
117751
|
122761
|
122762
|
122763
|
122764
|
122765
|
122766
|
122767
|
122787
|
122788
|
122789
|
122790
|
122791
|
122792
|
122793
|
122976
|
122977
|
122978
|
122979
|
122980
|
122981
|
122982
|
122983
|
123071
|
123072
|
123073
|
123074
|
123075
|
123076
|
123077
|
123078
|
123079
|
123080
|
123257
|
123258
|
123259
|
123260
|
123261
|
123396