<https://www.sqlite.org/draft/gencol.html>
OMG. Much welcomed feature.
> • Every table must have at least one non-generated column.
I greatly admire this restriction.
Can I suggest an addition to gencol.html ? An explicit statement saying
whether VIRTUAL and/or STORED columns can be used in CREATE INDEX. In fact
it's such an obvious question it might be useful to have the same note in
lang_createindex.html . Not to mention expridx.html .
On 29 Oct 2019, at 8:44am, Keith Medcalf <kmedc...@dessus.com> wrote:
> Only VIRTUAL columns can be added using ALTER TABLE.
I agree with your criticism but not your suggested alternative, because the
command can be used to add other types of columns. I suggest something like
ALTER TABLE ADD COLUMN cannot be used to add GENERATED ALWAYS … STORED
columns
be used on /both/ pages.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
