G-2150
🆓Error
Avoid comparisons with NULL value, consider using IS [NOT] NULL.
Reason
The null value can cause confusion both from the standpoint of code review and code execution. You must always use the is null or is not null syntax when you need to check if a value is or is not null.
Example
Non-Compliant Example
declare
l_value integer;
begin
if l_value = null then
null;
end if;
end;
/Issues
| Line | Column | Message |
|---|---|---|
| 4 | 7 | Camparing variable l_value with NULL. |
Compliant Solution - ★★★★★
declare
l_value integer;
begin
if l_value is null then
null;
end if;
end;
/References
- same as Trivadis G-2150
- same as plsql:NullComparison
- same as plsqlopen:ComparisonWithNull
- same as SQLFluff convention.is_null