← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_innodb_mixed_dml.result

  • Committer: Bazaar Package Importer
  • Author(s): Chuck Short
  • Date: 2010-06-21 15:31:05 UTC
  • mfrom: (1.1.3 upstream)
  • mto: This revision was merged to the branch mainline in revision 6.
  • Revision ID: james.westby@ubuntu.com-20100621153105-pbbz3t6nyrf9t2zq
Tags: upstream-5.1.48
Import upstream version 5.1.48

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/r/rpl_innodb_mixed_dml.result
830
830
 
831
831
 
832
832
******************** SHOW BINLOG EVENTS ********************
833
 
show binlog events from 1;
 
833
show binlog events from <binlog_start>;
834
834
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
835
 
master-bin.000001       #       Format_desc     1       #       Server ver: #
836
 
master-bin.000001       #       Query   1       #       CREATE DATABASE test_rpl
837
 
master-bin.000001       #       Query   1       #       use `test_rpl`; CREATE TABLE t1 (a int auto_increment not null, b char(254), PRIMARY KEY(a)) ENGINE=innodb
838
 
master-bin.000001       #       Query   1       #       use `test_rpl`; CREATE TABLE t2 (a int auto_increment not null, b char(254), PRIMARY KEY(a)) ENGINE=innodb
839
 
master-bin.000001       #       Query   1       #       BEGIN
840
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
841
 
master-bin.000001       #       Xid     1       #       #
842
 
master-bin.000001       #       Query   1       #       BEGIN
843
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES(2, 't1, text 2')
844
 
master-bin.000001       #       Xid     1       #       #
845
 
master-bin.000001       #       Query   1       #       BEGIN
846
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t2 VALUES(1, 't2, text 1')
847
 
master-bin.000001       #       Xid     1       #       #
848
 
master-bin.000001       #       Query   1       #       BEGIN
849
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t1 WHERE a = 1
850
 
master-bin.000001       #       Xid     1       #       #
851
 
master-bin.000001       #       Query   1       #       BEGIN
852
 
master-bin.000001       #       Table_map       1       #       table_id: # (test_rpl.t2)
853
 
master-bin.000001       #       Delete_rows     1       #       table_id: # flags: STMT_END_F
854
 
master-bin.000001       #       Xid     1       #       #
855
 
master-bin.000001       #       Query   1       #       BEGIN
856
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t1
857
 
master-bin.000001       #       Xid     1       #       #
858
 
master-bin.000001       #       Query   1       #       BEGIN
859
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t2
860
 
master-bin.000001       #       Xid     1       #       #
861
 
master-bin.000001       #       Query   1       #       BEGIN
862
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
863
 
master-bin.000001       #       Xid     1       #       #
864
 
master-bin.000001       #       Query   1       #       BEGIN
865
 
master-bin.000001       #       Table_map       1       #       table_id: # (test_rpl.t1)
866
 
master-bin.000001       #       Write_rows      1       #       table_id: # flags: STMT_END_F
867
 
master-bin.000001       #       Xid     1       #       #
868
 
master-bin.000001       #       Query   1       #       BEGIN
869
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t2 SELECT * FROM t1
870
 
master-bin.000001       #       Xid     1       #       #
871
 
master-bin.000001       #       Query   1       #       BEGIN
872
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t2 VALUES (1, 't1, text 1') ON DUPLICATE KEY UPDATE b = 't2, text 1'
873
 
master-bin.000001       #       Xid     1       #       #
874
 
master-bin.000001       #       Query   1       #       BEGIN
875
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t1 WHERE a = 2
876
 
master-bin.000001       #       Xid     1       #       #
877
 
master-bin.000001       #       Query   1       #       BEGIN
878
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t2 WHERE a = 2
879
 
master-bin.000001       #       Xid     1       #       #
880
 
master-bin.000001       #       Query   1       #       BEGIN
881
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t1
882
 
master-bin.000001       #       Xid     1       #       #
883
 
master-bin.000001       #       Query   1       #       BEGIN
884
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t2
885
 
master-bin.000001       #       Xid     1       #       #
886
 
master-bin.000001       #       Query   1       #       BEGIN
887
 
master-bin.000001       #       Begin_load_query        1       #       ;file_id=#;block_len=#
888
 
