Code Inspections in SQL
This topic lists all GoLand code inspections available in SQL.
You can toggle specific inspections or change their severity level on the Editor | Inspections page of the Settings/Preferences Ctrl+Alt+S.
Inspection | Description | Default Severity |
---|---|---|
Adding not null column without default value | Necessary to specify the default value for the new column with not null constraint. | Warning |
Aggregate-related problems | This inspection reports incorrect or suspicious usages of SQL aggregate functions. | Warning |
Ambiguous reference | This inspection checks that column reference resolves to a single column. | Warning |
Auto-increment duplicate | This inspection checks | Warning |
Check using clause columns | This inspection checks that columns inside using clause exist in both tables. | Warning |
Column should be in group by clause | This inspection checks that column should be in group by clause or inside aggregate function call. | Warning |
Constant condition | Reports those conditions in the where or join clauses that are always | Warning |
Current console schema introspected | Warns if current session's schema/database is not introspected. | Warning |
Delete or update statement without where clauses | Reports usages of 'delete' or 'update' statements without any 'where' clauses. When used without 'where' clauses, 'delete' drops all the data from the table, and 'update' overwrites values for all table rows. | Warning |
Deprecated type | Since 8.0 the 'long' type is deprecated and not recommended to use (because API for this type doesn't utilize character streams but transfer whole values each time). In Oracle, do not create a table with LONG columns. Use LOB columns (CLOB, NCLOB, BLOB) instead. LONG columns are supported only for backward compatibility. | Warning |
Duplicating column name in SELECT | This inspection finds duplicating alias names for columns in SELECT output list. | Warning |
Each derived table should have alias | This inspection checks that each derived table should have own alias. | Warning |
Erroneous usages of ORDER BY in SQL Server queries | This inspection reports erroneous usages of ORDER BY clauses in SQL Server queries | Error |
Excessively long identifiers | This inspection reports identifiers which are considered too long in a particular DBMS | Error |
Function signature | This inspection performs function signature check. | Warning |
Identifier should be quoted | This inspection performs SQL identifier names check. | Warning |
Ill-formed date/time literals | This inspection reports errors in SQL date/time literals. | Warning |
Illegal cursor state | This inspection reports illegal cursor states inside SQL routines. | Warning |
Implicit string truncation | Detects variable assignments which involve implicit string truncation | Warning |
Index is dependent on column | This inspection checks dropping indexed columns in MS SQL and Sybase SQL Server. | Warning |
Insert NULL into NOT NULL column | This inspection reports insertions of NULL into NOT NULL columns. | Warning |
Insertion into generated columns | This inspection reports INSERT statements which assign values to generated columns | Warning |
LOAD statement path | Reports paths started with the tilde character in the | Warning |
Misleading references | This inspection reports potentially misleading references in SQL code | Warning |
Missing column aliases | This inspection reports queries without explicit aliases for output expressions other than column references. | Disabled |
Missing return statement | This inspection reports functions with missing return statements. | Error |
Multiple row limiting/offset clauses in queries | This inspection reports queries with multiple row limiting/offset clauses. | Warning |
MySQL: Syntax | Provides diagnostic of MySQL parser idiosyncrasies. | Warning |
Named arguments should be used | This inspection reports routine calls without named arguments | Disabled |
No data sources configured | Prompts one to create a data source if there is none. | Warning |
Null comparison | This inspection checks suspicious comparisons with NULL. | Warning |
Postgres: Select from procedure call | Select from | Warning |
Redundant ELSE NULL clause | This inspection reports redundant ELSE NULL clauses in CASE expressions. | Warning |
Redundant alias expressions | This inspection reports redundant alias expressions | Warning |
Redundant code in COALESCE call | This inspection reports redundant code inside COALESCE calls. | Warning |
Redundant ordering direction | This inspection reports redundant ordering direction in ORDER BY clauses. | Warning |
Redundant row limiting in queries | This inspection reports redundant row limiting in queries. | Warning |
SQL dialect detection | Detects the best matching SQL dialect for files in <Generic> dialect. | Warning |
SQL error handling | Highlights invalid usages of constructs that handle exceptions in SQL routines | Error |
SQL source modification detection | Detects that database sources have changed. | Warning |
Statement with side effects | This inspection only runs during a read-only connection and reports statements that may lead to modification of the database. | Warning |
Suspicious code in triggers | This inspection reports incorrect usages of transition table variables in triggers | Warning |
Suspicious or incorrect usages of built-in functions | This inspection reports suspicious or incorrect use cases of SQL Server built-in functions | Warning |
Types compatibility | This inspection performs type-related check. | Warning |
Unicode usage in SQL | This inspection reports string literals with national characters but lacking N prefix. | Warning |
Unreachable code | This inspection reports unreachable statements inside SQL routines. | Warning |
Unresolved reference | This inspection performs unresolved SQL references check. | Error |
Unsafe 'join' clause in 'delete' statement | Reports usages of 'join' clause inside a 'delete' statement where no 'on' or 'where' checks are present. Without conditional checks on 'join', 'delete' drops contents of the entire table. | Warning |
Unused common table expression | This inspection reports unused common table expression inside SQL. | Warning |
Unused subquery item | This inspection reports unused subquery items: columns and aliases that are not referenced in the outer query expression | Warning |
Unused variable | This inspection performs unused argument/variable check. | Warning |
Usages of GOTO statements | This inspection reports usages of a GOTO statement | Disabled |
Use of transaction management statements in triggers | This inspection reports usages of transaction management statements like COMMIT or ROLLBACK in trigger bodies | Warning |
Using CASE instead of COALESCE function and vice versa | This inspection reports CASE expressions which can be replaced with COALESCE calls or vice versa depending on the chosen preferences | Warning |
Using CASE instead of conditional function and vice versa | This inspection reports CASE expressions which can be replaced with IF-like function calls or vice versa depending on the chosen preferences | Warning |
VALUES clause cardinality | This inspection checks that the number of VALUES (...) parameters matches target table column list size. | Warning |