Subversion Repositories DevTools

Rev

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

Rev 7247 Rev 7267
Line 19... Line 19...
19 
                    FROM package_dependencies pd, package_versions pv1, package_versions pv2
19 
                    FROM package_dependencies pd, package_versions pv1, package_versions pv2
20 
                    WHERE pv1.pv_id IN ( SELECT pv_id FROM release_content WHERE rtag_id = :RTAG_ID )
20 
                    WHERE pv1.pv_id IN ( SELECT pv_id FROM release_content WHERE rtag_id = :RTAG_ID )
21 
                    AND pd.pv_id = pv1.pv_id AND pd.dpv_id = pv2.pv_id ),
 21 
                    AND pd.pv_id = pv1.pv_id AND pd.dpv_id = pv2.pv_id ),
22 
-- Remove those packages that are Advisory Ripple, Pegged or from an SDK
 22 
-- Remove those packages that are Advisory Ripple, Pegged or from an SDK
23 
bb as ( select * from small_pd
23 
bb as ( select * from small_pd
24 
        where pkg_sig not in (
 24 
        where dpkg_sig not in (
25 
            select pkg_id || v_ext as pkg_sig from package_versions
25 
            select pkg_id || v_ext as pkg_sig from package_versions
26 
            where pv_id in (
 26 
            where pv_id in (
27 
                select pv_id from advisory_ripple WHERE rtag_id = :RTAG_ID
 27 
                select pv_id from advisory_ripple WHERE rtag_id = :RTAG_ID
28 
                union
 28 
                union
29 
                select pv_id from pegged_versions WHERE rtag_id = :RTAG_ID
 29 
                select pv_id from pegged_versions WHERE rtag_id = :RTAG_ID