sp_trans_log.result 745 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14
CREATE TABLE t1 (a int  NOT NULL auto_increment primary key) ENGINE=MyISAM|
CREATE TABLE t2 (a int  NOT NULL auto_increment, b int, PRIMARY KEY (a)) ENGINE=InnoDB|
insert into t2 values (1,1)|
create function bug23333() 
RETURNS int(11)
DETERMINISTIC
begin
insert into t1 values (null);
select count(*) from t1 into @a;
return @a;
end|
reset master|
insert into t2 values (bug23333(),1)|
ERROR 23000: Duplicate entry '1' for key 1
15 16 17 18
show binlog events from 98 /* with fixes for #23333 will show there are 2 queries */|
Log_name	Pos	Event_type	Server_id	End_log_pos	Info
master-bin.000001	#	Query	1	#	#
master-bin.000001	#	Query	1	#	#
19
master-bin.000001	#	Query	1	#	#
20 21 22 23
select count(*),@a from t1 /* must be 1,1 */|
count(*)	@a
1	1
drop table t1, t2|