Debian Codegraph @

mysql-test/suite/innodb/t/innodb-consistent.test

raw
1
2 --disable_warnings
3 drop table if exists t1;
4 --enable_warnings
5
6 # REPLACE INTO ... SELECT and INSERT INTO ... SELECT should do
7 # a consistent read of the source table.
8
9 connect (a,localhost,root,,);
10 connect (b,localhost,root,,);
11 connection a;
12 set session transaction isolation level read committed;
13 create table t1(a int not null) engine=innodb DEFAULT CHARSET=latin1;
14 create table t2 like t1;
15 insert into t2 values (1),(2),(3),(4),(5),(6),(7);
16 set autocommit=0;
17
18 # REPLACE INTO ... SELECT case
19 begin;
20 # this should not result in any locks on t2.
21 replace into t1 select * from t2;
22
23 connection b;
24 set session transaction isolation level read committed;
25 set autocommit=0;
26 # should not cause a lock wait.
27 delete from t2 where a=5;
28 commit;
29 delete from t2;
30 commit;
31 connection a;
32 commit;
33
34 # INSERT INTO ... SELECT case
35 begin;
36 # this should not result in any locks on t2.
37 insert into t1 select * from t2;
38
39 connection b;
40 set session transaction isolation level read committed;
41 set autocommit=0;
42 # should not cause a lock wait.
43 delete from t2 where a=5;
44 commit;
45 delete from t2;
46 commit;
47 connection a;
48 commit;
49
50 select * from t1;
51 drop table t1;
52 drop table t2;
53
54 connection default;
55 disconnect a;
56 disconnect b;