Debian Codegraph @

mysql-test/suite/binlog_gtid/r/binlog_gtid_mix_response_packet.result

raw
1 RESET MASTER;
2 CREATE TABLE t1 (c1 INT) Engine=InnoDB;
3 DROP TABLE t1;
4 set session session_track_gtids='own_gtid';
5 CREATE TABLE t1 (c1 INT) Engine=InnoDB;
6 -- Tracker : SESSION_TRACK_GTIDS
7 -- 00000000-1111-0000-1111-000000000000:3
8
9 INSERT INTO t1 VALUES (1);
10 -- Tracker : SESSION_TRACK_GTIDS
11 -- 00000000-1111-0000-1111-000000000000:4
12
13 set session session_track_gtids='all_gtids';
14 SELECT * FROM t1;
15 c1
16 1
17 -- Tracker : SESSION_TRACK_GTIDS
18 -- 00000000-1111-0000-1111-000000000000:1-4
19
20 DROP TABLE t1;
21 -- Tracker : SESSION_TRACK_GTIDS
22 -- 00000000-1111-0000-1111-000000000000:1-5
23
24 set session session_track_gtids='off';
25 -- Tracker : SESSION_TRACK_GTIDS
26 -- 00000000-1111-0000-1111-000000000000:1-5
27
28 RESET MASTER;
29 SELECT @@server_uuid;
30 @@server_uuid
31 00000000-1111-0000-1111-000000000000
32 SET SESSION SESSION_TRACK_GTIDS=OFF;
33 SET SESSION GTID_NEXT='11111111-AAAA-2222-BBBB-000000000000:1';
34 CREATE TABLE t1 (c1 INT) Engine=InnoDB;
35 SET SESSION GTID_NEXT=AUTOMATIC;
36 SET SESSION SESSION_TRACK_GTIDS=OWN_GTID;
37 SET SESSION GTID_NEXT='11111111-AAAA-2222-BBBB-111111111111:1';
38 CREATE TABLE t2 (c1 INT) Engine=InnoDB;
39 -- Tracker : SESSION_TRACK_GTIDS
40 -- 11111111-aaaa-2222-bbbb-111111111111:1
41
42 SET SESSION GTID_NEXT=AUTOMATIC;
43 SET SESSION SESSION_TRACK_GTIDS=ALL_GTIDS;
44 CREATE TABLE t3 (c1 INT) Engine=InnoDB;
45 -- Tracker : SESSION_TRACK_GTIDS
46 -- 00000000-1111-0000-1111-000000000000:1,
47 11111111-aaaa-2222-bbbb-000000000000:1,
48 11111111-aaaa-2222-bbbb-111111111111:1
49
50 DROP TABLE t1, t2, t3;
51 -- Tracker : SESSION_TRACK_GTIDS
52 -- 00000000-1111-0000-1111-000000000000:1-2,
53 11111111-aaaa-2222-bbbb-000000000000:1,
54 11111111-aaaa-2222-bbbb-111111111111:1
55
56 SET SESSION SESSION_TRACK_GTIDS= OFF;
57 RESET MASTER;
58 SET SESSION SESSION_TRACK_GTIDS=ALL_GTIDS;
59 RESET MASTER;
60 CREATE TABLE t1 (c1 INT) Engine=InnoDB;
61 -- Tracker : SESSION_TRACK_GTIDS
62 -- 00000000-1111-0000-1111-000000000000:1
63
64 BEGIN;
65 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
66 -- T_______
67
68 INSERT INTO t1 VALUES (1);
69 COMMIT;
70 -- Tracker : SESSION_TRACK_GTIDS
71 -- 00000000-1111-0000-1111-000000000000:1-2
72
73 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
74 -- ________
75
76 BEGIN;
77 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
78 -- T_______
79
80 INSERT INTO t1 VALUES (2);
81 CREATE TABLE t2 (c1 INT) Engine=InnoDB;
82 -- Tracker : SESSION_TRACK_GTIDS
83 -- 00000000-1111-0000-1111-000000000000:1-4
84
85 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
86 -- ________
87
88 INSERT INTO t2 VALUES (1);
89 -- Tracker : SESSION_TRACK_GTIDS
90 -- 00000000-1111-0000-1111-000000000000:1-5
91
92 SELECT * FROM t1;
93 c1
94 1
95 2
96 -- Tracker : SESSION_TRACK_GTIDS
97 -- 00000000-1111-0000-1111-000000000000:1-5
98
99 BEGIN;
100 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
101 -- T_______
102
103 INSERT INTO t1 VALUES (2);
104 SAVEPOINT s;
105 INSERT INTO t1 VALUES (3);
106 ROLLBACK TO SAVEPOINT s;
107 ROLLBACK;
108 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
109 -- ________
110
111 DROP TABLE t1, t2;
112 -- Tracker : SESSION_TRACK_GTIDS
113 -- 00000000-1111-0000-1111-000000000000:1-6
114
115 SET SESSION SESSION_TRACK_GTIDS=OWN_GTID;
116 -- Tracker : SESSION_TRACK_GTIDS
117 -- 00000000-1111-0000-1111-000000000000:1-6
118
119 RESET MASTER;
120 CREATE TABLE t1 (c1 INT) Engine=InnoDB;
121 -- Tracker : SESSION_TRACK_GTIDS
122 -- 00000000-1111-0000-1111-000000000000:1
123
124 BEGIN;
125 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
126 -- T_______
127
128 INSERT INTO t1 VALUES (1);
129 COMMIT;
130 -- Tracker : SESSION_TRACK_GTIDS
131 -- 00000000-1111-0000-1111-000000000000:2
132
133 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
134 -- ________
135
136 BEGIN;
137 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
138 -- T_______
139
140 INSERT INTO t1 VALUES (2);
141 CREATE TABLE t2 (c1 INT) Engine=InnoDB;
142 -- Tracker : SESSION_TRACK_GTIDS
143 -- 00000000-1111-0000-1111-000000000000:3-4
144
145 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
146 -- ________
147
148 INSERT INTO t2 VALUES (1);
149 -- Tracker : SESSION_TRACK_GTIDS
150 -- 00000000-1111-0000-1111-000000000000:5
151
152 SELECT * FROM t1;
153 c1
154 1
155 2
156 BEGIN;
157 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
158 -- T_______
159
160 INSERT INTO t1 VALUES (2);
161 SAVEPOINT s;
162 INSERT INTO t1 VALUES (3);
163 ROLLBACK TO SAVEPOINT s;
164 ROLLBACK;
165 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
166 -- ________
167
168 DROP TABLE t1, t2;
169 -- Tracker : SESSION_TRACK_GTIDS
170 -- 00000000-1111-0000-1111-000000000000:6
171
172 SET SESSION SESSION_TRACK_GTIDS=OFF;
173 RESET MASTER;
174 CREATE TABLE t1 (c1 INT) Engine=InnoDB;
175 BEGIN;
176 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
177 -- T_______
178
179 INSERT INTO t1 VALUES (1);
180 COMMIT;
181 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
182 -- ________
183
184 BEGIN;
185 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
186 -- T_______
187
188 INSERT INTO t1 VALUES (2);
189 CREATE TABLE t2 (c1 INT) Engine=InnoDB;
190 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
191 -- ________
192
193 INSERT INTO t2 VALUES (1);
194 SELECT * FROM t1;
195 c1
196 1
197 2
198 BEGIN;
199 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
200 -- T_______
201
202 INSERT INTO t1 VALUES (2);
203 SAVEPOINT s;
204 INSERT INTO t1 VALUES (3);
205 ROLLBACK TO SAVEPOINT s;
206 ROLLBACK;
207 -- Tracker : SESSION_TRACK_TRANSACTION_STATE
208 -- ________
209
210 DROP TABLE t1, t2;