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.
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