SQL Queries - CAST Central Base - Queries on Metrics - How to get the added metric list between two Cast versions

Purpose of Query

The queries provide the list of Quality rule that has been added since a referenced version.

Applicable CAST Version
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(question)
Microsoft SQL Server(question)
CSS(tick)
Query for CSS
SELECT * 
FROM   <new_version_central>.dss_metric_types t 
WHERE  t.metric_group = 1 
AND    metric_id NOT IN 
       ( 
              SELECT metric_id 
              FROM   <referenced_version_central>.dss_metric_types t 
              WHERE  t.metric_group = 1 )
Query result example

--8114;"Avoid numerical data corruption during incompatible mutation";"This rule identifies ABAP control elements that contain numeric data which are updated with a value which has an incompatible type.

This quality rule checks if exceptions are correctly used.

Note: This quality rule implements the rule ASCSM-CWE-681 of the CISQ standard.";3;1;"";0;3;140556
--8112;"Avoid improper processing of the execution status of data handling operations";"This rule identifies Java control elements that embed data resource access actions without checking return code or handling error.

This quality rule checks methods that contain calls to SQL insert, update, select, create table enclosed in a try/catch block. Cases where SQL calls in functions that throw exceptions to be caught higher in the call graph are not addressed by this rule.
Either empty catch blocks, catch blocks with comments only, or only write to a stream are violating the rule. Appropriate logging or other treatment of exception are said to be valid.

Note: This quality rule implements the rule ASCSM-CWE-252 of the CISQ standard.";0;1;"";0;535;140550
--8110;"Use dedicated stored procedures when multiple data accesses are needed (ASCPEM-PRF-10)";"This rule identifies client-side control elements that embed a number of data resource access actions that exceed a threshold value.

The threshold for the number of data queries is a parameter and can be changed at will. The default value is 2.

Note: This quality rule implements the rule ASCPEM-PRF-10 of the CISQ standard.";3;1;"";0;911;140546

Query result interpretation

The query was run between a central schema of CAST AIP 7.3.1 and a central schema of CAST AIP 8.1.0. The query provides you the metric_id, the metric name and the metric description.

Query for Oracle
Enter the SQL query
Query result example

Query result interpretation

Query for SQL server
Enter the SQL query
Query result example

Query result interpretation

Notes/comments



Related Pages