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: 11 February 2022