Subversion Repositories DevTools

Rev

Rev 6489 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6489 Rev 6750
Line 4... Line 4...
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,rc.FILE_PATH,
 9 
        SELECT REGEXP_REPLACE(rc.file_path, '[/\\]', '/') || rc.FILE_NAME AS NAME,REGEXP_REPLACE(rc.file_path, '[/\\]', '/') AS 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,
15 
       (
 15 
       (
16 
        SELECT rc.FILE_PATH || rc.FILE_NAME AS NAME
 16 
        SELECT REGEXP_REPLACE(rc.file_path, '[/\\]', '/') || rc.FILE_NAME AS NAME
17 
          FROM RELEASE_COMPONENTS rc
 17 
          FROM RELEASE_COMPONENTS rc
18 
         WHERE rc.PV_ID = :PV_ID
 18 
         WHERE rc.PV_ID = :PV_ID
19 
        MINUS
19 
        MINUS
20 
        SELECT rc.FILE_PATH || rc.FILE_NAME AS NAME
 20 
        SELECT REGEXP_REPLACE(rc.file_path, '[/\\]', '/') || rc.FILE_NAME AS NAME
21 
          FROM RELEASE_COMPONENTS rc
 21 
          FROM RELEASE_COMPONENTS rc
22 
         WHERE rc.PV_ID = :COMPARE_PV_ID
22 
         WHERE rc.PV_ID = :COMPARE_PV_ID
23 
       ) crc
 23 
       ) crc
24 
 WHERE rc.NAME = crc.NAME
24 
 WHERE rc.NAME = crc.NAME
25
25
Line 31... Line 31...
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, rc.FILE_PATH,
 36 
        SELECT REGEXP_REPLACE(rc.file_path, '[/\\]', '/') || rc.FILE_NAME AS NAME,REGEXP_REPLACE(rc.file_path, '[/\\]', '/') AS 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,
42 
       (
 42 
       (
43 
        SELECT rc.FILE_PATH || rc.FILE_NAME AS NAME
 43 
        SELECT REGEXP_REPLACE(rc.file_path, '[/\\]', '/') || rc.FILE_NAME AS NAME
44 
          FROM RELEASE_COMPONENTS rc
 44 
          FROM RELEASE_COMPONENTS rc
45 
         WHERE rc.PV_ID = :COMPARE_PV_ID
45 
         WHERE rc.PV_ID = :COMPARE_PV_ID
46 
        MINUS
46 
        MINUS
47 
        SELECT rc.FILE_PATH || rc.FILE_NAME AS NAME
 47 
        SELECT REGEXP_REPLACE(rc.file_path, '[/\\]', '/') || rc.FILE_NAME AS NAME
48 
          FROM RELEASE_COMPONENTS rc
 48 
          FROM RELEASE_COMPONENTS rc
49 
         WHERE rc.PV_ID = :PV_ID
49 
         WHERE rc.PV_ID = :PV_ID
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, pv.FILE_PATH,
 55 
SELECT pv.NAME, REGEXP_REPLACE(pv.file_path, '[/\\]', '/') AS 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, rc.FILE_PATH,
 62 
        SELECT REGEXP_REPLACE(rc.file_path, '[/\\]', '/') || rc.FILE_NAME AS NAME,REGEXP_REPLACE(rc.file_path, '[/\\]', '/') AS 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,
68 
       (
 68 
       (
69 
        SELECT rc.FILE_PATH || rc.FILE_NAME AS NAME,
 69 
        SELECT REGEXP_REPLACE(rc.file_path, '[/\\]', '/') || rc.FILE_NAME AS NAME,
70 
               rc.BYTE_SIZE,
70 
               rc.BYTE_SIZE,
71 
               rc.CRC_CKSUM
 71 
               rc.CRC_CKSUM
72 
          FROM RELEASE_COMPONENTS rc
 72 
          FROM RELEASE_COMPONENTS rc
73 
         WHERE rc.PV_ID = :COMPARE_PV_ID
 73 
         WHERE rc.PV_ID = :COMPARE_PV_ID
74 
       ) cpv
 74 
       ) cpv