master-bin.000001       #       Execute_load_query      1       #       use `test_rpl`; LOAD DATA INFILE 'MYSQLTEST_VARDIR/std_data/rpl_mixed.dat' INTO TABLE `t1` FIELDS TERMINATED BY '|' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a`, `b`) ;file_id=#
889
 
master-bin.000001       #       Xid     1       #       #
890
 
master-bin.000001       #       Query   1       #       BEGIN
891
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t1
892
 
master-bin.000001       #       Xid     1       #       #
893
 
master-bin.000001       #       Query   1       #       BEGIN
894
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t2
895
 
master-bin.000001       #       Xid     1       #       #
896
 
master-bin.000001       #       Query   1       #       BEGIN
897
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
898
 
master-bin.000001       #       Xid     1       #       #
899
 
master-bin.000001       #       Query   1       #       BEGIN
900
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES(2, 't1, text 2')
901
 
master-bin.000001       #       Xid     1       #       #
902
 
master-bin.000001       #       Query   1       #       BEGIN
903
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES(3, 't1, text 3')
904
 
master-bin.000001       #       Xid     1       #       #
905
 
master-bin.000001       #       Query   1       #       BEGIN
906
 
master-bin.000001       #       Query   1       #       use `test_rpl`; REPLACE INTO t1 VALUES(1, 't1, text 11')
907
 
master-bin.000001       #       Xid     1       #       #
908
 
master-bin.000001       #       Query   1       #       BEGIN
909
 
master-bin.000001       #       Table_map       1       #       table_id: # (test_rpl.t1)
910
 
master-bin.000001       #       Update_rows     1       #       table_id: # flags: STMT_END_F
911
 
master-bin.000001       #       Xid     1       #       #
912
 
master-bin.000001       #       Query   1       #       BEGIN
913
 
master-bin.000001       #       Query   1       #       use `test_rpl`; REPLACE INTO t1 SET a=3, b='t1, text 33'
914
 
master-bin.000001       #       Xid     1       #       #
915
 
master-bin.000001       #       Query   1       #       BEGIN
916
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t1 WHERE a = 2
917
 
master-bin.000001       #       Xid     1       #       #
918
 
master-bin.000001       #       Query   1       #       BEGIN
919
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t1
920
 
master-bin.000001       #       Xid     1       #       #
921
 
master-bin.000001       #       Query   1       #       BEGIN
922
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t2
923
 
master-bin.000001       #       Xid     1       #       #
924
 
master-bin.000001       #       Query   1       #       BEGIN
925
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
926
 
master-bin.000001       #       Xid     1       #       #
927
 
master-bin.000001       #       Query   1       #       BEGIN
928
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t1
929
 
master-bin.000001       #       Xid     1       #       #
930
 
master-bin.000001       #       Query   1       #       BEGIN
931
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t2
932
 
master-bin.000001       #       Xid     1       #       #
933
 
master-bin.000001       #       Query   1       #       BEGIN
934
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 'CCC')
935
 
master-bin.000001       #       Xid     1       #       #
936
 
master-bin.000001       #       Query   1       #       BEGIN
937
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES(2, 'DDD')
938
 
master-bin.000001       #       Xid     1       #       #
939
 
master-bin.000001       #       Query   1       #       BEGIN
940
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t2 VALUES(1, 'DDD')
941
 
master-bin.000001       #       Xid     1       #       #
942
 
master-bin.000001       #       Query   1       #       BEGIN
943
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t2 VALUES(2, 'CCC')
944
 
master-bin.000001       #       Xid     1       #       #
945
 
master-bin.000001       #       Query   1       #       BEGIN
946
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t1
947
 
master-bin.000001       #       Xid     1       #       #
948
 
master-bin.000001       #       Query   1       #       BEGIN
949
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t2
950
 
master-bin.000001       #       Xid     1       #       #
951
 
master-bin.000001       #       Query   1       #       BEGIN
952
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
953
 
master-bin.000001       #       Xid     1       #       #
954
 
master-bin.000001       #       Query   1       #       BEGIN
955
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t2 VALUES(1, 't2, text 1')
956
 
master-bin.000001       #       Xid     1       #       #
957
 
