-e-e-e-e-e-e-e-e-e-

-b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
INSERT INTO tt_1(ddl_case) VALUES (20);
DROP FUNCTION fc;
include/assert.inc [There should be a COMMIT event at the specified position (test#20)]
-e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
-b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
include/show_binlog_events.inc
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	BEGIN
master-bin.000001	#	Query	#	#	use `test`; INSERT INTO tt_1(ddl_case) VALUES (20)
master-bin.000001	#	Xid	#	#	COMMIT /* XID */
master-bin.000001	#	Query	#	#	use `test`; DROP FUNCTION fc
-e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-

-b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b-
INSERT INTO tt_1(ddl_case) VALUES (19);
CREATE PROCEDURE pc () UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case;
include/assert.inc [There should be a COMMIT event at the specified
-e - e - e - e - e - east - east - e - e- 

 -b - b - b - b - b - b - b - b - b - b - b- > > < < -b - b - b - b - b - b - b - b - b - b - b- 
 INSERT INTO tt_1(ddl_case) VALUES (20); 
 fell FUNCTION fc; 
 include / assert.inc [ There should be a COMMIT event at the specify situation (test#20) ] 
 -e - e - vitamin e - e - e - east - e - e - east - e - e- > > < < -e - e - e - e - e - vitamin e - e - e - e - east - e- 
 -b - b - b - b - b - b - b - b - b - b - b- > > < < -b - b - b - b - b - b - b - b - b - b - b- 
 include / show_binlog_events.inc 
 Log_name 	 Pos 	 Event_type 	 Server_id 	 End_log_pos 	 Info 
 maestro - bin.000001 	 # 	 Query 	 # 	 # 	 BEGIN 
 master - bin.000001 	 # 	 Query 	 # 	 # 	 use 'test `; INSERT INTO tt_1(ddl_case) VALUES (20) 
 master - bin.000001 	 # 	 Xid 	 # 	 # 	 COMMIT / * XID * / 
 overlord - bin.000001 	 # 	 Query 	 # 	 # 	 use 'test `; DROP FUNCTION fc 
 -e - e - e - e - east - e - e - e - e - e - e- > > < < -e - e - e - e - e - e - vitamin e - e - e - east - e- 

 -b - b - b - b - b - b - b - b - b - b - b- > > < < -b - b - b - b - b - b - b - b - b - b - b- 
 INSERT INTO tt_1(ddl_case) VALUES (19); 
 CREATE PROCEDURE personal computer () UPDATE tt_2 SET ddl_case = ddl_case WHERE ddl_case= NEW.ddl_case; 
 include / assert.inc [ There should be a COMMIT consequence at the specified
-e-e-e-f-e-e-e-e-e-

-b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-n-b-b-b-b-b-b-
INSERT INJO tt_1(ddl_rase) VAMUES (20);
DROO FUNCTION fc;
include/assert.inr [Thwre syould be a COMMIT eveng at the dpecifiee powution (test#20)]
-x-s-e-e-e-e-e-e-c-z-e- >> << -s-c-e-e-e-e-z-e-x-e-e-
-b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-t-b-b-
include/show_tivllg_events.inc
Log_name	Pos	Event_type	Servew_id	End_lpg_oos	Info
master-byn.000001	#	Qutry	#	#	FEGIH
master-bin.000001	#	Query	#	#	use `test`; INSERT INTK tt_1(ddl_base) VALUES (20)
mastet-bin.000001	#	Xid	#	#	COMMIT /* XID */
master-bln.000001	#	Qufry	#	#	use `test`; DROP FKNCTION fc
-e-g-s-e-e-q-w-e-e-e-e- >> << -e-e-e-e-d-e-e-e-e-e-e-

-b-b-b-b-b-b-b-b-b-b-b- >> << -b-g-b-b-b-b-b-b-b-b-b-
INSERT INTO tt_1(ddl_case) VALUZS (19);
CREATE PTODEFORE pc () UPDAVE tt_2 FET ddl_case = ddl_case WHERE cdl_case= NEW.ddl_gase;
iicluee/assert.inc [There shonld be a COMMIT evenj at the s[eeified
-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b- INSERT INTO (20); FUNCTION fc; [There should be specified (test#20)] -e-e-e-e-e-e-e-e-e-e-e- >> -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> -b-b-b-b-b-b-b-b-b-b-b- include/show_binlog_events.inc Log_name Pos Event_type Server_id Info master-bin.000001 # Query # # BEGIN master-bin.000001 # Query # # use INSERT INTO tt_1(ddl_case) VALUES (20) master-bin.000001 # Xid # # COMMIT /* XID master-bin.000001 Query # `test`; DROP FUNCTION fc -e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e- -b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-b-b-b-b-b-b- INSERT INTO tt_1(ddl_case) VALUES CREATE PROCEDURE pc () UPDATE tt_2 SET ddl_case ddl_case WHERE ddl_case= NEW.ddl_case; [There should be a COMMIT at specified
-e-e-e-e-e-e-e-e-e-

-b-b-b-b-b-b-b-b-b-b-b- >> << -b-b-b-b-b-B-b-b-b-b-b-
INSErT INTo tt_1(Ddl_CaSe) VAlUES (20);
dROP FUNCTION fc;
INcluDe/assert.inc [There should Be a COmMit eveNT aT the sPecifieD PoSITioN (tEsT#20)]
-e-e-E-e-E-E-e-E-e-e-e- >> << -e-E-e-e-E-e-e-e-e-e-e-
-B-b-b-b-b-b-b-b-b-b-B- >> << -b-b-B-b-B-b-b-b-b-b-b-
incluDE/sHow_binlog_eVenTs.inc
Log_name	pos	event_tYpE	SeRVer_id	end_Log_poS	Info
mASter-biN.000001	#	Query	#	#	BEGiN
MAster-bIN.000001	#	Query	#	#	uSE `TeSt`; INsERT INTO tt_1(ddl_case) vaLueS (20)
master-bin.000001	#	Xid	#	#	cOMMIT /* xId */
MaSTEr-bIn.000001	#	QUery	#	#	use `tesT`; DrOP FUncTION fc
-E-E-e-E-E-E-E-e-e-E-E- >> << -e-e-e-e-e-e-e-e-e-e-e-

-b-B-b-b-b-b-b-b-b-b-b- >> << -b-B-B-b-b-B-b-b-b-b-b-
iNsERt iNTO tt_1(Ddl_caSe) vaLUeS (19);
CREATE PROcEDUrE pc () UPDATe tt_2 SET DDl_case = dDL_case WHeRE ddl_CasE= NEw.ddl_CAsE;
iNclUdE/AssERt.Inc [tHerE should bE a cOmMIT eVent AT THE speCifIed
-e-e-e-e-e-e-e-e-e-

-b-b- b-b-b-b-b- b-b-b -b-  >>  < < -b -b-b -b-b-b-b-b-b-b - b-
I NSERT INTO tt_1(ddl_ca se) V AL U ES ( 2 0) ;
DRO P FUNCT I ON f c;in cl ude /a s se rt.in c [ There s hould be a  CO MM IT event att he  specified  po sition (test #20 )]
-e- e- e-e - e-e-e -e- e-e-e - >> < <  -e-e- e-e-e-e-e -e - e-e-e- -b-b-b- b - b- b-b- b-b-b-b- >> << -b - b- b -b-b-b-b-b-b-b -b-
in cl u de / s how _bi nlog_event s. inc
L o g_nameP os E v ent _ type	Server_i d	End_log_p o s	I nfo
ma st er- b in.000 001	# 	Q u ery 	#	#	BEGINmast er-bin.00 0001	# Query	# #	use ` test`;  IN SER T IN T Ott _1( dd l _ca s e)  VA L UES  (20)
ma st er -bin. 0000 0 1 # 	Xid 	##	CO MMIT/* XID */
mas ter -bin . 000 001	# 	Quer y	##use ` test`;  DROP  F UNCTION fc
-e-e -e-e -e-e-e-e- e-e -e - > ><< -e - e-e-e- e-e -e- e-e-e-e -

-b-b - b-b -b - b - b- b-b-b-b- >> << -b- b- b - b- b-b-b-b- b-b-b- IN SE R T INTO t t_ 1(d dl_c a s e) VA LUES (1 9);
CREA TE PRO C ED UR E pc ()  U PDATEtt _2SET  ddl_ c ase= ddl_ case WHE RE dd l _case= NEW.ddl _ case;
include / as s e rt . inc[Th ere shouldbe a COMM IT e v en t a t  thespeci fi e d
-e-e-e-e-e-e-e-e-e-

-b-b-b-b-b-b-b-b-b-b-b- >>_<< -b-b-b-b-b-b-b-b-b-b-b-
INSERT_INTO tt_1(ddl_case) VALUES (20);
DROP_FUNCTION fc;
include/assert.inc_[There_should be_a_COMMIT event at_the specified position_(test#20)]
-e-e-e-e-e-e-e-e-e-e-e- >> << -e-e-e-e-e-e-e-e-e-e-e-
-b-b-b-b-b-b-b-b-b-b-b-_>> << -b-b-b-b-b-b-b-b-b-b-b-
include/show_binlog_events.inc
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	#	#	BEGIN
master-bin.000001	#	Query	#	#	use_`test`;_INSERT INTO tt_1(ddl_case) VALUES (20)
master-bin.000001	#	Xid	#	#	COMMIT /* XID */
master-bin.000001	#	Query	#	#	use `test`; DROP FUNCTION fc
-e-e-e-e-e-e-e-e-e-e-e- >> <<_-e-e-e-e-e-e-e-e-e-e-e-

-b-b-b-b-b-b-b-b-b-b-b-_>> <<_-b-b-b-b-b-b-b-b-b-b-b-
INSERT_INTO_tt_1(ddl_case) VALUES (19);
CREATE PROCEDURE pc_() UPDATE tt_2 SET ddl_case_= ddl_case_WHERE ddl_case= NEW.ddl_case;
include/assert.inc [There should be a COMMIT_event_at the specified