25 lines
747 B
Plaintext
25 lines
747 B
Plaintext
drop function if exists bug23333;
|
|
drop table if exists t1,t2;
|
|
CREATE TABLE t1 (a int NOT NULL auto_increment primary key) ENGINE=XEngine;
|
|
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|
|
|
Warnings:
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
reset master;
|
|
insert into t2 values (bug23333(),1);
|
|
ERROR 23000: Duplicate entry '1' for key 'PRIMARY'
|
|
include/show_binlog_events.inc
|
|
select count(*),@a from t1 /* must be 1,1 */;
|
|
count(*) @a
|
|
0 1
|
|
drop table t1,t2;
|
|
drop function if exists bug23333;
|