~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/alter_table.test

  • Committer: Andrew Hutchings
  • Date: 2010-09-08 19:03:09 UTC
  • mfrom: (1750 staging)
  • mto: (1750.1.1 build)
  • mto: This revision was merged to the branch mainline in revision 1751.
  • Revision ID: andrew@linuxjedi.co.uk-20100908190309-mya1nu7xvo1fpvk8
Merge trunk into branch

Show diffs side-by-side

added added

removed removed

Lines of Context:
522
522
#create table t1(f1 int);
523
523
#alter table t1 add column f2 datetime not null, add column f21 date not null;
524
524
#insert into t1 values(1,'2000-01-01','2000-01-01');
525
 
#--error 1292
 
525
#--error ER_TRUNCATED_WRONG_VALUE
526
526
#alter table t1 add column f3 datetime not null;
527
 
#--error 1292
 
527
#--error ER_TRUNCATED_WRONG_VALUE
528
528
#alter table t1 add column f3 date not null;
529
 
#--error 1292
 
529
#--error ER_TRUNCATED_WRONG_VALUE
530
530
#alter table t1 add column f4 datetime not null default '2002-02-02',
531
531
#  add column f41 date not null;
532
532
#alter table t1 add column f4 datetime not null default '2002-02-02',