Difference between revisions of "Bugzilla Analysis"

From CDOT Wiki
Jump to: navigation, search
Line 98: Line 98:
 
<tr>
 
<tr>
 
<th>How many bugs for just Firefox (vs. Thunderbird, Calendar, and other products)</th>
 
<th>How many bugs for just Firefox (vs. Thunderbird, Calendar, and other products)</th>
 +
</tr>
 +
<tr>
 +
<td>Core</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Calendar</td>
 +
<td>select count(*) from bugs where product_id=2;</td>
 +
<td>8,059</td>
 +
</tr>
 +
<tr>
 +
<td>CCK</td>
 +
<td>select count(*) from bugs where product_id=3;</td>
 +
<td>694</td>
 +
</tr>
 +
<tr>
 +
<td>Directory</td>
 +
<td>select count(*) from bugs where product_id=4;</td>
 +
<td>630</td>
 +
</tr>
 +
<tr>
 +
<td>Grendel</td>
 +
<td>select count(*) from bugs where product_id=5;</td>
 +
<td>87</td>
 +
</tr>
 +
<tr>
 +
<td>MozillaClassic</td>
 +
<td>select count(*) from bugs where product_id=7;</td>
 +
<td>480</td>
 +
</tr>
 +
<tr>
 +
<td>Webtools</td>
 +
<td>select count(*) from bugs where product_id=8;</td>
 +
<td>2,207</td>
 +
</tr>
 +
<tr>
 +
<td>NSPR</td>
 +
<td>select count(*) from bugs where product_id=9;</td>
 +
<td>1,299</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 +
</tr>
 +
<tr>
 +
<td>Core(ID=1)</td>
 +
<td>select count(*) from bugs where product_id=1;</td>
 +
<td>176,713</td>
 
</tr>
 
</tr>
 
<tr>
 
<tr>
Line 103: Line 248:
 
<td>select count(*) from bugs where product_id=1;</td>
 
<td>select count(*) from bugs where product_id=1;</td>
 
<td>176,713</td>
 
<td>176,713</td>
 +
</tr>
 
</table>
 
</table>

Revision as of 23:28, 25 June 2008

Students in BTR490 are working on analyzing historical Bugzilla data for Mozilla. This pages documents some of their findings and ideas.


Bugzilla Database Questions

By:Timothy Kwan, Rajiv Gagwani, Jasdeep Singh Goraya

Questions Query Result
How many bugs are there? Select count(bug_id) from bugs; 425,992
How many bugs per year?
1994 Select count(distinct bug_id) from bugs where creation_ts like '1994%'; 2
1995 Select count(distinct bug_id) from bugs where creation_ts like '1995%'; 1
1996 Select count(distinct bug_id) from bugs where creation_ts like '1996%'; 5
1997 Select count(distinct bug_id) from bugs where creation_ts like '1997%'; 36
1998 Select count(distinct bug_id) from bugs where creation_ts like '1998%'; 2020
1999 Select count(distinct bug_id) from bugs where creation_ts like '1999%'; 20,411
2000 Select count(distinct bug_id) from bugs where creation_ts like '2000%'; 40298
2001 Select count(distinct bug_id) from bugs where creation_ts like '2001%'; 53,468
2002 Select count(distinct bug_id) from bugs where creation_ts like '2002%'; 69,701
2003 Select count(distinct bug_id) from bugs where creation_ts like '2003%'; 42,371
2004 Select count(distinct bug_id) from bugs where creation_ts like '2004%'; 46,739
2005 Select count(distinct bug_id) from bugs where creation_ts like '2005%'; 45,173
2006 Select count(distinct bug_id) from bugs where creation_ts like '2006%'; 41,898
2007 Select count(distinct bug_id) from bugs where creation_ts like '2007%'; 41,872
2008 Select count(distinct bug_id) from bugs where creation_ts like '2008%'; 21,997
How many bugs for just Firefox (vs. Thunderbird, Calendar, and other products)
Core select count(*) from bugs where product_id=1; 176,713
Calendar select count(*) from bugs where product_id=2; 8,059
CCK select count(*) from bugs where product_id=3; 694
Directory select count(*) from bugs where product_id=4; 630
Grendel select count(*) from bugs where product_id=5; 87
MozillaClassic select count(*) from bugs where product_id=7; 480
Webtools select count(*) from bugs where product_id=8; 2,207
NSPR select count(*) from bugs where product_id=9; 1,299
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Core(ID=1) select count(*) from bugs where product_id=1; 176,713
Retrieved from "https://wiki.cdot.senecapolytechnic.ca/w/index.php?title=Bugzilla_Analysis&oldid=15756"