1 DROP TABLE IF EXISTS t1;
2 ==== Test BUG#32407 ====
7 ==== Test BINLOG statement w/o FD event ====
9 SVtYRxMBAAAAKQAAADQBAAAAABAAAAAAAAAABHRlc3QAAnQxAAEDAAE=
10 SVtYRxcBAAAAIgAAAFYBAAAQABAAAAAAAAEAAf/+AgAAAA==
12 ERROR HY000: The BINLOG statement of type `Table_map` was not preceded by a format description BINLOG statement.
17 ==== Test BINLOG statement with FD event ====
19 ODdYRw8BAAAAZgAAAGoAAAABAAQANS4xLjIzLXJjLWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA
20 AAAAAAAAAAAAAAAAAAA4N1hHEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
23 TFtYRxMBAAAAKQAAAH8BAAAAABAAAAAAAAAABHRlc3QAAnQxAAEDAAE=
24 TFtYRxcBAAAAIgAAAKEBAAAQABAAAAAAAAEAAf/+AwAAAA==
31 ==== Test --base64-output=never on a binlog with row events ====
32 /*!40019 SET @@session.max_insert_delayed_threads=0*/;
33 /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
39 SET TIMESTAMP=1196959712/*!*/;
40 <#>SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1, @@session.autocommit=1/*!*/;
41 SET @@session.sql_mode=0/*!*/;
42 SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
44 SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
45 SET @@session.lc_time_names=0/*!*/;
46 SET @@session.collation_database=DEFAULT/*!*/;
47 create table t1 (a int) engine= myisam
52 ROLLBACK /* added by mysqlbinlog */;
53 /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
54 ==== Test non-matching FD event and Row event ====
56 4CdYRw8BAAAAYgAAAGYAAAAAAAQANS4xLjE1LW5kYi02LjEuMjQtZGVidWctbG9nAAAAAAAAAAAA
57 AAAAAAAAAAAAAAAAAADgJ1hHEzgNAAgAEgAEBAQEEgAATwAEGggICAg=
60 Dl1YRxMBAAAAKQAAADQBAAAAABAAAAAAAAAABHRlc3QAAnQxAAEDAAE=
61 Dl1YRxcBAAAAIgAAAFYBAAAQABAAAAAAAAEAAf/+BQAAAA==
63 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
69 CREATE TABLE char128_utf8 (
71 c CHAR(128) CHARACTER SET utf8 NOT NULL,
73 CREATE TABLE char63_utf8 (
75 c CHAR(63) CHARACTER SET utf8 NOT NULL,
78 MuNkSA8BAAAAZgAAAGoAAAAAAAQANS4xLjI1LXJjLWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA
79 AAAAAAAAAAAAAAAAAAAy42RIEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
82 3u9kSBMBAAAANgAAAJYBAAAAABAAAAAAAAAABHRlc3QAC2NoYXI2M191dGY4AAMD/gMC/r0A
83 3u9kSBcBAAAAKgAAAMABAAAQABAAAAAAAAEAA//4AQAAAAMxMjMBAAAA
85 SELECT * FROM char63_utf8;
89 iONkSBMBAAAANwAAAJkBAAAAABAAAAAAAAAABHRlc3QADGNoYXIxMjhfdXRmOAADA/4DAv6AAA==
90 iONkSBcBAAAAKwAAAMQBAAAQABAAAAAAAAEAA//4AQAAAAMAMTIzAQAAAA==
92 ERROR HY000: master may suffer from http://bugs.mysql.com/bug.php?id=37426 so slave stops; check error log on slave for more info
93 drop table t1, char63_utf8, char128_utf8;
94 call mtr.add_suppression("Slave SQL.*master suffers from this bug: http:..bugs.mysql.com.bug.php.id=37426.* Error_code: 1105");
95 call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column 1 size mismatch.* Error_code: 1535");
97 # Bug #54393: crash and/or valgrind errors in
98 # mysql_client_binlog_statement
101 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
103 BINLOG '-2079193929';
104 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use
106 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use