JetBrains Rider 2018.2 Help

Code Inspections in SQL

Inspection

Description

Default Severity

Unresolved reference

This inspection performs unresolved SQL references check.

Warning

Types compatibility

This inspection performs type-related check.

Warning

Unused variable

This inspection performs unused argument/variable check.

Warning

Identifier should be quoted

This inspection performs SQL identifier names check.

Warning

Ambiguous reference

This inspection checks that column reference resolves to a single column

Warning

VALUES clause cardinality

This inspection checks that the number of VALUES (...) parameters matches target table column list size

Warning

SQL dialect detection

Detects the best matching SQL dialect for files in <Generic> dialect.

Warning

SQL source modification detection

Detects that database sources have changed.

Warning

No data sources configured

Prompts one to create a data source if there is none.

Warning

Each derived table should have alias

This inspection checks that each derived table should have own alias.

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

This inspection reports those conditions in the where or join clauses that are always true or false.

Warning

Auto-increment duplicate

This inspection checks auto_increment duplicates in MySQL, MS SQL and DB2 dialect. A table in those dialects can contain only one auto-incrementing field.

Warning

Index is dependent on column

This inspection checks dropping indexed columns in MS SQL and Sybase SQL Server.

Warning

Adding not null column without default value

Necessary to specify the default value for the new column with not null constraint.

Warning

Check using clause columns

This inspection checks that columns inside using clause exist in both tables.

Warning

Null comparison

This inspection checks suspicious comparisons with NULL.

Warning

Function signature

This inspection performs function signature check.

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

MySQL syntax

Provides diagnostic of MySQL parser idiosyncrasies

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

Select from procedure call

Select from dblink or function that returns record require typed alias list.Scalar functions do not require alias and forbid typed alias lists completely.

Warning

Last modified: 28 November 2018