← Back to branch summary

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

« back to all changes in this revision

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

  • Committer: Bazaar Package Importer
  • Author(s): Norbert Tretkowski
  • Date: 2010-06-17 22:38:56 UTC
  • mto: (1.2.1 upstream) (2.1.4 sid)
  • mto: This revision was merged to the branch mainline in revision 6.
  • Revision ID: james.westby@ubuntu.com-20100617223856-p3sfjw3y37l2g0u6
Import upstream version 5.1.48

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/sp_trans_log.result
14
14
reset master|
15
15
insert into t2 values (bug23333(),1)|
16
16
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
17
 
show binlog events from 106 /* with fixes for #23333 will show there is the query */|
 
17
show binlog events from <binlog_start>|
18
18
Log_name        Pos     Event_type      Server_id       End_log_pos     Info
19
 
master-bin.000001       #       Query   1       #       #
20
 
master-bin.000001       #       Table_map       1       #       #
21
 
master-bin.000001       #       Table_map       1       #       #
22
 
master-bin.000001       #       Write_rows      1       #       #
23
 
master-bin.000001       #       Query   1       #       #
 
19
master-bin.000001       #       Query   #       #       BEGIN
 
20
master-bin.000001       #       Table_map       #       #       table_id: # (test.t2)
 
21
master-bin.000001       #       Table_map       #       #       table_id: # (test.t1)
 
22
master-bin.000001       #       Write_rows      #       #       table_id: # flags: STMT_END_F
 
23
master-bin.000001       #       Query   #       #       ROLLBACK
24
24
select count(*),@a from t1 /* must be 1,1 */|
25
25
count(*)        @a
26
26
1       1