On Tue, Jun 29, 2010 at 06:59:18AM -0400, Tim Romano scratched on the wall: > CREATE TABLE "main"."proto" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT > NULL , "name" TEXT) > CREATE TABLE "main"."clone" as select * from PROTO > > The primary key of table CLONE is defined as "INT" not "INTEGER".
The only information preserved by CREATE TABLE ... AS SELECT is the column affinity (not "type"). These are equivalent, and both translate to an INTEGER affinity. ...which actually surprises me, since I was under the impression CREATE TABLE ... AS SELECT always produced NONE affinities. Is this a semi-recent (last year) change? -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users