Code Inspection: Unsupported syntax in pre-8.0 versions
Configure inspections: Settings | Editor | Inspections
Show intention actions: AltEnter
Reports invalid usages of UNION in queries.
The inspection works in MySQL versions that are earlier than 8.0.
Example (MySQL):
SELECT * FROM (SELECT 1 UNION (SELECT 1 UNION SELECT 2)) a;
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.