From c70ff10412b775ad58e074508836c2fc1aa760bb Mon Sep 17 00:00:00 2001 From: "mkanat%kerio.com" <> Date: Thu, 17 Mar 2005 14:50:44 +0000 Subject: Bug 284125: PostgreSQL cannot call SUM on a boolean (Boolean Charts) Patch By Tomas Kopal r=mkanat, a=justdave --- Bugzilla/Search.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'Bugzilla') diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm index 3aba68ad9..1f8e53ea3 100644 --- a/Bugzilla/Search.pm +++ b/Bugzilla/Search.pm @@ -812,8 +812,8 @@ sub init { # If the numbers are the same, all flags match the condition, # so this bug should be included. if ($t =~ m/not/) { - push(@fields, "SUM($ff IS NOT NULL) AS allflags_$chartid"); - push(@fields, "SUM($term) AS matchingflags_$chartid"); + push(@fields, "SUM(CASE WHEN $ff IS NOT NULL THEN 1 ELSE 0 END) AS allflags_$chartid"); + push(@fields, "SUM(CASE WHEN $term THEN 1 ELSE 0 END) AS matchingflags_$chartid"); push(@having, "allflags_$chartid = matchingflags_$chartid"); $term = "0=0"; } -- cgit v1.2.3-24-g4f1b