Debian Codegraph @

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

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