~vkolesnikov/pbxt/pbxt-preload-test-bug

« back to all changes in this revision

Viewing changes to pbxt/mysql-test-update/mysql-test/r/user_var-binlog.result

  • Committer: paul-mccullagh
  • Date: 2008-03-10 11:36:34 UTC
  • Revision ID: paul-mccullagh-417ebf175a9c8ee6e5b3777d9e2398e1fb197391
Implemented full durability

Show diffs side-by-side

added added

removed removed

Lines of Context:
6
6
set @var1= "';aaa";
7
7
SET @var2=char(ascii('a'));
8
8
insert into t1 values (@var1),(@var2);
9
 
show binlog events from 102;
 
9
show binlog events from <binlog_start>;
10
10
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
11
 
master-bin.000001       #       User var        1       #       @`a b`=_latin1 0x68656C6C6F COLLATE latin1_swedish_ci
12
 
master-bin.000001       #       Query   1       #       use `test`; INSERT INTO t1 VALUES(@`a b`)
13
 
master-bin.000001       #       User var        1       #       @`var1`=_latin1 0x273B616161 COLLATE latin1_swedish_ci
14
 
master-bin.000001       #       User var        1       #       @`var2`=_binary 0x61 COLLATE binary
15
 
master-bin.000001       #       Query   1       #       use `test`; insert into t1 values (@var1),(@var2)
 
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
16
flush logs;
17
17
/*!40019 SET @@session.max_insert_delayed_threads=0*/;
18
18
/*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;