On Tue, Jun 29, 2010 at 09:51:42AM -0400, Pavel Ivanov scratched on the wall: > > ?...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? > > It looks like the only recent change was a year ago: > http://www.sqlite.org/changes.html#version_3_6_15. > But according to release notes even before that column affinities > should have been preserved...
Yeah, I actually found the specific check-in for this and looked at the diffs. It looks like it has been there, in some form, for some time. I suspect I'm mis-remembering a big discussion from some months ago about why a generated table that uses a numeric expression doesn't have numeric columns, or something like that. -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
