DataGrip 2021.2 Help

Code Inspection: Ambiguous reference

Reports columns that have identical names but belong to different tables.

Example (MySQL):

CREATE TABLE foo(id INT PRIMARY KEY); CREATE TABLE bar(id INT PRIMARY KEY); SELECT foo.id, bar.id FROM foo, bar WHERE id > 0;


The id column appears in foo and bar tables. You need to qualify the column name to make the query correct.
SELECT foo.id, bar.id FROM foo, bar WHERE foo.id > 0;

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