Subversion Repositories DevTools

Rev

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

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

            41
            
        ) errmsg

          

          

            -
            
 

            42
            
ORDER BY priority                     

          

          

            -
            
 

            43
            

          

          

            33
            

            44