Debian Codegraph @

mysql-test/suite/innodb/r/innodb-consistent.result

raw
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;