Debian Codegraph @

mysql-test/suite/binlog_nogtid/r/binlog_xa_gtid_consistency_violation.result

raw
1 include/only_with_option.inc [GLOBAL.xa_detach_on_prepare = 0]
2 include/rpl_set_gtid_mode.inc [OFF on servers 1]
3 [connection default]
4 # 1) start with GTID_NEXT to 'AUTOMATIC' and
5 # and then change to 'ANONYMOUS'
6 #
7 # 1.a) Create transaction, create temporary
8 # table, end transaction with XA PREPARE
9 # and XA COMMIT
10 #
11 SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
12 XA START 'trx1';
13 CREATE TEMPORARY TABLE temp_table_1 (a INT);
14 XA END 'trx1';
15 XA PREPARE 'trx1';
16 SET @@SESSION.GTID_NEXT = 'ANONYMOUS';
17 [connection verify]
18 include/assert.inc [There are no AUTOMATIC violating transactions]
19 include/assert.inc [There are no ANONYMOUS violating transactions]
20 [connection default]
21 XA COMMIT 'trx1';
22 DROP TEMPORARY TABLE IF EXISTS temp_table_1;
23 # 1.b) Create transaction, create temporary
24 # table, end transaction with XA PREPARE
25 # and XA ROLLBACK
26 #
27 SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
28 XA START 'trx1';
29 CREATE TEMPORARY TABLE temp_table_1 (a INT);
30 XA END 'trx1';
31 XA PREPARE 'trx1';
32 SET @@SESSION.GTID_NEXT = 'ANONYMOUS';
33 [connection verify]
34 include/assert.inc [There are no AUTOMATIC violating transactions]
35 include/assert.inc [There are no ANONYMOUS violating transactions]
36 [connection default]
37 XA ROLLBACK 'trx1';
38 Warnings:
39 Warning 1751 The creation of some temporary tables could not be rolled back.
40 DROP TEMPORARY TABLE IF EXISTS temp_table_1;
41 # 1.c) Create transaction, create temporary
42 # table, end transaction with XA COMMIT
43 # ONE PHASE
44 #
45 SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
46 XA START 'trx1';
47 CREATE TEMPORARY TABLE temp_table_1 (a INT);
48 XA END 'trx1';
49 XA COMMIT 'trx1' ONE PHASE;
50 SET @@SESSION.GTID_NEXT = 'ANONYMOUS';
51 [connection verify]
52 include/assert.inc [There are no AUTOMATIC violating transactions]
53 include/assert.inc [There are no ANONYMOUS violating transactions]
54 [connection default]
55 DROP TEMPORARY TABLE IF EXISTS temp_table_1;
56 [connection default]
57 # 2) start with GTID_NEXT to 'ANONYMOUS' and
58 # and then change to 'AUTOMATIC'
59 #
60 # 2.a) Create transaction, create temporary
61 # table, end transaction with XA PREPARE
62 # and XA COMMIT
63 #
64 SET @@SESSION.GTID_NEXT = 'ANONYMOUS';
65 XA START 'trx1';
66 CREATE TEMPORARY TABLE temp_table_1 (a INT);
67 XA END 'trx1';
68 XA PREPARE 'trx1';
69 SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
70 [connection verify]
71 include/assert.inc [There are no AUTOMATIC violating transactions]
72 include/assert.inc [There are no ANONYMOUS violating transactions]
73 [connection default]
74 XA COMMIT 'trx1';
75 DROP TEMPORARY TABLE IF EXISTS temp_table_1;
76 # 2.b) Create transaction, create temporary
77 # table, end transaction with XA PREPARE
78 # and XA ROLLBACK
79 #
80 SET @@SESSION.GTID_NEXT = 'ANONYMOUS';
81 XA START 'trx1';
82 CREATE TEMPORARY TABLE temp_table_1 (a INT);
83 XA END 'trx1';
84 XA PREPARE 'trx1';
85 SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
86 [connection verify]
87 include/assert.inc [There are no AUTOMATIC violating transactions]
88 include/assert.inc [There are no ANONYMOUS violating transactions]
89 [connection default]
90 XA ROLLBACK 'trx1';
91 Warnings:
92 Warning 1751 The creation of some temporary tables could not be rolled back.
93 DROP TEMPORARY TABLE IF EXISTS temp_table_1;
94 # 2.c) Create transaction, create temporary
95 # table, end transaction with XA COMMIT
96 # ONE PHASE
97 #
98 SET @@SESSION.GTID_NEXT = 'ANONYMOUS';
99 XA START 'trx1';
100 CREATE TEMPORARY TABLE temp_table_1 (a INT);
101 XA END 'trx1';
102 XA COMMIT 'trx1' ONE PHASE;
103 SET @@SESSION.GTID_NEXT = 'AUTOMATIC';
104 [connection verify]
105 include/assert.inc [There are no AUTOMATIC violating transactions]
106 include/assert.inc [There are no ANONYMOUS violating transactions]
107 [connection default]
108 DROP TEMPORARY TABLE IF EXISTS temp_table_1;