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. | |
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;
| |
Whitespace between the function name and the open parenthesis | Reports any whitespace in a function call between the function name and the open parenthesis, which is not supported by default. Example (MySQL): SELECT MAX (qty) FROM orders; |
