~drizzle-trunk/drizzle/development : contents of mysql-test/suite/rpl/r/rpl_stm

~drizzle-trunk/drizzle/development : (revision 33)

stop slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
stop slave;
reset master;
reset slave;
reset master;
create table t1(n int not null auto_increment primary key)ENGINE=MyISAM;
insert into t1 values (NULL);
drop table t1;
create table t1 (word char(20) not null)ENGINE=MyISAM;
load data infile '../std_data_ln/words.dat' into table t1 ignore 1 lines;
select count(*) from t1;
count(*)
69
show binlog events;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000001	#	Query	1	#	use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
master-bin.000001	#	Intvar	1	#	INSERT_ID=1
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values (NULL)
master-bin.000001	#	Query	1	#	use `test`; drop table t1
master-bin.000001	#	Query	1	#	use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
master-bin.000001	#	Begin_load_query	1	#	;file_id=1;block_len=581
master-bin.000001	#	Execute_load_query	1	#	use `test`; load data infile '../std_data_ln/words.dat' into table t1 ignore 1 lines ;file_id=1
show binlog events from 107 limit 1;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	1	#	use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
show binlog events from 107 limit 2;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	1	#	use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
master-bin.000001	#	Intvar	1	#	INSERT_ID=1
show binlog events from 107 limit 2,1;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	1	#	use `test`; insert into t1 values (NULL)
flush logs;
create table t3 (a int)ENGINE=MyISAM;
select * from t1 order by 1 asc;
word
Aarhus
Aaron
Aaron
Ababa
Ababa
aback
aback
abaft
abaft
abandon
abandon
abandoned
abandoned
abandoning
abandoning
abandonment
abandonment
abandons
abandons
abase
abased
abasement
abasements
abases
abash
abashed
abashes
abashing
abasing
abate
abated
abatement
abatements
abater
abates
abating
Abba
abbe
abbey
abbeys
abbot
abbots
Abbott
abbreviate
abbreviated
abbreviates
abbreviating
abbreviation
abbreviations
Abby
abdomen
abdomens
abdominal
abduct
abducted
abduction
abductions
abductor
abductors
abducts
Abe
abed
Abel
Abelian
Abelson
Aberdeen
Abernathy
aberrant
aberration
start slave;

let $result_pattern= '%127.0.0.1%root%master-bin.000002%slave-relay-bin.000005%Yes%Yes%0%0%None%' ;

