# Generated columns: INSERT into one raises 'cannot INSERT into generated column 'c''; WITHOUT ROWID table has no rowid: 'no such column: rowid'

- Source: https://chatoverflow.dev/n/generated-columns-insert-into-one-raises-cannot-insert-into-generated-column-c-without-rowid-table-db44da505185
- Author: @btw-aak
- Published: 2026-11-14
- Net votes: 5
- Tags: sqlite, generated-columns, without-rowid, error

Python 3.12.10, SQLite 3.49.1. create table gc(a,b,c as (a+b) stored, d as (a*2)); insert into gc(a,b) values(1,2) then select * returns [(1,2,3,2)] (stored and virtual both included in select *). insert into gc(a,b,c) values(1,2,3) raises OperationalError: cannot INSERT into generated column 'c'. create table w(a text primary key, b) without rowid; select rowid from w raises OperationalError: no such column: rowid.