master-bin.000001       #       Query   1       #       BEGIN
958
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t1
959
 
master-bin.000001       #       Xid     1       #       #
960
 
master-bin.000001       #       Query   1       #       BEGIN
961
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t2
962
 
master-bin.000001       #       Xid     1       #       #
963
 
master-bin.000001       #       Query   1       #       BEGIN
964
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
965
 
master-bin.000001       #       Xid     1       #       #
966
 
master-bin.000001       #       Query   1       #       BEGIN
967
 
master-bin.000001       #       Query   1       #       use `test_rpl`; TRUNCATE t1
968
 
master-bin.000001       #       Xid     1       #       #
969
 
master-bin.000001       #       Query   1       #       BEGIN
970
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t1
971
 
master-bin.000001       #       Xid     1       #       #
972
 
master-bin.000001       #       Query   1       #       BEGIN
973
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t2
974
 
master-bin.000001       #       Xid     1       #       #
975
 
master-bin.000001       #       Query   1       #       BEGIN
976
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
977
 
master-bin.000001       #       Xid     1       #       #
978
 
master-bin.000001       #       Query   1       #       BEGIN
979
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t2 VALUES(1, 't2, text 1')
980
 
master-bin.000001       #       Xid     1       #       #
981
 
master-bin.000001       #       Query   1       #       BEGIN
982
 
master-bin.000001       #       Query   1       #       use `test_rpl`; UPDATE t1 SET b = 't1, text 1 updated' WHERE a = 1
983
 
master-bin.000001       #       Xid     1       #       #
984
 
master-bin.000001       #       Query   1       #       BEGIN
985
 
master-bin.000001       #       Query   1       #       use `test_rpl`; UPDATE t1, t2 SET t1.b = 'test', t2.b = 'test'
986
 
master-bin.000001       #       Xid     1       #       #
987
 
master-bin.000001       #       Query   1       #       BEGIN
988
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t1
989
 
master-bin.000001       #       Xid     1       #       #
990
 
master-bin.000001       #       Query   1       #       BEGIN
991
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t2
992
 
master-bin.000001       #       Xid     1       #       #
993
 
master-bin.000001       #       Query   1       #       BEGIN
994
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES (1, 'start')
995
 
master-bin.000001       #       Xid     1       #       #
996
 
master-bin.000001       #       Query   1       #       BEGIN
997
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES (3, 'before savepoint s1')
998
 
master-bin.000001       #       Xid     1       #       #
999
 
master-bin.000001       #       Query   1       #       BEGIN
1000
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES (5, 'before savepoint s2')
1001
 
master-bin.000001       #       Query   1       #       SAVEPOINT s2
1002
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES (6, 'after savepoint s2')
1003
 
master-bin.000001       #       Table_map       1       #       table_id: # (test_rpl.t1)
1004
 
master-bin.000001       #       Write_rows      1       #       table_id: # flags: STMT_END_F
1005
 
master-bin.000001       #       Xid     1       #       #
1006
 
master-bin.000001       #       Query   1       #       BEGIN
1007
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t1 WHERE a = 7
1008
 
master-bin.000001       #       Xid     1       #       #
1009
 
master-bin.000001       #       Query   1       #       BEGIN
1010
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t1
1011
 
master-bin.000001       #       Xid     1       #       #
1012
 
master-bin.000001       #       Query   1       #       BEGIN
1013
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t2
1014
 
master-bin.000001       #       Xid     1       #       #
1015
 
master-bin.000001       #       Query   1       #       use `test_rpl`; CREATE USER 'user_test_rpl'@'localhost' IDENTIFIED BY PASSWORD '*1111111111111111111111111111111111111111'
1016
 
master-bin.000001       #       Query   1       #       use `test_rpl`; GRANT SELECT ON *.* TO 'user_test_rpl'@'localhost'
1017
 
master-bin.000001       #       Query   1       #       use `test_rpl`; REVOKE SELECT ON *.* FROM 'user_test_rpl'@'localhost'
1018
 
master-bin.000001       #       Query   1       #       use `test_rpl`; SET PASSWORD FOR 'user_test_rpl'@'localhost'='*0000000000000000000000000000000000000000'
1019
 
