[sqlite] CREATE TABLE AS SELECT * FROM changes column definition -- bug or feature?

SQLite version 3.6.11 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE TABLE foo (id INTEGER PRIMARY KEY, desc TEXT, num INTEGER DEFAULT 0); sqlite> INSERT INTO foo (desc) VALUES ('foo'); sqlite> INSERT INTO foo (desc) VALUES ('bar'); sqlite> INSERT INTO foo

Re: [sqlite] CREATE TABLE AS SELECT * FROM changes column definition --bug or feature?

P Kishor wrote: > SQLite version 3.6.11 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> CREATE TABLE foo (id INTEGER PRIMARY KEY, desc TEXT, num > INTEGER DEFAULT 0); > sqlite> INSERT INTO foo (desc) VALUES ('foo'); > sqlite> INSERT INTO foo (desc) VALUES ('b

Re: [sqlite] CREATE TABLE AS SELECT * FROM changes column definition --bug or feature?

On Sun, Aug 2, 2009 at 10:39 PM, Igor Tandetnik wrote: > P Kishor wrote: >> SQLite version 3.6.11 >> Enter ".help" for instructions >> Enter SQL statements terminated with a ";" >> sqlite> CREATE TABLE foo (id INTEGER PRIMARY KEY, desc TEXT, num >> INTEGER DEFAULT 0); >> sqlite> INSERT INTO foo (de