DataGrip 2021.2 Help

Code Inspection: Unsupported syntax in pre-8.0 versions

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;

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