Subversion Repositories DevTools

Rev

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

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

            62
            
        SELECT rc.FILE_PATH || rc.FILE_NAME AS NAME,

          

          

            -
            
 

            63
            
               rc.BYTE_SIZE, 

          

          

            -
            
 

            64
            
               rc.CRC_CKSUM

          

          

            -
            
 

            65
            
          FROM RELEASE_COMPONENTS rc

          

          

            -
            
 

            66
            
         WHERE rc.PV_ID = :PV_ID 

          

          

            -
            
 

            67
            
       ) pv,

          

          

            -
            
 

            68
            
       (

          

          

            -
            
 

            69
            
        SELECT rc.FILE_PATH || rc.FILE_NAME AS NAME,

          

          

            -
            
 

            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
            
 

          

          

            -
            
 

            77