CREATE TABLE t1 (a int NOT NULL default 42);
INSERT INTO t1 values ();
SELECT * FROM t1;
ALTER TABLE t1 ALTER COLUMN a DROP DEFAULT;
--error ER_NO_DEFAULT_FOR_FIELD
INSERT INTO t1 values ();
INSERT INTO t1 (a) VALUES (11);
SELECT * FROM t1 ORDER BY a;
DROP TABLE t1;
|