From deafafeff5cc1d28b0e749acf5bfcb6012a24bae Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Wed, 18 Nov 2020 12:23:48 +0100 Subject: [PATCH] Bug 26940: Take empty strings into account --- installer/data/mysql/atomicupdate/bug_26940.perl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_26940.perl b/installer/data/mysql/atomicupdate/bug_26940.perl index a58d14a5e7..5a7999735c 100644 --- a/installer/data/mysql/atomicupdate/bug_26940.perl +++ b/installer/data/mysql/atomicupdate/bug_26940.perl @@ -4,7 +4,7 @@ if( CheckVersion( $DBversion ) ) { SELECT d.borrowernumber, GROUP_CONCAT(comment SEPARATOR '\n') AS comment FROM borrower_debarments d LEFT JOIN borrowers b ON b.borrowernumber=d.borrowernumber - WHERE b.debarredcomment IS NULL AND ( expiration > CURRENT_DATE() OR expiration IS NULL ) + WHERE ( b.debarredcomment IS NULL OR b.debarredcomment = "" ) AND ( expiration > CURRENT_DATE() OR expiration IS NULL ) GROUP BY d.borrowernumber |, { Slice => {} }); -- 2.20.1