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