← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/innobase/tests/r/innodb.result

  • 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/innobase/tests/r/innodb.result
422
422
3       4
423
423
4       7
424
424
5       2
425
 
alter table t1 add co3 int not null;
 
425
ALTER TABLE t1 ADD co3 INT DEFAULT 42 NOT NULL;
426
426
select * from t1;
427
427
col1    col2    co3
428
 
1       1       0
429
 
2       3       0
430
 
3       4       0
431
 
4       7       0
432
 
5       2       0
 
428
1       1       42
 
429
2       3       42
 
430
3       4       42
 
431
4       7       42
 
432
5       2       42
433
433
update t1 set col2='9' where col1='2';
434
434
select * from t1;
435
435
col1    col2    co3
436
 
1       1       0
437
 
2       9       0
438
 
3       4       0
439
 
4       7       0
440
 
5       2       0
 
436
1       1       42
 
437
2       9       42
 
438
3       4       42
 
439
4       7       42
 
440
5       2       42
441
441
drop table t1;
442
442
create table t1 (a int not null , b int, primary key (a)) engine = innodb;
443
443
create TEMPORARY table t2 (a int not null , b int, primary key (a)) engine = myisam;