When creating a new table, I accidentally assigned a default value of CURRENT_DATE to an INTEGER PRIMARY KEY AUTOINCREMENT field and was surprised that I didn't get an error on CREATE TABLE as a result. It seems that the default is ignored as an INSERT with DEFAULT VALUES assigned the correct value to the primary key field. IS this expected behavior?
-- Pete _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
