Attachment 118526 Details for Bug 16223 – Bug 26940: Take empty strings into account

Bug 26940: Take empty strings into account

Bug-26940-Take-empty-strings-into-account.patch (text/plain), 1.29 KB, created by ByWater Sandboxes on 2021-03-19 12:54:25 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: ByWater Sandboxes

Created: 2021-03-19 12:54:25 UTC

Size: 1.29 KB

patch

obsolete

>From 670ef3cf65d72272f3d6a654f24767f32839d50b Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Wed, 18 Nov 2020 12:23:48 +0100
>Subject: [PATCH] Bug 26940: Take empty strings into account
>
>Signed-off-by: Katariina Hanhisalo <katariina.hanhisalo@xamk.fi>
>
>Signed-off-by: Katariina Hanhisalo <katariina.hanhisalo@xamk.fi>
>
>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

Actions: View

Attachments on bug 16223: 50078 | 50084 | 99697 | 99698 | 104399 | 104400 | 114272 | 114273 | 118526 | 118572 | 118574 | 118575 | 122768 | 122769 | 127252 | 128005 | 132284 | 132285 | 132286 | 132287 | 143388 | 143389 | 143390 | 143462 | 143670 | 143671 | 143672 | 143688 | 143689 | 143690 | 143765 | 143766 | 143767 | 143768 | 143769 | 143770 | 143936 | 146051 | 146052 | 146053 | 146054 | 146055 | 146056 | 146057 | 148307 | 148308 | 148309 | 148310 | 148311 | 148312 | 148313 | 150024 | 150025 | 150026 | 150027 | 150028 | 150029 | 153024 | 153025 | 153026 | 153027 | 153028 | 153029 | 155644 | 155645 | 155646 | 155647 | 155648 | 155649 | 155650 | 156841 | 156842 | 156843 | 156844 | 156845 | 156846 | 156847 | 156848 | 156849 | 156850