Debian Codegraph @

mysql-test/suite/perfschema/r/transaction_gtid.result

raw
1 include/rpl_init.inc [topology=none]
2 ==== Configure ====
3 SET GLOBAL ENFORCE_GTID_CONSISTENCY = ON;
4 CREATE TABLE t1 (a INT);
5 ==== Test ====
6 ---- Case 1: Specify ANONYMOUS prior to transaction ----
7 * BEGIN ... ROLLBACK
8 - history=none current=none
9 SET SESSION GTID_NEXT = 'ANONYMOUS';
10 BEGIN;
11 INSERT INTO t1 VALUES (1);
12 ROLLBACK;
13 - history=ANONYMOUS current=ANONYMOUS
14 * BEGIN ... COMMIT
15 - history=none current=none
16 SET SESSION GTID_NEXT = 'ANONYMOUS';
17 - history=none current=none
18 [START] BEGIN;
19 - history=none current=AUTOMATIC
20 [END] BEGIN;
21 - history=none current=ANONYMOUS
22 INSERT INTO t1 VALUES (1);
23 - history=none current=ANONYMOUS
24 COMMIT;
25 - history=ANONYMOUS current=ANONYMOUS
26 * AUTOCOMMIT = OFF
27 SET @@SESSION.AUTOCOMMIT = 0;
28 - history=none current=none
29 SET SESSION GTID_NEXT = 'ANONYMOUS';
30 - history=none current=none
31 [START] INSERT INTO t1 VALUES (1);
32 - history=none current=ANONYMOUS
33 [END] INSERT INTO t1 VALUES (1);
34 - history=none current=ANONYMOUS
35 COMMIT;
36 - history=ANONYMOUS current=ANONYMOUS
37 * AUTOCOMMIT = ON
38 SET @@SESSION.AUTOCOMMIT = 1;
39 - history=none current=none
40 SET SESSION GTID_NEXT = 'ANONYMOUS';
41 - history=none current=none
42 [START] INSERT INTO t1 VALUES (1);
43 - history=none current=ANONYMOUS
44 [END] INSERT INTO t1 VALUES (1);
45 - history=ANONYMOUS current=ANONYMOUS
46 ---- Case 2: Generate ANONYMOUS at commit ----
47 * BEGIN ... ROLLBACK
48 - history=none current=none
49 SET SESSION GTID_NEXT = 'AUTOMATIC';
50 BEGIN;
51 INSERT INTO t1 VALUES (2);
52 ROLLBACK;
53 - history=AUTOMATIC current=AUTOMATIC
54 * BEGIN ... COMMIT
55 - history=none current=none
56 SET SESSION GTID_NEXT = 'AUTOMATIC';
57 - history=none current=none
58 [START] BEGIN;
59 - history=none current=AUTOMATIC
60 [END] BEGIN;
61 - history=none current=AUTOMATIC
62 INSERT INTO t1 VALUES (2);
63 - history=none current=AUTOMATIC
64 COMMIT;
65 - history=ANONYMOUS current=ANONYMOUS
66 * AUTOCOMMIT = OFF
67 SET @@SESSION.AUTOCOMMIT = 0;
68 - history=none current=none
69 SET SESSION GTID_NEXT = 'AUTOMATIC';
70 - history=none current=none
71 [START] INSERT INTO t1 VALUES (2);
72 - history=none current=AUTOMATIC
73 [END] INSERT INTO t1 VALUES (2);
74 - history=none current=AUTOMATIC
75 COMMIT;
76 - history=ANONYMOUS current=ANONYMOUS
77 * AUTOCOMMIT = ON
78 SET @@SESSION.AUTOCOMMIT = 1;
79 - history=none current=none
80 SET SESSION GTID_NEXT = 'AUTOMATIC';
81 - history=none current=none
82 [START] INSERT INTO t1 VALUES (2);
83 - history=none current=AUTOMATIC
84 [END] INSERT INTO t1 VALUES (2);
85 - history=ANONYMOUS current=ANONYMOUS
86 include/rpl_set_gtid_mode.inc [ON on servers 1]
87 ---- Case 3: Specify GTID prior to transaction ----
88 * BEGIN ... ROLLBACK
89 - history=none current=none
90 SET SESSION GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
91 BEGIN;
92 INSERT INTO t1 VALUES (3);
93 ROLLBACK;
94 - history=A:1 current=A:1
95 * BEGIN ... COMMIT
96 - history=none current=none
97 SET SESSION GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
98 - history=none current=none
99 [START] BEGIN;
100 - history=none current=AUTOMATIC
101 [END] BEGIN;
102 - history=none current=A:1
103 INSERT INTO t1 VALUES (3);
104 - history=none current=A:1
105 COMMIT;
106 - history=A:1 current=A:1
107 * AUTOCOMMIT = OFF
108 SET @@SESSION.AUTOCOMMIT = 0;
109 - history=none current=none
110 SET SESSION GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
111 - history=none current=none
112 [START] INSERT INTO t1 VALUES (3);
113 - history=none current=A:1
114 [END] INSERT INTO t1 VALUES (3);
115 - history=none current=A:1
116 COMMIT;
117 - history=A:1 current=A:1
118 * AUTOCOMMIT = ON
119 SET @@SESSION.AUTOCOMMIT = 1;
120 - history=none current=none
121 SET SESSION GTID_NEXT = 'aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa:1';
122 - history=none current=none
123 [START] INSERT INTO t1 VALUES (3);
124 - history=none current=A:1
125 [END] INSERT INTO t1 VALUES (3);
126 - history=A:1 current=A:1
127 ---- Case 4: Generate GTID at commit ----
128 * BEGIN ... ROLLBACK
129 - history=none current=none
130 SET SESSION GTID_NEXT = 'AUTOMATIC';
131 BEGIN;
132 INSERT INTO t1 VALUES (4);
133 ROLLBACK;
134 - history=AUTOMATIC current=AUTOMATIC
135 * BEGIN ... COMMIT
136 - history=none current=none
137 SET SESSION GTID_NEXT = 'AUTOMATIC';
138 - history=none current=none
139 [START] BEGIN;
140 - history=none current=AUTOMATIC
141 [END] BEGIN;
142 - history=none current=AUTOMATIC
143 INSERT INTO t1 VALUES (4);
144 - history=none current=AUTOMATIC
145 COMMIT;
146 - history=SERVER_UUID:1 current=SERVER_UUID:1
147 * AUTOCOMMIT = OFF
148 SET @@SESSION.AUTOCOMMIT = 0;
149 - history=none current=none
150 SET SESSION GTID_NEXT = 'AUTOMATIC';
151 - history=none current=none
152 [START] INSERT INTO t1 VALUES (4);
153 - history=none current=AUTOMATIC
154 [END] INSERT INTO t1 VALUES (4);
155 - history=none current=AUTOMATIC
156 COMMIT;
157 - history=SERVER_UUID:1 current=SERVER_UUID:1
158 * AUTOCOMMIT = ON
159 SET @@SESSION.AUTOCOMMIT = 1;
160 - history=none current=none
161 SET SESSION GTID_NEXT = 'AUTOMATIC';
162 - history=none current=none
163 [START] INSERT INTO t1 VALUES (4);
164 - history=none current=AUTOMATIC
165 [END] INSERT INTO t1 VALUES (4);
166 - history=SERVER_UUID:1 current=SERVER_UUID:1
167 ==== Clean up ====
168 DROP TABLE t1;
169 include/rpl_set_gtid_mode.inc [OFF on servers 1]
170 SET GLOBAL ENFORCE_GTID_CONSISTENCY = OFF;
171 include/rpl_end.inc