Difference between revisions of "Bugzilla Analysis"

From CDOT Wiki
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 248: Line 248:
 
<td>select count(*) from bugs where product_id=37;</td>
 
<td>select count(*) from bugs where product_id=37;</td>
 
<td>572</td>
 
<td>572</td>
 +
</tr>
 +
<tr>
 +
<td>Testopia</td>
 +
<td>select count(*) from bugs where product_id=38;</td>
 +
<td>423</td>
 +
</tr>
 +
<tr>
 +
<td>Penelope</td>
 +
<td>select count(*) from bugs where product_id=39;</td>
 +
<td>375</td>
 +
</tr>
 +
<tr>
 +
<td>Mozilla Labs</td>
 +
<td>select count(*) from bugs where product_id=40;</td>
 +
<td>588</td>
 +
</tr>
 +
<tr>
 +
<td>Sumo</td>
 +
<td>select count(*) from bugs where product_id=42;</td>
 +
<td>570</td>
 +
</tr>
 +
<tr>
 +
<td>Tamarin</td>
 +
<td>select count(*) from bugs where product_id=43;</td>
 +
<td>426</td>
 +
</tr>
 +
<tr>
 +
<td>Extend Firefox</td>
 +
<td>select count(*) from bugs where product_id=44;</td>
 +
<td>5</td>
 +
</tr>
 +
<tr>
 +
<td>Fennec</td>
 +
<td>select count(*) from bugs where product_id=46;</td>
 +
<td>27</td>
 +
</tr>
 +
<tr>
 +
<th>How many bugs are currently NEW vs. ASSIGNED vs. RESOLVED, etc.</th>
 +
</tr>
 +
<tr>
 +
<td>New</td>
 +
<td>select count(*) from bugs where bug_status='NEW';</td>
 +
<td>44,568</td>
 +
</tr>
 +
<tr>
 +
<td>Assigned</td>
 +
<td>select count(*) from bugs where bug_status='ASSIGNED';</td>
 +
<td>4,697</td>
 +
</tr>
 +
<tr>
 +
<td>Resolved</td>
 +
<td>select count(*) from bugs where bug_status='RESOLVED';</td>
 +
<td>207,496</td>
 +
</tr>
 +
<tr>
 +
<td>Verified</td>
 +
<td>select count(*) from bugs where bug_status='VERIFIED';</td>
 +
<td>148,747</td>
 +
</tr>
 +
<tr>
 +
<td>Closed</td>
 +
<td>select count(*) from bugs where bug_status='CLOSED';</td>
 +
<td>1,496</td>
 +
</tr>
 +
<tr>
 +
<td>Reopened</td>
 +
<td>select count(*) from bugs where bug_status=REOPENED';</td>
 +
<td>962</td>
 +
</tr>
 +
<tr>
 +
<td>Unconfirmed</td>
 +
<td>select count(*) from bugs where bug_status='UNCONFIRMED';</td>
 +
<td>18,026</td>
 
</tr>
 
</tr>
 
</table>
 
</table>

Latest revision as of 00:49, 26 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
mozilla.org select count(*) from bugs where product_id=10; 11,086
Rhino select count(*) from bugs where product_id=11; 697
Derivatives select count(*) from bugs where product_id=12; 28
Documentation select count(*) from bugs where product_id=13; 651
Tech Evangelism select count(*) from bugs where product_id=15; 9,461
NSS select count(*) from bugs where product_id=16; 3,761
Mozilla Localizations select count(*) from bugs where product_id=17; 3,250
JSS select count(*) from bugs where product_id=18; 316
Bugzilla select count(*) from bugs where product_id=19; 12,957
Camino select count(*) from bugs where product_id=20; 8,239
Firefox select count(*) from bugs where product_id=21; 71,596
Other Applications select count(*) from bugs where product_id=28; 3,003
addons.mozilla.org select count(*) from bugs where product_id=31; 3,743
Composer select count(*) from bugs where product_id=27; 37
Marketing select count(*) from bugs where product_id=22; 316
Thunderbird select count(*) from bugs where product_id=23; 19,955
Minimo select count(*) from bugs where product_id=24; 445
Mozilla Application Suite select count(*) from bugs where product_id=25; 79,698
Toolkit select count(*) from bugs where product_id=30; 2,181
AUS select count(*) from bugs where product_id=34; 83
Websites select count(*) from bugs where product_id=36; 1,331
Mozilla Developer Center select count(*) from bugs where product_id=37; 572
Testopia select count(*) from bugs where product_id=38; 423
Penelope select count(*) from bugs where product_id=39; 375
Mozilla Labs select count(*) from bugs where product_id=40; 588
Sumo select count(*) from bugs where product_id=42; 570
Tamarin select count(*) from bugs where product_id=43; 426
Extend Firefox select count(*) from bugs where product_id=44; 5
Fennec select count(*) from bugs where product_id=46; 27
How many bugs are currently NEW vs. ASSIGNED vs. RESOLVED, etc.
New select count(*) from bugs where bug_status='NEW'; 44,568
Assigned select count(*) from bugs where bug_status='ASSIGNED'; 4,697
Resolved select count(*) from bugs where bug_status='RESOLVED'; 207,496
Verified select count(*) from bugs where bug_status='VERIFIED'; 148,747
Closed select count(*) from bugs where bug_status='CLOSED'; 1,496
Reopened select count(*) from bugs where bug_status=REOPENED'; 962
Unconfirmed select count(*) from bugs where bug_status='UNCONFIRMED'; 18,026
Retrieved from "https://wiki.cdot.senecapolytechnic.ca/w/index.php?title=Bugzilla_Analysis&oldid=15760"