On Wed, Apr 18, 2012 at 01:20:59PM +0000, Black, Michael (IS) scratched on the wall: > default values are during INSERT...not SELECT. >
Unless the table has had a column added with ALTER TABLE. In that case, the column doesn't exist in the on-disk record of the row. The SELECT knows it doesn't have enough columns, so it figure out what the default value for that column should be and silently adds it without altering the original record. -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
