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:

  1. 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') 
}}
  1. 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%')
}}
  1. 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'
}}
  1. 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):

  1. opened TM=FUTURE defects: 2827
  2. TM=FUTURE defects fixed in 6.5 release: 887
  3. bugs ever having TM=FUTURE: 9441
  4. 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

??

Not logged in. Log in, Register

By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo