Debian Codegraph @

mysql-test/suite/rpl/r/rpl_stm_log.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection slave;
4 include/stop_slave.inc
5 include/wait_for_slave_to_stop.inc
6 reset master;
7 reset slave;
8 start slave;
9 include/wait_for_slave_to_start.inc
10 connection slave;
11 set @save_slave_ddl_exec_mode=@@global.slave_ddl_exec_mode;
12 set @@global.slave_ddl_exec_mode=STRICT;
13 connection master;
14 create table t1(n int not null auto_increment primary key)ENGINE=MyISAM;
15 insert into t1 values (NULL);
16 drop table t1;
17 create table t1 (word char(20) not null)ENGINE=MyISAM;
18 load data infile 'LOAD_FILE' into table t1 ignore 1 lines;
19 select count(*) from t1;
20 count(*)
21 69
22 include/show_binlog_events.inc
23 Log_name Pos Event_type Server_id End_log_pos Info
24 master-bin.000001 # Gtid # # GTID #-#-#
25 master-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
26 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
27 master-bin.000001 # Intvar # # INSERT_ID=1
28 master-bin.000001 # Query # # use `test`; insert into t1 values (NULL)
29 master-bin.000001 # Query # # COMMIT
30 master-bin.000001 # Gtid # # GTID #-#-#
31 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
32 master-bin.000001 # Gtid # # GTID #-#-#
33 master-bin.000001 # Query # # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
34 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
35 master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=#
36 master-bin.000001 # Execute_load_query # # use `test`; LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 1 LINES (`word`) ;file_id=#
37 master-bin.000001 # Query # # COMMIT
38 include/show_binlog_events.inc
39 Log_name Pos Event_type Server_id End_log_pos Info
40 master-bin.000001 # Gtid # # GTID #-#-#
41 master-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
42 include/show_binlog_events.inc
43 Log_name Pos Event_type Server_id End_log_pos Info
44 master-bin.000001 # Gtid # # GTID #-#-#
45 master-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
46 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
47 include/show_binlog_events.inc
48 Log_name Pos Event_type Server_id End_log_pos Info
49 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
50 master-bin.000001 # Intvar # # INSERT_ID=1
51 master-bin.000001 # Query # # use `test`; insert into t1 values (NULL)
52 master-bin.000001 # Query # # COMMIT
53 master-bin.000001 # Gtid # # GTID #-#-#
54 flush logs;
55 create table t3 (a int)ENGINE=MyISAM;
56 connection master;
57 select * from t1 order by 1 asc;
58 word
59 Aarhus
60 Aaron
61 Aaron
62 Ababa
63 Ababa
64 aback
65 aback
66 abaft
67 abaft
68 abandon
69 abandon
70 abandoned
71 abandoned
72 abandoning
73 abandoning
74 abandonment
75 abandonment
76 abandons
77 abandons
78 abase
79 abased
80 abasement
81 abasements
82 abases
83 abash
84 abashed
85 abashes
86 abashing
87 abasing
88 abate
89 abated
90 abatement
91 abatements
92 abater
93 abates
94 abating
95 Abba
96 abbe
97 abbey
98 abbeys
99 abbot
100 abbots
101 Abbott
102 abbreviate
103 abbreviated
104 abbreviates
105 abbreviating
106 abbreviation
107 abbreviations
108 Abby
109 abdomen
110 abdomens
111 abdominal
112 abduct
113 abducted
114 abduction
115 abductions
116 abductor
117 abductors
118 abducts
119 Abe
120 abed
121 Abel
122 Abelian
123 Abelson
124 Aberdeen
125 Abernathy
126 aberrant
127 aberration
128 connection slave;
129 select * from t1 order by 1 asc;
130 word
131 Aarhus
132 Aaron
133 Aaron
134 Ababa
135 Ababa
136 aback
137 aback
138 abaft
139 abaft
140 abandon
141 abandon
142 abandoned
143 abandoned
144 abandoning
145 abandoning
146 abandonment
147 abandonment
148 abandons
149 abandons
150 abase
151 abased
152 abasement
153 abasements
154 abases
155 abash
156 abashed
157 abashes
158 abashing
159 abasing
160 abate
161 abated
162 abatement
163 abatements
164 abater
165 abates
166 abating
167 Abba
168 abbe
169 abbey
170 abbeys
171 abbot
172 abbots
173 Abbott
174 abbreviate
175 abbreviated
176 abbreviates
177 abbreviating
178 abbreviation
179 abbreviations
180 Abby
181 abdomen
182 abdomens
183 abdominal
184 abduct
185 abducted
186 abduction
187 abductions
188 abductor
189 abductors
190 abducts
191 Abe
192 abed
193 Abel
194 Abelian
195 Abelson
196 Aberdeen
197 Abernathy
198 aberrant
199 aberration
200 flush logs;
201 include/stop_slave.inc
202 include/start_slave.inc
203 connection master;
204 create table t2 (n int)ENGINE=MyISAM;
205 insert into t2 values (1);
206 include/show_binlog_events.inc
207 Log_name Pos Event_type Server_id End_log_pos Info
208 master-bin.000001 # Gtid # # GTID #-#-#
209 master-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
210 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
211 master-bin.000001 # Intvar # # INSERT_ID=1
212 master-bin.000001 # Query # # use `test`; insert into t1 values (NULL)
213 master-bin.000001 # Query # # COMMIT
214 master-bin.000001 # Gtid # # GTID #-#-#
215 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
216 master-bin.000001 # Gtid # # GTID #-#-#
217 master-bin.000001 # Query # # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
218 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
219 master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=#
220 master-bin.000001 # Execute_load_query # # use `test`; LOAD DATA INFILE '../../std_data/words.dat' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 1 LINES (`word`) ;file_id=#
221 master-bin.000001 # Query # # COMMIT
222 master-bin.000001 # Rotate # # master-bin.000002;pos=POS
223 include/show_binlog_events.inc
224 Log_name Pos Event_type Server_id End_log_pos Info
225 master-bin.000002 # Gtid # # GTID #-#-#
226 master-bin.000002 # Query # # use `test`; create table t3 (a int)ENGINE=MyISAM
227 master-bin.000002 # Gtid # # GTID #-#-#
228 master-bin.000002 # Query # # use `test`; create table t2 (n int)ENGINE=MyISAM
229 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
230 master-bin.000002 # Query # # use `test`; insert into t2 values (1)
231 master-bin.000002 # Query # # COMMIT
232 show binary logs;
233 Log_name File_size
234 master-bin.000001 #
235 master-bin.000002 #
236 connection slave;
237 show binary logs;
238 Log_name File_size
239 slave-bin.000001 #
240 slave-bin.000002 #
241 include/show_binlog_events.inc
242 Log_name Pos Event_type Server_id End_log_pos Info
243 slave-bin.000001 # Gtid # # GTID #-#-#
244 slave-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
245 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
246 slave-bin.000001 # Intvar # # INSERT_ID=1
247 slave-bin.000001 # Query # # use `test`; insert into t1 values (NULL)
248 slave-bin.000001 # Query # # COMMIT
249 slave-bin.000001 # Gtid # # GTID #-#-#
250 slave-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
251 slave-bin.000001 # Gtid # # GTID #-#-#
252 slave-bin.000001 # Query # # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
253 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
254 slave-bin.000001 # Begin_load_query # # ;file_id=#;block_len=#
255 slave-bin.000001 # Execute_load_query # # use `test`; LOAD DATA INFILE '../../tmp/SQL_LOAD-<SERVER UUID>-<MASTER server-id>-<file-id>.<extension>' INTO TABLE `t1` FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 1 LINES (`word`) ;file_id=#
256 slave-bin.000001 # Query # # COMMIT
257 slave-bin.000001 # Gtid # # GTID #-#-#
258 slave-bin.000001 # Query # # use `test`; create table t3 (a int)ENGINE=MyISAM
259 slave-bin.000001 # Rotate # # slave-bin.000002;pos=POS
260 include/show_binlog_events.inc
261 Log_name Pos Event_type Server_id End_log_pos Info
262 slave-bin.000002 # Gtid # # GTID #-#-#
263 slave-bin.000002 # Query # # use `test`; create table t2 (n int)ENGINE=MyISAM
264 slave-bin.000002 # Gtid # # BEGIN GTID #-#-#
265 slave-bin.000002 # Query # # use `test`; insert into t2 values (1)
266 slave-bin.000002 # Query # # COMMIT
267 include/check_slave_is_running.inc
268 show binlog events in 'slave-bin.000005' from 4;
269 ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log
270 connection master;
271 DROP TABLE t1;
272 DROP TABLE t2;
273 DROP TABLE t3;
274 include/rpl_reset.inc
275 connection master;
276 create table t1(a int auto_increment primary key, b int);
277 insert into t1 values (NULL, 1);
278 set insert_id=5;
279 insert into t1 values (NULL, last_insert_id()), (NULL, last_insert_id());
280 include/show_binlog_events.inc
281 Log_name Pos Event_type Server_id End_log_pos Info
282 master-bin.000001 # Gtid # # GTID #-#-#
283 master-bin.000001 # Query # # use `test`; create table t1(a int auto_increment primary key, b int)
284 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
285 master-bin.000001 # Intvar # # INSERT_ID=1
286 master-bin.000001 # Query # # use `test`; insert into t1 values (NULL, 1)
287 master-bin.000001 # Query # # COMMIT
288 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
289 master-bin.000001 # Intvar # # LAST_INSERT_ID=1
290 master-bin.000001 # Intvar # # INSERT_ID=5
291 master-bin.000001 # Query # # use `test`; insert into t1 values (NULL, last_insert_id()), (NULL, last_insert_id())
292 master-bin.000001 # Query # # COMMIT
293 select * from t1;
294 a b
295 1 1
296 5 1
297 6 1
298 drop table t1;
299 connection slave;
300 set @@global.slave_ddl_exec_mode=@save_slave_ddl_exec_mode;
301 connection master;
302 include/rpl_end.inc