Purpose

This page gives information about Quality rule  Avoid "Select *" queries

Applicable in CAST Version
Release
Yes/No
8.3.x(tick)
Applicable RDBMS
RDBMS
Yes/No
CSS(tick)
Details

The rule "Avoid "Select *" queries" does not violate if your SQL statement does not contain select *. The rule will not violate any dynamic syntax.

For instance if you have a statement “SELECT t from TABLE t” and you are expecting the rule to be violated then your expectation is wrong because in the syntax "t" can be replaced with any value during the run time, the code changed at runtime is not analysed. The analyzer considers only static code. For the analyzer if there was a " * " in the query instead of " t " only then the violation would have been triggered.
Now since there is no * , the rule will not take into consideration this this dynamic syntax - “SELECT t from TABLE t
This is expected behaviour.

Notes/comments


Related Pages