ProblemsWithFutureTM
Introduction
In issuezilla there is defined Target Milestone "FUTURE". Since issues with TM=FUTURE are evaluated there is assumption that such issues live in issuezilla for long time then - no one reevaluates them. We need some analysis first to be sure that issues with TM=FUTURE reside in issuezilla for long time.
Analysis
Following numbers may tell us whether it is valuable to change process with TM=FUTURE or not:
- how many opened defects with TM=FUTURE do we have
SELECT count(*)
from issue
where
target_milestone='FUTURE'
and issue.issue_type='DEFECT'
and issue.issue_status IN ('NEW','STARTED','REOPENED') }}- how many defects with TM=FUTURE has been resolved in 6.5
SELECT count(*)
from issue,
(select distinct history.issue_id as id
from history
where history.target_milestone='FUTURE') as inner_table
where
issue.issue_id = inner_table.id
and issue.issue_type = 'DEFECT'
and issue.issue_status in ('RESOLVED', 'VERIFIED', 'CLOSED')
and issue.target_milestone LIKE ('6.5%') }}- how many defects have anytime TM=FUTURE
SELECT count(*)
from issue,
(select distinct history.issue_id as id
from history
where history.target_milestone='FUTURE') as inner_table
where
issue.issue_id = inner_table.id
and issue.issue_type = 'DEFECT' }}- how many defects that have anytime TM=FUTURE are already resolved
SELECT count(*)
from issue,
(select distinct history.issue_id as id
from history
where history.target_milestone='FUTURE') as inner_table
where
issue.issue_id = inner_table.id
and issue.issue_type = 'DEFECT'
and issue.issue_status in ('RESOLVED','VERIFIED','CLOSED') }}
Results
General results
Queries above returned following results (executed on 2008/10/01-14:35):
- opened TM=FUTURE defects: 2827
- TM=FUTURE defects fixed in 6.5 release: 887
- bugs ever having TM=FUTURE: 9441
- resolved bugs ever having TM=FUTURE: 6415
Detailed results by teams
Following table shows the distribution by teams. Issues not belonging to these teams are not counted. The teams definition is following:
count(IF( ((component='ant' and subcomponent not in ( 'debugger' ) ) or (component='apisupport' ) or (component='autoupdate' ) or (component='core' and subcomponent not in ( 'window system v1' , 'terminal emulator' ) ) or (component='java' and subcomponent in ( 'freeform' ) ) or (component='openide' and subcomponent not in ( 'looks' , 'registry' ) ) or (component='openidex' ) or (component='projects' ) or (component='ui' and subcomponent in ( 'welcome' ) ) or (component='ide' and subcomponent in ( 'registration' , 'eclipse project import' ) ) or (component='javawebstart' ) or (component='tasklist' and subcomponent not in ( 'buglist' , 'compiler' , 'editor' , 'html' , 'javadoc' , 'javaparser' , 'pmd' , 'usertasks' , 'Other' ) ) or (component='logger' and subcomponent in ( 'metrics' ) ) or (component='graph' )), 1, NULL)) as ooo_core, count(IF( ((component='beans' ) or (component='classfile' ) or (component='clazz' ) or (component='editor' ) or (component='java' and subcomponent not in ( 'freeform' , 'javacore' , 'srcmodel' , 'unsupported' ) ) or (component='javadoc' ) or (component='refactoring' and subcomponent not in ( 'experimental' ) ) or (component='lexer' ) or (component='languages' and subcomponent not in ( 'yaml' , 'java' , 'scala' , 'erlang' ) ) or (component='utilities' and subcomponent in ( 'jumpto' ) )), 1, NULL)) as ooo_editor, count(IF( ((component='ant' and subcomponent in ( 'debugger' ) ) or (component='debuggercore' ) or (component='debuggerjpda' ) or (component='diff' and subcomponent not in ( 'experimental profiles' , 'changelog' ) ) or (component='form' and subcomponent not in ( 'JDNC' ) ) or (component='i18n' ) or (component='image' ) or (component='junit' ) or (component='properties' ) or (component='utilities' and subcomponent not in ( 'jumpto' ) ) or (component='cvs' ) or (component='subversion' ) or (component='localhistory' ) or (component='mercurial' ) or (component='versioncontrol' and subcomponent not in ( 'vcsgeneric' ) )), 1, NULL)) as ooo_LCT, count(IF( ((component='mobility' and subcomponent not in ( 'www' ) )), 1, NULL)) as ooo_mobility, count(IF( ((component='applet' ) or (component='html' ) or (component='httpserver' ) or (component='j2ee' and subcomponent not in ( 'blueprints' , 'persistence' ) ) or (component='j2eeserver' ) or (component='schema2beans' ) or (component='serverplugins' and subcomponent not in ( 'webserver7' , 'oc4j' , 'businessone' , 'avk' ) ) or (component='tomcatint' ) or (component='web' and subcomponent not in ( 'facelets' , 'pagefloweditor' , 'jsf' , 'struts' , 'spring' , 'hibernate' ) ) or (component='xml' and subcomponent in ( 'multiview' ) ) or (component='javascript' and subcomponent in ( 'editor' ) )), 1, NULL)) as ooo_j2ee, count(IF( ((component='ruby' ) or (component='languages' and subcomponent in ( 'yaml' ) )), 1, NULL)) as ooo_ruby, count(IF( ((component='websvc' and subcomponent not in ( 'axis2' , 'soapui' , 'rest' , 'manager' , 'jaxrpc' ) ) or (component='identity' and subcomponent in ( 'code' , 'documentation' ) ) or (component='xml' and subcomponent in ( 'jaxb' ) )), 1, NULL)) as ooo_web, count(IF( ((component='visualweb' ) or (component='web' and subcomponent in ( 'pagefloweditor' ) ) or (component='extbrowser' ) or (component='db' and subcomponent in ( 'visualsqleditor' ) )), 1, NULL)) as ooo_visualweb, count(IF( ((component='nbi' ) or (component='installer' and subcomponent not in ( 'sunstudio' ) )), 1, NULL)) as ooo_installer, count(IF( ((component='enterprise' and subcomponent not in ( 'IEP editor' , 'IEP project' , 'data integrator' , 'mashup' ) ) or (component='print' and subcomponent in ( 'code' ) ) or (component='xml' and subcomponent in ( 'wsdl tools' , 'wsdl model' , 'xsl' , 'xslt model' ) )), 1, NULL)) as ooo_soa, count(IF( ((component='cnd' )), 1, NULL)) as ooo_cnd, count(IF( ((component='xml' and subcomponent not in ( 'wsdl tools' , 'wsdl model' , 'xsl' , 'xslt model' , 'jaxb' , 'multiview' ) )), 1, NULL)) as ooo_xml, count(IF( ((component='db' and subcomponent not in ( 'visualsqleditor' ) )), 1, NULL)) as ooo_db, count(IF( ((component='j2ee' and subcomponent in ( 'persistence' ) ) or (component='web' and subcomponent in ( 'jsf' , 'struts' , 'spring' , 'hibernate' , 'facelets' ) )), 1, NULL)) as ooo_webframeworks, count(IF( ((component='profiler' )), 1, NULL)) as ooo_profiler, count(IF( ((component='php' )), 1, NULL)) as ooo_php, count(IF( ((component='groovy' )), 1, NULL)) as ooo_groovy, count(IF( ((component='websvc' and subcomponent in ( 'rest' , 'manager' ) )), 1, NULL)) as ooo_rest, count(IF( ((component='debuggerjavascript' ) or (component='monitor' ) or (component='javascript' and subcomponent not in ( 'editor' , 'ejs' ) )), 1, NULL)) as ooo_ajax, count(IF( ((component='libs' ) or (component='ui' and subcomponent not in ( 'welcome' , 'styleguide' ) ) or (component='usersguide' ) or (component='nbbuild' and subcomponent in ( 'update centre content' ) ) or (component='performance' and subcomponent in ( 'code' ) )), 1, NULL)) as ooo_other, count(IF( ((component='uml' )), 1, NULL)) as ooo_uml, count(IF( (((component='ant' and subcomponent not in ( 'debugger' ) ) or (component='apisupport' ) or (component='autoupdate' ) or (component='core' and subcomponent not in ( 'window system v1' , 'terminal emulator' ) ) or (component='java' and subcomponent in ( 'freeform' ) ) or (component='openide' and subcomponent not in ( 'looks' , 'registry' ) ) or (component='openidex' ) or (component='projects' ) or (component='ui' and subcomponent in ( 'welcome' ) ) or (component='ide' and subcomponent in ( 'registration' , 'eclipse project import' ) ) or (component='javawebstart' ) or (component='tasklist' and subcomponent not in ( 'buglist' , 'compiler' , 'editor' , 'html' , 'javadoc' , 'javaparser' , 'pmd' , 'usertasks' , 'Other' ) ) or (component='logger' and subcomponent in ( 'metrics' ) ) or (component='graph' )) OR ((component='beans' ) or (component='classfile' ) or (component='clazz' ) or (component='editor' ) or (component='java' and subcomponent not in ( 'freeform' , 'javacore' , 'srcmodel' , 'unsupported' ) ) or (component='javadoc' ) or (component='refactoring' and subcomponent not in ( 'experimental' ) ) or (component='lexer' ) or (component='languages' and subcomponent not in ( 'yaml' , 'java' , 'scala' , 'erlang' ) ) or (component='utilities' and subcomponent in ( 'jumpto' ) )) OR ((component='ant' and subcomponent in ( 'debugger' ) ) or (component='debuggercore' ) or (component='debuggerjpda' ) or (component='diff' and subcomponent not in ( 'experimental profiles' , 'changelog' ) ) or (component='form' and subcomponent not in ( 'JDNC' ) ) or (component='i18n' ) or (component='image' ) or (component='junit' ) or (component='properties' ) or (component='utilities' and subcomponent not in ( 'jumpto' ) ) or (component='cvs' ) or (component='subversion' ) or (component='localhistory' ) or (component='mercurial' ) or (component='versioncontrol' and subcomponent not in ( 'vcsgeneric' ) )) OR ((component='mobility' and subcomponent not in ( 'www' ) )) OR ((component='applet' ) or (component='html' ) or (component='httpserver' ) or (component='j2ee' and subcomponent not in ( 'blueprints' , 'persistence' ) ) or (component='j2eeserver' ) or (component='schema2beans' ) or (component='serverplugins' and subcomponent not in ( 'webserver7' , 'oc4j' , 'businessone' , 'avk' ) ) or (component='tomcatint' ) or (component='web' and subcomponent not in ( 'facelets' , 'pagefloweditor' , 'jsf' , 'struts' , 'spring' , 'hibernate' ) ) or (component='xml' and subcomponent in ( 'multiview' ) ) or (component='javascript' and subcomponent in ( 'editor' ) )) OR ((component='ruby' ) or (component='languages' and subcomponent in ( 'yaml' ) )) OR ((component='websvc' and subcomponent not in ( 'axis2' , 'soapui' , 'rest' , 'manager' , 'jaxrpc' ) ) or (component='identity' and subcomponent in ( 'code' , 'documentation' ) ) or (component='xml' and subcomponent in ( 'jaxb' ) )) OR ((component='visualweb' ) or (component='web' and subcomponent in ( 'pagefloweditor' ) ) or (component='extbrowser' ) or (component='db' and subcomponent in ( 'visualsqleditor' ) )) OR ((component='nbi' ) or (component='installer' and subcomponent not in ( 'sunstudio' ) )) OR ((component='enterprise' and subcomponent not in ( 'IEP editor' , 'IEP project' , 'data integrator' , 'mashup' ) ) or (component='print' and subcomponent in ( 'code' ) ) or (component='xml' and subcomponent in ( 'wsdl tools' , 'wsdl model' , 'xsl' , 'xslt model' ) )) OR ((component='cnd' )) OR ((component='xml' and subcomponent not in ( 'wsdl tools' , 'wsdl model' , 'xsl' , 'xslt model' , 'jaxb' , 'multiview' ) )) OR ((component='db' and subcomponent not in ( 'visualsqleditor' ) )) OR ((component='j2ee' and subcomponent in ( 'persistence' ) ) or (component='web' and subcomponent in ( 'jsf' , 'struts' , 'spring' , 'hibernate' , 'facelets' ) )) OR ((component='profiler' )) OR ((component='php' )) OR ((component='groovy' )) OR ((component='websvc' and subcomponent in ( 'rest' , 'manager' ) )) OR ((component='debuggerjavascript' ) or (component='monitor' ) or (component='javascript' and subcomponent not in ( 'editor' , 'ejs' ) )) OR ((component='libs' ) or (component='ui' and subcomponent not in ( 'welcome' , 'styleguide' ) ) or (component='usersguide' ) or (component='nbbuild' and subcomponent in ( 'update centre content' ) ) or (component='performance' and subcomponent in ( 'code' ) )) OR ((component='uml' ))), 1, NULL)) as ooo_all
| Team | 1) opened TM=FUTURE | 2) TM=FUTURE resolved in 6.5 | 3) ever having TM=FUTURE | 4) ever having TM=FUTURE resolved |
|---|---|---|---|---|
| core | 470 | 109 | 1553 | 1049 |
| editor | 366 | 55 | 992 | 605 |
| LCT | 333 | 51 | 890 | 542 |
| mobility | 58 | 11 | 138 | 77 |
| j2ee | 180 | 30 | 528 | 320 |
| ruby | 85 | 15 | 129 | 44 |
| web | 3 | 4 | 64 | 49 |
| visualweb | 120 | 15 | 330 | 208 |
| installer | 6 | 3 | 89 | 83 |
| soa | 59 | 7 | 111 | 49 |
| cnd | 258 | 68 | 2164 | 1892 |
| xml | 24 | 13 | 120 | 81 |
| db | 65 | 35 | 170 | 103 |
| webframeworks | 33 | 13 | 78 | 44 |
| profiler | 66 | 26 | 197 | 131 |
| php | 21 | 30 | 77 | 55 |
| groovy | 0 | 1 | 1 | 1 |
| rest | 9 | 7 | 26 | 17 |
| ajax | 11 | 0 | 17 | 2 |
| other | 21 | 4 | 68 | 46 |
| uml | 387 | 381 | 991 | 581 |
| SUM | 2575 | 878 | 8733 | 5979 |
Conclusion
??
