Difference between revisions of "Bugzilla Analysis"
| Line 24: | Line 24: | ||
<td>1994</td> | <td>1994</td> | ||
<td>Select count(distinct bug_id) from bugs where creation_ts like '1994%';</td> | <td>Select count(distinct bug_id) from bugs where creation_ts like '1994%';</td> | ||
| − | < | + | <td>2</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>1995</td> | <td>1995</td> | ||
<td>Select count(distinct bug_id) from bugs where creation_ts like '1995%';</td> | <td>Select count(distinct bug_id) from bugs where creation_ts like '1995%';</td> | ||
| − | < | + | <td>1</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>1996</td> | <td>1996</td> | ||
<td>Select count(distinct bug_id) from bugs where creation_ts like '1996%';</td> | <td>Select count(distinct bug_id) from bugs where creation_ts like '1996%';</td> | ||
| − | < | + | <td>5</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>1997</td> | <td>1997</td> | ||
<td>Select count(distinct bug_id) from bugs where creation_ts like '1997%';</td> | <td>Select count(distinct bug_id) from bugs where creation_ts like '1997%';</td> | ||
| − | < | + | <td>36</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>1998</td> | <td>1998</td> | ||
<td>Select count(distinct bug_id) from bugs where creation_ts like '1998%';</td> | <td>Select count(distinct bug_id) from bugs where creation_ts like '1998%';</td> | ||
| − | < | + | <td>2020</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>1999</td> | <td>1999</td> | ||
<td>Select count(distinct bug_id) from bugs where creation_ts like '1999%';</td> | <td>Select count(distinct bug_id) from bugs where creation_ts like '1999%';</td> | ||
| − | < | + | <td>20,411</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>2000</td> | <td>2000</td> | ||
<td>Select count(distinct bug_id) from bugs where creation_ts like '2000%';</td> | <td>Select count(distinct bug_id) from bugs where creation_ts like '2000%';</td> | ||
| − | < | + | <td>40298</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>2001</td> | <td>2001</td> | ||
<td>Select count(distinct bug_id) from bugs where creation_ts like '2001%';</td> | <td>Select count(distinct bug_id) from bugs where creation_ts like '2001%';</td> | ||
| − | < | + | <td>53,468</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>2002</td> | <td>2002</td> | ||
<td>Select count(distinct bug_id) from bugs where creation_ts like '2002%';</td> | <td>Select count(distinct bug_id) from bugs where creation_ts like '2002%';</td> | ||
| − | < | + | <td>69,701</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>2003</td> | <td>2003</td> | ||
<td>Select count(distinct bug_id) from bugs where creation_ts like '2003%';</td> | <td>Select count(distinct bug_id) from bugs where creation_ts like '2003%';</td> | ||
| − | < | + | <td>42,371</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>2004</td> | <td>2004</td> | ||
<td>Select count(distinct bug_id) from bugs where creation_ts like '2004%';</td> | <td>Select count(distinct bug_id) from bugs where creation_ts like '2004%';</td> | ||
| − | < | + | <td>46,739</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>2005</td> | <td>2005</td> | ||
<td>Select count(distinct bug_id) from bugs where creation_ts like '2005%';</td> | <td>Select count(distinct bug_id) from bugs where creation_ts like '2005%';</td> | ||
| − | < | + | <td>45,173</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>2006</td> | <td>2006</td> | ||
<td>Select count(distinct bug_id) from bugs where creation_ts like '2006%';</td> | <td>Select count(distinct bug_id) from bugs where creation_ts like '2006%';</td> | ||
| − | < | + | <td>41,898</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>2007</td> | <td>2007</td> | ||
<td>Select count(distinct bug_id) from bugs where creation_ts like '2007%';</td> | <td>Select count(distinct bug_id) from bugs where creation_ts like '2007%';</td> | ||
| − | < | + | <td>41,872</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
<td>2008</td> | <td>2008</td> | ||
<td>Select count(distinct bug_id) from bugs where creation_ts like '2008%';</td> | <td>Select count(distinct bug_id) from bugs where creation_ts like '2008%';</td> | ||
| − | < | + | <td>21,997</td> |
</tr> | </tr> | ||
</table> | </table> | ||
Revision as of 23:16, 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 |
