← Back to branch summary

~mdcallag/+junk/5.1-map

« back to all changes in this revision

Viewing changes to mysql-test/r/binlog_row_insert_select.result

  • Committer: msvensson at pilot
  • Date: 2007-04-24 09:11:45 UTC
  • mfrom: (2469.1.106)
  • Revision ID: sp1r-msvensson@pilot.blaudden-20070424091145-10463
Merge pilot.blaudden:/home/msvensson/mysql/my51-m-mysql_upgrade
into  pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/binlog_row_insert_select.result
6
6
reset master;
7
7
insert into t1 select * from t2;
8
8
ERROR 23000: Duplicate entry '2' for key 'a'
9
 
show binlog events;
 
9
show binlog events from <binlog_start>;
10
10
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
11
 
master-bin.000001       4       Format_desc     1       102     Server ver: VERSION, Binlog ver: 4
12
 
master-bin.000001       102     Table_map       1       141     table_id: # (test.t1)
13
 
master-bin.000001       141     Write_rows      1       175     table_id: # flags: STMT_END_F
 
11
master-bin.000001       #       Table_map       #       #       table_id: # (test.t1)
 
12
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
14
13
select * from t1;
15
14
a
16
15
1
21
20
reset master;
22
21
create table t2(unique(a)) select a from t1;
23
22
ERROR 23000: Duplicate entry '1' for key 'a'
24
 
show binlog events;
 
23
show binlog events from <binlog_start>;
25
24
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
26
 
master-bin.000001       4       Format_desc     1       102     Server ver: VERSION, Binlog ver: 4
27
25
drop table t1;