Subversion Repositories DevTools

Rev

Rev 6489 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Added Components */
6489 dpurdie 2 
SELECT rc.NAME, rc.FILE_PATH,
6375 dpurdie 3 
       rc.BYTE_SIZE,
4 
       rc.CRC_CKSUM,
5 
       3 AS DIFF_STATE,
6 
       NULL as COMP_BYTE_SIZE,
6376 dpurdie 7 
       NULL as COMP_CRC_CKSUM
119 ghuddy 8 
  FROM (
6750 dpurdie 9 
        SELECT REGEXP_REPLACE(rc.file_path, '[/\\]', '/') || rc.FILE_NAME AS NAME,REGEXP_REPLACE(rc.file_path, '[/\\]', '/') AS FILE_PATH,
6375 dpurdie 10 
               rc.BYTE_SIZE,
11 
               rc.CRC_CKSUM
12 
          FROM RELEASE_COMPONENTS rc
13 
         WHERE rc.PV_ID = :PV_ID
14 
       ) rc,
15 
       (
6750 dpurdie 16 
        SELECT REGEXP_REPLACE(rc.file_path, '[/\\]', '/') || rc.FILE_NAME AS NAME
6375 dpurdie 17 
          FROM RELEASE_COMPONENTS rc
18 
         WHERE rc.PV_ID = :PV_ID
19 
        MINUS
6750 dpurdie 20 
        SELECT REGEXP_REPLACE(rc.file_path, '[/\\]', '/') || rc.FILE_NAME AS NAME
6375 dpurdie 21 
          FROM RELEASE_COMPONENTS rc
22 
         WHERE rc.PV_ID = :COMPARE_PV_ID
23 
       ) crc
119 ghuddy 24 
 WHERE rc.NAME = crc.NAME
25 
 
26 
UNION
27 
 
28 
/* Removed Components */
6489 dpurdie 29 
SELECT rc.NAME,rc.FILE_PATH,
6375 dpurdie 30 
       NULL as BYTE_SIZE,
6376 dpurdie 31 
       NULL as CRC_CKSUM,
6375 dpurdie 32 
       2 AS DIFF_STATE,
33 
       rc.BYTE_SIZE as COMP_BYTE_SIZE,
34 
       rc.CRC_CKSUM as COMP_CRC_CKSUM
119 ghuddy 35 
  FROM (
6750 dpurdie 36 
        SELECT REGEXP_REPLACE(rc.file_path, '[/\\]', '/') || rc.FILE_NAME AS NAME,REGEXP_REPLACE(rc.file_path, '[/\\]', '/') AS FILE_PATH,
6375 dpurdie 37 
               rc.BYTE_SIZE,
38 
               rc.CRC_CKSUM
39 
          FROM RELEASE_COMPONENTS rc
40 
         WHERE rc.PV_ID = :COMPARE_PV_ID
41 
       ) rc,
42 
       (
6750 dpurdie 43 
        SELECT REGEXP_REPLACE(rc.file_path, '[/\\]', '/') || rc.FILE_NAME AS NAME
6375 dpurdie 44 
          FROM RELEASE_COMPONENTS rc
45 
         WHERE rc.PV_ID = :COMPARE_PV_ID
46 
        MINUS
6750 dpurdie 47 
        SELECT REGEXP_REPLACE(rc.file_path, '[/\\]', '/') || rc.FILE_NAME AS NAME
6375 dpurdie 48 
          FROM RELEASE_COMPONENTS rc
49 
         WHERE rc.PV_ID = :PV_ID
50 
       ) crc
51 
 WHERE rc.NAME = crc.NAME
119 ghuddy 52 
 
53 
UNION
54 
 
6750 dpurdie 55 
SELECT pv.NAME, REGEXP_REPLACE(pv.file_path, '[/\\]', '/') AS FILE_PATH,
119 ghuddy 56 
       pv.BYTE_SIZE,
6375 dpurdie 57 
       pv.CRC_CKSUM,
58 
       DECODE ( pv.CRC_CKSUM, cpv.CRC_CKSUM, 0, 1 ) AS DIFF_STATE,
59 
       cpv.BYTE_SIZE as COMP_BYTE_SIZE,
60 
       cpv.CRC_CKSUM as COMP_CRC_CKSUM
119 ghuddy 61 
  FROM (
6750 dpurdie 62 
        SELECT REGEXP_REPLACE(rc.file_path, '[/\\]', '/') || rc.FILE_NAME AS NAME,REGEXP_REPLACE(rc.file_path, '[/\\]', '/') AS FILE_PATH,
6375 dpurdie 63 
               rc.BYTE_SIZE,
64 
               rc.CRC_CKSUM
65 
          FROM RELEASE_COMPONENTS rc
66 
         WHERE rc.PV_ID = :PV_ID
67 
       ) pv,
68 
       (
6750 dpurdie 69 
        SELECT REGEXP_REPLACE(rc.file_path, '[/\\]', '/') || rc.FILE_NAME AS NAME,
6375 dpurdie 70 
               rc.BYTE_SIZE,
71 
               rc.CRC_CKSUM
72 
          FROM RELEASE_COMPONENTS rc
73 
         WHERE rc.PV_ID = :COMPARE_PV_ID
74 
       ) cpv
75 
 WHERE pv.NAME = cpv.NAME
76