gerv at mozilla.org
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