JetBrains Rider 2021.1 Help

Code Inspections in MySQL

This topic lists all JetBrains Rider code inspections available in MySQL.

You can toggle specific inspections or change their severity level on the Editor | Inspection Settings | Inspection Severity | Other Languages page of the IDE settings Ctrl+Alt+S.

InspectionDescriptionDefault Severity
LOAD statement path

Reports paths that start with the tilde character in LOAD statements.

Example (MySQL):

CREATE TABLE table_name (id int); LOAD DATA LOCAL INFILE '~/Documents/some_file.txt' INTO TABLE table_name FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 LINES;

Instead of the tilde character, use a full path to the file.

Warning Warning
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;

Warning Warning
Last modified: 16 July 2021