Subversion Repositories DevTools

Rev

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

Rev 5506 Rev 6189
Line 1... Line 1...
1
/* Release Diff */
1
                                                               /* Release Diff */
2
SELECT qry.*
2
SELECT qry.*
3
    FROM (
3
    FROM (
4
 
4
 
5
       /* Removed Packages */
5
       /* Removed Packages */
6
       SELECT 'R' AS CHANGE_TYPE,
6
       SELECT 'R' AS CHANGE_TYPE,
Line 220... Line 220...
220
         AND :UPDATED IS NULL
220
         AND :UPDATED IS NULL
221
 
221
 
222
       UNION
222
       UNION
223
 
223
 
224
       /* NOT CHANGED Packages - NOTE '0' as change type so these entries appear ahead of additions, in sort order */
224
       /* NOT CHANGED Packages - NOTE '0' as change type so these entries appear ahead of additions, in sort order */
225
       SELECT '0' AS CHANGE_TYPE,
225
       SELECT 'B' AS CHANGE_TYPE,
226
              ra.VIEW_ID,
226
              ra.VIEW_ID,
227
              ra.VIEW_NAME,
227
              ra.VIEW_NAME,
228
              ra.PKG_ID,
228
              ra.PKG_ID,
229
              ra.PV_ID AS PV_ID_A,
229
              ra.PV_ID AS PV_ID_A,
230
              ra.COMMENTS AS COMMENTS_A,
230
              ra.COMMENTS AS COMMENTS_A,
Line 255... Line 255...
255
                 AND pv.PKG_ID = pkg.PKG_ID
255
                 AND pv.PKG_ID = pkg.PKG_ID
256
                 AND v.VIEW_ID = rc.BASE_VIEW_ID
256
                 AND v.VIEW_ID = rc.BASE_VIEW_ID
257
            ) ra,
257
            ) ra,
