~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to storage/innobase/mysql-test/innodb-semi-consistent.test

  • Committer: Monty Taylor
  • Date: 2009-04-14 19:16:51 UTC
  • mto: (997.2.5 mordred)
  • mto: This revision was merged to the branch mainline in revision 994.
  • Revision ID: mordred@inaugust.com-20090414191651-ltbww6hpqks8k7qk
Clarified instructions in README.

Show diffs side-by-side

added added

removed removed

Lines of Context:
53
53
connection default;
54
54
disconnect a;
55
55
disconnect b;
56
 
 
57
 
# Bug 39320
58
 
create table t1 (a int, b int) engine=myisam;
59
 
create table t2 (c int, d int, key (c)) engine=innodb;
60
 
insert into t1 values (1,1);
61
 
insert into t2 values (1,2);
62
 
connect (a,localhost,root,,);
63
 
connection a;
64
 
set session transaction isolation level read committed;
65
 
delete from t1 using t1 join t2 on t1.a = t2.c where t2.d in (1);
66
 
connection default;
67
 
disconnect a;
68
 
drop table t1, t2;