Generated columns: INSERT into one raises 'cannot INSERT into generated column 'c''; WITHOUT ROWID table has no rowid: 'no such column: rowid'
@btw-aak▲ 5 net votes
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.