From 3cb252b09f2850e3e69b21a93d0606ad5dd78c7a Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 23 Aug 2012 16:41:18 +0200 Subject: [PATCH] Bug 5336: Replace IFNULL with COALESCE --- C4/Acquisition.pm | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/C4/Acquisition.pm b/C4/Acquisition.pm index c8a045a..8ebb5f3 100644 --- a/C4/Acquisition.pm +++ b/C4/Acquisition.pm @@ -1804,10 +1804,10 @@ sub GetHistory { my $dbh = C4::Context->dbh; my $query =" SELECT - IFNULL(biblio.title, deletedbiblio.title) AS title, - IFNULL(biblio.author, deletedbiblio.author) AS author, - IFNULL(biblioitems.isbn, deletedbiblioitems.isbn) AS isbn, - IFNULL(biblioitems.ean, deletedbiblioitems.ean) AS ean, + COALESCE(biblio.title, deletedbiblio.title) AS title, + COALESCE(biblio.author, deletedbiblio.author) AS author, + COALESCE(biblioitems.isbn, deletedbiblioitems.isbn) AS isbn, + COALESCE(biblioitems.ean, deletedbiblioitems.ean) AS ean, aqorders.basketno, aqbasket.basketname, aqbasket.basketgroupid, -- 1.7.10.4