summaryrefslogtreecommitdiff
path: root/mysql-test/r/sp_trans_log.result
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/r/sp_trans_log.result')
-rw-r--r--mysql-test/r/sp_trans_log.result9
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/sp_trans_log.result b/mysql-test/r/sp_trans_log.result
index 117f6de754a..34d24f70848 100644
--- a/mysql-test/r/sp_trans_log.result
+++ b/mysql-test/r/sp_trans_log.result
@@ -14,5 +14,14 @@ end|
reset master|
insert into t2 values (bug23333(),1)|
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
+show binlog events from <binlog_start>|
+Log_name Pos Event_type Server_id End_log_pos Info
+master-bin.000001 # Query # # BEGIN
+master-bin.000001 # Table_map # # table_id: # (test.t1)
+master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
+master-bin.000001 # Query # # COMMIT
+select count(*),@a from t1 /* must be 1,1 */|
+count(*) @a
+1 1
drop table t1,t2;
drop function if exists bug23333;