~drizzle-trunk/drizzle/development

CREATE TABLE t1 (a int NOT NULL default 42);
INSERT INTO t1 values ();
SELECT * FROM t1;
a
42
ALTER TABLE t1 ALTER COLUMN a DROP DEFAULT;
INSERT INTO t1 values ();
ERROR HY000: Field 'a' doesn't have a default value
INSERT INTO t1 (a) VALUES (11);
SELECT * FROM t1 ORDER BY a;
a
11
42
DROP TABLE t1;