On 1 Jul 2010, at 2:49pm, Pavel Ivanov wrote: >> This is obviously wrong. The SELECT command from TABLE t could never have >> returned any INT values (because SQLite has no INT datatype). So why was >> TABLE t_copy created with an INT column ? > > Because three letters INT are enough to assign INTEGER affinity to the column.
There is no such datatype as 'INT' in SQLite. No part of SQLite should be declaring /any/ column as having an affinity of 'INT'. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
