← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/haildb/tests/t/alter_table.test

  • Committer: Brian Aker
  • Date: 2010-12-07 09:12:12 UTC
  • mto: This revision was merged to the branch mainline in revision 1985.
  • Revision ID: brian@tangent.org-20101207091212-1m0w20tck6z7632m
This is a fix for bug lp:686197

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/haildb/tests/t/alter_table.test
15
15
col6 int not null, to_be_deleted int);
16
16
insert into t1 values (2,4,3,5,"PENDING",1,7);
17
17
alter table t1
18
 
add column col4_5 varchar(20) not null after col4,
19
 
add column col7 varchar(30) not null after col5,
20
 
add column col8 datetime not null default '1000-01-01 00:00:00', drop column to_be_deleted,
 
18
ADD COLUMN col4_5 varchar(20) DEFAULT "cat" not null after col4,
 
19
ADD COLUMN col7 varchar(30) DEFAULT "dog" not null after col5,
 
20
ADD COLUMN col8 datetime not null default '1000-01-01 00:00:00', drop column to_be_deleted,
21
21
change column col2 fourth varchar(30) not null after col3,
22
22
modify column col6 int not null first;
23
23
select * from t1;