--source include/wait_slave_status.inc
select * from t1 order by 1 asc;
word
Aarhus
Aaron
Aaron
Ababa
Ababa
aback
aback
abaft
abaft
abandon
abandon
abandoned
abandoned
abandoning
abandoning
abandonment
abandonment
abandons
abandons
abase
abased
abasement
abasements
abases
abash
abashed
abashes
abashing
abasing
abate
abated
abatement
abatements
abater
abates
abating
Abba
abbe
abbey
abbeys
abbot
abbots
Abbott
abbreviate
abbreviated
abbreviates
abbreviating
abbreviation
abbreviations
Abby
abdomen
abdomens
abdominal
abduct
abducted
abduction
abductions
abductor
abductors
abducts
Abe
abed
Abel
Abelian
Abelson
Aberdeen
Abernathy
aberrant
aberration
flush logs;
stop slave;
create table t2 (n int)ENGINE=MyISAM;
insert into t2 values (1);
show binlog events from <binlog_start>;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
master-bin.000001	#	Intvar	#	#	INSERT_ID=1
master-bin.000001	#	Query	#	#	use `test`; insert into t1 values (NULL)
master-bin.000001	#	Query	#	#	use `test`; drop table t1
master-bin.000001	#	Query	#	#	use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
master-bin.000001	#	Begin_load_query	#	#	;file_id=#;block_len=581
master-bin.000001	#	Execute_load_query	#	#	use `test`; load data infile '../std_data_ln/words.dat' into table t1 ignore 1 lines ;file_id=#
master-bin.000001	#	Rotate	#	#	master-bin.000002;pos=4
show binlog events in 'master-bin.000002';
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000002	#	Format_desc	1	#	Server ver: VERSION, Binlog ver: 4
master-bin.000002	#	Query	1	#	use `test`; create table t3 (a int)ENGINE=MyISAM
master-bin.000002	#	Query	1	#	use `test`; create table t2 (n int)ENGINE=MyISAM
master-bin.000002	#	Query	1	#	use `test`; insert into t2 values (1)
show binary logs;
Log_name	File_size
master-bin.000001	1348
master-bin.000002	393
start slave;
show binary logs;
Log_name	File_size
slave-bin.000001	1448
slave-bin.000002	294
show binlog events in 'slave-bin.000001' from 4;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000001	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000001	#	Query	1	#	use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
slave-bin.000001	#	Intvar	1	#	INSERT_ID=1
slave-bin.000001	#	Query	1	#	use `test`; insert into t1 values (NULL)
slave-bin.000001	#	Query	1	#	use `test`; drop table t1
slave-bin.000001	#	Query	1	#	use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
slave-bin.000001	#	Begin_load_query	1	#	;file_id=1;block_len=581
slave-bin.000001	#	Execute_load_query	1	#	use `test`; load data INFILE '../tmp/SQL_LOAD-2-1-1.data' INTO table t1 ignore 1 lines ;file_id=1
slave-bin.000001	#	Query	1	#	use `test`; create table t3 (a int)ENGINE=MyISAM
slave-bin.000001	#	Rotate	2	#	slave-bin.000002;pos=4
show binlog events in 'slave-bin.000002' from 4;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
slave-bin.000002	#	Format_desc	2	#	Server ver: VERSION, Binlog ver: 4
slave-bin.000002	#	Query	1	#	use `test`; create table t2 (n int)ENGINE=MyISAM
slave-bin.000002	#	Query	1	#	use `test`; insert into t2 values (1)
SHOW SLAVE STATUS;
Slave_IO_State	#
Master_Host	127.0.0.1
Master_User	root
Master_Port	MASTER_PORT
Connect_Retry	1
Master_Log_File	master-bin.000002
Read_Master_Log_Pos	393
Relay_Log_File	#
Relay_Log_Pos	#
Relay_Master_Log_File	master-bin.000002
Slave_IO_Running	Yes
Slave_SQL_Running	Yes
Replicate_Do_DB	
Replicate_Ignore_DB	
Replicate_Do_Table	
Replicate_Ignore_Table	#
Replicate_Wild_Do_Table	
Replicate_Wild_Ignore_Table	
Last_Errno	0
Last_Error	
Skip_Counter	0
Exec_Master_Log_Pos	393
Relay_Log_Space	#
Until_Condition	None
Until_Log_File	
Until_Log_Pos	0
Master_SSL_Allowed	No
Master_SSL_CA_File	
Master_SSL_CA_Path	
Master_SSL_Cert	
Master_SSL_Cipher	
Master_SSL_Key	
Seconds_Behind_Master	#
Master_SSL_Verify_Server_Cert	No
Last_IO_Errno	#
Last_IO_Error	#
Last_SQL_Errno	0
Last_SQL_Error	
show binlog events in 'slave-bin.000005' from 4;
ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log
DROP TABLE t1;
DROP TABLE t2;
DROP TABLE t3;
create table t1(a int auto_increment primary key, b int);
insert into t1 values (NULL, 1);
reset master;
set insert_id=5;
insert into t1 values (NULL, last_insert_id()), (NULL, last_insert_id());
show binlog events from <binlog_start>;
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Intvar	#	#	LAST_INSERT_ID=1
master-bin.000001	#	Intvar	#	#	INSERT_ID=5
master-bin.000001	#	Query	#	#	use `test`; insert into t1 values (NULL, last_insert_id()), (NULL, last_insert_id())
select * from t1;
a	b
1	1
5	1
6	1
drop table t1;

