Closed
Bug 284125
Opened 20 years ago
Closed 20 years ago
PostgreSQL cannot call SUM on a boolean (Boolean Charts)
Categories
(Bugzilla :: Query/Bug List, defect, P1)
Tracking
()
RESOLVED
FIXED
Bugzilla 2.20
People
(Reporter: mkanat, Assigned: Tomas.Kopal)
References
Details
Attachments
(1 file)
|
(deleted),
patch
|
mkanat
:
review+
|
Details | Diff | Splinter Review |
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•20 years ago
|
||
Oh, by the way, ignore that "::varchar," that's a local customization. (That's
not in the tip Search.pm.)
|
Assignee | |
Updated•20 years ago
|
Assignee: query-and-buglist → Tomas.Kopal
|
|
Assignee | |
Updated•20 years ago
|
Status: NEW → ASSIGNED
Target Milestone: --- → Bugzilla 2.20
|
|
Assignee | |
Comment 2•20 years ago
|
||
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•20 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•20 years ago
|
Flags: blocking2.20?
Flags: approval?
Priority: -- → P1
|
||
Updated•20 years ago
|
Flags: blocking2.20?
Flags: blocking2.20+
Flags: approval?
Flags: approval+
|
|
Reporter | |
Comment 4•20 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
Closed: 20 years ago
Resolution: --- → FIXED
You need to log in
before you can comment on or make changes to this bug.
Description
•