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: Bugs System CPU Architecture:Any

[24 Nov 2004 17:04] Peter Gulutzan
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
[24 Nov 2004 20:36] MySQL Verification Team
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
[25 Nov 2004 11:29] Per-Erik Martin
The same problem exists for PURGE ... LOGS BEFORE ...