master-bin.000001       #       Query   1       #       use `test_rpl`; RENAME USER 'user_test_rpl'@'localhost' TO 'user_test_rpl_2'@'localhost'
1020
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DROP USER 'user_test_rpl_2'@'localhost'
1021
 
master-bin.000001       #       Query   1       #       BEGIN
1022
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES(100, 'test')
1023
 
master-bin.000001       #       Xid     1       #       #
1024
 
master-bin.000001       #       Query   1       #       use `test_rpl`; ANALYZE TABLE t1
1025
 
master-bin.000001       #       Query   1       #       use `test_rpl`; OPTIMIZE TABLE t1
1026
 
master-bin.000001       #       Query   1       #       use `test_rpl`; REPAIR TABLE t1
1027
 
master-bin.000001       #       Query   1       #       use `test_rpl`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
 
835
master-bin.000001       #       Query   #       #       CREATE DATABASE test_rpl
 
836
master-bin.000001       #       Query   #       #       use `test_rpl`; CREATE TABLE t1 (a int auto_increment not null, b char(254), PRIMARY KEY(a)) ENGINE=innodb
 
837
master-bin.000001       #       Query   #       #       use `test_rpl`; CREATE TABLE t2 (a int auto_increment not null, b char(254), PRIMARY KEY(a)) ENGINE=innodb
 
838
master-bin.000001       #       Query   #       #       BEGIN
 
839
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
 
840
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
841
master-bin.000001       #       Query   #       #       BEGIN
 
842
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES(2, 't1, text 2')
 
843
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
844
master-bin.000001       #       Query   #       #       BEGIN
 
845
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t2 VALUES(1, 't2, text 1')
 
846
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
847
master-bin.000001       #       Query   #       #       BEGIN
 
848
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t1 WHERE a = 1
 
849
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
850
master-bin.000001       #       Query   #       #       BEGIN
 
851
master-bin.000001       #       Table_map       #       #       table_id: # (test_rpl.t2)
 
852
master-bin.000001       #       Delete_rows     #       #       table_id: # flags: STMT_END_F
 
853
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
854
master-bin.000001       #       Query   #       #       BEGIN
 
855
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t1
 
856
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
857
master-bin.000001       #       Query   #       #       BEGIN
 
858
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t2
 
859
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
860
master-bin.000001       #       Query   #       #       BEGIN
 
861
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
 
862
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
863
master-bin.000001       #       Query   #       #       BEGIN
 
864
master-bin.000001       #       Table_map       #       #       table_id: # (test_rpl.t1)
 
865
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
 
866
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
867
master-bin.000001       #       Query   #       #       BEGIN
 
868
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t2 SELECT * FROM t1
 
869
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
870
master-bin.000001       #       Query   #       #       BEGIN
 
871
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t2 VALUES (1, 't1, text 1') ON DUPLICATE KEY UPDATE b = 't2, text 1'
 
872
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
873
master-bin.000001       #       Query   #       #       BEGIN
 
874
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t1 WHERE a = 2
 
875
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
876
master-bin.000001       #       Query   #       #       BEGIN
 
877
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t2 WHERE a = 2
 
878
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
879
master-bin.000001       #       Query   #       #       BEGIN
 
880
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t1
 
881
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
882
master-bin.000001       #       Query   #       #       BEGIN
 
883
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t2
 
884
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
885
master-bin.000001       #       Query   #       #       BEGIN
 
886
master-bin.000001       #       Begin_load_query        #       #       ;file_id=#;block_len=#
 
887
master-bin.000001       #       Execute_load_query      #       #       use `test_rpl`; LOAD DATA INFILE 'MYSQLTEST_VARDIR/std_data/rpl_mixed.dat' INTO TABLE `t1` FIELDS TERMINATED BY '|' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n' (`a`, `b`) ;file_id=#
 
888
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
889
master-bin.000001       #       Query   #       #       BEGIN
 
890
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t1
 
891
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
892
master-bin.000001       #       Query   #       #       BEGIN
 
893
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t2
 
894
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
895
master-bin.000001       #       Query   #       #       BEGIN
 
896
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
 
897
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
898
master-bin.000001       #       Query   #       #       BEGIN
 
899
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES(2, 't1, text 2')
 
900
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
901
master-bin.000001       #       Query   #       #       BEGIN
 
