Re: [sqlite] PRAGMA table_info incomplete

2014-11-28 Thread Staffan Tylen
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. >

Re: [sqlite] PRAGMA table_info incomplete

2014-11-28 Thread Clemens Ladisch
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|

[sqlite] PRAGMA table_info incomplete

2014-11-28 Thread Staffan Tylen
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