Code Inspection: Redundant ELSE NULL clause
Reports redundant ELSE NULL clauses.
SELECT CASE WHEN 2 > 1 THEN 'OK' ELSE NULL END AS alias FROM foo;
ELSE NULLpart will never be executed and may be omitted.
Suppress an inspection in the editor
Position the caret at the highlighted line and press Alt+Enter or click .
Click the arrow next to the inspection you want to suppress and select the necessary suppress action.
Last modified: 16 July 2021