Difference between revisions of "Bugzilla Analysis"

From CDOT Wiki
Jump to: navigation, search
 
 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
Students in BTR490 are working on analyzing historical Bugzilla data for Mozilla.  This pages documents some of their findings and ideas.
 
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
 +
 +
----
 +
 +
<table class="standard-table" border=1>
 +
  <tr>
 +
    <th>Questions</th>
 +
    <th>Query</th>
 +
<th>Result</th>
 +
  </tr>
 +
  <tr>
 +
    <th>How many bugs are there?</th>
 +
    <td>Select count(bug_id) from bugs;</td>
 +
<td>425,992</td>
 +
  </tr>
 +
<tr>
 +
<th>How many bugs per year?</th>
 +
</tr>
 +
<tr>
 +
<td>1994</td>
 +
<td>Select count(distinct bug_id) from bugs where creation_ts like '1994%';</td>
 +
<td>2</td>
 +
</tr>
 +
<tr>
 +
<td>1995</td>
 +
<td>Select count(distinct bug_id) from bugs where creation_ts like '1995%';</td>
 +
<td>1</td>
 +
</tr>
 +
<tr>
 +
<td>1996</td>
 +
<td>Select count(distinct bug_id) from bugs where creation_ts like '1996%';</td>
 +
<td>5</td>
 +
</tr>
 +
<tr>
 +
<td>1997</td>
 +
<td>Select count(distinct bug_id) from bugs where creation_ts like '1997%';</td>
 +
<td>36</td>
 +
</tr>
 +
<tr>
 +
<td>1998</td>
 +
<td>Select count(distinct bug_id) from bugs where creation_ts like '1998%';</td>
 +
<td>2020</td>
 +
</tr>
 +
<tr>
 +
<td>1999</td>
 +
<td>Select count(distinct bug_id) from bugs where creation_ts like '1999%';</td>
 +
<td>20,411</td>
 +
</tr>
 +
<tr>
 +
<td>2000</td>
 +
<td>Select count(distinct bug_id) from bugs where creation_ts like '2000%';</td>
 +
<td>40298</td>
 +
</tr>
 +
<tr>
 +
<td>2001</td>
 +
<td>Select count(distinct bug_id) from bugs where creation_ts like '2001%';</td>
 +
<td>53,468</td>
 +
</tr>
 +
<tr>
 +
<td>2002</td>
 +
<td>Select count(distinct bug_id) from bugs where creation_ts like '2002%';</td>
 +
<td>69,701</td>
 +
</tr>
 +
<tr>
 +
<td>2003</td>
 +
<td>Select count(distinct bug_id) from bugs where creation_ts like '2003%';</td>
 +
<td>42,371</td>
 +
</tr>
 +
<tr>
 +
<td>2004</td>
 +
<td>Select count(distinct bug_id) from bugs where creation_ts like '2004%';</td>
 +
<td>46,739</td>
 +
</tr>
 +
<tr>
 +
<td>2005</td>
 +
<td>Select count(distinct bug_id) from bugs where creation_ts like '2005%';</td>
 +
<td>45,173</td>
 +
</tr>
 +
<tr>
 +
<td>2006</td>
 +
<td>Select count(distinct bug_id) from bugs where creation_ts like '2006%';</td>
 +
<td>41,898</td>
 +
</tr>
 +
<tr>
 +
<td>2007</td>
 +
<td>Select count(distinct bug_id) from bugs where creation_ts like '2007%';</td>
 +
<td>41,872</td>
 +
</tr>
 +
<tr>
 +
<td>2008</td>
 +
<td>Select count(distinct bug_id) from bugs where creation_ts like '2008%';</td>
 +
<td>21,997</td>
 +
</tr>
 +
<tr>
 +
<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>mozilla.org</td>
 +
<td>select count(*) from bugs where product_id=10;</td>
 +
<td>11,086</td>
 +
</tr>
 +
<tr>
 +
<td>Rhino</td>
 +
<td>select count(*) from bugs where product_id=11;</td>
 +
<td>697</td>
 +
</tr>
 +
<tr>
 +
<td>Derivatives</td>
 +
<td>select count(*) from bugs where product_id=12;</td>
 +
<td>28</td>
 +
</tr>
 +
<tr>
 +
<td>Documentation</td>
 +
<td>select count(*) from bugs where product_id=13;</td>
 +
<td>651</td>
 +
</tr>
 +
<tr>
 +
<td>Tech Evangelism</td>
 +
<td>select count(*) from bugs where product_id=15;</td>
 +
<td>9,461</td>
 +
</tr>
 +
<tr>
 +
<td>NSS</td>
 +
<td>select count(*) from bugs where product_id=16;</td>
 +
<td>3,761</td>
 +
</tr>
 +
<tr>
 +
<td>Mozilla Localizations</td>
 +
<td>select count(*) from bugs where product_id=17;</td>
 +
<td>3,250</td>
 +
</tr>
 +
<tr>
 +
<td>JSS</td>
 +
<td>select count(*) from bugs where product_id=18;</td>
 +
<td>316</td>
 +
</tr>
 +
<tr>
 +
<td>Bugzilla</td>
 +
<td>select count(*) from bugs where product_id=19;</td>
 +
<td>12,957</td>
 +
</tr>
 +
<tr>
 +
<td>Camino</td>
 +
<td>select count(*) from bugs where product_id=20;</td>
 +
<td>8,239</td>
 +
</tr>
 +
<tr>
 +
<td>Firefox</td>
 +
<td>select count(*) from bugs where product_id=21;</td>
 +
<td>71,596</td>
 +
</tr>
 +
<tr>
 +
<td>Other Applications</td>
 +
<td>select count(*) from bugs where product_id=28;</td>
 +
<td>3,003</td>
 +
</tr>
 +
<tr>
 +
<td>addons.mozilla.org</td>
 +
<td>select count(*) from bugs where product_id=31;</td>
 +
<td>3,743</td>
 +
</tr>
 +
<tr>
 +
<td>Composer</td>
 +
<td>select count(*) from bugs where product_id=27;</td>
 +
<td>37</td>
 +
</tr>
 +
<tr>
 +
<td>Marketing</td>
 +
<td>select count(*) from bugs where product_id=22;</td>
 +
<td>316</td>
 +
</tr>
 +
<tr>
 +
<td>Thunderbird</td>
 +
<td>select count(*) from bugs where product_id=23;</td>
 +
<td>19,955</td>
 +
</tr>
 +
<tr>
 +
<td>Minimo</td>
 +
<td>select count(*) from bugs where product_id=24;</td>
 +
<td>445</td>
 +
</tr>
 +
<tr>
 +
<td>Mozilla Application Suite</td>
 +
<td>select count(*) from bugs where product_id=25;</td>
 +
<td>79,698</td>
 +
</tr>
 +
<tr>
 +
<td>Toolkit</td>
 +
<td>select count(*) from bugs where product_id=30;</td>
 +
<td>2,181</td>
 +
</tr>
 +
<tr>
 +
<td>AUS</td>
 +
<td>select count(*) from bugs where product_id=34;</td>
 +
<td>83</td>
 +
</tr>
 +
<tr>
 +
<td>Websites</td>
 +
<td>select count(*) from bugs where product_id=36;</td>
 +
<td>1,331</td>
 +
</tr>
 +
<tr>
 +
<td>Mozilla Developer Center</td>
 +
<td>select count(*) from bugs where product_id=37;</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>
 +
</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"