Difference between revisions of "Bugzilla Analysis"
| Line 160: | Line 160: | ||
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> | + | <td>Tech Evangelism</td> |
| − | <td>select count(*) from bugs where product_id= | + | <td>select count(*) from bugs where product_id=15;</td> |
| − | <td> | + | <td>9,461</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> | + | <td>NSS</td> |
| − | <td>select count(*) from bugs where product_id= | + | <td>select count(*) from bugs where product_id=16;</td> |
| − | <td> | + | <td>3,761</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> | + | <td>Mozilla Localizations</td> |
| − | <td>select count(*) from bugs where product_id= | + | <td>select count(*) from bugs where product_id=17;</td> |
| − | <td> | + | <td>3,250</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> | + | <td>JSS</td> |
| − | <td>select count(*) from bugs where product_id= | + | <td>select count(*) from bugs where product_id=18;</td> |
| − | <td> | + | <td>316</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> | + | <td>Bugzilla</td> |
| − | <td>select count(*) from bugs where product_id= | + | <td>select count(*) from bugs where product_id=19;</td> |
| − | <td> | + | <td>12,957</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> | + | <td>Camino</td> |
| − | <td>select count(*) from bugs where product_id= | + | <td>select count(*) from bugs where product_id=20;</td> |
| − | <td> | + | <td>8,239</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> | + | <td>Firefox</td> |
| − | <td>select count(*) from bugs where product_id= | + | <td>select count(*) from bugs where product_id=21;</td> |
| − | <td> | + | <td>71,596</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> | + | <td>Other Applications</td> |
| − | <td>select count(*) from bugs where product_id= | + | <td>select count(*) from bugs where product_id=28;</td> |
| − | <td> | + | <td>3,003</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> | + | <td>addons.mozilla.org</td> |
| − | <td>select count(*) from bugs where product_id= | + | <td>select count(*) from bugs where product_id=31;</td> |
| − | <td> | + | <td>3,743</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> | + | <td>Composer</td> |
| − | <td>select count(*) from bugs where product_id= | + | <td>select count(*) from bugs where product_id=27;</td> |
| − | <td> | + | <td>37</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> | + | <td>Marketing</td> |
| − | <td>select count(*) from bugs where product_id= | + | <td>select count(*) from bugs where product_id=22;</td> |
| − | <td> | + | <td>316</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> | + | <td>Thunderbird</td> |
| − | <td>select count(*) from bugs where product_id= | + | <td>select count(*) from bugs where product_id=23;</td> |
| − | <td> | + | <td>19,955</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> | + | <td>Minimo</td> |
| − | <td>select count(*) from bugs where product_id= | + | <td>select count(*) from bugs where product_id=24;</td> |
| − | <td> | + | <td>445</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> | + | <td>Mozilla Application Suite</td> |
| − | <td>select count(*) from bugs where product_id= | + | <td>select count(*) from bugs where product_id=25;</td> |
| − | <td> | + | <td>79,698</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> | + | <td>Toolkit</td> |
| − | <td>select count(*) from bugs where product_id= | + | <td>select count(*) from bugs where product_id=30;</td> |
| − | <td> | + | <td>2,181</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> | + | <td>AUS</td> |
| − | <td>select count(*) from bugs where product_id= | + | <td>select count(*) from bugs where product_id=34;</td> |
| − | <td> | + | <td>83</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> | + | <td>Websites</td> |
| − | <td>select count(*) from bugs where product_id= | + | <td>select count(*) from bugs where product_id=36;</td> |
| − | <td> | + | <td>1,331</td> |
</tr> | </tr> | ||
<tr> | <tr> | ||
| − | <td> | + | <td>Mozilla Developer Center</td> |
| − | <td>select count(*) from bugs where product_id= | + | <td>select count(*) from bugs where product_id=37;</td> |
| − | <td> | + | <td>572</td> |
</tr> | </tr> | ||
</table> | </table> | ||
Revision as of 00:40, 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 |