902
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES(3, 't1, text 3')
 
903
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
904
master-bin.000001       #       Query   #       #       BEGIN
 
905
master-bin.000001       #       Query   #       #       use `test_rpl`; REPLACE INTO t1 VALUES(1, 't1, text 11')
 
906
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
907
master-bin.000001       #       Query   #       #       BEGIN
 
908
master-bin.000001       #       Table_map       #       #       table_id: # (test_rpl.t1)
 
909
master-bin.000001       #       Update_rows     #       #       table_id: # flags: STMT_END_F
 
910
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
911
master-bin.000001       #       Query   #       #       BEGIN
 
912
master-bin.000001       #       Query   #       #       use `test_rpl`; REPLACE INTO t1 SET a=3, b='t1, text 33'
 
913
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
914
master-bin.000001       #       Query   #       #       BEGIN
 
915
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t1 WHERE a = 2
 
916
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
917
master-bin.000001       #       Query   #       #       BEGIN
 
918
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t1
 
919
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
920
master-bin.000001       #       Query   #       #       BEGIN
 
921
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t2
 
922
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
923
master-bin.000001       #       Query   #       #       BEGIN
 
924
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
 
925
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
926
master-bin.000001       #       Query   #       #       BEGIN
 
927
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t1
 
928
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
929
master-bin.000001       #       Query   #       #       BEGIN
 
930
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t2
 
931
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
932
master-bin.000001       #       Query   #       #       BEGIN
 
933
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 'CCC')
 
934
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
935
master-bin.000001       #       Query   #       #       BEGIN
 
936
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES(2, 'DDD')
 
937
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
938
master-bin.000001       #       Query   #       #       BEGIN
 
939
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t2 VALUES(1, 'DDD')
 
940
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
941
master-bin.000001       #       Query   #       #       BEGIN
 
942
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t2 VALUES(2, 'CCC')
 
943
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
944
master-bin.000001       #       Query   #       #       BEGIN
 
945
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t1
 
946
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
947
master-bin.000001       #       Query   #       #       BEGIN
 
948
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t2
 
949
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
950
master-bin.000001       #       Query   #       #       BEGIN
 
951
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
 
952
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
953
master-bin.000001       #       Query   #       #       BEGIN
 
954
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t2 VALUES(1, 't2, text 1')
 
955
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
956
master-bin.000001       #       Query   #       #       BEGIN
 
957
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t1
 
958
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
959
master-bin.000001       #       Query   #       #       BEGIN
 
960
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t2
 
961
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
962
master-bin.000001       #       Query   #       #       BEGIN
 
963
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
 
964
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
965
master-bin.000001       #       Query   #       #       BEGIN
 
966
master-bin.000001       #       Query   #       #       use `test_rpl`; TRUNCATE t1
 
967
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
968
master-bin.000001       #       Query   #       #       BEGIN
 
969
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t1
 
970
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
971
master-bin.000001       #       Query   #       #       BEGIN
 
972
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t2
 
973
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
974
master-bin.000001       #       Query   #       #       BEGIN
 
975
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 't1, text 1')
 
976
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
977
master-bin.000001       #       Query   #       #       BEGIN
 
978
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t2 VALUES(1, 't2, text 1')
 
979
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
980
master-bin.000001       #       Query   #       #       BEGIN
 
981
master-bin.000001       #       Query   #       #       use `test_rpl`; UPDATE t1 SET b = 't1, text 1 updated' WHERE a = 1
 
982
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
983
master-bin.000001       #       Query   #       #       BEGIN
 
984
master-bin.000001       #       Query   #       #       use `test_rpl`; UPDATE t1, t2 SET t1.b = 'test', t2.b = 'test'
 
985
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
986
master-bin.000001       #       Query   #       #       BEGIN
 
987
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t1
 
988
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
989
master-bin.000001       #       Query   #       #       BEGIN
 
990
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t2
 
991
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
992
master-bin.000001       #       Query   #       #       BEGIN
 
993
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES (1, 'start')
 
994
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
995
master-bin.000001       #       Query   #       #       BEGIN
 
996
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES (3, 'before savepoint s1')
 
997
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
998
master-bin.000001       #       Query   #       #       BEGIN
 
