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
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