--disable_warnings
drop database if exists bug24833;
create database bug24833;
--enable_warnings

create table `t1` (
  `id` int(10) unsigned not null auto_increment,
  primary key  (`id`)
) engine=myisam default charset=latin1; 


create table `t2` (
  `id` int(10) unsigned not null auto_increment,
  primary key  (`id`)
) engine=myisam default charset=latin1;

insert into t1 values (1), (2), (3), (4), (5);

insert into t2 values (1), (2), (3), (4), (5);

delimiter |;

create trigger bug24833 before delete on t1
for each row begin
declare i int;
drop temporary table if exists t3;
create temporary table t3(id int not null);
insert into t3 values(null);
end;
|

delimiter ;|

delete ignore from t1;

insert ignore into t1 values (1), (2), (3), (4), (5);

delete ignore from t1, t2 using t1, t2 where t1.id=t2.id;


--disable_warnings
drop database bug24833;
--enable_warnings