On 4/4/2012 8:48 PM, Pete wrote:
The test this time was:sqlite> create table t1 (Col1,Col2); sqlite> insert into t1 (Col1) values ('xxx'); sqlite> select * from t1; xxx| sqlite> create table t2 (Col1, col2 not null default 'abc'); sqlite> insert into t2 SELECT * from t1; SQL error: t2.col2 may not be NULL
Default clause applies when you omit a column from the list in INSERT (like you did when inserting into t1). It doesn't apply when you attempt to insert NULL explicitly.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
