|
1008.3.29
by Stewart Smith
add missing result file for: 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 |
a
|
|
5 |
42
|
|
6 |
ALTER TABLE t1 ALTER COLUMN a DROP DEFAULT;
|
|
7 |
INSERT INTO t1 values ();
|
|
8 |
ERROR HY000: Field 'a' doesn't have a default value
|
|
9 |
INSERT INTO t1 (a) VALUES (11);
|
|
10 |
SELECT * FROM t1 ORDER BY a;
|
|
11 |
a
|
|
12 |
11
|
|
13 |
42
|
|
14 |
DROP TABLE t1;
|