Comment 2 for bug 1734312

Revision history for this message
Sveta Smirnova (svetasmirnova) wrote :

Actually BEGIN TRANSACTION ... COMMIT is not required. Crash is repeatable with:

for i in `seq 1 1 100`; do mysqlmtr -P13000 test -e "create table t_$i(id int not null auto_increment primary key, f1 int) engine=innodb"; mysqlmtr -P13000 test --delimiter='|' -e "create procedure p_$i() begin declare i int; set i = 0; while i < 100 do insert into t_$i(f1) values(i);set i = i+1;end while;end"; mysqlmtr -P13000 test --delimiter='|' -e "create event ev_$i on schedule every 1 minute do call p_$i()"; done