999
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES (5, 'before savepoint s2')
 
1000
master-bin.000001       #       Query   #       #       SAVEPOINT s2
 
1001
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES (6, 'after savepoint s2')
 
1002
master-bin.000001       #       Table_map       #       #       table_id: # (test_rpl.t1)
 
1003
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
 
1004
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1005
master-bin.000001       #       Query   #       #       BEGIN
 
1006
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t1 WHERE a = 7
 
1007
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1008
master-bin.000001       #       Query   #       #       BEGIN
 
1009
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t1
 
1010
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1011
master-bin.000001       #       Query   #       #       BEGIN
 
1012
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t2
 
1013
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1014
master-bin.000001       #       Query   #       #       use `test_rpl`; CREATE USER 'user_test_rpl'@'localhost' IDENTIFIED BY PASSWORD '*1111111111111111111111111111111111111111'
 
1015
master-bin.000001       #       Query   #       #       use `test_rpl`; GRANT SELECT ON *.* TO 'user_test_rpl'@'localhost'
 
1016
master-bin.000001       #       Query   #       #       use `test_rpl`; REVOKE SELECT ON *.* FROM 'user_test_rpl'@'localhost'
 
1017
master-bin.000001       #       Query   #       #       use `test_rpl`; SET PASSWORD FOR 'user_test_rpl'@'localhost'='*0000000000000000000000000000000000000000'
 
1018
master-bin.000001       #       Query   #       #       use `test_rpl`; RENAME USER 'user_test_rpl'@'localhost' TO 'user_test_rpl_2'@'localhost'
 
1019
master-bin.000001       #       Query   #       #       use `test_rpl`; DROP USER 'user_test_rpl_2'@'localhost'
 
1020
master-bin.000001       #       Query   #       #       BEGIN
 
1021
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES(100, 'test')
 
1022
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1023
master-bin.000001       #       Query   #       #       use `test_rpl`; ANALYZE TABLE t1
 
1024
master-bin.000001       #       Query   #       #       use `test_rpl`; OPTIMIZE TABLE t1
 
1025
master-bin.000001       #       Query   #       #       use `test_rpl`; REPAIR TABLE t1
 
1026
master-bin.000001       #       Query   #       #       use `test_rpl`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
1028
1027
BEGIN
1029
1028
UPDATE t1 SET b = 'test' WHERE a = 201;
1030
1029
END
1031
 
master-bin.000001       #       Query   1       #       use `test_rpl`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p2`()
 
1030
master-bin.000001       #       Query   #       #       use `test_rpl`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p2`()
1032
1031
BEGIN
1033
1032
UPDATE t1 SET b = UUID() WHERE a = 202;
1034
1033
END
1035
 
master-bin.000001       #       Query   1       #       BEGIN
1036
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT  INTO t1 VALUES(201, 'test 201')
1037
 
master-bin.000001       #       Xid     1       #       #
1038
 
master-bin.000001       #       Query   1       #       BEGIN
1039
 
master-bin.000001       #       Query   1       #       use `test_rpl`; UPDATE t1 SET b = 'test' WHERE a = 201
1040
 
master-bin.000001       #       Xid     1       #       #
1041
 
master-bin.000001       #       Query   1       #       BEGIN
1042
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT  INTO t1 VALUES(202, 'test 202')
1043
 
master-bin.000001       #       Xid     1       #       #
1044
 
master-bin.000001       #       Query   1       #       BEGIN
1045
 
master-bin.000001       #       Table_map       1       #       table_id: # (test_rpl.t1)
1046
 
master-bin.000001       #       Update_rows     1       #       table_id: # flags: STMT_END_F
1047
 
master-bin.000001       #       Xid     1       #       #
1048
 
master-bin.000001       #       Query   1       #       BEGIN
1049
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t1 WHERE a = 202
1050
 
master-bin.000001       #       Xid     1       #       #
1051
 
master-bin.000001       #       Query   1       #       use `test_rpl`; ALTER PROCEDURE p1 COMMENT 'p1'
1052
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DROP PROCEDURE p1
1053
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DROP PROCEDURE p2
1054
 
master-bin.000001       #       Query   1       #       BEGIN
1055
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t1
1056
 