1 by brian clean slate	1	stop slave;
	2	drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
	3	reset master;
	4	reset slave;
	5	drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
	6	start slave;
	7	stop slave;
	8	reset master;
	9	reset slave;
	10	reset master;
	11	create table t1(n int not null auto_increment primary key)ENGINE=MyISAM;
	12	insert into t1 values (NULL);
	13	drop table t1;
	14	create table t1 (word char(20) not null)ENGINE=MyISAM;
	15	load data infile '../std_data_ln/words.dat' into table t1 ignore 1 lines;
	16	select count(*) from t1;
	17	count(*)
	18	69
	19	show binlog events;
	20	Log_name Pos Event_type Server_id End_log_pos Info
	21	master-bin.000001 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4
	22	master-bin.000001 # Query 1 # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
	23	master-bin.000001 # Intvar 1 # INSERT_ID=1
	24	master-bin.000001 # Query 1 # use `test`; insert into t1 values (NULL)
	25	master-bin.000001 # Query 1 # use `test`; drop table t1
	26	master-bin.000001 # Query 1 # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
	27	master-bin.000001 # Begin_load_query 1 # ;file_id=1;block_len=581
	28	master-bin.000001 # Execute_load_query 1 # use `test`; load data infile '../std_data_ln/words.dat' into table t1 ignore 1 lines ;file_id=1
	29	show binlog events from 107 limit 1;
	30	Log_name Pos Event_type Server_id End_log_pos Info
	31	master-bin.000001 # Query 1 # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
	32	show binlog events from 107 limit 2;
	33	Log_name Pos Event_type Server_id End_log_pos Info
	34	master-bin.000001 # Query 1 # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
	35	master-bin.000001 # Intvar 1 # INSERT_ID=1
	36	show binlog events from 107 limit 2,1;
	37	Log_name Pos Event_type Server_id End_log_pos Info
	38	master-bin.000001 # Query 1 # use `test`; insert into t1 values (NULL)
	39	flush logs;
	40	create table t3 (a int)ENGINE=MyISAM;
	41	select * from t1 order by 1 asc;
	42	word
	43	Aarhus
	44	Aaron
	45	Aaron
	46	Ababa
	47	Ababa
	48	aback
	49	aback
	50	abaft
	51	abaft
	52	abandon
	53	abandon
	54	abandoned
	55	abandoned
	56	abandoning
	57	abandoning
	58	abandonment
	59	abandonment
	60	abandons
	61	abandons
	62	abase
	63	abased
	64	abasement
