Subversion Repositories DevTools

Rev

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

Rev 7267 Rev 7293
Line 33... Line 33...
33 
           )
 33 
           )
34 
),
 34 
),
35 
-- Generate a tree of packages starting at the package of interest
 35 
-- Generate a tree of packages starting at the package of interest
36 
aa as (SELECT * from (
 36 
aa as (SELECT * from (
37 
    SELECT pv_id, build_time
37 
    SELECT pv_id, build_time
38 
        FROM bb connect by
38 
        FROM bb connect by NOCYCLE
39 
                           prior pkg_sig = dpkg_sig
 39 
                           prior pkg_sig = dpkg_sig
40 
                           start with dpkg_sig in (SELECT pkg_id || v_ext FROM package_versions where pv_id = :PV_ID )
 40 
                           start with dpkg_sig in (SELECT pkg_id || v_ext FROM package_versions where pv_id = :PV_ID )
41 
    UNION
 41 
    UNION
42 
     SELECT pv_id, build_time from package_versions where pv_id = :PV_ID
 42 
     SELECT pv_id, build_time from package_versions where pv_id = :PV_ID
43 
) ),
 43 
) ),