MySQL Bugs: #6807: Stored procedure crash if CREATE PROCEDURE ... KILL QUERY

Bug #6807	Stored procedure crash if CREATE PROCEDURE ... KILL QUERY
Submitted:	24 Nov 2004 17:04	Modified:	25 Nov 2004 17:56
Reporter:	Peter Gulutzan	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.2-alpha-debug	OS:	Linux (SuSE 8.2)
Assigned to:	Per-Erik Martin	CPU Architecture:	Any

Description:
I was hoping to use "KILL QUERY variable-name" in a stored procedure. 
But the CREATE PROCEDURE statement causes a crash in the server. 
 

How to repeat:
mysql> create procedure p99 () begin declare v int; kill query v; end;// 
ERROR 2013 (HY000): Lost connection to MySQL server during query

Verified with 5.0.2-alpha-debug-log

(gdb) bt
#0  Item_splocal::this_item (this=0x8d3fb20) at sp_rcontext.h:81
#1  0x0810c776 in Item_splocal::val_int (this=0x8d3fb20) at item.h:385
#2  0x08199b6e in yyparse (yythd=0x8d2db28) at sql_yacc.yy:6311
#3  0x0818538a in mysql_parse (thd=0x8d2db28,
    inBuf=0x8d3a820 "create procedure p99 () begin declare v int; kill query v; end", length=62)
    at sql_parse.cc:4565
#4  0x0817e36f in dispatch_command (command=COM_QUERY, thd=0x8d2db28,
    packet=0x8d253a9 "create procedure p99 () begin declare v int; kill query v; end;",
    packet_length=64) at sql_parse.cc:1503
#5  0x0817dd28 in do_command (thd=0x8d2db28) at sql_parse.cc:1311
#6  0x0817d28a in handle_one_connection (arg=0x8d2db28) at sql_parse.cc:1047
#7  0xb7e4714b in pthread_start_thread () from /lib/libpthread.so.0
#8  0xb7e471df in pthread_start_thread_event () from /lib/libpthread.so.0
#9  0xb7d7a50a in clone () from /lib/libc.so.6

The same problem exists for PURGE ... LOGS BEFORE ...