From 670ef3cf65d72272f3d6a654f24767f32839d50b 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 Signed-off-by: Katariina Hanhisalo Signed-off-by: Katariina Hanhisalo https://bugs.koha-community.org/show_bug.cgi?id=16223 --- 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.11.0