~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/alter_table.test

  • Committer: Brian Aker
  • Date: 2010-06-08 05:20:09 UTC
  • Revision ID: brian@gaz-20100608052009-mx7m19jknje012yf
datetime was still allowing an alter table with an invalid date.

Show diffs side-by-side

added added

removed removed

Lines of Context:
17
17
alter table t1
18
18
add column col4_5 varchar(20) not null after col4,
19
19
add column col7 varchar(30) not null after col5,
20
 
add column col8 datetime not null, drop column to_be_deleted,
 
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;