From d3bc972289d244e2f116e0d25f8d14e59139be09 Mon Sep 17 00:00:00 2001 From: "mkanat%kerio.com" <> Date: Fri, 8 Jul 2005 09:37:09 +0000 Subject: Bug 292768: [PostgreSQL] COALESCE requires both arguments to be of similar types Patch By Max Kanat-Alexander r=glob, r=dkl, a=justdave --- CGI.pl | 9 +++++++-- 1 file changed, 7 insertions(+), 2 deletions(-) (limited to 'CGI.pl') diff --git a/CGI.pl b/CGI.pl index d2a6b50ef..e00881ade 100644 --- a/CGI.pl +++ b/CGI.pl @@ -262,8 +262,13 @@ sub GetBugActivity { $suppwhere = "AND COALESCE(attachments.isprivate, 0) = 0"; } my $query = " - SELECT COALESCE(fielddefs.description, bugs_activity.fieldid), - fielddefs.name, bugs_activity.attach_id, " . + SELECT COALESCE(fielddefs.description, " + # This is a hack - PostgreSQL requires both COALESCE + # arguments to be of the same type, and this is the only + # way supported by both MySQL 3 and PostgreSQL to convert + # an integer to a string. MySQL 4 supports CAST. + . $dbh->sql_string_concat('bugs_activity.fieldid', q{''}) . + "), fielddefs.name, bugs_activity.attach_id, " . $dbh->sql_date_format('bugs_activity.bug_when', '%Y.%m.%d %H:%i:%s') . ", bugs_activity.removed, bugs_activity.added, profiles.login_name FROM bugs_activity -- cgit v1.2.3-24-g4f1b