Debian Codegraph @

storage/myisam/mysql-test/storage_engine/trx/level_read_committed.rdiff

raw
1 --- suite/storage_engine/trx/level_read_committed.result
2 +++ suite/storage_engine/trx/level_read_committed.reject
3 @@ -1,3 +1,9 @@
4 +# -- WARNING ----------------------------------------------------------------
5 +# According to I_S.ENGINES, MyISAM does not support transactions.
6 +# If it is true, the test will most likely fail; you can
7 +# either create an rdiff file, or add the test to disabled.def.
8 +# If transactions should be supported, check the data in Information Schema.
9 +# ---------------------------------------------------------------------------
10 DROP TABLE IF EXISTS t1;
11 connect con1,localhost,root,,;
12 SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
13 @@ -16,6 +22,7 @@
14 connection con1;
15 SELECT a FROM t1;
16 a
17 +1
18 connection con2;
19 INSERT INTO t1 (a) VALUES (2);
20 # WARNING: Statement ended with errno 0, errname ''.
21 @@ -23,25 +30,37 @@
22 connection con1;
23 SELECT a FROM t1;
24 a
25 +1
26 +2
27 INSERT INTO t1 (a) SELECT a+100 FROM t1;
28 # WARNING: Statement ended with errno 0, errname ''.
29 # If it differs from the result file, it might indicate a problem.
30 SELECT a FROM t1;
31 a
32 +1
33 +101
34 +102
35 +2
36 connection con2;
37 SELECT a FROM t1;
38 a
39 1
40 +101
41 +102
42 2
43 COMMIT;
44 SELECT a FROM t1;
45 a
46 1
47 +101
48 +102
49 2
50 connection con1;
51 SELECT a FROM t1;
52 a
53 1
54 +101
55 +102
56 2
57 INSERT INTO t1 (a) SELECT a+200 FROM t1;
58 # WARNING: Statement ended with errno 0, errname ''.
59 @@ -49,23 +68,35 @@
60 SELECT a FROM t1;
61 a
62 1
63 +101
64 +102
65 2
66 201
67 202
68 +301
69 +302
70 COMMIT;
71 SELECT a FROM t1;
72 a
73 1
74 +101
75 +102
76 2
77 201
78 202
79 +301
80 +302
81 connection con2;
82 SELECT a FROM t1;
83 a
84 1
85 +101
86 +102
87 2
88 201
89 202
90 +301
91 +302
92 connection default;
93 disconnect con1;
94 disconnect con2;