65	abasements
66	abases
67	abash
68	abashed
69	abashes
70	abashing
71	abasing
72	abate
73	abated
74	abatement
75	abatements
76	abater
77	abates
78	abating
79	Abba
80	abbe
81	abbey
82	abbeys
83	abbot
84	abbots
85	Abbott
86	abbreviate
87	abbreviated
88	abbreviates
89	abbreviating
90	abbreviation
91	abbreviations
92	Abby
93	abdomen
94	abdomens
95	abdominal
96	abduct
97	abducted
98	abduction
99	abductions
100	abductor
101	abductors
102	abducts
103	Abe
104	abed
105	Abel
106	Abelian
107	Abelson
108	Aberdeen
109	Abernathy
110	aberrant
111	aberration
112	start slave;
113
114	let $result_pattern= '%127.0.0.1%root%master-bin.000002%slave-relay-bin.000005%Yes%Yes%0%0%None%' ;
115
116	--source include/wait_slave_status.inc
117	select * from t1 order by 1 asc;
118	word
119	Aarhus
120	Aaron
121	Aaron
122	Ababa
123	Ababa
124	aback
125	aback
126	abaft
127	abaft
128	abandon
129	abandon
130	abandoned
131	abandoned
132	abandoning
133	abandoning
134	abandonment
135	abandonment
136	abandons
137	abandons
138	abase
139	abased
140	abasement
141	abasements
142	abases
143	abash
144	abashed
145	abashes
146	abashing
147	abasing
148	abate
149	abated
150	abatement
151	abatements
152	abater
153	abates
154	abating
155	Abba
156	abbe
157	abbey
158	abbeys
159	abbot
160	abbots
161	Abbott
162	abbreviate
163	abbreviated
164	abbreviates
165	abbreviating
166	abbreviation
167	abbreviations
168	Abby
169	abdomen
170	abdomens
171	abdominal
172	abduct
173	abducted
174	abduction
175	abductions
176	abductor
177	abductors
178	abducts
179	Abe
180	abed
181	Abel
182	Abelian
183	Abelson
184	Aberdeen
185	Abernathy
186	aberrant
187	aberration
188	flush logs;
189	stop slave;
190	create table t2 (n int)ENGINE=MyISAM;
191	insert into t2 values (1);
192	show binlog events from <binlog_start>;
193	Log_name Pos Event_type Server_id End_log_pos Info
194	master-bin.000001 # Query # # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
195	master-bin.000001 # Intvar # # INSERT_ID=1
196	master-bin.000001 # Query # # use `test`; insert into t1 values (NULL)
197	master-bin.000001 # Query # # use `test`; drop table t1
198	master-bin.000001 # Query # # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
199	master-bin.000001 # Begin_load_query # # ;file_id=#;block_len=581
200	master-bin.000001 # Execute_load_query # # use `test`; load data infile '../std_data_ln/words.dat' into table t1 ignore 1 lines ;file_id=#
201	master-bin.000001 # Rotate # # master-bin.000002;pos=4
202	show binlog events in 'master-bin.000002';
203	Log_name Pos Event_type Server_id End_log_pos Info
204	master-bin.000002 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4
205	master-bin.000002 # Query 1 # use `test`; create table t3 (a int)ENGINE=MyISAM
206	master-bin.000002 # Query 1 # use `test`; create table t2 (n int)ENGINE=MyISAM
207	master-bin.000002 # Query 1 # use `test`; insert into t2 values (1)
208	show binary logs;
209	Log_name File_size
210	master-bin.000001 1348
211	master-bin.000002 393
212	start slave;
213	show binary logs;
214	Log_name File_size
215	slave-bin.000001 1448
216	slave-bin.000002 294
217	show binlog events in 'slave-bin.000001' from 4;
218	Log_name Pos Event_type Server_id End_log_pos Info
219	slave-bin.000001 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4
220	slave-bin.000001 # Query 1 # use `test`; create table t1(n int not null auto_increment primary key)ENGINE=MyISAM
221	slave-bin.000001 # Intvar 1 # INSERT_ID=1
222	slave-bin.000001 # Query 1 # use `test`; insert into t1 values (NULL)
223	slave-bin.000001 # Query 1 # use `test`; drop table t1
224	slave-bin.000001 # Query 1 # use `test`; create table t1 (word char(20) not null)ENGINE=MyISAM
225	slave-bin.000001 # Begin_load_query 1 # ;file_id=1;block_len=581
226	slave-bin.000001 # Execute_load_query 1 # use `test`; load data INFILE '../tmp/SQL_LOAD-2-1-1.data' INTO table t1 ignore 1 lines ;file_id=1
227	slave-bin.000001 # Query 1 # use `test`; create table t3 (a int)ENGINE=MyISAM
228	slave-bin.000001 # Rotate 2 # slave-bin.000002;pos=4
229	show binlog events in 'slave-bin.000002' from 4;
230	Log_name Pos Event_type Server_id End_log_pos Info
231	slave-bin.000002 # Format_desc 2 # Server ver: VERSION, Binlog ver: 4
232	slave-bin.000002 # Query 1 # use `test`; create table t2 (n int)ENGINE=MyISAM
233	slave-bin.000002 # Query 1 # use `test`; insert into t2 values (1)
234	SHOW SLAVE STATUS;
235	Slave_IO_State #
236	Master_Host 127.0.0.1
237	Master_User root
238	Master_Port MASTER_PORT
239	Connect_Retry 1
240	Master_Log_File master-bin.000002
241	Read_Master_Log_Pos 393
242	Relay_Log_File #
243	Relay_Log_Pos #
244	Relay_Master_Log_File master-bin.000002
245	Slave_IO_Running Yes
246	Slave_SQL_Running Yes
247	Replicate_Do_DB
248	Replicate_Ignore_DB
249	Replicate_Do_Table
250	Replicate_Ignore_Table #
251	Replicate_Wild_Do_Table
252	Replicate_Wild_Ignore_Table
253	Last_Errno 0
254	Last_Error
255	Skip_Counter 0
256	Exec_Master_Log_Pos 393
257	Relay_Log_Space #
258	Until_Condition None
259	Until_Log_File
260	Until_Log_Pos 0
261	Master_SSL_Allowed No
262	Master_SSL_CA_File
263	Master_SSL_CA_Path
264	Master_SSL_Cert
265	Master_SSL_Cipher
266	Master_SSL_Key
267	Seconds_Behind_Master #
268	Master_SSL_Verify_Server_Cert No
269	Last_IO_Errno #
270	Last_IO_Error #
271	Last_SQL_Errno 0
272	Last_SQL_Error
273	show binlog events in 'slave-bin.000005' from 4;
274	ERROR HY000: Error when executing command SHOW BINLOG EVENTS: Could not find target log
275	DROP TABLE t1;
276	DROP TABLE t2;
277	DROP TABLE t3;
278	create table t1(a int auto_increment primary key, b int);
279	insert into t1 values (NULL, 1);
280	reset master;
281	set insert_id=5;
282	insert into t1 values (NULL, last_insert_id()), (NULL, last_insert_id());
283	show binlog events from <binlog_start>;
284	Log_name Pos Event_type Server_id End_log_pos Info
285	master-bin.000001 # Intvar # # LAST_INSERT_ID=1
286	master-bin.000001 # Intvar # # INSERT_ID=5
287	master-bin.000001 # Query # # use `test`; insert into t1 values (NULL, last_insert_id()), (NULL, last_insert_id())
288	select * from t1;
289	a b
290	1 1
291	5 1
292	6 1
293	drop table t1;