Subversion Repositories DevTools

Rev

Rev 6790 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6790 Rev 6827
Line 2... Line 2...
2 
--      :RTAG_ID
 2 
--      :RTAG_ID
3 
--      :PV_ID
 3 
--      :PV_ID
4 
--
 4 
--
5 
-- All the package-vesrions that use a specified package-version in a specified release
 5 
-- All the package-vesrions that use a specified package-version in a specified release
6 
--
 6 
--
7 
With small_pd as ( SELECT pd.*, pd.pkg_id || pv1.v_ext as pkg_sig, pd.dpkg_id || pv2.v_ext as dpkg_sig FROM package_dependencies pd, package_versions pv1, package_versions pv2 WHERE pv1.pv_id IN ( SELECT pv_id FROM release_content WHERE rtag_id = :RTAG_ID) AND pd.pv_id = pv1.pv_id AND pd.dpv_id = pv2.pv_id ),
 7 
With small_pd as ( SELECT pd.*, pd.pkg_id || pv1.v_ext as pkg_sig, pd.dpkg_id || pv2.v_ext as dpkg_sig FROM package_dependencies pd, package_versions pv1, package_versions pv2 WHERE pv1.pv_id IN (
- 
 
 8 
        SELECT pv_id FROM release_content WHERE rtag_id = :RTAG_ID
- 
 
 9 
        ) AND pd.pv_id = pv1.pv_id AND pd.dpv_id = pv2.pv_id ),
8 
aa as (select * from (
 10 
aa as (select * from (
9 
    select LEVEL as ll, pv_id from small_pd pd connect by prior pkg_sig = dpkg_sig start with dpv_id=:PV_ID
 11 
    select LEVEL as ll, pv_id from small_pd pd connect by prior pkg_sig = dpkg_sig start with dpkg_sig in (select pkg_id || v_ext from package_versions where pv_id = :PV_ID )
10 
    UNION
 12 
    UNION
11 
    SELECT 0 AS ll, to_number(:PV_ID) AS pv_id FROM dual
 13 
    SELECT 0 AS ll, to_number(:PV_ID) AS pv_id FROM dual
12 
) )
 14 
) )
13 
select t.*,  p.pkg_name, pv.pkg_version, pv.MODIFIED_STAMP,pv.DLOCKED,pv.pkg_id, rc.deprecated_state, pv.build_time, rc.PKG_STATE, usr.FULL_NAME, usr.USER_EMAIL
 15 
select t.*,  p.pkg_name, pv.pkg_version, pv.MODIFIED_STAMP,pv.DLOCKED,pv.pkg_id, rc.deprecated_state, pv.build_time, rc.PKG_STATE, usr.FULL_NAME, usr.USER_EMAIL
14 
from (select MIN(ll) as buildLevel, pv_id
 16 
from (select MIN(ll) as buildLevel, pv_id