Great, thanks a lot, Dan! Best, Manuel
On Mon, May 6, 2019 at 6:18 PM Dan Kennedy <danielk1...@gmail.com> wrote: > > On 6/5/62 16:42, Manuel Rigger wrote: > > Hi everyone, > > > > the following example fails with an error "no such column: c0": > > > > CREATE TABLE t0 (c0 INTEGER, PRIMARY KEY (c0)) WITHOUT ROWID; > > ALTER TABLE t0 RENAME COLUMN c0 TO c1; > > Thanks again for the bug reports. This one is now fixed here: > > https://sqlite.org/src/info/91f701d39852ef1ddb29 > > Dan. > > > > > > > However, specifying c0 as the PRIMARY KEY in the column definition rather > > than in a table constraint seems to work: > > > > CREATE TABLE t0 (c0 INTEGER PRIMARY KEY) WITHOUT ROWID; > > ALTER TABLE t0 RENAME COLUMN c0 TO c1; > > > > Best, > > Manuel > > _______________________________________________ > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users