WebSVN – DevTools – Diff – /ManagerSuite/Release_Manager/trunk/queries/ReleaseDiff.sql



              pv.PKG_VERSION AS PKG_VERSION_A,
              pv.V_NMM AS MAJOR_MINOR_A,
              get_patch_version(pv.V_MM) AS PATCH_NUMBER_A,
              get_build_number(pv.V_MM) AS BUILD_NUMBER_A,
              rc.deprecated_state AS PKG_STATE_A,
              NVL2(rc.SDKTAG_ID, 1, 0) AS PKG_SDK_A,
              NULL AS PV_ID_B,
              NULL AS COMMENTS_B,
              NULL AS PKG_NAME_B,
              NULL AS PKG_VERSION_B,
              NULL AS MAJOR_MINOR_B,
              NULL AS PATCH_NUMBER_B,
              NULL AS BUILD_NUMBER_B,
              NULL AS PKG_STATE_B,
              0 AS PKG_SDK_B
       FROM (
             /* ReleaseContent@A - ( ReleaseContent@B + Planned@B(Additions) - Planned@B(Subtractions) ) */
             SELECT pv.PKG_ID, pv.V_EXT
                FROM RELEASE_CONTENT rc,
                     PACKAGE_VERSIONS pv

              NULL AS PKG_VERSION_A,
              NULL AS MAJOR_MINOR_A,
              NULL AS PATCH_NUMBER_A,
              NULL AS BUILD_NUMBER_A,
              NULL AS PKG_STATE_A,
              0 AS PKG_SDK_A,
              pv.PV_ID AS PV_ID_B,
              pv.COMMENTS AS COMMENTS_B,
              pkg.PKG_NAME AS PKG_NAME_B,
              pv.PKG_VERSION AS PKG_VERSION_B,
              pv.V_NMM AS MAJOR_MINOR_B,
              get_patch_version(pv.V_MM) AS PATCH_NUMBER_B,
              get_build_number(pv.V_MM) AS BUILD_NUMBER_B,
              rc.deprecated_state as PKG_STATE_B,
              NVL2(rc.SDKTAG_ID, 1, 0) AS PKG_SDK_B
       FROM (
             /* ( ReleaseContent@B + Planned@B(Additions) - Planned@B(Subtractions) ) - ReleaseContent@A */
             ((SELECT pv.PKG_ID, pv.V_EXT
                 FROM RELEASE_CONTENT rc,
                      PACKAGE_VERSIONS pv

              ra.PKG_VERSION AS PKG_VERSION_A,
              ra.V_NMM AS MAJOR_MINOR_A,
              ra.patch_number AS PATCH_NUMBER_A,
              ra.build_number AS BUILD_NUMBER_A,
              ra.DEPRECATED_STATE AS PKG_STATE_A,
              NVL2(ra.SDKTAG_ID, 1, 0) AS PKG_SDK_A,
              rb.PV_ID AS PV_ID_B,
              rb.COMMENTS AS COMMENTS_B,
              rb.PKG_NAME AS PKG_NAME_B,
              rb.PKG_VERSION AS PKG_VERSION_B,
              rb.V_NMM AS MAJOR_MINOR_B,
              rb.patch_number AS PATCH_NUMBER_B,
              rb.build_number AS BUILD_NUMBER_B,
              rb.DEPRECATED_STATE AS PKG_STATE_B,
              NVL2(rb.SDKTAG_ID, 1, 0) AS PKG_SDK_B
       FROM (
              SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, v.VIEW_NAME, v.VIEW_ID, rc.DEPRECATED_STATE,
                     get_patch_version(pv.V_MM) AS patch_number,
                     get_build_number(pv.V_MM) AS build_number,
                     rc.SDKTAG_ID AS SDKTAG_ID
                FROM RELEASE_CONTENT rc,
                     PACKAGE_VERSIONS pv,
                     PACKAGES pkg,
                     VIEWS v
               WHERE rc.PV_ID = pv.PV_ID

              ) ra,
              (
               /* ( ReleaseContent@B + Planned@B(Additions) - Planned@B(Subtractions) ) */
               ((SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, rc.DEPRECATED_STATE,
                        get_patch_version(pv.V_MM) AS patch_number,
                        get_build_number(pv.V_MM) AS build_number,
                        rc.SDKTAG_ID AS SDKTAG_ID
                   FROM RELEASE_CONTENT rc,
                        PACKAGE_VERSIONS pv,
                        PACKAGES pkg
                  WHERE rc.PV_ID = pv.PV_ID
                    AND rc.RTAG_ID = :RTAG_B
                    AND pv.PKG_ID = pkg.PKG_ID
                 UNION
                 SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, NULL AS DEPRECATED_STATE,
                        get_patch_version(pv.V_MM) AS patch_number,
                        get_build_number(pv.V_MM) AS build_number,
                        NULL AS SDKTAG_ID
                   FROM PLANNED pl,
                        PACKAGE_VERSIONS pv,
                        PACKAGES pkg
                  WHERE pl.PV_ID = pv.PV_ID
                    AND pv.PKG_ID = pkg.PKG_ID
                    AND pl.operation = 'A'
                    AND pl.RTAG_ID = :RTAG_B)
                MINUS
                SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, NULL AS DEPRECATED_STATE,
                       get_patch_version(pv.V_MM) AS patch_number,
                       get_build_number(pv.V_MM) AS build_number,
                       NULL AS SDKTAG_ID
                  FROM PLANNED pl,
                       PACKAGE_VERSIONS pv,
                       PACKAGES pkg
                 WHERE pl.PV_ID = pv.PV_ID
                   AND pv.PKG_ID = pkg.PKG_ID

              ra.PKG_VERSION AS PKG_VERSION_A,
              ra.V_NMM AS MAJOR_MINOR_A,
              get_patch_version(ra.V_MM) AS PATCH_NUMBER_A,
              get_build_number(ra.V_MM) AS BUILD_NUMBER_A,
              ra.DEPRECATED_STATE as PKG_STATE_A,
              NVL2(ra.SDKTAG_ID, 1, 0) AS PKG_SDK_A,
              rb.PV_ID AS PV_ID_B,
              rb.COMMENTS AS COMMENTS_B,
              rb.PKG_NAME AS PKG_NAME_B,
              rb.PKG_VERSION AS PKG_VERSION_B,
              rb.V_NMM AS MAJOR_MINOR_B,
              get_patch_version(rb.V_MM) AS PATCH_NUMBER_B,
              get_build_number(rb.V_MM) AS BUILD_NUMBER_B,
              rb.DEPRECATED_STATE AS PKG_STATE_B,
              NVL2(rb.SDKTAG_ID, 1, 0) AS PKG_SDK_B
       FROM (
              SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, v.VIEW_NAME, v.VIEW_ID, rc.DEPRECATED_STATE, rc.SDKTAG_ID
                FROM RELEASE_CONTENT rc,
                     PACKAGE_VERSIONS pv,
                     PACKAGES pkg,
                     VIEWS v
               WHERE rc.PV_ID = pv.PV_ID

                 AND pv.PKG_ID = pkg.PKG_ID
                 AND v.VIEW_ID = rc.BASE_VIEW_ID
            ) ra,
            (
              /* ( ReleaseContent@B + Planned@B(Additions) - Planned@B(Subtractions) ) */
              (SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, rc.DEPRECATED_STATE , rc.SDKTAG_ID
                 FROM RELEASE_CONTENT rc,
                      PACKAGE_VERSIONS pv,
                      PACKAGES pkg
                WHERE rc.PV_ID = pv.PV_ID
                  AND rc.RTAG_ID = :RTAG_B
                  AND pv.PKG_ID = pkg.PKG_ID
               UNION
               SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, NULL AS DEPRECATED_STATE, NULL AS SDKTAG_ID
                 FROM PLANNED pl,
                      PACKAGE_VERSIONS pv,
                      PACKAGES pkg
                WHERE pl.PV_ID = pv.PV_ID
                  AND pl.RTAG_ID = :RTAG_B
                  AND pl.operation = 'A'
                  AND pv.PKG_ID = pkg.PKG_ID)
              MINUS
              SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, NULL AS DEPRECATED_STATE, NULL AS SDKTAG_ID
                FROM PLANNED pl,
                     PACKAGE_VERSIONS pv,
                     PACKAGES pkg
               WHERE pl.PV_ID = pv.PV_ID
                 AND pl.RTAG_ID = :RTAG_B

Rev 123	Rev 5081
Line 13...	Line 13...
13	`pv.PKG_VERSION AS PKG_VERSION_A,`	13	`pv.PKG_VERSION AS PKG_VERSION_A,`
14	`pv.V_NMM AS MAJOR_MINOR_A,`	14	`pv.V_NMM AS MAJOR_MINOR_A,`
15	`get_patch_version(pv.V_MM) AS PATCH_NUMBER_A,`	15	`get_patch_version(pv.V_MM) AS PATCH_NUMBER_A,`
16	`get_build_number(pv.V_MM) AS BUILD_NUMBER_A,`	16	`get_build_number(pv.V_MM) AS BUILD_NUMBER_A,`
17	`rc.deprecated_state AS PKG_STATE_A,`	17	`rc.deprecated_state AS PKG_STATE_A,`
-		18	`NVL2(rc.SDKTAG_ID, 1, 0) AS PKG_SDK_A,`
18	`NULL AS PV_ID_B,`	19	`NULL AS PV_ID_B,`
19	`NULL AS COMMENTS_B,`	20	`NULL AS COMMENTS_B,`
20	`NULL AS PKG_NAME_B,`	21	`NULL AS PKG_NAME_B,`
21	`NULL AS PKG_VERSION_B,`	22	`NULL AS PKG_VERSION_B,`
22	`NULL AS MAJOR_MINOR_B,`	23	`NULL AS MAJOR_MINOR_B,`
23	`NULL AS PATCH_NUMBER_B,`	24	`NULL AS PATCH_NUMBER_B,`
24	`NULL AS BUILD_NUMBER_B,`	25	`NULL AS BUILD_NUMBER_B,`
25	`NULL AS PKG_STATE_B`	26	`NULL AS PKG_STATE_B,`
-		27	`0 AS PKG_SDK_B`
26	`FROM (`	28	`FROM (`
27	`/* ReleaseContent@A - ( ReleaseContent@B + Planned@B(Additions) - Planned@B(Subtractions) ) */`	29	`/* ReleaseContent@A - ( ReleaseContent@B + Planned@B(Additions) - Planned@B(Subtractions) ) */`
28	`SELECT pv.PKG_ID, pv.V_EXT`	30	`SELECT pv.PKG_ID, pv.V_EXT`
29	`FROM RELEASE_CONTENT rc,`	31	`FROM RELEASE_CONTENT rc,`
30	`PACKAGE_VERSIONS pv`	32	`PACKAGE_VERSIONS pv`
Line 76...	Line 78...
76	`NULL AS PKG_VERSION_A,`	78	`NULL AS PKG_VERSION_A,`
77	`NULL AS MAJOR_MINOR_A,`	79	`NULL AS MAJOR_MINOR_A,`
78	`NULL AS PATCH_NUMBER_A,`	80	`NULL AS PATCH_NUMBER_A,`
79	`NULL AS BUILD_NUMBER_A,`	81	`NULL AS BUILD_NUMBER_A,`
80	`NULL AS PKG_STATE_A,`	82	`NULL AS PKG_STATE_A,`
-		83	`0 AS PKG_SDK_A,`
81	`pv.PV_ID AS PV_ID_B,`	84	`pv.PV_ID AS PV_ID_B,`
82	`pv.COMMENTS AS COMMENTS_B,`	85	`pv.COMMENTS AS COMMENTS_B,`
83	`pkg.PKG_NAME AS PKG_NAME_B,`	86	`pkg.PKG_NAME AS PKG_NAME_B,`
84	`pv.PKG_VERSION AS PKG_VERSION_B,`	87	`pv.PKG_VERSION AS PKG_VERSION_B,`
85	`pv.V_NMM AS MAJOR_MINOR_B,`	88	`pv.V_NMM AS MAJOR_MINOR_B,`
86	`get_patch_version(pv.V_MM) AS PATCH_NUMBER_B,`	89	`get_patch_version(pv.V_MM) AS PATCH_NUMBER_B,`
87	`get_build_number(pv.V_MM) AS BUILD_NUMBER_B,`	90	`get_build_number(pv.V_MM) AS BUILD_NUMBER_B,`
88	`rc.deprecated_state as PKG_STATE_B`	91	`rc.deprecated_state as PKG_STATE_B,`
-		92	`NVL2(rc.SDKTAG_ID, 1, 0) AS PKG_SDK_B`
89	`FROM (`	93	`FROM (`
90	`/* ( ReleaseContent@B + Planned@B(Additions) - Planned@B(Subtractions) ) - ReleaseContent@A */`	94	`/* ( ReleaseContent@B + Planned@B(Additions) - Planned@B(Subtractions) ) - ReleaseContent@A */`
91	`((SELECT pv.PKG_ID, pv.V_EXT`	95	`((SELECT pv.PKG_ID, pv.V_EXT`
92	`FROM RELEASE_CONTENT rc,`	96	`FROM RELEASE_CONTENT rc,`
93	`PACKAGE_VERSIONS pv`	97	`PACKAGE_VERSIONS pv`
Line 147...	Line 151...
147	`ra.PKG_VERSION AS PKG_VERSION_A,`	151	`ra.PKG_VERSION AS PKG_VERSION_A,`
148	`ra.V_NMM AS MAJOR_MINOR_A,`	152	`ra.V_NMM AS MAJOR_MINOR_A,`
149	`ra.patch_number AS PATCH_NUMBER_A,`	153	`ra.patch_number AS PATCH_NUMBER_A,`
150	`ra.build_number AS BUILD_NUMBER_A,`	154	`ra.build_number AS BUILD_NUMBER_A,`
151	`ra.DEPRECATED_STATE AS PKG_STATE_A,`	155	`ra.DEPRECATED_STATE AS PKG_STATE_A,`
-		156	`NVL2(ra.SDKTAG_ID, 1, 0) AS PKG_SDK_A,`
152	`rb.PV_ID AS PV_ID_B,`	157	`rb.PV_ID AS PV_ID_B,`
153	`rb.COMMENTS AS COMMENTS_B,`	158	`rb.COMMENTS AS COMMENTS_B,`
154	`rb.PKG_NAME AS PKG_NAME_B,`	159	`rb.PKG_NAME AS PKG_NAME_B,`
155	`rb.PKG_VERSION AS PKG_VERSION_B,`	160	`rb.PKG_VERSION AS PKG_VERSION_B,`
156	`rb.V_NMM AS MAJOR_MINOR_B,`	161	`rb.V_NMM AS MAJOR_MINOR_B,`
157	`rb.patch_number AS PATCH_NUMBER_B,`	162	`rb.patch_number AS PATCH_NUMBER_B,`
158	`rb.build_number AS BUILD_NUMBER_B,`	163	`rb.build_number AS BUILD_NUMBER_B,`
159	`rb.DEPRECATED_STATE AS PKG_STATE_B`	164	`rb.DEPRECATED_STATE AS PKG_STATE_B,`
-		165	`NVL2(rb.SDKTAG_ID, 1, 0) AS PKG_SDK_B`
160	`FROM (`	166	`FROM (`
161	`SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, v.VIEW_NAME, v.VIEW_ID, rc.DEPRECATED_STATE,`	167	`SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, v.VIEW_NAME, v.VIEW_ID, rc.DEPRECATED_STATE,`
162	`get_patch_version(pv.V_MM) AS patch_number,`	168	`get_patch_version(pv.V_MM) AS patch_number,`
163	`get_build_number(pv.V_MM) AS build_number`	169	`get_build_number(pv.V_MM) AS build_number,`
-		170	`rc.SDKTAG_ID AS SDKTAG_ID`
164	`FROM RELEASE_CONTENT rc,`	171	`FROM RELEASE_CONTENT rc,`
165	`PACKAGE_VERSIONS pv,`	172	`PACKAGE_VERSIONS pv,`
166	`PACKAGES pkg,`	173	`PACKAGES pkg,`
167	`VIEWS v`	174	`VIEWS v`
168	`WHERE rc.PV_ID = pv.PV_ID`	175	`WHERE rc.PV_ID = pv.PV_ID`
Line 172...	Line 179...
172	`) ra,`	179	`) ra,`
173	`(`	180	`(`
174	`/* ( ReleaseContent@B + Planned@B(Additions) - Planned@B(Subtractions) ) */`	181	`/* ( ReleaseContent@B + Planned@B(Additions) - Planned@B(Subtractions) ) */`
175	`((SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, rc.DEPRECATED_STATE,`	182	`((SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, rc.DEPRECATED_STATE,`
176	`get_patch_version(pv.V_MM) AS patch_number,`	183	`get_patch_version(pv.V_MM) AS patch_number,`
177	`get_build_number(pv.V_MM) AS build_number`	184	`get_build_number(pv.V_MM) AS build_number,`
-		185	`rc.SDKTAG_ID AS SDKTAG_ID`
178	`FROM RELEASE_CONTENT rc,`	186	`FROM RELEASE_CONTENT rc,`
179	`PACKAGE_VERSIONS pv,`	187	`PACKAGE_VERSIONS pv,`
180	`PACKAGES pkg`	188	`PACKAGES pkg`
181	`WHERE rc.PV_ID = pv.PV_ID`	189	`WHERE rc.PV_ID = pv.PV_ID`
182	`AND rc.RTAG_ID = :RTAG_B`	190	`AND rc.RTAG_ID = :RTAG_B`
183	`AND pv.PKG_ID = pkg.PKG_ID`	191	`AND pv.PKG_ID = pkg.PKG_ID`
184	`UNION`	192	`UNION`
185	`SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, NULL AS DEPRECATED_STATE,`	193	`SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, NULL AS DEPRECATED_STATE,`
186	`get_patch_version(pv.V_MM) AS patch_number,`	194	`get_patch_version(pv.V_MM) AS patch_number,`
187	`get_build_number(pv.V_MM) AS build_number`	195	`get_build_number(pv.V_MM) AS build_number,`
-		196	`NULL AS SDKTAG_ID`
188	`FROM PLANNED pl,`	197	`FROM PLANNED pl,`
189	`PACKAGE_VERSIONS pv,`	198	`PACKAGE_VERSIONS pv,`
190	`PACKAGES pkg`	199	`PACKAGES pkg`
191	`WHERE pl.PV_ID = pv.PV_ID`	200	`WHERE pl.PV_ID = pv.PV_ID`
192	`AND pv.PKG_ID = pkg.PKG_ID`	201	`AND pv.PKG_ID = pkg.PKG_ID`
193	`AND pl.operation = 'A'`	202	`AND pl.operation = 'A'`
194	`AND pl.RTAG_ID = :RTAG_B)`	203	`AND pl.RTAG_ID = :RTAG_B)`
195	`MINUS`	204	`MINUS`
196	`SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, NULL AS DEPRECATED_STATE,`	205	`SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, NULL AS DEPRECATED_STATE,`
197	`get_patch_version(pv.V_MM) AS patch_number,`	206	`get_patch_version(pv.V_MM) AS patch_number,`
198	`get_build_number(pv.V_MM) AS build_number`	207	`get_build_number(pv.V_MM) AS build_number,`
-		208	`NULL AS SDKTAG_ID`
199	`FROM PLANNED pl,`	209	`FROM PLANNED pl,`
200	`PACKAGE_VERSIONS pv,`	210	`PACKAGE_VERSIONS pv,`
201	`PACKAGES pkg`	211	`PACKAGES pkg`
202	`WHERE pl.PV_ID = pv.PV_ID`	212	`WHERE pl.PV_ID = pv.PV_ID`
203	`AND pv.PKG_ID = pkg.PKG_ID`	213	`AND pv.PKG_ID = pkg.PKG_ID`
Line 222...	Line 232...
222	`ra.PKG_VERSION AS PKG_VERSION_A,`	232	`ra.PKG_VERSION AS PKG_VERSION_A,`
223	`ra.V_NMM AS MAJOR_MINOR_A,`	233	`ra.V_NMM AS MAJOR_MINOR_A,`
224	`get_patch_version(ra.V_MM) AS PATCH_NUMBER_A,`	234	`get_patch_version(ra.V_MM) AS PATCH_NUMBER_A,`
225	`get_build_number(ra.V_MM) AS BUILD_NUMBER_A,`	235	`get_build_number(ra.V_MM) AS BUILD_NUMBER_A,`
226	`ra.DEPRECATED_STATE as PKG_STATE_A,`	236	`ra.DEPRECATED_STATE as PKG_STATE_A,`
-		237	`NVL2(ra.SDKTAG_ID, 1, 0) AS PKG_SDK_A,`
227	`rb.PV_ID AS PV_ID_B,`	238	`rb.PV_ID AS PV_ID_B,`
228	`rb.COMMENTS AS COMMENTS_B,`	239	`rb.COMMENTS AS COMMENTS_B,`
229	`rb.PKG_NAME AS PKG_NAME_B,`	240	`rb.PKG_NAME AS PKG_NAME_B,`
230	`rb.PKG_VERSION AS PKG_VERSION_B,`	241	`rb.PKG_VERSION AS PKG_VERSION_B,`
231	`rb.V_NMM AS MAJOR_MINOR_B,`	242	`rb.V_NMM AS MAJOR_MINOR_B,`
232	`get_patch_version(rb.V_MM) AS PATCH_NUMBER_B,`	243	`get_patch_version(rb.V_MM) AS PATCH_NUMBER_B,`
233	`get_build_number(rb.V_MM) AS BUILD_NUMBER_B,`	244	`get_build_number(rb.V_MM) AS BUILD_NUMBER_B,`
234	`rb.DEPRECATED_STATE AS PKG_STATE_B`	245	`rb.DEPRECATED_STATE AS PKG_STATE_B,`
-		246	`NVL2(rb.SDKTAG_ID, 1, 0) AS PKG_SDK_B`
235	`FROM (`	247	`FROM (`
236	`SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, v.VIEW_NAME, v.VIEW_ID, rc.DEPRECATED_STATE`	248	`SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, v.VIEW_NAME, v.VIEW_ID, rc.DEPRECATED_STATE, rc.SDKTAG_ID`
237	`FROM RELEASE_CONTENT rc,`	249	`FROM RELEASE_CONTENT rc,`
238	`PACKAGE_VERSIONS pv,`	250	`PACKAGE_VERSIONS pv,`
239	`PACKAGES pkg,`	251	`PACKAGES pkg,`
240	`VIEWS v`	252	`VIEWS v`
241	`WHERE rc.PV_ID = pv.PV_ID`	253	`WHERE rc.PV_ID = pv.PV_ID`
Line 243...	Line 255...
243	`AND pv.PKG_ID = pkg.PKG_ID`	255	`AND pv.PKG_ID = pkg.PKG_ID`
244	`AND v.VIEW_ID = rc.BASE_VIEW_ID`	256	`AND v.VIEW_ID = rc.BASE_VIEW_ID`
245	`) ra,`	257	`) ra,`
246	`(`	258	`(`
247	`/* ( ReleaseContent@B + Planned@B(Additions) - Planned@B(Subtractions) ) */`	259	`/* ( ReleaseContent@B + Planned@B(Additions) - Planned@B(Subtractions) ) */`
248	`(SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, rc.DEPRECATED_STATE`	260	`(SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, rc.DEPRECATED_STATE , rc.SDKTAG_ID`
249	`FROM RELEASE_CONTENT rc,`	261	`FROM RELEASE_CONTENT rc,`
250	`PACKAGE_VERSIONS pv,`	262	`PACKAGE_VERSIONS pv,`
251	`PACKAGES pkg`	263	`PACKAGES pkg`
252	`WHERE rc.PV_ID = pv.PV_ID`	264	`WHERE rc.PV_ID = pv.PV_ID`
253	`AND rc.RTAG_ID = :RTAG_B`	265	`AND rc.RTAG_ID = :RTAG_B`
254	`AND pv.PKG_ID = pkg.PKG_ID`	266	`AND pv.PKG_ID = pkg.PKG_ID`
255	`UNION`	267	`UNION`
256	`SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, NULL AS DEPRECATED_STATE`	268	`SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, NULL AS DEPRECATED_STATE, NULL AS SDKTAG_ID`
257	`FROM PLANNED pl,`	269	`FROM PLANNED pl,`
258	`PACKAGE_VERSIONS pv,`	270	`PACKAGE_VERSIONS pv,`
259	`PACKAGES pkg`	271	`PACKAGES pkg`
260	`WHERE pl.PV_ID = pv.PV_ID`	272	`WHERE pl.PV_ID = pv.PV_ID`
261	`AND pl.RTAG_ID = :RTAG_B`	273	`AND pl.RTAG_ID = :RTAG_B`
262	`AND pl.operation = 'A'`	274	`AND pl.operation = 'A'`
263	`AND pv.PKG_ID = pkg.PKG_ID)`	275	`AND pv.PKG_ID = pkg.PKG_ID)`
264	`MINUS`	276	`MINUS`
265	`SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, NULL AS DEPRECATED_STATE`	277	`SELECT pv.PKG_ID, pv.V_EXT, pv.PV_ID, pv.V_NMM, pv.V_MM, pv.COMMENTS, pkg.PKG_NAME, pv.PKG_VERSION, NULL AS DEPRECATED_STATE, NULL AS SDKTAG_ID`
266	`FROM PLANNED pl,`	278	`FROM PLANNED pl,`
267	`PACKAGE_VERSIONS pv,`	279	`PACKAGE_VERSIONS pv,`
268	`PACKAGES pkg`	280	`PACKAGES pkg`
269	`WHERE pl.PV_ID = pv.PV_ID`	281	`WHERE pl.PV_ID = pv.PV_ID`
270	`AND pl.RTAG_ID = :RTAG_B`	282	`AND pl.RTAG_ID = :RTAG_B`

Subversion Repositories DevTools

(root)/ManagerSuite/Release_Manager/trunk/queries/ReleaseDiff.sql @ 5098 – Rev 123 → 5081