← Back to branch summary

~ubuntu-branches/ubuntu/precise/mysql-5.1/precise

« back to all changes in this revision

Viewing changes to mysql-test/suite/rpl/r/rpl_rbr_to_sbr.result

  • Committer: Bazaar Package Importer
  • Author(s): Chuck Short
  • Date: 2010-06-21 15:31:05 UTC
  • mfrom: (1.1.3 upstream)
  • mto: This revision was merged to the branch mainline in revision 6.
  • Revision ID: james.westby@ubuntu.com-20100621153105-pbbz3t6nyrf9t2zq
Tags: upstream-5.1.48
Import upstream version 5.1.48

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/rpl/r/rpl_rbr_to_sbr.result
14
14
CREATE TABLE t1 (a INT, b LONG);
15
15
INSERT INTO t1 VALUES (1,1), (2,2);
16
16
INSERT INTO t1 VALUES (3,UUID()), (4,UUID());
17
 
SHOW BINLOG EVENTS;
 
17
show binlog events from <binlog_start>;
18
18
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
19
 
master-bin.000001       #       Format_desc     1       #       Server ver: VERSION, Binlog ver: 4
20
 
master-bin.000001       #       Query   1       #       use `test`; CREATE TABLE t1 (a INT, b LONG)
21
 
master-bin.000001       #       Query   1       #       use `test`; INSERT INTO t1 VALUES (1,1), (2,2)
22
 
master-bin.000001       #       Query   1       #       BEGIN
23
 
master-bin.000001       #       Table_map       1       #       table_id: # (test.t1)
24
 
master-bin.000001       #       Write_rows      1       #       table_id: # flags: STMT_END_F
25
 
master-bin.000001       #       Query   1       #       COMMIT
 
19
master-bin.000001       #       Query   #       #       use `test`; CREATE TABLE t1 (a INT, b LONG)
 
20
master-bin.000001       #       Query   #       #       use `test`; INSERT INTO t1 VALUES (1,1), (2,2)
 
21
master-bin.000001       #       Query   #       #       BEGIN
 
22
master-bin.000001       #       Table_map       #       #       table_id: # (test.t1)
 
23
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
 
24
master-bin.000001       #       Query   #       #       COMMIT
26
25
**** On Slave ****
27
 
SHOW SLAVE STATUS;
28
 
Slave_IO_State  #
29
 
Master_Host     127.0.0.1
30
 
Master_User     root
31
 
Master_Port     MASTER_PORT
32
 
Connect_Retry   1
33
 
Master_Log_File master-bin.000001
34
 
Read_Master_Log_Pos     594
35
 
Relay_Log_File  #
36
 
Relay_Log_Pos   #
37
 
Relay_Master_Log_File   master-bin.000001
38
 
Slave_IO_Running        Yes
39
 
Slave_SQL_Running       Yes
40
 
Replicate_Do_DB 
41
 
Replicate_Ignore_DB     
42
 
Replicate_Do_Table      
43
 
Replicate_Ignore_Table  
44
 
Replicate_Wild_Do_Table 
45
 
Replicate_Wild_Ignore_Table     
46
 
Last_Errno      0
47
 
Last_Error      
48
 
Skip_Counter    0
49
 
Exec_Master_Log_Pos     594
50
 
Relay_Log_Space #
51
 
Until_Condition None
52
 
Until_Log_File  
53
 
Until_Log_Pos   0
54
 
Master_SSL_Allowed      No
55
 
Master_SSL_CA_File      
56
 
Master_SSL_CA_Path      
57
 
Master_SSL_Cert 
58
 
Master_SSL_Cipher       
59
 
Master_SSL_Key  
60
 
Seconds_Behind_Master   #
61
 
Master_SSL_Verify_Server_Cert   #
62
 
Last_IO_Errno   #
63
 
Last_IO_Error   
64
 
Last_SQL_Errno  0
65
 
Last_SQL_Error  
66
 
SHOW BINLOG EVENTS;
 
26
show binlog events from <binlog_start>;
67
27
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
68
 
slave-bin.000001        #       Format_desc     2       #       Server ver: VERSION, Binlog ver: 4
69
 
slave-bin.000001        #       Query   1       #       use `test`; CREATE TABLE t1 (a INT, b LONG)
70
 
slave-bin.000001        #       Query   1       #       use `test`; INSERT INTO t1 VALUES (1,1), (2,2)
71
 
slave-bin.000001        #       Query   1       #       BEGIN
72
 
slave-bin.000001        #       Table_map       1       #       table_id: # (test.t1)
73
 
slave-bin.000001        #       Write_rows      1       #       table_id: # flags: STMT_END_F
74
 
slave-bin.000001        #       Query   1       #       COMMIT
 
28
slave-bin.000001        #       Query   #       #       use `test`; CREATE TABLE t1 (a INT, b LONG)
 
29
slave-bin.000001        #       Query   #       #       use `test`; INSERT INTO t1 VALUES (1,1), (2,2)
 
30
slave-bin.000001        #       Query   #       #       BEGIN
 
31
slave-bin.000001        #       Table_map       #       #       table_id: # (test.t1)
 
32
slave-bin.000001        #       Write_rows      #       #       table_id: # flags: STMT_END_F
 
33
slave-bin.000001        #       Query   #       #       COMMIT
75
34
DROP TABLE IF EXISTS t1;
76
35
SET @@global.binlog_format= @old_binlog_format;