Subversion Repositories DevTools

Rev

Rev 5506 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
SELECT *
5898 dpurdie 2 
  FROM  (
119 ghuddy 3 
 
5898 dpurdie 4 
        /* ------- ERROR: Package Information Section Incomplete ------- */
5 
        SELECT DISTINCT 'enum_MSG_PACKAGE_CHANGETYPE_INCOMPLETE' AS err_message,
6 
                        'fixed_issues.asp' AS rfile,
7 
                        '#CHANGE_TYPE' AS anchor,
8 
                        2 AS priority,
9 
                        'ERROR' AS products_msg
10 
                   FROM PACKAGE_VERSIONS pv
11 
                  WHERE pv.pv_id = :PV_ID
12 
                    AND ( pv.CHANGE_TYPE IS NULL )
13 
 
14 
        UNION
119 ghuddy 15 
 
5898 dpurdie 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 
               3 AS priority,
21 
               'ERROR' AS products_msg
2365 dpurdie 22 
         FROM  PACKAGE_VERSIONS pv,
23 
               VCS_TYPE vt
5898 dpurdie 24 
         WHERE pv.pv_id = :PV_ID
2365 dpurdie 25 
           AND pv.vcs_type_id  = vt.vcs_type_id
5898 dpurdie 26 
           AND ( vt.tag = 'CC' or vt.tag = 'CVS' )
27 
           AND ( PK_RMAPI.IsSVN(pv.pkg_id) > 0 )
2365 dpurdie 28 
 
5898 dpurdie 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'
119 ghuddy 40 
 
5898 dpurdie 41 
        ) errmsg
42 
ORDER BY priority