Code Inspection: Using CASE instead of conditional function and vice versa

Reports situations when CASE and IF are interchangeable.

Example (MySQL):

SELECT CASE
WHEN C1 IS NULL THEN 1
ELSE 0
END
FROM dual;

To keep your code short, you can replace the CASE structure with IF. You can do that by applying the Replace with 'IF' call intention action. The example code will look as follows:

SELECT IF(C1 IS NULL, 1, 0)
FROM dual;

To revert IF to CASE, click IF and apply the Replace with CASE expression intention action.