Documentation for Generated Columns missing pragma table_xinfo statement
(1) By Vedran (phidrho) on 2022-11-09 15:54:41 [source]
if we run a
t1 is a table with 'Generated Columns' we get list of only ordinary columns, ie generated column(s) are not displayed, even if STORED option is used.
So, there is a need to use
statement to get result that includes all columns - regular and generated (computed) ones.
I think that this behavior should be documented in Generated Columns article, and also in pragma table_xinfo.
(2) By Richard Hipp (drh) on 2022-11-09 20:14:22 in reply to 1 [link] [source]
The documentation has been updated as suggested.