← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/innobase/mysql-test/innodb-consistent.result

  • Committer: Brian Aker
  • Date: 2009-10-15 00:22:33 UTC
  • mto: (1183.1.11 merge)
  • mto: This revision was merged to the branch mainline in revision 1198.
  • Revision ID: brian@gaz-20091015002233-fa4ao2mbc67wls91
First pass of information engine. OMG, ponies... is it so much easier to
deal with creating and engine.

The list table iterator though... its ass, needs to go. We should also
abstract out share. Very few engines need a custom one. Just say'in

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/innobase/mysql-test/innodb-consistent.result
1
 
drop table if exists t1;
2
 
set session transaction isolation level read committed;
3
 
create table t1(a int not null) engine=innodb DEFAULT CHARSET=latin1;
4
 
create table t2 like t1;
5
 
insert into t2 values (1),(2),(3),(4),(5),(6),(7);
6
 
set autocommit=0;
7
 
begin;
8
 
replace into t1 select * from t2;
9
 
set session transaction isolation level read committed;
10
 
set autocommit=0;
11
 
delete from t2 where a=5;
12
 
commit;
13
 
delete from t2;
14
 
commit;
15
 
commit;
16
 
begin;
17
 
insert into t1 select * from t2;
18
 
set session transaction isolation level read committed;
19
 
set autocommit=0;
20
 
delete from t2 where a=5;
21
 
commit;
22
 
delete from t2;
23
 
commit;
24
 
commit;
25
 
select * from t1;
26
 
a
27
 
1
28
 
2
29
 
3
30
 
4
31
 
5
32
 
6
33
 
7
34
 
drop table t1;
35
 
drop table t2;