The draft says "Nor may a generated column depend on the ROWID." If my table uses ROWID by default:
CREATE TABLE foo (id INTEGER PRIMARY KEY, a INTEGER, b AS (id+a)); where id is ROWID by default, is the generated column disallowed because it has an implied dependency on ROWID? Doug > -----Original Message----- > From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> > On Behalf Of Simon Slavin > Sent: Tuesday, October 29, 2019 6:21 AM > To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Subject: Re: [sqlite] https://www.sqlite.org/draft/gencol.html > Typo > > <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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
