sp_trans_log.result 648 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
show master status /* the offset must denote there is the query */|
File	Position	Binlog_Do_DB	Binlog_Ignore_DB
master-bin.000001	284		
18 19 20 21
select count(*),@a from t1 /* must be 1,1 */|
count(*)	@a
1	1
drop table t1, t2|