Subversion Repositories DevTools

Rev

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

Rev 6375 Rev 6376
Line 2... Line 2...
2 
SELECT rc.NAME,
 2 
SELECT rc.NAME,
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,
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
Line 26... Line 26...
26 
UNION
26 
UNION
27
27
28 
/* Removed Components */
 28 
/* Removed Components */
29 
SELECT rc.NAME,
 29 
SELECT rc.NAME,
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,