| 119 |
ghuddy |
1 |
SELECT pkg.pkg_id, pv.pv_id, dpv.pv_id AS dpv_id,
|
|
|
2 |
DECODE(fullrel.v_nmm,
|
|
|
3 |
NULL, DECODE(dpv.pv_id, 0, 'DEPENDENCIES NOT DEFINED','NOT FOUND'),
|
|
|
4 |
dpv.v_nmm, DECODE(fullrel.v_mm, dpv.v_mm, NULL, 'MINOR MINOR'),
|
|
|
5 |
'MAJOR') AS message,
|
|
|
6 |
DECODE(fullrel.v_nmm,
|
|
|
7 |
NULL, NULL,
|
|
|
8 |
dpv.v_nmm, DECODE(fullrel.v_mm, dpv.v_mm, NULL, fullrel.pkg_version),
|
|
|
9 |
fullrel.pkg_version) AS latest
|
|
|
10 |
FROM packages pkg,
|
|
|
11 |
packages dpkg,
|
|
|
12 |
package_dependencies dep,
|
|
|
13 |
package_versions pv,
|
|
|
14 |
release_content rel,
|
|
|
15 |
package_versions dpv,
|
|
|
16 |
(
|
|
|
17 |
SELECT rel.pv_id, pkg.pkg_name, pv.pkg_version, pv.v_mm, pv.v_nmm
|
|
|
18 |
FROM release_content rel,
|
|
|
19 |
package_versions pv,
|
|
|
20 |
packages pkg
|
|
|
21 |
WHERE rel.pv_id = pv.pv_id
|
|
|
22 |
AND pv.pkg_id = pkg.pkg_id
|
|
|
23 |
AND rel.rtag_id = $RTAG_ID$
|
|
|
24 |
) fullrel
|
|
|
25 |
WHERE pkg.pkg_id = pv.pkg_id
|
|
|
26 |
AND dpkg.pkg_id = dpv.pkg_id
|
|
|
27 |
AND pv.pv_id = dep.pv_id
|
|
|
28 |
AND pv.pv_id = rel.pv_id
|
|
|
29 |
AND dpv.pv_id = dep.dpv_id
|
|
|
30 |
AND dpkg.pkg_name = fullrel.pkg_name(+)
|
|
|
31 |
/*AND dpv.pv_id NOT IN ( SELECT iw.iw_id FROM ignore_warnings iw WHERE iw.rtag_id = $RTAG_ID$ )*/
|
|
|
32 |
AND DECODE(fullrel.v_nmm,
|
|
|
33 |
NULL, DECODE(dpv.pv_id, 0, 'DEPENDENCIES NOT DEFINED','NOT FOUND'),
|
|
|
34 |
dpv.v_nmm, DECODE(fullrel.v_mm, dpv.v_mm, NULL, 'MINOR MINOR'),
|
|
|
35 |
'MAJOR') IS NOT NULL
|
|
|
36 |
AND rel.rtag_id = $RTAG_ID$
|