Inspectopedia Help

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.

Last modified: 29 April 2024