Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_log_innodb.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=InnoDB;
7 insert into t1 values (NULL);
8 drop table t1;
9 create table t1 (word char(20) not null)ENGINE=InnoDB;
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=InnoDB
17 master-bin.000001 # Query # # BEGIN
18 master-bin.000001 # Table_map # # table_id: # (test.t1)
19 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
20 master-bin.000001 # Xid # # COMMIT /* XID */
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=InnoDB
23 master-bin.000001 # Query # # BEGIN
24 master-bin.000001 # Table_map # # table_id: # (test.t1)
25 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
26 master-bin.000001 # Xid # # COMMIT /* XID */
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=InnoDB
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 # Table_map # # table_id: # (test.t1)
34 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
35 master-bin.000001 # Xid # # COMMIT /* XID */
36 flush logs;
37 create table t3 (a int)ENGINE=InnoDB;
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=InnoDB;
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=InnoDB
189 master-bin.000001 # Query # # BEGIN
190 master-bin.000001 # Table_map # # table_id: # (test.t1)
191 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
192 master-bin.000001 # Xid # # COMMIT /* XID */
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=InnoDB
195 master-bin.000001 # Query # # BEGIN
196 master-bin.000001 # Table_map # # table_id: # (test.t1)
197 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
198 master-bin.000001 # Xid # # COMMIT /* XID */
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=InnoDB
203 master-bin.000002 # Query # # use `test`; create table t2 (n int)ENGINE=InnoDB
204 master-bin.000002 # Query # # BEGIN
205 master-bin.000002 # Table_map # # table_id: # (test.t2)
206 master-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
207 master-bin.000002 # Xid # # COMMIT /* XID */
208 show binary logs;
209 Log_name File_size Encrypted
210 master-bin.000001 # #
211 master-bin.000002 # #
212 include/sync_slave_sql_with_master.inc
213 show binary logs;
214 Log_name File_size Encrypted
215 slave-bin.000001 # #
216 slave-bin.000002 # #
217 include/show_binlog_events.inc
218 Log_name Pos Event_type Server_id End_log_pos Info
219 slave-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=InnoDB
220 slave-bin.000001 # Query # # BEGIN
221 slave-bin.000001 # Table_map # # table_id: # (test.t1)
222 slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
223 slave-bin.000001 # Xid # # COMMIT /* XID */
224 slave-bin.000001 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
225 slave-bin.000001 # Query # # use `test`; create table t1 (word char(20) not null)ENGINE=InnoDB
226 slave-bin.000001 # Query # # BEGIN
227 slave-bin.000001 # Table_map # # table_id: # (test.t1)
228 slave-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
229 slave-bin.000001 # Xid # # COMMIT /* XID */
230 slave-bin.000001 # Query # # use `test`; create table t3 (a int)ENGINE=InnoDB
231 slave-bin.000001 # Rotate # # slave-bin.000002;pos=POS
232 include/show_binlog_events.inc
233 Log_name Pos Event_type Server_id End_log_pos Info
234 slave-bin.000002 # Query # # use `test`; create table t2 (n int)ENGINE=InnoDB
235 slave-bin.000002 # Query # # BEGIN
236 slave-bin.000002 # Table_map # # table_id: # (test.t2)
237 slave-bin.000002 # Write_rows # # table_id: # flags: STMT_END_F
238 slave-bin.000002 # Xid # # COMMIT /* XID */
239 include/check_slave_is_running.inc
240 show binlog events in 'slave-bin.000005' from 4;
241 ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log
242 DROP TABLE t1;
243 DROP TABLE t2;
244 DROP TABLE t3;
245 include/rpl_reset.inc
246 create table t1(a int auto_increment primary key, b int);
247 insert into t1 values (NULL, 1);
248 set insert_id=5;
249 insert into t1 values (NULL, last_insert_id()), (NULL, last_insert_id());
250 include/show_binlog_events.inc
251 Log_name Pos Event_type Server_id End_log_pos Info
252 master-bin.000001 # Query # # use `test`; create table t1(a int auto_increment primary key, b int)
253 master-bin.000001 # Query # # BEGIN
254 master-bin.000001 # Table_map # # table_id: # (test.t1)
255 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
256 master-bin.000001 # Xid # # COMMIT /* XID */
257 master-bin.000001 # Query # # BEGIN
258 master-bin.000001 # Table_map # # table_id: # (test.t1)
259 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
260 master-bin.000001 # Xid # # COMMIT /* XID */
261 select * from t1;
262 a b
263 1 1
264 5 1
265 6 1
266 drop table t1;
267 include/sync_slave_sql_with_master.inc
268 include/rpl_end.inc