The default bug view has changed. See this FAQ.

PostgreSQL cannot call SUM on a boolean (Boolean Charts)

RESOLVED FIXED in Bugzilla 2.20

Status

()

Bugzilla
Query/Bug List
P1
normal
RESOLVED FIXED
12 years ago
12 years ago

People

(Reporter: Max Kanat-Alexander, Assigned: Tomas Kopal)

Tracking

2.19.2
Bugzilla 2.20
Bug Flags:
approval +
blocking2.20 +

Details

Attachments

(1 attachment)

V1
863 bytes, patch
Max Kanat-Alexander
: review+
Details | Diff | Splinter Review
(Reporter)

Description

12 years ago
The boolean charts try to do something like:

SUM(CONCAT(flagtypes_0.name, flags_0.status::varchar) != 'review+')

(That's the boolean chart "Flag is not equal to review+".)

However, PostgreSQL throws an error when you try to do this:

"Function sum(boolean) does not exist"
(Reporter)

Comment 1

12 years ago
Oh, by the way, ignore that "::varchar," that's a local customization. (That's
not in the tip Search.pm.)
(Assignee)

Updated

12 years ago
Assignee: query-and-buglist → Tomas.Kopal
(Assignee)

Updated

12 years ago
Status: NEW → ASSIGNED
Target Milestone: --- → Bugzilla 2.20
(Assignee)

Comment 2

12 years ago
Created attachment 177663 [details] [diff] [review]
V1

It turned out to be simpler than I expected - only one occurence of this
problem in the whole of bugzilla :-).
Attachment #177663 - Flags: review?(mkanat)
(Reporter)

Comment 3

12 years ago
Comment on attachment 177663 [details] [diff] [review]
V1

Hey, that's quite a clever fix! :-)
Attachment #177663 - Flags: review?(mkanat) → review+
(Reporter)

Updated

12 years ago
Flags: blocking2.20?
Flags: approval?
Priority: -- → P1
Flags: blocking2.20?
Flags: blocking2.20+
Flags: approval?
Flags: approval+
(Reporter)

Comment 4

12 years ago
Checking in Bugzilla/Search.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/Search.pm,v  <--  Search.pm
new revision: 1.92; previous revision: 1.91
done
Status: ASSIGNED → RESOLVED
Last Resolved: 12 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.