SQLite Forum

Serious problems with STORED columns
Login
> Unlike a VIRTUAL column that is computed on the fly, a generated STORED column is actual stored data and as such it must survive dumps, i.e., it must be possible to restore to the exact same content it had before a DUMP.

That would be hard, as a dump file just contains DDL and INSERT statements.
And you can't INSERT :
```
insert into log(dt,msg) VALUES ('somestamp','c');
Error: near line ...: cannot INSERT into generated column "dt"
```

> AFAIC, a solution is needed for that.  The current behavior in my eyes is buggy!

A solution is available in the <code>backup</code> interface and the <code>VACUUM INTO</code> statement.