Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 connect con1,localhost,root,,;
3 SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE;
4 connect con2,localhost,root,,;
5 SET SESSION TRANSACTION ISOLATION LEVEL SERIALIZABLE;
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 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
15 # WARNING: Statement ended with errno 1205, errname 'ER_LOCK_WAIT_TIMEOUT'.
16 # If it differs from the result file, it might indicate a problem.
17 connection con1;
18 SELECT a FROM t1;
19 a
20 connection con2;
21 INSERT INTO t1 (a) VALUES (2);
22 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
23 # WARNING: Statement ended with errno 1205, errname 'ER_LOCK_WAIT_TIMEOUT'.
24 # If it differs from the result file, it might indicate a problem.
25 connection con1;
26 SELECT a FROM t1;
27 a
28 INSERT INTO t1 (a) SELECT a+100 FROM t1;
29 # WARNING: Statement ended with errno 0, errname ''.
30 # If it differs from the result file, it might indicate a problem.
31 SELECT a FROM t1;
32 a
33 connection con2;
34 SELECT a FROM t1;
35 a
36 COMMIT;
37 SELECT a FROM t1;
38 a
39 connection con1;
40 SELECT a FROM t1;
41 a
42 INSERT INTO t1 (a) SELECT a+200 FROM t1;
43 # WARNING: Statement ended with errno 0, errname ''.
44 # If it differs from the result file, it might indicate a problem.
45 SELECT a FROM t1;
46 a
47 COMMIT;
48 SELECT a FROM t1;
49 a
50 connection con2;
51 SELECT a FROM t1;
52 a
53 connection default;
54 disconnect con1;
55 disconnect con2;
56 DROP TABLE t1;