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 <[email protected]> > On Behalf Of Simon Slavin > Sent: Tuesday, October 29, 2019 6:21 AM > To: SQLite mailing list <[email protected]> > 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 <[email protected]> > 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 > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite- > users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
