Debian Codegraph @

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

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 create table t1(n int not null auto_increment primary key)ENGINE=MyISAM;
7 insert into t1 values (NULL);
8 drop table t1;
9 create table t1 (word char(20) not null)ENGINE=MyISAM;
10 load data infile 'LOAD_FILE' into table t1 ignore 1 lines;
11 select count(*) from t1;
12 count(*)
13 69
14 include/show_binlog_events.inc
15 Log_name Pos Event_type Server_id End_log_pos Info
16 master-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
17 master-bin.000001 # Query # # BEGIN
18 master-bin.000001 # Intvar # # INSERT_ID=1
19 master-bin.000001 # Query # # use `test`; insert into t1 values (NULL)
20 master-bin.000001 # Query # # COMMIT
21 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
22 master-bin.000001 # Query # # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
23 master-bin.000001 # Query # # BEGIN
24 master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=#
25 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=#
26 master-bin.000001 # Query # # COMMIT
27 include/show_binlog_events.inc
28 Log_name Pos Event_type Server_id End_log_pos Info
29 master-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
30 include/show_binlog_events.inc
31 Log_name Pos Event_type Server_id End_log_pos Info
32 master-bin.000001 # Query # # BEGIN
33 master-bin.000001 # Intvar # # INSERT_ID=1
34 master-bin.000001 # Query # # use `test`; insert into t1 values (NULL)
35 master-bin.000001 # Query # # COMMIT
36 flush logs;
37 create table t3 (a int)ENGINE=MyISAM;
38 select * from t1 order by 1 asc;
39 word
40 Aarhus
41 Aaron
42 Aaron
43 Ababa
44 Ababa
45 aback
46 aback
47 abaft
48 abaft
49 abandon
50 abandon
51 abandoned
52 abandoned
53 abandoning
54 abandoning
55 abandonment
56 abandonment
57 abandons
58 abandons
59 abase
60 abased
61 abasement
62 abasements
63 abases
64 abash
65 abashed
66 abashes
67 abashing
68 abasing
69 abate
70 abated
71 abatement
72 abatements
73 abater
74 abates
75 abating
76 Abba
77 abbe
78 abbey
79 abbeys
80 abbot
81 abbots
82 Abbott
83 abbreviate
84 abbreviated
85 abbreviates
86 abbreviating
87 abbreviation
88 abbreviations
89 Abby
90 abdomen
91 abdomens
92 abdominal
93 abduct
94 abducted
95 abduction
96 abductions
97 abductor
98 abductors
99 abducts
100 Abe
101 abed
102 Abel
103 Abelian
104 Abelson
105 Aberdeen
106 Abernathy
107 aberrant
108 aberration
109 include/sync_slave_sql_with_master.inc
110 select * from t1 order by 1 asc;
111 word
112 Aarhus
113 Aaron
114 Aaron
115 Ababa
116 Ababa
117 aback
118 aback
119 abaft
120 abaft
121 abandon
122 abandon
123 abandoned
124 abandoned
125 abandoning
126 abandoning
127 abandonment
128 abandonment
129 abandons
130 abandons
131 abase
132 abased
133 abasement
134 abasements
135 abases
136 abash
137 abashed
138 abashes
139 abashing
140 abasing
141 abate
142 abated
143 abatement
144 abatements
145 abater
146 abates
147 abating
148 Abba
149 abbe
150 abbey
151 abbeys
152 abbot
153 abbots
154 Abbott
155 abbreviate
156 abbreviated
157 abbreviates
158 abbreviating
159 abbreviation
160 abbreviations
161 Abby
162 abdomen
163 abdomens
164 abdominal
165 abduct
166 abducted
167 abduction
168 abductions
169 abductor
170 abductors
171 abducts
172 Abe
173 abed
174 Abel
175 Abelian
176 Abelson
177 Aberdeen
178 Abernathy
179 aberrant
180 aberration
181 flush logs;
182 include/stop_slave.inc
183 include/start_slave.inc
184 create table t2 (n int)ENGINE=MyISAM;
185 insert into t2 values (1);
186 include/show_binlog_events.inc
187 Log_name Pos Event_type Server_id End_log_pos Info
188 master-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
189 master-bin.000001 # Query # # BEGIN
190 master-bin.000001 # Intvar # # INSERT_ID=1
191 master-bin.000001 # Query # # use `test`; insert into t1 values (NULL)
192 master-bin.000001 # Query # # COMMIT
193 master-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
194 master-bin.000001 # Query # # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
195 master-bin.000001 # Query # # BEGIN
196 master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=#
197 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=#
198 master-bin.000001 # Query # # COMMIT
199 master-bin.000001 # Rotate # # master-bin.000002;pos=POS
200 include/show_binlog_events.inc
201 Log_name Pos Event_type Server_id End_log_pos Info
202 master-bin.000002 # Query # # use `test`; create table t3 (a int)ENGINE=MyISAM
203 master-bin.000002 # Query # # use `test`; create table t2 (n int)ENGINE=MyISAM
204 master-bin.000002 # Query # # BEGIN
205 master-bin.000002 # Query # # use `test`; insert into t2 values (1)
206 master-bin.000002 # Query # # COMMIT
207 show binary logs;
208 Log_name File_size Encrypted
209 master-bin.000001 # #
210 master-bin.000002 # #
211 include/sync_slave_sql_with_master.inc
212 show binary logs;
213 Log_name File_size Encrypted
214 slave-bin.000001 # #
215 slave-bin.000002 # #
216 include/show_binlog_events.inc
217 Log_name Pos Event_type Server_id End_log_pos Info
218 slave-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
219 slave-bin.000001 # Query # # BEGIN
220 slave-bin.000001 # Intvar # # INSERT_ID=1
221 slave-bin.000001 # Query # # use `test`; insert into t1 values (NULL)
222 slave-bin.000001 # Query # # COMMIT
223 slave-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
224 slave-bin.000001 # Query # # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
225 slave-bin.000001 # Query # # BEGIN
226 slave-bin.000001 # Begin_load_query # # ;file_id=#;block_len=#
227 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=#
228 slave-bin.000001 # Query # # COMMIT
229 slave-bin.000001 # Query # # use `test`; create table t3 (a int)ENGINE=MyISAM
230 slave-bin.000001 # Rotate # # slave-bin.000002;pos=POS
231 include/show_binlog_events.inc
232 Log_name Pos Event_type Server_id End_log_pos Info
233 slave-bin.000002 # Query # # use `test`; create table t2 (n int)ENGINE=MyISAM
234 slave-bin.000002 # Query # # BEGIN
235 slave-bin.000002 # Query # # use `test`; insert into t2 values (1)
236 slave-bin.000002 # Query # # COMMIT
237 include/check_slave_is_running.inc
238 show binlog events in 'slave-bin.000005' from 4;
239 ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log
240 DROP TABLE t1;
241 DROP TABLE t2;
242 DROP TABLE t3;
243 include/rpl_reset.inc
244 create table t1(a int auto_increment primary key, b int);
245 insert into t1 values (NULL, 1);
246 set insert_id=5;
247 insert into t1 values (NULL, last_insert_id()), (NULL, last_insert_id());
248 include/show_binlog_events.inc
249 Log_name Pos Event_type Server_id End_log_pos Info
250 master-bin.000001 # Query # # use `test`; create table t1(a int auto_increment primary key, b int)
251 master-bin.000001 # Query # # BEGIN
252 master-bin.000001 # Intvar # # INSERT_ID=1
253 master-bin.000001 # Query # # use `test`; insert into t1 values (NULL, 1)
254 master-bin.000001 # Query # # COMMIT
255 master-bin.000001 # Query # # BEGIN
256 master-bin.000001 # Intvar # # LAST_INSERT_ID=1
257 master-bin.000001 # Intvar # # INSERT_ID=5
258 master-bin.000001 # Query # # use `test`; insert into t1 values (NULL, last_insert_id()), (NULL, last_insert_id())
259 master-bin.000001 # Query # # COMMIT
260 select * from t1;
261 a b
262 1 1
263 5 1
264 6 1
265 drop table t1;
266 include/sync_slave_sql_with_master.inc
267 include/rpl_end.inc