← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/alter_column_drop_default.result

  • Committer: Stewart Smith
  • Date: 2009-05-19 07:48:05 UTC
  • mto: (991.1.9 for-brian)
  • mto: This revision was merged to the branch mainline in revision 1033.
  • Revision ID: stewart@flamingspork.com-20090519074805-n3osbf0o2vluefgf
add missing result file for: add test for ALTER column DROP DEFAULT. Improves sql_yacc.yy code coverage (among other places)

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/alter_column_drop_default.result
 
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;