Debian Codegraph @

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

raw
1 --- suite/storage_engine/trx/xa.result
2 +++ suite/storage_engine/trx/xa.reject
3 @@ -1,3 +1,9 @@
4 +# -- WARNING ----------------------------------------------------------------
5 +# According to I_S.ENGINES, MyISAM does not support XA.
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 XA should be supported, check the data in Information Schema.
9 +# ---------------------------------------------------------------------------
10 DROP TABLE IF EXISTS t1;
11 connect con1,localhost,root,,;
12 connect con2,localhost,root,,;
13 @@ -9,17 +15,22 @@
14 connection con1;
15 SELECT a FROM t1;
16 a
17 +1
18 connection con2;
19 INSERT INTO t1 (a) VALUES (2);
20 XA END 'xa1';
21 connection con1;
22 SELECT a FROM t1;
23 a
24 +1
25 +2
26 connection con2;
27 XA PREPARE 'xa1';
28 connection con1;
29 SELECT a FROM t1;
30 a
31 +1
32 +2
33 connection con2;
34 XA RECOVER;
35 formatID gtrid_length bqual_length data
36 @@ -38,6 +49,7 @@
37 a
38 1
39 2
40 +3
41 connection con2;
42 INSERT INTO t1 (a) VALUES (4);
43 XA END 'xa2';
44 @@ -46,6 +58,8 @@
45 a
46 1
47 2
48 +3
49 +4
50 connection con2;
51 XA COMMIT 'xa2' ONE PHASE;
52 connection con1;
53 @@ -65,6 +79,7 @@
54 2
55 3
56 4
57 +5
58 connection con2;
59 INSERT INTO t1 (a) VALUES (6);
60 XA END 'xa3';
61 @@ -75,6 +90,8 @@
62 2
63 3
64 4
65 +5
66 +6
67 connection con2;
68 XA PREPARE 'xa3';
69 connection con1;
70 @@ -84,8 +101,12 @@
71 2
72 3
73 4
74 +5
75 +6
76 connection con2;
77 XA ROLLBACK 'xa3';
78 +Warnings:
79 +Warning 1196 Some non-transactional changed tables couldn't be rolled back
80 connection con1;
81 SELECT a FROM t1;
82 a
83 @@ -93,4 +114,6 @@
84 2
85 3
86 4
87 +5
88 +6
89 DROP TABLE t1;