Open main menu

CDOT Wiki β

Bugzilla Analysis

Revision as of 00:12, 26 June 2008 by Tkwan9 (talk | contribs)

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%'; 2
2002 Select count(distinct bug_id) from bugs where creation_ts like '2002%'; 2
2003 Select count(distinct bug_id) from bugs where creation_ts like '2003%'; 2
2004 Select count(distinct bug_id) from bugs where creation_ts like '2004%'; 2
2005 Select count(distinct bug_id) from bugs where creation_ts like '2005%'; 2
2006 Select count(distinct bug_id) from bugs where creation_ts like '2006%'; 2
2007 Select count(distinct bug_id) from bugs where creation_ts like '2007%'; 2
2008 Select count(distinct bug_id) from bugs where creation_ts like '2008%'; 2