Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Added Components */
2 
SELECT rc.NAME,
3 
	   rc.BYTE_SIZE,
4 
	   rc.CRC_CKSUM,
5 
	   3 AS DIFF_STATE
6 
  FROM (
7 
  		SELECT rc.FILE_PATH || rc.FILE_NAME AS NAME,
8 
			   rc.BYTE_SIZE,
9 
			   rc.CRC_CKSUM
10 
		  FROM RELEASE_COMPONENTS rc
11 
		 WHERE rc.PV_ID = :PV_ID
12 
  	   ) rc,
13 
  	   (
14 
		SELECT rc.FILE_PATH || rc.FILE_NAME AS NAME
15 
		  FROM RELEASE_COMPONENTS rc
16 
		 WHERE rc.PV_ID = :PV_ID
17 
		MINUS
18 
		SELECT rc.FILE_PATH || rc.FILE_NAME AS NAME
19 
		  FROM RELEASE_COMPONENTS rc
20 
		 WHERE rc.PV_ID = :COMPARE_PV_ID
21 
	   ) crc
22 
 WHERE rc.NAME = crc.NAME
23 
 
24 
UNION
25 
 
26 
/* Removed Components */
27 
SELECT rc.NAME,
28 
	   rc.BYTE_SIZE,
29 
	   rc.CRC_CKSUM,
30 
	   2 AS DIFF_STATE
31 
  FROM (
32 
  		SELECT rc.FILE_PATH || rc.FILE_NAME AS NAME,
33 
			   rc.BYTE_SIZE,
34 
			   rc.CRC_CKSUM
35 
		  FROM RELEASE_COMPONENTS rc
36 
		 WHERE rc.PV_ID = :COMPARE_PV_ID
37 
  	   ) rc,
38 
  	   (
39 
		SELECT rc.FILE_PATH || rc.FILE_NAME AS NAME
40 
		  FROM RELEASE_COMPONENTS rc
41 
		 WHERE rc.PV_ID = :COMPARE_PV_ID
42 
		MINUS
43 
		SELECT rc.FILE_PATH || rc.FILE_NAME AS NAME
44 
		  FROM RELEASE_COMPONENTS rc
45 
		 WHERE rc.PV_ID = :PV_ID
46 
	   ) crc
47 
 WHERE rc.NAME = crc.NAME
48 
 
49 
UNION
50 
 
51 
SELECT pv.NAME,
52 
       pv.BYTE_SIZE,
53 
	   pv.CRC_CKSUM,
54 
	   DECODE ( pv.CRC_CKSUM, cpv.CRC_CKSUM, 0, 1 ) AS DIFF_STATE
55 
  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