Debian Codegraph @

mysql-test/suite/binlog/r/binlog_base64_flag.result

raw
1 call mtr.add_suppression("BINLOG_BASE64_EVENT: According to the master's version");
2 call mtr.add_suppression("BINLOG_BASE64_EVENT: Column 1 of table 'test.char128_utf8' cannot be converted");
3 CREATE TABLE t1 (a int);
4 INSERT INTO t1 VALUES (1), (1);
5 select * from t1;
6 a
7 1
8 1
9 ==== Test BINLOG statement w/o FD event ====
10 BINLOG '
11 SVtYRxMBAAAAKQAAADQBAAAAABAAAAAAAAAABHRlc3QAAnQxAAEDAAE=
12 SVtYRxcBAAAAIgAAAFYBAAAQABAAAAAAAAEAAf/+AgAAAA==
13 ';
14 ERROR HY000: The BINLOG statement of type Table_map was not preceded by a format description BINLOG statement
15 select * from t1;
16 a
17 1
18 1
19 ==== Test BINLOG statement with FD event ====
20 BINLOG '
21 ODdYRw8BAAAAZgAAAGoAAAABAAQANS4xLjIzLXJjLWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA
22 AAAAAAAAAAAAAAAAAAA4N1hHEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
23 ';
24 BINLOG '
25 TFtYRxMBAAAAKQAAAH8BAAAAABAAAAAAAAAABHRlc3QAAnQxAAEDAAE=
26 TFtYRxcBAAAAIgAAAKEBAAAQABAAAAAAAAEAAf/+AwAAAA==
27 ';
28 select * from t1;
29 a
30 1
31 1
32 3
33 DELETE FROM t1 WHERE a=3;
34 BINLOG '
35 ODdYRw8BAAAAZgAAAGoAAAABAAQANS4xLjIzLXJjLWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA
36 AAAAAAAAAAAAAAAAAAA4N1hHEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
37 ';
38 SET @binlog_fragment_0='
39 TFtYRxMBAAAAKQAAAH8BAAAAABAAAAAAAAAABHRlc3QAAnQxAAEDAAE=
40 TFtYRxcBAAAAIgAAAKEBAAAQABAAAAAAAAEAAf/+AwAAAA==
41 ';
42 SET @binlog_fragment_1='';
43 BINLOG @binlog_fragment_0, @binlog_fragment_1;
44 select * from t1;
45 a
46 1
47 1
48 3
49 SELECT @binlog_fragment_0, @binlog_fragment_1 as 'NULL','NULL';
50 @binlog_fragment_0 NULL NULL
51 NULL NULL NULL
52 ==== Test non-matching FD event and Row event ====
53 BINLOG '
54 4CdYRw8BAAAAYgAAAGYAAAAAAAQANS4xLjE1LW5kYi02LjEuMjQtZGVidWctbG9nAAAAAAAAAAAA
55 AAAAAAAAAAAAAAAAAADgJ1hHEzgNAAgAEgAEBAQEEgAATwAEGggICAg=
56 ';
57 BINLOG '
58 Dl1YRxMBAAAAKQAAADQBAAAAABAAAAAAAAAABHRlc3QAAnQxAAEDAAE=
59 Dl1YRxcBAAAAIgAAAFYBAAAQABAAAAAAAAEAAf/+BQAAAA==
60 ';
61 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use
62 select * from t1;
63 a
64 1
65 1
66 3
67 CREATE TABLE char128_utf8 (
68 i1 INT NOT NULL,
69 c CHAR(128) CHARACTER SET utf8 NOT NULL,
70 i2 INT NOT NULL);
71 CREATE TABLE char63_utf8 (
72 i1 INT NOT NULL,
73 c CHAR(63) CHARACTER SET utf8 NOT NULL,
74 i2 INT NOT NULL);
75 BINLOG '
76 MuNkSA8BAAAAZgAAAGoAAAAAAAQANS4xLjI1LXJjLWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA
77 AAAAAAAAAAAAAAAAAAAy42RIEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
78 ';
79 BINLOG '
80 3u9kSBMBAAAANgAAAJYBAAAAABAAAAAAAAAABHRlc3QAC2NoYXI2M191dGY4AAMD/gMC/r0A
81 3u9kSBcBAAAAKgAAAMABAAAQABAAAAAAAAEAA//4AQAAAAMxMjMBAAAA
82 ';
83 SELECT * FROM char63_utf8;
84 i1 c i2
85 1 123 1
86 BINLOG '
87 iONkSBMBAAAANwAAAJkBAAAAABAAAAAAAAAABHRlc3QADGNoYXIxMjhfdXRmOAADA/4DAv6AAA==
88 iONkSBcBAAAAKwAAAMQBAAAQABAAAAAAAAEAA//4AQAAAAMAMTIzAQAAAA==
89 ';
90 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
91 drop table t1, char63_utf8, char128_utf8;
92 call mtr.add_suppression("Slave SQL.*master suffers from this bug: http:..bugs.mysql.com.bug.php.id=37426.* error.* 1105");
93 call mtr.add_suppression("Slave SQL.*Table definition on master and slave does not match: Column 1 size mismatch.* error.* 1535");
94 call mtr.add_suppression("Slave SQL.*Column 1 of table .test.char128_utf8. cannot be converted.* error.* 1677");
95 #
96 # Bug #54393: crash and/or valgrind errors in
97 # mysql_client_binlog_statement
98 #
99 BINLOG '';
100 ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use
101 BINLOG '123';
102 ERROR HY000: Decoding of base64 string failed
103 BINLOG '-2079193929';
104 ERROR HY000: Decoding of base64 string failed
105 BINLOG 'xç↓%~∙D╒ƒ╡';
106 ERROR HY000: Decoding of base64 string failed