CAST Engineering Dashboard - Violations - No violation - Avoid using SQL queries inside a loop
Description
Some objects of technology ABAP are violating the quality rule Avoid using SQL queries inside a loop, but in dashboard violations are missing.
Observed in CAST AIP
| Release | Yes/No |
|---|---|
| 8.3.x | ✅ |
Observed on RDBMS
| RDBMS | Yes/No |
|---|---|
| CSS | ✅ |
Step by Step Scenario
Below is the step-by-step scenario leading to the problem:
- Run the analysis.
- Take a snapshot.
Impact of the Problem
The impact of the problem on the analysis or the dashboard is:
Missing violations
Action Plan
Starting from AIP 8.0.1 we have remove ABAP from quality rule “Avoid using SQL queries inside a loop”. The reason why we opted for this choice is:
When analyzing an ABAP application, 2 rules are violated when there is SQL query in a loop:
- Avoid Open SQL queries in loops, this quality rule is applied for all technologies and not specific to ABAP technology.
- Avoid using SQL queries inside a loop, this quality rule is applied only for ABAP technology.
This delivers redundant information to Dashboard consumers and impacts grades at Technical Criteria level. As a consequence, only one rule should be kept and if both are similar, then we prefer keeping the one for all technologies.
Notes/comments
Ticket # 5711
Related Pages