DataGrip 2021.2 Help

Code Inspection: Redundant alias expressions

Reports alias expressions that duplicate names of columns in tables and might be redundant.

Example (PostgreSQL):

CREATE TABLE foo(a INT, b INT); SELECT * FROM foo foo(a, b); SELECT * FROM foo foo(a); SELECT * FROM foo foo(x); SELECT * FROM foo foo(x, y);


The first two aliases use the same column names as in the foo table. They are considered redundant because they column names are identical.

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: 16 July 2021