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
		   
4
           
5
		/* ------- ERROR: SBOM Priority Section Incomplete ------- */   
5
        /* ------- ERROR: SBOM Priority Section Incomplete ------- */   
6
		SELECT DISTINCT 'enum_MSG_PACKAGE_SBOMPRIORITY_INCOMPLETE' AS err_message,
6
        SELECT DISTINCT 'enum_MSG_PACKAGE_SBOMPRIORITY_INCOMPLETE' AS err_message,
7
					    'fixed_issues.asp' AS rfile,
7
                        'fixed_issues.asp' AS rfile,
8
				        '#SBOM_PRIORITY' AS anchor,
8
                        '#SBOM_PRIORITY' AS anchor,
9
		                1 AS priority,
9
                        1 AS priority,
10
					    'ERROR' AS products_msg
10
                        'ERROR' AS products_msg
11
				   FROM PACKAGE_VERSIONS pv
11
                   FROM PACKAGE_VERSIONS pv
12
				  WHERE pv.pv_id = :PV_ID
12
                  WHERE pv.pv_id = :PV_ID
13
				    AND ( pv.SBOM_PRIORITY IS NULL )
13
                    AND ( pv.SBOM_PRIORITY IS NULL )
14
				       	            
14
                                    
-
 
15
        /* ------- ERROR: Package is unbuildable ------- */
-
 
16
        SELECT DISTINCT 'enum_MSG_UNBUILDABLE_PACKAGE' AS err_message,
-
 
17
               'fixed_issues.asp' AS rfile,
-
 
18
               '#PACKAGE_INFORMATION' AS anchor,
-
 
19
               2 AS priority,
-
 
20
               'ERROR' AS products_msg
-
 
21
         FROM  PACKAGE_VERSIONS pv
-
 
22
         WHERE pv.pv_id = :PV_ID
-
 
23
           AND pv.build_type  = 'U'
15
 
24
 
16
         
25
         
17
		) errmsg
-
 
18
ORDER BY priority        		      
-
 
19
26
        ) errmsg
-
 
27
ORDER BY priority                     
-
 
28
20
29