Counting comments

Gervase Markham gerv at
Sat Oct 16 15:38:18 UTC 2004

Is it possible, either via the GUI or directly in SQL, to say:

"Give me a list of all bugs meeting certain criteria, which in addition
have (exactly 1|more than 1) comment"?

I can do:

SELECT bug_id, count(bug_when) AS bug_count FROM longdescs GROUP BY bug_id;

but then I can't say "AND bug_count > 1" - it doesn't like that.

At a pinch, I could cope with a solution just for one of the two cases,
as I could do the root query and subtract.


More information about the developers mailing list