Subversion Repositories DevTools

Rev

Rev 5898 | 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 
 
7457 dpurdie 16 
        /* ------- ERROR: Subversion to CC regression or GIT to Subversion regression ------- */
17 
        SELECT DISTINCT 'enum_MSG_MIXED_VCS' AS err_message,
5898 dpurdie 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,
7457 dpurdie 23 
               PACKAGES pkg,
2365 dpurdie 24 
               VCS_TYPE vt
5898 dpurdie 25 
         WHERE pv.pv_id = :PV_ID
7457 dpurdie 26 
           AND pv.pkg_id = pkg.pkg_id
2365 dpurdie 27 
           AND pv.vcs_type_id  = vt.vcs_type_id
7457 dpurdie 28 
           AND PK_RMAPI.has_mixed_vcs(vt.tag, pkg.pkg_name) > 0
2365 dpurdie 29 
 
5898 dpurdie 30 
        UNION
31 
 
32 
        /* ------- ERROR: Package is unbuildable ------- */
33 
        SELECT DISTINCT 'enum_MSG_UNBUILDABLE_PACKAGE' AS err_message,
34 
               'fixed_issues.asp' AS rfile,
35 
               '#PACKAGE_INFORMATION' AS anchor,
36 
               1 AS priority,
37 
               'ERROR' AS products_msg
38 
         FROM  PACKAGE_VERSIONS pv
39 
         WHERE pv.pv_id = :PV_ID
40 
           AND pv.build_type  = 'U'
119 ghuddy 41 
 
5898 dpurdie 42 
        ) errmsg
43 
ORDER BY priority