From 7cea397f3ea0988b4edd4b2225fc65bf28b63611 Mon Sep 17 00:00:00 2001
From: "jocuri%softhome.net" <>
Date: Sat, 31 Jul 2004 15:59:16 +0000
Subject: Patch for bug 253357: replace IFNULL with COALESCE for increased
 database compatibility; patch by Tomas Kopal <Tomas.Kopal@altap.cz>; r=vladd,
 a=justdave.

---
 long_list.cgi | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'long_list.cgi')

diff --git a/long_list.cgi b/long_list.cgi
index 657ff9e24..5644a5323 100755
--- a/long_list.cgi
+++ b/long_list.cgi
@@ -42,7 +42,7 @@ my $cgi = Bugzilla->cgi;
 my $generic_query = "
   SELECT 
     bugs.bug_id, 
-    IFNULL(bugs.alias,''), 
+    COALESCE(bugs.alias, ''), 
     products.name, 
     bugs.version, 
     bugs.rep_platform,
-- 
cgit v1.2.3-24-g4f1b