DataGrip
 
Get DataGrip

Code Inspection: Redundant code in COALESCE call

Last modified: 13 May 2022

Reports all the arguments except for the first expression that does not evaluate to NULL in COALESCE functions.

Example (MySQL):

The first NOT NULL argument is 42, all other arguments will be grayed out.