Debian Codegraph @

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

raw
1 DROP TABLE IF EXISTS t1;
2 connect con1,localhost,root,,;
3 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
4 connect con2,localhost,root,,;
5 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
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 # WARNING: Statement ended with errno 0, errname ''.
28 # If it differs from the result file, it might indicate a problem.
29 SELECT a FROM t1;
30 a
31 connection con2;
32 SELECT a FROM t1;
33 a
34 1
35 2
36 COMMIT;
37 SELECT a FROM t1;
38 a
39 1
40 2
41 connection con1;
42 SELECT a FROM t1;
43 a
44 1
45 2
46 INSERT INTO t1 (a) SELECT a+200 FROM t1;
47 # WARNING: Statement ended with errno 0, errname ''.
48 # If it differs from the result file, it might indicate a problem.
49 SELECT a FROM t1;
50 a
51 1
52 2
53 201
54 202
55 COMMIT;
56 SELECT a FROM t1;
57 a
58 1
59 2
60 201
61 202
62 connection con2;
63 SELECT a FROM t1;
64 a
65 1
66 2
67 201
68 202
69 connection default;
70 disconnect con1;
71 disconnect con2;
72 DROP TABLE t1;
73 DROP TABLE IF EXISTS t1;
74 connect con1,localhost,root,,;
75 connect con2,localhost,root,,;
76 connection con1;
77 CREATE TABLE t1 (a <INT_COLUMN>) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>;
78 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
79 START TRANSACTION WITH CONSISTENT SNAPSHOT;
80 connection con2;
81 INSERT INTO t1 (a) VALUES (1);
82 connection con1;
83 # If consistent read works on this isolation level (READ COMMITTED), the following SELECT should not return the value we inserted (1)
84 SELECT a FROM t1;
85 a
86 1
87 COMMIT;
88 connection default;
89 disconnect con1;
90 disconnect con2;
91 DROP TABLE t1;