CAST Engineering Dashboard - Violations - False Violation - Avoid SQL queries with implicit conversions in the WHERE clause

 Violation for quality rule 'Avoid SQL queries with implicit conversions in the WHERE clause' seems to be not correct

You are not expecting a violation for this rule since the source code does not seem to contain implicit conversions in the where clause.

If the code looks like below :

Select T.id 
from Table T 
where T.name = 'example_name';  

T.name = 'example_name' is seen as an implicit conversion from CHAR to VARCHAR ,'example_name'  is identified with a CHAR, provided name is declared as VARCHAR.

Hence it is a normal behavior