From 07cab93d5d9bd292368e097305f309419e746e2f Mon Sep 17 00:00:00 2001
From: Fridolin Somers <fridolin.somers@biblibre.com>
Date: Fri, 16 Oct 2020 10:45:41 +0200
Subject: [PATCH] Bug 26032: (follow-up) Replace IFNULL() mysqlism with
 COALESCE()
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

Signed-off-by: Emmi Takkinen <emmi.takkinen@outlook.com>
Signed-off-by: Séverine QUEUNE <severine.queune@bulac.fr>
Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
---
 C4/Items.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/C4/Items.pm b/C4/Items.pm
index 55bae137f9..740d4275f0 100644
--- a/C4/Items.pm
+++ b/C4/Items.pm
@@ -1379,7 +1379,7 @@ sub _SearchItems_build_where_fragment {
             }
 
             if ( defined $ifnull ) {
-                $column = "IFNULL($column, ?)";
+                $column = "COALESCE($column, ?)";
             }
 
             if (ref $query eq 'ARRAY') {
-- 
2.39.5