Open main menu

CDOT Wiki β

Changes

Bugzilla Analysis

488 bytes added, 23:08, 25 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>
<td>How many bugs are there?</td>
<td>Select count(bug_id) from bugs;</td>
<td>425,992</td>
</tr>
<tr>
<td>How many bugs per year?</td>
</tr>
<tr>
<td>1994</td>
<td>Select count(distinct bug_id) from bugs where creation_ts like '1994%';</td>
<th>2</th>
</table>
1
edit