Code Inspection: Redundant code in COALESCE call
Reports all the arguments except for the first expression that does not evaluate to NULL in COALESCE functions.
SELECT COALESCE(NULL, NULL, NULL, 42, NULL, 'string') as a;
The first NOT NULL argument is
42, all other arguments will be grayed out.
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: 13 May 2022