This interesting bug (in latest master) was reported by email:

CREATE TABLE sometable (id INTEGER PRIMARY KEY,
somefield TEXT,
somefield2 INTEGER NOT NULL DEFAULT 6, /*stopped*/
somefield3 TEXT);

"sometable" is created, but when new rows are added they have 0 in the somefield2 column instead of 6.

Tested it myself on newly compiled master, and it's definitely happening there.

Any ideas?