1drop table if exists t1,t2; 2set @myisam_icp_notembedded_tmp=@@optimizer_switch; 3set optimizer_switch='mrr=on,mrr_sort_keys=on,index_condition_pushdown=on'; 4# 5# BUG#933412: Server crashes in _mi_put_key_in_record on KILL QUERY with ICP, STRAIGHT_JOIN 6# 7CREATE TABLE t1 ( 8b INT, 9c VARCHAR(1) NOT NULL, 10d DATETIME, 11KEY (c, b) 12) ENGINE=MyISAM; 13# INSERT some data 14CREATE TABLE t2 ( a INT ) ENGINE=MyISAM; 15INSERT INTO t2 VALUES 16(7),(3),(7),(3); 17connect con2,127.0.0.1,root,,test; 18# Now run a number of ICP queries while trying to kill them 19disconnect con2; 20connection default; 21DROP TABLE t1,t2; 22set optimizer_switch=@myisam_icp_notembedded_tmp; 23