Debian Codegraph @

mysql-test/suite/storage_engine/trx/level_repeatable_read.result

raw
1 DROP TABLE IF EXISTS t1;
2 connect con1,localhost,root,,;
3 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
4 connect con2,localhost,root,,;
5 SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ;
6 connection con1;
7 CREATE TABLE t1 (a <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
8 START TRANSACTION;
9 SELECT a FROM t1;
10 a
11 connection con2;
12 BEGIN;
13 INSERT INTO t1 (a) VALUES(1);
14 # WARNING: Statement ended with errno 0, errname ''.
15 # If it differs from the result file, it might indicate a problem.
16 connection con1;
17 SELECT a FROM t1;
18 a
19 connection con2;
20 INSERT INTO t1 (a) VALUES (2);
21 # WARNING: Statement ended with errno 0, errname ''.
22 # If it differs from the result file, it might indicate a problem.
23 connection con1;
24 SELECT a FROM t1;
25 a
26 INSERT INTO t1 (a) SELECT a+100 FROM t1;
27 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
28 # WARNING: Statement ended with errno 1205, errname 'ER_LOCK_WAIT_TIMEOUT'.
29 # If it differs from the result file, it might indicate a problem.
30 SELECT a FROM t1;
31 a
32 connection con2;
33 SELECT a FROM t1;
34 a
35 1
36 2
37 COMMIT;
38 SELECT a FROM t1;
39 a
40 1
41 2
42 connection con1;
43 SELECT a FROM t1;
44 a
45 INSERT INTO t1 (a) SELECT a+200 FROM t1;
46 # WARNING: Statement ended with errno 0, errname ''.
47 # If it differs from the result file, it might indicate a problem.
48 SELECT a FROM t1;
49 a
50 201
51 202
52 COMMIT;
53 SELECT a FROM t1;
54 a
55 1
56 2
57 201
58 202
59 connection con2;
60 SELECT a FROM t1;
61 a
62 1
63 2
64 201
65 202
66 connection default;
67 disconnect con1;
68 disconnect con2;
69 DROP TABLE t1;