Code Inspection: Column is shadowed by alias
Configure inspections: Settings | Editor | Inspections
Show intention actions: AltEnter
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.
Place the caret at the highlighted line and press AltEnter or click
.
Click the arrow next to the inspection you want to suppress and select the necessary suppress action.