|
1
by brian
clean slate |
1 |
DROP TABLE IF EXISTS t1; |
2 |
==== Test BUG#32407 ==== |
|
3 |
select * from t1; |
|
4 |
a
|
|
5 |
1
|
|
6 |
1
|
|
7 |
==== Test BINLOG statement w/o FD event ==== |
|
8 |
BINLOG ' |
|
9 |
SVtYRxMBAAAAKQAAADQBAAAAABAAAAAAAAAABHRlc3QAAnQxAAEDAAE=
|
|
10 |
SVtYRxcBAAAAIgAAAFYBAAAQABAAAAAAAAEAAf/+AgAAAA==
|
|
11 |
'; |
|
12 |
ERROR HY000: The BINLOG statement of type `Table_map` was not preceded by a format description BINLOG statement. |
|
13 |
select * from t1; |
|
14 |
a
|
|
15 |
1
|
|
16 |
1
|
|
17 |
==== Test BINLOG statement with FD event ==== |
|
18 |
BINLOG ' |
|
19 |
ODdYRw8BAAAAZgAAAGoAAAABAAQANS4xLjIzLXJjLWRlYnVnLWxvZwAAAAAAAAAAAAAAAAAAAAAA
|
|
20 |
AAAAAAAAAAAAAAAAAAA4N1hHEzgNAAgAEgAEBAQEEgAAUwAEGggAAAAICAgC
|
|
21 |
'; |
|
22 |
BINLOG ' |
|
23 |
TFtYRxMBAAAAKQAAAH8BAAAAABAAAAAAAAAABHRlc3QAAnQxAAEDAAE=
|
|
24 |
TFtYRxcBAAAAIgAAAKEBAAAQABAAAAAAAAEAAf/+AwAAAA==
|
|
25 |
'; |
|
26 |
select * from t1; |
|
27 |
a
|
|
28 |
1
|
|
29 |
1
|
|
30 |
3
|
|
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*/; |
|
34 |
DELIMITER /*!*/; |
|
35 |
# at 4
|
|
36 |
<#>ROLLBACK/*!*/; |
|
37 |
# at 102
|
|
38 |
<#>use test/*!*/; |
|
39 |
SET TIMESTAMP=1196959712/*!*/; |
|
40 |
<#>SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1/*!*/; |
|
41 |
SET @@session.sql_mode=0/*!*/; |
|
42 |
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; |
|
43 |
/*!\C latin1 *//*!*/; |
|
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 |
|
48 |
/*!*/; |
|
49 |
# at 203
|
|
50 |
DELIMITER ; |
|
51 |
# End of log file
|
|
52 |
ROLLBACK /* added by mysqlbinlog */; |
|
53 |
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; |
|
54 |
==== Test non-matching FD event and Row event ==== |
|
55 |
BINLOG ' |
|
56 |
4CdYRw8BAAAAYgAAAGYAAAAAAAQANS4xLjE1LW5kYi02LjEuMjQtZGVidWctbG9nAAAAAAAAAAAA
|
|
57 |
AAAAAAAAAAAAAAAAAADgJ1hHEzgNAAgAEgAEBAQEEgAATwAEGggICAg=
|
|
58 |
'; |
|
59 |
BINLOG ' |
|
60 |
Dl1YRxMBAAAAKQAAADQBAAAAABAAAAAAAAAABHRlc3QAAnQxAAEDAAE=
|
|
61 |
Dl1YRxcBAAAAIgAAAFYBAAAQABAAAAAAAAEAAf/+BQAAAA==
|
|
62 |
'; |
|
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 |
|
64 |
select * from t1; |
|
65 |
a
|
|
66 |
1
|
|
67 |
1
|
|
68 |
3
|
|
69 |
drop table t1; |