This page gives information about Quality rule Avoid "Select *" queries
Release | Yes/No |
---|---|
8.3.x |
RDBMS | Yes/No |
---|---|
CSS |
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.