Closed Bug 284125 Opened 17 years ago Closed 17 years ago
SQL cannot call SUM on a boolean (Boolean Charts)
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"
Oh, by the way, ignore that "::varchar," that's a local customization. (That's not in the tip Search.pm.)
Status: NEW → ASSIGNED
Target Milestone: --- → Bugzilla 2.20
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)
Comment on attachment 177663 [details] [diff] [review] V1 Hey, that's quite a clever fix! :-)
Attachment #177663 - Flags: review?(mkanat) → review+
Priority: -- → P1
17 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: 17 years ago
Resolution: --- → FIXED
You need to log in before you can comment on or make changes to this bug.