Subversion Repositories DevTools

Rev

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

Rev 6376 Rev 6489
Line 1... Line 1...
1 
/* Added Components */
 1 
/* Added Components */
2 
SELECT rc.NAME,
 2 
SELECT rc.NAME, rc.FILE_PATH,
3 
       rc.BYTE_SIZE,
 3 
       rc.BYTE_SIZE,
4 
       rc.CRC_CKSUM,
 4 
       rc.CRC_CKSUM,
5 
       3 AS DIFF_STATE,
 5 
       3 AS DIFF_STATE,
6 
       NULL as COMP_BYTE_SIZE,
 6 
       NULL as COMP_BYTE_SIZE,
7 
       NULL as COMP_CRC_CKSUM
 7 
       NULL as COMP_CRC_CKSUM
8 
  FROM (
 8 
  FROM (
9 
        SELECT rc.FILE_PATH || rc.FILE_NAME AS NAME,
 9 
        SELECT rc.FILE_PATH || rc.FILE_NAME AS NAME,rc.FILE_PATH,
10 
               rc.BYTE_SIZE,
10 
               rc.BYTE_SIZE,
11 
               rc.CRC_CKSUM
 11 
               rc.CRC_CKSUM
12 
          FROM RELEASE_COMPONENTS rc
 12 
          FROM RELEASE_COMPONENTS rc
13 
         WHERE rc.PV_ID = :PV_ID
 13 
         WHERE rc.PV_ID = :PV_ID
14 
       ) rc,
 14 
       ) rc,
Line 24... Line 24...
24 
 WHERE rc.NAME = crc.NAME
24 
 WHERE rc.NAME = crc.NAME
25
25
26 
UNION
26 
UNION
27
27
28 
/* Removed Components */
 28 
/* Removed Components */
29 
SELECT rc.NAME,
 29 
SELECT rc.NAME,rc.FILE_PATH,
30 
       NULL as BYTE_SIZE,
 30 
       NULL as BYTE_SIZE,
31 
       NULL as CRC_CKSUM,
 31 
       NULL as CRC_CKSUM,
32 
       2 AS DIFF_STATE,
 32 
       2 AS DIFF_STATE,
33 
       rc.BYTE_SIZE as COMP_BYTE_SIZE,
 33 
       rc.BYTE_SIZE as COMP_BYTE_SIZE,
34 
       rc.CRC_CKSUM as COMP_CRC_CKSUM
 34 
       rc.CRC_CKSUM as COMP_CRC_CKSUM
35 
  FROM (
 35 
  FROM (
36 
        SELECT rc.FILE_PATH || rc.FILE_NAME AS NAME,
 36 
        SELECT rc.FILE_PATH || rc.FILE_NAME AS NAME, rc.FILE_PATH,
37 
               rc.BYTE_SIZE,
37 
               rc.BYTE_SIZE,
38 
               rc.CRC_CKSUM
 38 
               rc.CRC_CKSUM
39 
          FROM RELEASE_COMPONENTS rc
 39 
          FROM RELEASE_COMPONENTS rc
40 
         WHERE rc.PV_ID = :COMPARE_PV_ID
40 
         WHERE rc.PV_ID = :COMPARE_PV_ID
41 
       ) rc,
 41 
       ) rc,
Line 50... Line 50...
50 
       ) crc
 50 
       ) crc
51 
 WHERE rc.NAME = crc.NAME
51 
 WHERE rc.NAME = crc.NAME
52
52
53 
UNION
53 
UNION
54
54
55 
SELECT pv.NAME,
 55 
SELECT pv.NAME, pv.FILE_PATH,
56 
       pv.BYTE_SIZE,
56 
       pv.BYTE_SIZE,
57 
       pv.CRC_CKSUM,
 57 
       pv.CRC_CKSUM,
58 
       DECODE ( pv.CRC_CKSUM, cpv.CRC_CKSUM, 0, 1 ) AS DIFF_STATE,
 58 
       DECODE ( pv.CRC_CKSUM, cpv.CRC_CKSUM, 0, 1 ) AS DIFF_STATE,
59 
       cpv.BYTE_SIZE as COMP_BYTE_SIZE,
 59 
       cpv.BYTE_SIZE as COMP_BYTE_SIZE,
60 
       cpv.CRC_CKSUM as COMP_CRC_CKSUM
 60 
       cpv.CRC_CKSUM as COMP_CRC_CKSUM
61 
  FROM (
 61 
  FROM (
62 
        SELECT rc.FILE_PATH || rc.FILE_NAME AS NAME,
 62 
        SELECT rc.FILE_PATH || rc.FILE_NAME AS NAME, rc.FILE_PATH,
63 
               rc.BYTE_SIZE,
63 
               rc.BYTE_SIZE,
64 
               rc.CRC_CKSUM
 64 
               rc.CRC_CKSUM
65 
          FROM RELEASE_COMPONENTS rc
 65 
          FROM RELEASE_COMPONENTS rc
66 
         WHERE rc.PV_ID = :PV_ID
66 
         WHERE rc.PV_ID = :PV_ID
67 
       ) pv,
 67 
       ) pv,