Subversion Repositories DevTools

Rev

Rev 882 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 882 Rev 884
Line 1990... Line 1990...
1990
          
1990
          
1991
          rset8.close();
1991
          rset8.close();
1992
          stmt8.close();
1992
          stmt8.close();
1993
 
1993
 
1994
          // get released package dependency info
1994
          // get released package dependency info
-
 
1995
          // the not exists subquery was added to ignore dependencies for 'pegged' package versions in a release - DEVI 48876
-
 
1996
          // this is the ONLY support for dealing with an inconsistent set of package versions
1995
          CallableStatement stmt9 = mConnection.prepareCall(
1997
          CallableStatement stmt9 = mConnection.prepareCall(
1996
          "select rc.pv_id, dpv.pv_id, p.pkg_name, dpv.v_ext " +
1998
          "select rc.pv_id, dpv.pv_id, p.pkg_name, dpv.v_ext " +
1997
          "from release_manager.release_content rc, release_manager.package_versions pv, release_manager.package_dependencies pd, release_manager.package_versions dpv, release_manager.packages p " +
1999
          "from release_manager.release_content rc, release_manager.package_versions pv, release_manager.package_dependencies pd, release_manager.package_versions dpv, release_manager.packages p " +
1998
          "where rc.rtag_id=" + baseline +
2000
          "where rc.rtag_id=" + baseline +
1999
          " and pv.pv_id = rc.pv_id and pd.pv_id=pv.pv_id and dpv.pv_id=pd.dpv_id and p.pkg_id=dpv.pkg_id " +
2001
          " and pv.pv_id = rc.pv_id and pd.pv_id=pv.pv_id and dpv.pv_id=pd.dpv_id and p.pkg_id=dpv.pkg_id " +
-
 
2002
          " and not exists (select pv_id from pegged_versions where pv_id=pv.pv_id and rtag_id=rc.rtag_id) " +
2000
          "order by rc.pv_id"
2003
          "order by rc.pv_id"
2001
          );
2004
          );
2002
          ResultSet rset9 = stmt9.executeQuery();
2005
          ResultSet rset9 = stmt9.executeQuery();
2003
             
2006
             
2004
          while( rset9.next() )
2007
          while( rset9.next() )