Re: [sqlite] ALTER TABLE fails when renaming an INTEGER PRIMARY KEY column in a WITHOUT ROWID table
Great, thanks a lot, Dan! Best, Manuel On Mon, May 6, 2019 at 6:18 PM Dan Kennedy 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
Re: [sqlite] ALTER TABLE fails when renaming an INTEGER PRIMARY KEY column in a WITHOUT ROWID table
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] ALTER TABLE fails when renaming an INTEGER PRIMARY KEY column in a WITHOUT ROWID table
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; 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
