PhpStorm 2021.2 Help

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

  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