← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/suite/binlog/r/binlog_base64_flag.result

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/binlog/r/binlog_base64_flag.result
 
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;