258
            (
258
            (
259
              /* ( ReleaseContent@B + Planned@B(Additions) - Planned@B(Subtractions) ) */
259
              /* ( ReleaseContent@B + Planned@B(Additions) - Planned@B(Subtractions) ) */
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
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
261
                 FROM RELEASE_CONTENT rc,
261
                 FROM RELEASE_CONTENT rc,
262
                      PACKAGE_VERSIONS pv,
262
                      PACKAGE_VERSIONS pv,
263
                      PACKAGES pkg
263
                      PACKAGES pkg
264
                WHERE rc.PV_ID = pv.PV_ID
264
                WHERE rc.PV_ID = pv.PV_ID
265
                  AND rc.RTAG_ID = :RTAG_B
265
                  AND rc.RTAG_ID = :RTAG_B
Line 270... Line 270...
270
                      PACKAGE_VERSIONS pv,
270
                      PACKAGE_VERSIONS pv,
271
                      PACKAGES pkg
271
                      PACKAGES pkg
272
                WHERE pl.PV_ID = pv.PV_ID
272
                WHERE pl.PV_ID = pv.PV_ID
273
                  AND pl.RTAG_ID = :RTAG_B
273
                  AND pl.RTAG_ID = :RTAG_B
274
                  AND pl.operation = 'A'
274
                  AND pl.operation = 'A'
275
                  AND pv.PKG_ID = pkg.PKG_ID)
275
                  AND pv.PKG_ID = pkg.PKG_ID
276
              MINUS
276
              MINUS
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
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
278
                FROM PLANNED pl,
278
                FROM PLANNED pl,
279
                     PACKAGE_VERSIONS pv,
279
                     PACKAGE_VERSIONS pv,
280
                     PACKAGES pkg
280
                     PACKAGES pkg
Line 286... Line 286...
286
       WHERE ra.PKG_ID = rb.PKG_ID
286
       WHERE ra.PKG_ID = rb.PKG_ID
287
         AND NVL( ra.V_EXT, '|LINK_A_NULL|') = NVL( rb.V_EXT, '|LINK_A_NULL|')
287
         AND NVL( ra.V_EXT, '|LINK_A_NULL|') = NVL( rb.V_EXT, '|LINK_A_NULL|')
288
         AND ra.PV_ID = rb.PV_ID
288
         AND ra.PV_ID = rb.PV_ID
289
         AND :NO_CHANGE IS NULL
289
         AND :NO_CHANGE IS NULL
290
 
290
 
-
 
291
      /* All Pending additions and Removals
-
 
292
         Change_Type is set so that these will first
-
 
293
       */
-
 
294
      UNION
-
 
295
             SELECT rb.CHANGE_TYPE AS CHANGE_TYPE,
-
 
296
              ra.VIEW_ID,
-
 
297
              ra.VIEW_NAME,
-
 
298
              ra.PKG_ID,
-
 
299
              ra.PV_ID AS PV_ID_A,
-
 
300
              ra.COMMENTS AS COMMENTS_A,
-
 
301
              ra.PKG_NAME AS PKG_NAME_A,
-
 
302
              ra.PKG_VERSION AS PKG_VERSION_A,
-
 
303
              ra.V_NMM AS MAJOR_MINOR_A,
-
 
304
              get_patch_version(ra.V_MM) AS PATCH_NUMBER_A,
-
 
305
              get_build_number(ra.V_MM) AS BUILD_NUMBER_A,
-
 
306
              ra.DEPRECATED_STATE as PKG_STATE_A,
-
 
307
              NVL2(ra.SDKTAG_ID, 1, 0) AS PKG_SDK_A,
-
 
308
              rb.PV_ID AS PV_ID_B,
-
 
309
              rb.COMMENTS AS COMMENTS_B,
-
 
310
              rb.PKG_NAME AS PKG_NAME_B,
-
 
311
              rb.PKG_VERSION AS PKG_VERSION_B,
-
 
312
              rb.V_NMM AS MAJOR_MINOR_B,
-
 
313
              get_patch_version(rb.V_MM) AS PATCH_NUMBER_B,
-
 
314
              get_build_number(rb.V_MM) AS BUILD_NUMBER_B,
-
 
315
              rb.DEPRECATED_STATE AS PKG_STATE_B,
-
 
316
              NVL2(rb.SDKTAG_ID, 1, 0) AS PKG_SDK_B
-
 
317
       FROM (
-
 
318
              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
-
 
319
                FROM RELEASE_CONTENT rc,
-
 
320
                     PACKAGE_VERSIONS pv,
-
 
321
                     PACKAGES pkg,
-
 
322
                     VIEWS v
-
 
323
               WHERE rc.PV_ID = pv.PV_ID
-
 
324
                 AND rc.RTAG_ID = :RTAG_A
-
 
325
                 AND pv.PKG_ID = pkg.PKG_ID
-
 
326
                 AND v.VIEW_ID = rc.BASE_VIEW_ID
-
 
327
            ) ra,
-
 
328
            (
-
 
329
              /* ( Planned@B(Additions) and Planned@B(Subtractions) ) */
-
 
330
              (
-
 
331
               SELECT 'APA' as CHANGE_TYPE, 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
-
 
332
                 FROM PLANNED pl,
-
 
333
                      PACKAGE_VERSIONS pv,
-
 
334
                      PACKAGES pkg
-
 
335
                WHERE pl.PV_ID = pv.PV_ID
-
 
336
                  AND pl.RTAG_ID = :RTAG_B
-
 
337
                  AND pl.operation = 'A'
-
 
338
                  AND pv.PKG_ID = pkg.PKG_ID)
-
 
339
              UNION
-
 
340
              SELECT 'APS' as CHANGE_TYPE, 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
-
 
341
                FROM PLANNED pl,
-
 
342
                     PACKAGE_VERSIONS pv,
-
 
343
                     PACKAGES pkg
-
 
344
               WHERE pl.PV_ID = pv.PV_ID
-
 
345
                 AND pl.RTAG_ID = :RTAG_B
-
 
346
                 AND pl.operation = 'S'
-
 
347
                 AND pv.PKG_ID = pkg.PKG_ID
-
 
348
            ) rb
-
 
349
       WHERE ra.PKG_ID = rb.PKG_ID
-
 
350
         AND NVL( ra.V_EXT, '|LINK_A_NULL|') = NVL( rb.V_EXT, '|LINK_A_NULL|')
-
 
351
 
-
 
352
 
291
    ) qry
353
    ) qry
292
   /* NOTE: Sorting by change type has been added to ensure diff.asp can display items correctly and filter out */
354
   /* NOTE: Sorting by change type has been added to ensure diff.asp can display items correctly and filter out */
293
   /*       duplicates. Order is Unchanged, Additions, Removals, and finally Updates. */
355
   /*       duplicates. Order is Pending, Unchanged, Additions, Removals, and finally Updates. */
-
 
356
 
294
ORDER BY UPPER(qry.VIEW_NAME),UPPER(qry.PKG_NAME_A),CHANGE_TYPE
357
ORDER BY UPPER(qry.VIEW_NAME),UPPER(qry.PKG_NAME_A),qry.CHANGE_TYPE
-
 
358