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.
Example (MySQL):
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
Place 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