JetBrains Rider 2022.2 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.

Inspection

Description

Default 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: 13 May 2022