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