Code Inspection: Using CASE instead of COALESCE function and vice versa
Reports situations when CASE and COALESCE calls are interchangeable. This inspection has the following intention actions: Replace with 'COALESCE' call and the opposite one Replace with CASE expression.
In the example, the CASE statement can be replaced with
SELECT COALESCE(C1, 0)that produces the same output.
If you prefer using CASE expressions, select the Prefer CASE expressions over COALESCE function option on the inspection page.
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.