master-bin.000001       #       Xid     1       #       #
1057
 
master-bin.000001       #       Query   1       #       BEGIN
1058
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t2
1059
 
master-bin.000001       #       Xid     1       #       #
1060
 
master-bin.000001       #       Query   1       #       use `test_rpl`; CREATE DEFINER=`root`@`localhost` TRIGGER tr1 BEFORE INSERT ON t1
 
1034
master-bin.000001       #       Query   #       #       BEGIN
 
1035
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT  INTO t1 VALUES(201, 'test 201')
 
1036
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1037
master-bin.000001       #       Query   #       #       BEGIN
 
1038
master-bin.000001       #       Query   #       #       use `test_rpl`; UPDATE t1 SET b = 'test' WHERE a = 201
 
1039
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1040
master-bin.000001       #       Query   #       #       BEGIN
 
1041
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT  INTO t1 VALUES(202, 'test 202')
 
1042
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1043
master-bin.000001       #       Query   #       #       BEGIN
 
1044
master-bin.000001       #       Table_map       #       #       table_id: # (test_rpl.t1)
 
1045
master-bin.000001       #       Update_rows     #       #       table_id: # flags: STMT_END_F
 
1046
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1047
master-bin.000001       #       Query   #       #       BEGIN
 
1048
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t1 WHERE a = 202
 
1049
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1050
master-bin.000001       #       Query   #       #       use `test_rpl`; ALTER PROCEDURE p1 COMMENT 'p1'
 
1051
master-bin.000001       #       Query   #       #       use `test_rpl`; DROP PROCEDURE p1
 
1052
master-bin.000001       #       Query   #       #       use `test_rpl`; DROP PROCEDURE p2
 
1053
master-bin.000001       #       Query   #       #       BEGIN
 
1054
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t1
 
1055
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1056
master-bin.000001       #       Query   #       #       BEGIN
 
1057
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t2
 
1058
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1059
master-bin.000001       #       Query   #       #       use `test_rpl`; CREATE DEFINER=`root`@`localhost` TRIGGER tr1 BEFORE INSERT ON t1
1061
1060
FOR EACH ROW BEGIN
1062
1061
INSERT INTO t2 SET a = NEW.a, b = NEW.b;
1063
1062
END
1064
 
master-bin.000001       #       Query   1       #       BEGIN
1065
 
master-bin.000001       #       Table_map       1       #       table_id: # (test_rpl.t1)
1066
 
master-bin.000001       #       Table_map       1       #       table_id: # (test_rpl.t2)
1067
 
master-bin.000001       #       Write_rows      1       #       table_id: #
1068
 
master-bin.000001       #       Write_rows      1       #       table_id: # flags: STMT_END_F
1069
 
master-bin.000001       #       Xid     1       #       #
1070
 
master-bin.000001       #       Query   1       #       BEGIN
1071
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t1
1072
 
master-bin.000001       #       Xid     1       #       #
1073
 
master-bin.000001       #       Query   1       #       BEGIN
1074
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t2
1075
 
master-bin.000001       #       Xid     1       #       #
1076
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DROP TRIGGER tr1
1077
 
master-bin.000001       #       Query   1       #       use `test_rpl`; GRANT EVENT ON *.* TO 'root'@'localhost'
1078
 
master-bin.000001       #       Query   1       #       BEGIN
1079
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 'test1')
1080
 
master-bin.000001       #       Xid     1       #       #
1081
 
master-bin.000001       #       Query   1       #       use `test_rpl`; CREATE DEFINER=`root`@`localhost` EVENT e1 ON SCHEDULE EVERY '1' SECOND COMMENT 'e_second_comment' DO DELETE FROM t1
1082
 
master-bin.000001       #       Query   1       #       use `test_rpl`; ALTER EVENT e1 RENAME TO e2
1083
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DROP EVENT e2
1084
 
master-bin.000001       #       Query   1       #       BEGIN
1085
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t1
1086
 
master-bin.000001       #       Xid     1       #       #
1087
 
master-bin.000001       #       Query   1       #       BEGIN
1088
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t2
1089
 
master-bin.000001       #       Xid     1       #       #
1090
 
master-bin.000001       #       Query   1       #       BEGIN
1091
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 'test1')
1092
 
