From 89b408e84fba20c2c27680bd922012a4a488ca26 Mon Sep 17 00:00:00 2001 From: Fridolin Somers 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=UTF-8 Content-Transfer-Encoding: 8bit Signed-off-by: Emmi Takkinen Signed-off-by: Séverine QUEUNE --- C4/Items.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Items.pm b/C4/Items.pm index 55bae13..740d427 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.1.4