-
Notifications
You must be signed in to change notification settings - Fork 1
/
mysql-rr.yml
35 lines (35 loc) · 1.02 KB
/
mysql-rr.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
driver: "com.mysql.cj.jdbc.Driver"
initUrl: "jdbc:mysql://192.168.169.132:3306?serverTimezone=UTC&useServerPrepStmts=true&cachePrepStmts=true"
connUrl: "jdbc:mysql://192.168.169.132:3306/reproduceDB?serverTimezone=UTC&useServerPrepStmts=true&cachePrepStmts=true"
user: "root"
password: "root"
create: true
load: true
createDatabaseList:
- "drop database if exists reproduceDB;"
- "create database reproduceDB;"
createTableList:
- "create table t(k int primary key, v int);"
loadList:
- "insert into t values(1, 101);"
operationList:
- trxId: "0"
sql: "set global transaction isolation level REPEATABLE READ;"
- trxId: "0"
sql: "commit;"
- trxId: "1"
sql: "select * from t where k=1;"
- trxId: "2"
sql: "select * from t where k=1;"
- trxId: "1"
sql: "update t set v=201 where k=1;"
- trxId: "1"
sql: "select * from t where k=1;"
- trxId: "2"
sql: "select * from t where k=1;"
- trxId: "1"
sql: "commit;"
- trxId: "2"
sql: "select * from t where k=1;"
- trxId: "2"
sql: "commit;"