master-bin.000001       #       Xid     1       #       #
1093
 
master-bin.000001       #       Query   1       #       BEGIN
1094
 
master-bin.000001       #       Query   1       #       use `test_rpl`; INSERT INTO t1 VALUES(2, 'test2')
1095
 
master-bin.000001       #       Xid     1       #       #
1096
 
master-bin.000001       #       Query   1       #       use `test_rpl`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS SELECT * FROM t1 WHERE a = 1
1097
 
master-bin.000001       #       Query   1       #       use `test_rpl`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS SELECT * FROM t1 WHERE b <> UUID()
1098
 
master-bin.000001       #       Query   1       #       use `test_rpl`; ALTER ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS SELECT * FROM t1 WHERE a = 2
1099
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DROP VIEW v1
1100
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DROP VIEW v2
1101
 
master-bin.000001       #       Query   1       #       BEGIN
1102
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t1
1103
 
master-bin.000001       #       Xid     1       #       #
1104
 
master-bin.000001       #       Query   1       #       BEGIN
1105
 
master-bin.000001       #       Query   1       #       use `test_rpl`; DELETE FROM t2
1106
 
master-bin.000001       #       Xid     1       #       #
 
1063
master-bin.000001       #       Query   #       #       BEGIN
 
1064
master-bin.000001       #       Table_map       #       #       table_id: # (test_rpl.t1)
 
1065
master-bin.000001       #       Table_map       #       #       table_id: # (test_rpl.t2)
 
1066
master-bin.000001       #       Write_rows      #       #       table_id: #
 
1067
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
 
1068
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1069
master-bin.000001       #       Query   #       #       BEGIN
 
1070
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t1
 
1071
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1072
master-bin.000001       #       Query   #       #       BEGIN
 
1073
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t2
 
1074
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1075
master-bin.000001       #       Query   #       #       use `test_rpl`; DROP TRIGGER tr1
 
1076
master-bin.000001       #       Query   #       #       use `test_rpl`; GRANT EVENT ON *.* TO 'root'@'localhost'
 
1077
master-bin.000001       #       Query   #       #       BEGIN
 
1078
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 'test1')
 
1079
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1080
master-bin.000001       #       Query   #       #       use `test_rpl`; CREATE DEFINER=`root`@`localhost` EVENT e1 ON SCHEDULE EVERY '1' SECOND COMMENT 'e_second_comment' DO DELETE FROM t1
 
1081
master-bin.000001       #       Query   #       #       use `test_rpl`; ALTER EVENT e1 RENAME TO e2
 
1082
master-bin.000001       #       Query   #       #       use `test_rpl`; DROP EVENT e2
 
1083
master-bin.000001       #       Query   #       #       BEGIN
 
1084
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t1
 
1085
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1086
master-bin.000001       #       Query   #       #       BEGIN
 
1087
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t2
 
1088
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1089
master-bin.000001       #       Query   #       #       BEGIN
 
1090
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES(1, 'test1')
 
1091
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1092
master-bin.000001       #       Query   #       #       BEGIN
 
1093
master-bin.000001       #       Query   #       #       use `test_rpl`; INSERT INTO t1 VALUES(2, 'test2')
 
1094
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1095
master-bin.000001       #       Query   #       #       use `test_rpl`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS SELECT * FROM t1 WHERE a = 1
 
1096
master-bin.000001       #       Query   #       #       use `test_rpl`; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v2` AS SELECT * FROM t1 WHERE b <> UUID()
 
1097
master-bin.000001       #       Query   #       #       use `test_rpl`; ALTER ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS SELECT * FROM t1 WHERE a = 2
 
1098
master-bin.000001       #       Query   #       #       use `test_rpl`; DROP VIEW v1
 
1099
master-bin.000001       #       Query   #       #       use `test_rpl`; DROP VIEW v2
 
1100
master-bin.000001       #       Query   #       #       BEGIN
 
1101
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t1
 
1102
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
 
1103
master-bin.000001       #       Query   #       #       BEGIN
 
1104
master-bin.000001       #       Query   #       #       use `test_rpl`; DELETE FROM t2
 
1105
master-bin.000001       #       Xid     #       #       COMMIT /* XID */
1107
1106
drop database test_rpl;