|
1008.3.28
by Stewart Smith
add test for ALTER column DROP DEFAULT. Improves sql_yacc.yy code coverage (among other places) |
1 |
CREATE TABLE t1 (a int NOT NULL default 42);
|
2 |
INSERT INTO t1 values ();
|
|
3 |
SELECT * FROM t1;
|
|
4 |
ALTER TABLE t1 ALTER COLUMN a DROP DEFAULT;
|
|
|
1731.3.1
by Lee Bieber
change tests to use enum values instead of error numbers |
5 |
--error ER_NO_DEFAULT_FOR_FIELD
|
|
1008.3.28
by Stewart Smith
add test for ALTER column DROP DEFAULT. Improves sql_yacc.yy code coverage (among other places) |
6 |
INSERT INTO t1 values ();
|
7 |
INSERT INTO t1 (a) VALUES (11);
|
|
8 |
SELECT * FROM t1 ORDER BY a;
|
|
9 |
DROP TABLE t1;
|