Code Inspection: Statement with side effects
Reports statements that might lead to modification of a database during a read-only connection.
To enable read-only mode for a connection, right-click a data source in the Database tool window (View | Tool Windows | Database) and select Properties. In the Data Sources and Drivers dialog, click the Options tab and select the Read-only checkbox.
Example (MySQL):
CREATE TABLE foo(a INT);
INSERT INTO foo VALUES (1);
As CREATE TABLE and INSERT INTO statements lead to a database modification, these statements will be highlighted in read-only connection mode.
Suppress an inspection in the editor
Place the caret at the highlighted line and press Alt+Enter or click
.Click the arrow next to the inspection you want to suppress and select the necessary suppress action.
Last modified: 13 May 2022