Subversion Repositories DevTools

Rev

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

Rev 1281 Rev 2362
Line 1... Line 1...
1
SELECT *
1
SELECT *
2
  FROM	(
2
  FROM	(
3
  
3
  
4
		   
-
 
5
		/* ------- ERROR: Package Information Section Incomplete ------- */   
4
		/* ------- ERROR: Package Information Section Incomplete ------- */
6
		SELECT DISTINCT 'enum_MSG_PACKAGE_CHANGETYPE_INCOMPLETE' AS err_message,
5
		SELECT DISTINCT 'enum_MSG_PACKAGE_CHANGETYPE_INCOMPLETE' AS err_message,
7
					    'fixed_issues.asp' AS rfile,
6
					    'fixed_issues.asp' AS rfile,
8
				        '#CHANGE_TYPE' AS anchor,
7
				        '#CHANGE_TYPE' AS anchor,
9
		                1 AS priority,
8
		                1 AS priority,
10
					    'ERROR' AS products_msg
9
					    'ERROR' AS products_msg
11
				   FROM PACKAGE_VERSIONS pv
10
				   FROM PACKAGE_VERSIONS pv
12
				  WHERE pv.pv_id = :PV_ID
11
				  WHERE pv.pv_id = :PV_ID
13
				    AND ( pv.CHANGE_TYPE IS NULL )
12
				    AND ( pv.CHANGE_TYPE IS NULL )
14
				       	            
13
				       	            
-
 
14
		UNION
-
 
15
 
-
 
16
		/* ------- ERROR: Subversion to CC regression ------- */
-
 
17
		SELECT DISTINCT 'enum_MSG_VCS_SUBVERSION_CC_MIX' AS err_message,
-
 
18
			   'fixed_issues.asp' AS rfile,
-
 
19
		       '#PACKAGE_INFORMATION' AS anchor,
-
 
20
               11 AS priority,
-
 
21
			   'ERROR' AS products_msg
-
 
22
         FROM  PACKAGE_VERSIONS pv,
-
 
23
               VCS_TYPE vt
-
 
24
		 WHERE pv.pv_id = :PV_ID
-
 
25
           AND pv.vcs_type_id  = vt.vcs_type_id
-
 
26
		   AND ( vt.tag = 'CC' or vt.tag = 'CVS' )
-
 
27
		   AND ( PK_RMAPI.IsSVN(pv.pkg_id) > 0 )
15
 
28
 
16
         
29
         
17
		) errmsg
30
		) errmsg
18
ORDER BY priority        		      
31
ORDER BY priority        		      
19
32