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
