Code Inspection: Redundant ELSE NULL clause
Configure inspections: Settings | Editor | Inspections
Show intention actions: AltEnter
Reports redundant ELSE NULL clauses.
Example (MySQL):
SELECT CASE WHEN 2 > 1 THEN 'OK' ELSE NULL END AS alias FROM foo;
The ELSE NULL
part will never be executed and may be omitted.
Place the caret at the highlighted line and press AltEnter or click
.
Click the arrow next to the inspection you want to suppress and select the necessary suppress action.