My apologies, I was accessing the wrong database :(
Thanks.
Staffan
On Fri, Nov 28, 2014 at 12:29 PM, Clemens Ladisch
wrote:
> Staffan Tylen wrote:
> > I've just found out that the column data returned by PRAGMA table_info
> does
> > not include columns added using ALTER COLUMN ADD COLUMN.
>
Staffan Tylen wrote:
> I've just found out that the column data returned by PRAGMA table_info does
> not include columns added using ALTER COLUMN ADD COLUMN.
sqlite> create table t(x);
sqlite> pragma table_info(t);
0|x||0||0
sqlite> alter table t add y;
sqlite> pragma table_info(t);
0|x||0||0
1|y|
I've just found out that the column data returned by PRAGMA table_info does
not include columns added using ALTER COLUMN ADD COLUMN. I guess this is
either a bug or the documentation is incomplete. If it's a bug I would
welcome a fix. If on the other hand it's 'by design', what method is
recommende
3 matches
Mail list logo