Code Inspection: Unused subquery item
Reports columns, aliases, and other subquery items that are not referenced in the outer query expression.
CREATE TABLE for_subquery(id INT); SELECT a, q FROM (SELECT 1 AS a, 10 AS b, 2 + 3 AS q, id FROM for_subquery) x;
q aliases from a subquery. But the
b alias and the
id column are not referenced in the outer SELECT statement. Therefore,
id are grayed out.
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: 13 May 2022