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