Open main menu

CDOT Wiki β

Changes

Bugzilla Analysis

6,831 bytes added, 00:49, 26 June 2008
no edit summary
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>
Tkwan9
1
edit
Retrieved from "https://wiki.cdot.senecapolytechnic.ca/wiki/Special:MobileDiff/15696...15760"