Code Inspection: Column is shadowed by alias
Reports SELECT aliases with names that match column names in the FROM clause.
Example (MySQL):
CREATE TABLE foo (a INT, b INT, c INT);
SELECT a b, c FROM foo;
The
a column uses the b alias but the b name is also used by the column from the foo table.Suppress an inspection in the editor
Position the caret at the highlighted line and press Alt+Enter or click
.Click the arrow next to the inspection you want to suppress and select the necessary suppress action.
Last modified: 16 July 2021