DataGrip 2020.3 Help

Code Inspection: Missing return statement

This inspection reports functions that miss return statements.

For example, consider the following code block for Oracle.

create function foo(n int) return int as begin case when n > 1 then return 1; when n < -1 then return -1; end case; end;

According to the RETURN Clause chapter in the Oracle documentation, the function must return a value. In our example, we must return the int value to have a valid code.

Missing return statement

Suppress an inspection in the editor

  1. Position the caret at the highlighted line and press Alt+Enter or click the Intention action icon.

  2. Click the arrow next to the inspection you want to suppress and select the necessary suppress action.

Last modified: 08 March 2021