Code Inspection: Insertion into generated columns
Reports INSERT statements that assign values to generated columns. Generated columns can be read, but their values can not be directly written.
Example (PostgreSQL):
CREATE TABLE foo
(
col1 INT,
col2 INT GENERATED ALWAYS AS (col1 + 1) STORED
);
INSERT INTO foo(col1, col2) VALUES (1, 2);
You cannot insert 2
into the col2
column because this column is generated. For this script to work, you can change 2
to DEFAULT.
INSERT INTO foo(col1, col2) VALUES (1, DEFAULT);
Suppress an inspection in the editor
Position 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