Queries with "converting HEAP to Aria" status do not respond to KILL QUERY

[Philip Stoev]

Queries for which the SHOW PROCESSLIST shows "converting HEAP to Aria" can not be killed using KILL QUERY. The connection status does not even change to "Killed"

     Id: 8
   User: root
   Host: localhost:52982
     db: test
Command: Query
   Time: 45
  State: converting HEAP to Aria
   Info: SELECT * FROM lineitem AS p_l , orders AS p_o WHERE p_l.l_orderkey = p_o.o_orderkey AND p_o.o_orderkey IN ( SELECT c_l.l_orderkey FROM lineitem AS c_l , orders AS c_o WHERE c_l.l_orderkey = c_o.o_orderkey AND c_o.o_orderkey < 70 AND c_o.o_orderkey > 180 ) OR p_o.o_orderkey IN ( SELECT p_l.l_orderkey FROM lineitem AS c_l , orders AS c_o WHERE c_l.l_orderkey = c_o.o_orderkey AND c_l.l_orderkey = 238 ) LIMIT 1

To reproduce, run the query above against the dbt3-s0.001.dump dataset that can be found here:

http://bazaar.launchpad.net/~randgen/randgen/rqg2/files/head:/conf/dbt3/

[Philip Stoev (philip-stoev)]

This code first appeared in maria-5.2 and was added by Monty, that is why I am assigning this bug to him.

The same query in mysql-5.5 is perfectly killable, so it is a regression in terms of the "drop in replacement" principle.

[Michael Widenius (monty)]

Fix committed into 5.1