On Thu Sep 25, 2014 at 03:59:55PM -0400, Richard Hipp wrote: > > I will make an effort to clarify this in the documentation.
If you are going to keep this behaviour would it not make more sense to ensure that the table creation fails? The DEFAULT clause is pretty straight-forward and I don't find it intuitive to go looking for PRIMARY KEY documentation when it is ignored. SQLite should either fail to accept the statement or do what the table definition says - anything else means heartache for those debugging problems (which I did for hours on this issue) and those reading the code afterwards. -- Mark Lawrence _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
