7.3.4
by Oleg Tsarev
1) split patches to test and code. |
1 |
# Establish connection con1 (user=root)
|
2 |
# Establish connection con2 (user=root)
|
|
3 |
# Establish connection con3 (user=root)
|
|
4 |
# Drop test table
|
|
5 |
drop table if exists t;
|
|
6 |
# Create test table
|
|
7 |
create table t(a INT PRIMARY KEY, b INT) engine=InnoDB;
|
|
8 |
# Insert two rows to test table
|
|
9 |
insert into t values(2,1);
|
|
10 |
insert into t values(1,2);
|
|
11 |
# Switch to connection con1
|
|
12 |
BEGIN;
|
|
13 |
SELECT b FROM t WHERE a=1 FOR UPDATE;
|
|
14 |
b
|
|
15 |
2
|
|
16 |
# Switch to connection con2
|
|
17 |
BEGIN;
|
|
18 |
SELECT b FROM t WHERE a=2 FOR UPDATE;
|
|
19 |
b
|
|
20 |
1
|
|
21 |
# Switch to connection con1
|
|
22 |
SELECT b FROM t WHERE a=2 FOR UPDATE;
|
|
23 |
# Switch to connection con2
|
|
24 |
SELECT b FROM t WHERE a=1 FOR UPDATE;
|
|
25 |
# Switch to connection con3
|
|
14
by Oleg Tsarev
fix test for deadlock count |
26 |
1
|
15
by Oleg Tsarev
fix deadlock tests |
27 |
# Drop test table
|
31.1.1
by Oleg Tsarev
fix incorrect test for percona_innodb_deadlock_count |
28 |
drop table t;
|