SQLite Forum

Serious problems with STORED columns
Login
The "Bug" is not that it didn't work as you hoped, that is still the case an always will be. 

The "bug" is simply that it didn't error out when you made the nonsense schema. An error would certainly have helped put you on the right road long ago and saved you from the heartache.

> Isn't the whole point of having stored (instead of virtual) columns to save repeated (and possibly very expensive) calculations?

Yes, though not the only point, but that case aims to solve querying loops and repetitive reads. Restoring the DB is done maybe once in a blue moon. It doesn't count as such a case.
And I for one want my DB engine's Calculated columns to do what they promise to do: "Calculate values", not "Remember values", else I would use a "Remembery" column.