← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/r/user_var-binlog.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/r/user_var-binlog.result
 
1
create table t1 (a varchar(50));
 
2
reset master;
 
3
SET TIMESTAMP=10000;
 
4
SET @`a b`='hello';
 
5
INSERT INTO t1 VALUES(@`a b`);
 
6
set @var1= "';aaa";
 
7
SET @var2=char(ascii('a'));
 
8
insert into t1 values (@var1),(@var2);
 
9
show binlog events from <binlog_start>;
 
10
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
 
11
master-bin.000001       #       User var        #       #       @`a b`=_latin1 0x68656C6C6F COLLATE latin1_swedish_ci
 
12
master-bin.000001       #       Query   #       #       use `test`; INSERT INTO t1 VALUES(@`a b`)
 
13
master-bin.000001       #       User var        #       #       @`var1`=_latin1 0x273B616161 COLLATE latin1_swedish_ci
 
14
master-bin.000001       #       User var        #       #       @`var2`=_binary 0x61 COLLATE binary
 
15
master-bin.000001       #       Query   #       #       use `test`; insert into t1 values (@var1),(@var2)
 
16
flush logs;
 
17
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
 
18
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;
 
19
DELIMITER /*!*/;
 
20
ROLLBACK/*!*/;
 
21
SET @`a b`:=_latin1 0x68656C6C6F COLLATE `latin1_swedish_ci`/*!*/;
 
22
use test/*!*/;
 
23
SET TIMESTAMP=10000/*!*/;
 
24
SET @@session.pseudo_thread_id=999999999/*!*/;
 
25
SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=1, @@session.unique_checks=1/*!*/;
 
26
SET @@session.sql_mode=0/*!*/;
 
27
SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/;
 
28
/*!\C latin1 *//*!*/;
 
29
SET @@session.character_set_client=8,@@session.collation_connection=8,@@session.collation_server=8/*!*/;
 
30
SET @@session.lc_time_names=0/*!*/;
 
31
SET @@session.collation_database=DEFAULT/*!*/;
 
32
INSERT INTO t1 VALUES(@`a b`)
 
33
/*!*/;
 
34
SET @`var1`:=_latin1 0x273B616161 COLLATE `latin1_swedish_ci`/*!*/;
 
35
SET @`var2`:=_binary 0x61 COLLATE `binary`/*!*/;
 
36
SET TIMESTAMP=10000/*!*/;
 
37
insert into t1 values (@var1),(@var2)
 
38
/*!*/;
 
39
DELIMITER ;
 
40
# End of log file
 
41
ROLLBACK /* added by mysqlbinlog */;
 
42
/*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/;
 
43
drop table t1;