Executing a query with a NULL in the WHERE filter should be avoided
A source code analyzer
Brought to you by:
adangel,
juansotuyo
Hi,
Could anyone plaese help me write a custome rule in Java for SonarQube for the following:
Executing a query with a NULL in a WHERE filter makes it unlikely that indexing will be applied. Such queries often scan the entire database to find appropriate records. Design the data model not to rely on NULLs as valid field values.
Thank you.