# Testcase derived from trigger.test # Attention: trigger.test runs with MyISAM tables # That means it does not catch this crash. --source include/have_innodb.inc --disable_warnings drop table if exists t1, t2; --enable_warnings # 1. Simplified variant create table t1 (i int, bt int) engine=myisam; create table t2 (i int) ENGINE = InnoDB; insert into t1 values (1, 1); insert into t2 values (1); create trigger bd before delete on t1 for each row set @a:= old.bt; alter table t1 drop column bt; # I get here a crash. --error ER_BAD_FIELD_ERROR delete t2, t1 from t2 straight_join t1 where t1.i = t2.i; drop table t1, t2; # 2. Full variant of trigger.test create table t1 (i int, bt int) engine=myisam; create table t2 (i int) ENGINE = InnoDB; insert into t1 values (1, 1); insert into t2 values (1); create trigger bd before delete on t1 for each row set @a:= old.bt; alter table t1 drop column bt; # I get here a crash. --error ER_BAD_FIELD_ERROR delete t2, t1 from t2 straight_join t1 where t1.i = t2.i; drop table t1, t2;