From 28d6ac4d917c54e5b7ee776b3a2a74d1299db0a0 Mon Sep 17 00:00:00 2001 From: Martin Renvoize Date: Thu, 25 Apr 2019 08:15:58 +0100 Subject: [PATCH] Bug 22729: (QA follow-up) Ensure no NULL values before setting NOT NULL Signed-off-by: Martin Renvoize --- installer/data/mysql/atomicupdate/bug_21336_followup.perl | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/installer/data/mysql/atomicupdate/bug_21336_followup.perl b/installer/data/mysql/atomicupdate/bug_21336_followup.perl index 880d83205e..ff2688900d 100644 --- a/installer/data/mysql/atomicupdate/bug_21336_followup.perl +++ b/installer/data/mysql/atomicupdate/bug_21336_followup.perl @@ -2,6 +2,9 @@ $DBversion = 'XXX'; if( CheckVersion( $DBversion ) ) { if ( column_exists( 'borrowers', 'flgAnonymized' ) ) { + $dbh->do(q{ + UPDATE borrowers SET flgAnonymized = 0 WHERE flgAnonymized IS NULL + }); $dbh->do(q{ ALTER TABLE borrowers CHANGE `flgAnonymized` `anonymized` TINYINT(1) NOT NULL DEFAULT 0 @@ -9,6 +12,9 @@ if( CheckVersion( $DBversion ) ) { } if ( column_exists( 'deletedborrowers', 'flgAnonymized' ) ) { + $dbh->do(q{ + UPDATE deletedborrowers SET flgAnonymized = 0 WHERE flgAnonymized IS NULL + }); $dbh->do(q{ ALTER TABLE deletedborrowers CHANGE `flgAnonymized` `anonymized` TINYINT(1) NOT NULL DEFAULT 0 -- 2.20.1