Subversion Repositories DevTools

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
29 jtweddle 1 
SELECT DISTINCT pv.pv_id, pv.pkg_id, pv.v_ext, pkg.pkg_name, pv.pkg_version, qry.prod_id as prev_pv_id
2 
FROM
3 
  bom_contents bc,
4 
  network_nodes nn,
5 
  operating_systems os,
6 
  os_contents osc,
7 
  packages pkg,
8 
  package_versions pv,
9 
  (
10 
  SELECT osc.prod_id, pv.pkg_id
11 
    FROM bom_contents bc,
12 
         network_nodes nn,
13 
         operating_systems os,
14 
         os_contents osc,
15 
         package_versions pv
16 
    WHERE osc.os_id = os.os_id
17 
      AND os.node_id = nn.node_id
18 
      AND nn.node_id = bc.node_id
19 
      AND bc.bom_id = :SBOM_B
20 
      AND osc.prod_id = pv.pv_id
21 
      AND pv.is_patch IS NULL
22 
  ) qry
23 
WHERE osc.os_id = os.os_id
24 
  AND os.node_id = nn.node_id
25 
  AND nn.node_id = bc.node_id
26 
  AND bc.bom_id = :SBOM_A
27 
  AND osc.prod_id = pv.pv_id
28 
  AND pv.pkg_id = pkg.pkg_id
29 
  AND osc.prod_id NOT IN
30 
      (
31 
      SELECT osc.prod_id
32 
        FROM bom_contents bc,
33 
             network_nodes nn,
34 
             operating_systems os,
35 
             os_contents osc
36 
        WHERE osc.os_id = os.os_id
37 
          AND os.node_id = nn.node_id
38 
          AND nn.node_id = bc.node_id
39 
          AND bc.bom_id = :SBOM_B
40 
      )
41 
  AND qry.pkg_id = pv.pkg_id
42 
ORDER BY UPPER(pkg.pkg_name || ' ' || pv.pkg_version)