SQLite Forum

Serious problems with STORED columns
Login
>This is how computed columns work. You do not want a computed column, you want a default:

Regardless of my example, and how one may avoid this issue by not using a stored column, the problem is real when using one.

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.

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