sp_trans_log.result 840 Bytes
Newer Older
1 2
drop function if exists bug23333|
drop table if exists t1,t2|
3 4 5 6 7 8 9 10 11 12 13 14 15 16
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
unknown's avatar
unknown committed
17 18 19 20
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	#	#
21
master-bin.000001	#	Query	1	#	#
22 23 24
select count(*),@a from t1 /* must be 1,1 */|
count(*)	@a
1	1
25 26
drop table t1,t2;
drop function if exists bug23333;